CFI bs.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
MortgageCar
StudentLoan
Mortgage - 1 yearCar - 1 year
2
Oustanding amount
$150,000.00$20,000.00$50,000.00AmountPaymentPrincipalInterestBalanceAmount
Payment
PrincipalInterestBalance
3
Rate4.00%0.90%3.00%1 $ 150,000.00 $1,109.53 $609.53 $ 500.00 $ 149,390.47 $20,000.00$341.01$326.01$15.00$19,673.99
4
Original term (years)
155102 $ 149,390.47 $1,109.53 $611.56 $ 497.97 $ 148,778.90 $19,673.99$341.01$326.26$14.76$19,347.73
5
Monthly payments
$1,109.53$341.01$482.803 $ 148,778.90 $1,109.53 $613.60 $ 495.93 $ 148,165.30 $19,347.73$341.01$326.50$14.51$19,021.22
6
Original CFI135591044 $ 148,165.30 $1,109.53 $615.65 $ 493.88 $ 147,549.65 $19,021.22$341.01$326.75$14.27$18,694.47
7
5 $ 147,549.65 $1,109.53 $617.70 $ 491.83 $ 146,931.95 $18,694.47$341.01$326.99$14.02$18,367.48
8
Extra money $ 1,333.79 6 $ 146,931.95 $1,109.53 $619.76 $ 489.77 $ 146,312.20 $18,367.48$341.01$327.24$13.78$18,040.24
9
7 $ 146,312.20 $1,109.53 $621.82 $ 487.71 $ 145,690.37 $18,040.24$341.01$327.48$13.53$17,712.76
10
8 $ 145,690.37 $1,109.53 $623.90 $ 485.63 $ 145,066.47 $17,712.76$341.01$327.73$13.28$17,385.03
11
9 $ 145,066.47 $1,109.53 $625.98 $ 483.55 $ 144,440.50 $17,385.03$341.01$327.98$13.04$17,057.05
12
10 $ 144,440.50 $1,109.53 $628.06 $ 481.47 $ 143,812.43 $17,057.05$341.01$328.22$12.79$16,728.83
13
11 $ 143,812.43 $1,109.53 $630.16 $ 479.37 $ 143,182.28 $16,728.83$341.01$328.47$12.55$16,400.36
14
12 $ 143,182.28 $1,109.53 $632.26 $ 477.27 $ 142,550.02 $16,400.36$341.01$328.71$12.30$16,071.65
15
$ 5,864.40 $163.82
16
17
AmountPaymentPrincipalInterestExtra PrinBalanceAmount
Payment
PrincipalInterestExtra PrinBalance
18
1 $ 150,000.00 $1,109.53 $609.53 $ 500.00 $ 1,333.79 $ 148,056.68 $20,000.00$341.01$326.01$15.00$1,333.79$18,340.20
19
2 $ 148,056.68 $1,109.53 $616.01 $ 493.52 $ 1,333.79 $ 146,106.88 $18,340.20$341.01$327.26$13.76$1,333.79$16,679.15
20
3 $ 146,106.88 $1,109.53 $622.51 $ 487.02 $ 1,333.79 $ 144,150.58 $16,679.15$341.01$328.51$12.51$1,333.79$15,016.86
21
4 $ 144,150.58 $1,109.53 $629.03 $ 480.50 $ 1,333.79 $ 142,187.77 $15,016.86$341.01$329.75$11.26$1,333.79$13,353.32
22
5 $ 142,187.77 $1,109.53 $635.57 $ 473.96 $ 1,333.79 $ 140,218.41 $13,353.32$341.01$331.00$10.01$1,333.79$11,688.53
23
6 $ 140,218.41 $1,109.53 $642.14 $ 467.39 $ 1,333.79 $ 138,242.48 $11,688.53$341.01$332.25$8.77$1,333.79$10,022.49
24
7 $ 138,242.48 $1,109.53 $648.72 $ 460.81 $ 1,333.79 $ 136,259.97 $10,022.49$341.01$333.50$7.52$1,333.79$8,355.21
25
8 $ 136,259.97 $1,109.53 $655.33 $ 454.20 $ 1,333.79 $ 134,270.85 $8,355.21$341.01$334.75$6.27$1,333.79$6,686.67
26
9 $ 134,270.85 $1,109.53 $661.96 $ 447.57 $ 1,333.79 $ 132,275.10 $6,686.67$341.01$336.00$5.02$1,333.79$5,016.88
27
10 $ 132,275.10 $1,109.53 $668.61 $ 440.92 $ 1,333.79 $ 130,272.69 $5,016.88$341.01$337.25$3.76$1,333.79$3,345.84
28
11 $ 130,272.69 $1,109.53 $675.29 $ 434.24 $ 1,333.79 $ 128,263.62 $3,345.84$341.01$338.51$2.51$1,333.79$1,673.55
29
12 $ 128,263.62 $1,109.53 $681.99 $ 427.55 $ 1,333.79 $ 126,247.84 $1,673.55$341.01$339.76$1.26$1,333.79$0.00
30
$ 5,567.68 $296.72$97.63$66.19
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu