Loan Analysis

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 7

Interest per month 0.

004166666666667 Loan 36000


Monthly payment 1078.952
Time (months) Balance (beginning) Interest Balance (end)
0 36000.00 150.00 35071.05
1 35071.05 146.13 34138.22
2 34138.22 142.24 33201.52
3 33201.52 138.34 32260.90
4 32260.90 134.42 31316.37
5 31316.37 130.48 30367.90
6 30367.90 126.53 29415.48
7 29415.48 122.56 28459.10
8 28459.10 118.58 27498.72
9 27498.72 114.58 26534.35
10 26534.35 110.56 25565.96
11 25565.96 106.52 24593.53
12 24593.53 102.47 23617.05
13 23617.05 98.40 22636.50
14 22636.50 94.32 21651.87
15 21651.87 90.22 20663.13
16 20663.13 86.10 19670.28
17 19670.28 81.96 18673.28
18 18673.28 77.81 17672.14
19 17672.14 73.63 16666.82
20 16666.82 69.45 15657.31
21 15657.31 65.24 14643.60
22 14643.60 61.01 13625.66
23 13625.66 56.77 12603.48
24 12603.48 52.51 11577.04
25 11577.04 48.24 10546.33
26 10546.33 43.94 9511.32
27 9511.32 39.63 8472.00
28 8472.00 35.30 7428.35
29 7428.35 30.95 6380.34
30 6380.34 26.58 5327.98
31 5327.98 22.20 4271.22
32 4271.22 17.80 3210.07
33 3210.07 13.38 2144.49
34 2144.49 8.94 1074.48
35 1074.48 4.48 0.00
Duration 36
Loan amount 18000
Interest rate 0.004166666667
Monthly payment 539.4761873601

Time Balance (beginning) Interest incurred Balance (end)


0 $18,000.00 $75.00 $18,075.00
1 $17,535.52 $73.06 $17,608.59
2 $17,069.11 $71.12 $17,140.23
3 $16,600.76 $69.17 $16,669.93
4 $16,130.45 $67.21 $16,197.66
5 $15,658.19 $65.24 $15,723.43
6 $15,183.95 $63.27 $15,247.22
7 $14,707.74 $61.28 $14,769.02
8 $14,229.55 $59.29 $14,288.84
9 $13,749.36 $57.29 $13,806.65
10 $13,267.17 $55.28 $13,322.45
11 $12,782.98 $53.26 $12,836.24
12 $12,296.76 $51.24 $12,348.00
13 $11,808.52 $49.20 $11,857.73
14 $11,318.25 $47.16 $11,365.41
15 $10,825.93 $45.11 $10,871.04
16 $10,331.57 $43.05 $10,374.61
17 $9,835.14 $40.98 $9,876.12
18 $9,336.64 $38.90 $9,375.54
19 $8,836.07 $36.82 $8,872.88
20 $8,333.41 $34.72 $8,368.13
21 $7,828.65 $32.62 $7,861.27
22 $7,321.80 $30.51 $7,352.31
23 $6,812.83 $28.39 $6,841.22
24 $6,301.74 $26.26 $6,328.00
25 $5,788.52 $24.12 $5,812.64
26 $5,273.16 $21.97 $5,295.13
27 $4,755.66 $19.82 $4,775.47
28 $4,236.00 $17.65 $4,253.65
29 $3,714.17 $15.48 $3,729.65
30 $3,190.17 $13.29 $3,203.46
31 $2,663.99 $11.10 $2,675.09
32 $2,135.61 $8.90 $2,144.51
33 $1,605.03 $6.69 $1,611.72
34 $1,072.24 $4.47 $1,076.71
35 $537.24 $2.24 $539.47
36 $0.00 $0.00 $0.00
Loan amount 18000 Monthly payment 539.47618736
Duration 36
Interest per month 0.00416666667

Time (months) Balance (beginning) Interest incurred Balance (end)


0 $18,000.00 $75.00 $18,075.00
1 $17,535.52 $73.06 $17,608.59
2 $17,069.11 $71.12 $17,140.23
3 $16,600.76 $69.17 $16,669.93
4 $16,130.45 $67.21 $16,197.66
5 $15,658.19 $65.24 $15,723.43
6 $15,183.95 $63.27 $15,247.22
7 $14,707.74 $61.28 $14,769.02
8 $14,229.55 $59.29 $14,288.84
9 $13,749.36 $57.29 $13,806.65
10 $13,267.17 $55.28 $13,322.45
11 $12,782.98 $53.26 $12,836.24
12 $12,296.76 $51.24 $12,348.00
13 $11,808.52 $49.20 $11,857.73
14 $11,318.25 $47.16 $11,365.41
15 $10,825.93 $45.11 $10,871.04
16 $10,331.57 $43.05 $10,374.61
17 $9,835.14 $40.98 $9,876.12
18 $9,336.64 $38.90 $9,375.54
19 $8,836.07 $36.82 $8,872.88
20 $8,333.41 $34.72 $8,368.13
21 $7,828.65 $32.62 $7,861.27
22 $7,321.80 $30.51 $7,352.31
23 $6,812.83 $28.39 $6,841.22
24 $6,301.74 $26.26 $6,328.00
25 $5,788.52 $24.12 $5,812.64
26 $5,273.16 $21.97 $5,295.13
27 $4,755.66 $19.82 $4,775.47
28 $4,236.00 $17.65 $4,253.65
29 $3,714.17 $15.48 $3,729.65
30 $3,190.17 $13.29 $3,203.46
31 $2,663.99 $11.10 $2,675.09
32 $2,135.61 $8.90 $2,144.51
33 $1,605.03 $6.69 $1,611.72
34 $1,072.24 $4.47 $1,076.71
35 $537.24 $2.24 $539.47
36 $0.00 $0.00 $0.00

You might also like