GilpinTutorial9Session1

GilpinTutorial9Session1 - Bent Cycling Author Date Purpose...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Bent Cycling Author Peyton Gilpin Date 10/14/2010 Purpose To analyze different investment and loan scenarios
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Bent Cycling Savings Proposals 07/19/2011 Bent Cycling Prepared: Investment Analysis Calculate Years Monthly Payment (PMT) ($400,000) $1,200,000 5.30% 12 0.44% 18 1.5 Investment Goal (FV) ($400,000) $993,780 5.30% 12 0.44% 18 1.5 Months (NPER) ($400,000) $1,200,000 5.30% 12 0.44% 23.93 1.99 Initial Investment (PV) ($590,493) $1,200,000 5.30% 12 0.44% 18 1.5 Rate per Month (RATE) ($400,000) $1,200,000 22.95% 12 1.91% 18 1.5 Initial Investment (PV) Investment Goal (FV) Annual Rate Months per Year Rate per Month (RATE) Months (NPER)
Background image of page 2
Bent Cycling Savings Proposals 07/19/2011 7/19/2011 ($41,033) ($30,000) ($30,000) ($30,000) ($30,000) Monthly Payment (PMT)
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Bent Cycling Loan Proposal 07/19/2011 Bent Cycling Prepared: 7/19/2011 Loan Schedule Loan (PV) Annual Rate Years $1,200,000 9.50% 4 2.38% 20 5 ($76,071) Amortization Schedule Year Quarter Total Payment 1 1 $1,200,000 ($28,500) ($47,571)
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

GilpinTutorial9Session1 - Bent Cycling Author Date Purpose...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online