3100_excel.xlsx
Sheet1
| | | Down pmt | Pmt period | Interest rate | Car price | | | 1st year | 2nd year | 3rd year | 4th year | 5th year |
| | Scenario 1 | 0% | 36 | 4.50% | $21,999 | | Starting period | 1 | 13 | 25 | 37 | 49 |
| | Scenario 2 | 5% | 36 | 3.38% | $21,799 | | Ending period | 12 | 24 | 36 | 48 | 60 |
| | Scenario 3 | 10% | 48 | 2.45% | $21,499 |
| | Scenario 4 | 15% | 60 | 2.36% | $21,299 |
| | | | | | | 1st Month |
| | | Car price | Down pmt | Total loan | Monthly pmt | Mo. principal | Mo. interest |
| | Scenario 1 |
| | Scenario 2 |
| | Scenario 3 |
| | Scenario 4 |
| | | | | | | | | | | | | Life of Loan |
| | | 1st year | | 2nd year | | 3rd year | | 4th year | | 5th year | | Total principal paid | Total interest paid |
| | | Total principal | Total interest | Total principal | Total interest | Total principal | Total interest | Total principal | Total interest | Total principal | Total interest |
| | Scenario 1 |
| | Scenario 2 |
| | Scenario 3 |
| | Scenario 4 |
ip7o
