Amortization Table

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

Amortization Table

New car at 16.52% 10% down payment:

Opening Ending
Year Balance Installment Interest Principle Balance

1 5,810,850.00 1,796,262.83 959,952.42 836,310.41 4,974,539.59

2 4,974,539.59 1,796,262.83 821,793.94 974,468.89 4,000,070.70

3 4,000,070.70 1,796,262.83 660,811.68 1,135,451.15 2,864,619.55

4 2,864,619.55 1,796,262.83 473,235.15 1,323,027.68 1,541,591.87

5 1,541,591.87 1,796,262.83 254,670.98 1,541,591.85 0.02

8,981,314.15

New car at 18.52% 10% down payment:


Opening Ending
Year Balance Installment Interest Principle Balance

1 5,810,850.00 1,880,113.54 1,076,169.42 803,944.12 5,006,905.88

2 5,006,905.88 1,880,113.54 927,278.97 952,834.57 4,054,071.31

3 4,054,071.31 1,880,113.54 750,814.01 1,129,299.53 2,924,771.78

4 2,924,771.78 1,880,113.54 541,667.73 1,338,445.81 1,586,325.97

5 1,586,325.97 1,880,113.54 293,787.57 1,586,325.97 (0.00)

9,400,567.70

You might also like