Investment Analysis - Copy

Investment Analysis - Copy - Bent Cycling Author Date...

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

View Full Document Right Arrow Icon
Bent Cycling Author Kory Johnson Date 3/20/2008 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 02/27/2012 Bent Cycling Prepared: 11/7/2009 Investment Analysis Calculate Years Monthly Payment(PMT) ($400,000) $1,200,000 5.30% 12 0.44% 18 1.5 ($41,033) Investment Goal(FV) ($400,000) $993,780 5.30% 12 0.44% 18 1.5 ($30,000) Months(NPER) ($400,000) $1,200,000 5.30% 12 0.44% 23.9317 1.994305 ($30,000) Initial Investment (PV) ($590,493) $1,200,000 5.30% 12 0.44% 18 1.5 ($30,000) Rate Per Month(Rate) ($400,000) $1,200,000 22.95% 12 1.91% 18 1.5 ($30,000) Initial Investment (PV) Investment Goal (FV) Annual Rate Months per Year Rate per Month (RATE) Months (NPER) Monthly Payment (PMT)
Background image of page 2
Bent Cycling Loan Proposal 02/27/2012 Bent Cycling Prepared: 11/7/2009 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) ($76,071) 1 2 $1,152,429 ($27,370) ($48,700)
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/27/2012 for the course CIT CIT140 taught by Professor Somsen during the Winter '12 term at BYU - ID.

Page1 / 3

Investment Analysis - Copy - Bent Cycling Author Date...

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

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