A | B | C | D | E | F | G | H | I | J | |
---|---|---|---|---|---|---|---|---|---|---|
1 | P | i | d | n | Pmts are frontloaded, higher at the beginning, but are level value when adjusted fo deflation. | |||||
2 | $100 | 5.000% | 30.000% | 10 | ||||||
3 | ||||||||||
4 | ||||||||||
5 | `=F6*(1+i) | `=F6*i | `=E7-C7 | `=E7*(1-d)^-A7 | Earnings from | |||||
6 | Balance | Int | Prin | Pmt | $100 | Def Adjusted | Cash | |||
7 | 1 | $105 | $36.50 | $(0.88) | $35.62 | $69.38 | $50.88 | $36.50 | ||
8 | 2 | $73 | $25.32 | $(0.39) | $24.93 | $47.92 | $50.88 | $25.32 | ||
9 | 3 | $50 | $17.49 | $(0.04) | $17.45 | $32.86 | $50.88 | $17.49 | ||
10 | 4 | $35 | $11.99 | $0.22 | $12.22 | $22.29 | $50.88 | $11.99 | ||
11 | 5 | $23 | $8.14 | $0.42 | $8.55 | $14.85 | $50.88 | $8.14 | ||
12 | 6 | $16 | $5.42 | $0.57 | $5.99 | $9.61 | $50.88 | $5.42 | ||
13 | 7 | $10 | $3.51 | $0.68 | $4.19 | $5.90 | $50.88 | $3.51 | ||
14 | 8 | $6 | $2.15 | $0.78 | $2.93 | $3.26 | $50.88 | $2.15 | ||
15 | 9 | $3 | $1.19 | $0.86 | $2.05 | $1.37 | $50.88 | $1.19 | ||
16 | 10 | $1 | $0.50 | $0.94 | $1.44 | $0.00 | $50.88 | $0.50 | ||
17 | $112.21 | |||||||||
18 | ||||||||||
19 | ||||||||||
20 |