Bent Cycling Savings Proposals 12/6/2011
Investment Analysis
Initial Investment Investment Annual Months Rate per Month Months Monthly Payment
Calculate (PV) Goal (FV) Rate per Year (RATE) (NPER) Years (PMT)
Bent Cycling Loan Proposal 12/6/2011
Loan Schedule
Quarters per Rate per Quarter Quarters Quarterly Payment
Loan (PV) Annual Rate Year (RATE) Years (NPER) (PMT)
Amortization Schedule
Interest Principal
Remaining Payment = IPMT Payment = PPMT
Year Quarter (PER) Principal () () Total Payment
1 1
1 2
1 3
1 4
2 5
2 6
2 7
2 8
3 9
3 10
3 11
3 12
4 13
4 14
4 15
4 16
5 17
5 18
5 19
5 20
Final Balance
and Principal Payments per Year
Year 1 Year 2 Year 3 Year 4 Year 5
Quarters
1 5 9 13 17
4 8 12 16 20 Total
Interest
Principal
Total