Bent Cycling
Author
Date
Purpose To analyze different investment and loan scenarios
Bent Cycling Savings Proposals 10/24/2011
Bent Cycling
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 10/24/2011
Bent Cycling
Loan Schedule
Quarters per Rate per Quarter Quarters Quarterly Payment
Loan (PV) Annual Rate Year (RATE) Years (NPER) (PMT)
Amortization Schedule
Remaining Interest Principal
Year Quarter Principal Payment Payment 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
Interest 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