Cycling
Author
Date
Purpose
Your Bent name goes here
Current Date
To analyze different investment and loan scenarios
Bent Cycling
Savings Proposals
Bent Cycling
4/6/2010
Prepared: 04/06/2010
Investment Analysis
Calculate
Monthly Payment (PMT)
Investment Goal (FV)
Months (NPER)
Initial Investment (PV)
Rate per Month (RATE)
Initial Investment
(PV)
($400,000)
($400,000)
($400,000)
($590,493)
($400,000)
Investment
Goal (FV)
$1,200,000
$993,780
$1,200,000
$1,200,000
$1,200,000
Annual
Months
Rate per
Months
Monthly Payment
Rate
per Year Month (RATE) (NPER)
Years
(PMT)
5.30%
12
0.44%
18
1.5
($41,033)
5.30%
12
0.44%
18
1.5
($30,000)
5.30%
12
0.44% 23.9317 1.99431
($30,000)
5.30%
12
0.44%
18
1.5
($30,000)
22.95%
12
1.91%
18
1.5
($30,000)
Bent Cycling
Loan Proposal
4/6/2010
Bent Cycling
Prepared: 04/06/2010
Loan Schedule
Loan (PV)
Annual Rate
$1,200,000
9.50%
Quarters per
Year
Rate per Quarter
(RATE)
Quarters (NPER)
4
2.38%
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Remaining
Principal
$1,200,000
$1,152,429
$1,103,729
$1,053,872
$1,002,831
$950,578
$897,083
$842,318
$786,253
$728,856
$670,096
$609,940
$548,355
$485,308
$420,764
$354,686
$287,039
$217,786
$146,888
$74,306
Interest
Payment
($28,500)
($27,370)
($26,214)
($25,029)
($23,817)
($22,576)
($21,306)
($20,005)
($18,674)
($17,310)
($15,915)
($14,486)
($13,023)
($11,526)
($9,993)
($8,424)
($6,817)
($5,172)
($3,489)
($1,765)
1
($107,113)
($197,169)
($304,282)
2
($87,704)
($216,578)
($304,282)
Year
3
($66,385)
($237,898)
($304,282)
20
Quarterly Payment
(PMT)
Years
5
($76,071)
Amortization Schedule
Year
Quarter
1
1
1
1
2
2
2
2
3
3
3
3
4
4
4
4
5
5
5
5
Yearly Payments
Interest
Principal
Total
Principal
Payment
Total Payment
($47,571)
($76,071)
($48,700)
($76,071)
($49,857)
($76,071)
($51,041)
($76,071)
($52,253)
($76,071)
($53,494)
($76,071)
($54,765)
($76,071)
($56,066)
($76,071)
($57,397)
($76,071)
($58,760)
($76,071)
($60,156)
($76,071)
($61,585)
($76,071)
($63,047)
($76,071)
($64,545)
($76,071)
($66,077)
($76,071)
($67,647)
($76,071)
($69,253)
($76,071)
($70,898)
($76,071)
($72,582)
($76,071)
($74,306)
($76,071)
4
($42,966)
($261,316)
($304,282)
5
($17,243)
($287,039)
($304,282)
Total
($321,412)
($1,200,000)
($1,521,412)