l1-1.xls
L1
| | AS-IS Analysis |
| | Rate | Payment Period | Amount Financed | Finance Charge |
| | 8% | 5 | $ 5,000.00 | $ 1,083.00 |
| Payment Monthly | $101.38 |
| | Sensitivity analysis |
| | Interest Rate |
| | | 7% | 7.50% | 8.00% | 8.50% | 9.00% |
| | $ 3,000.00 | $59.40 | $60.11 | $60.83 | $61.55 | $62.28 |
| | $ 4,000.00 | $79.20 | $80.15 | $81.11 | $82.07 | $83.03 |
| | $ 5,000.00 | $99.01 | $100.19 | $101.38 | $102.58 | $103.79 |
| Amount Financed | $ 6,000.00 | $118.81 | $120.23 | $121.66 | $123.10 | $124.55 |
| | $ 7,000.00 | $138.61 | $140.27 | $141.93 | $143.62 | $145.31 |
| | $ 8,000.00 | $158.41 | $160.30 | $162.21 | $164.13 | $166.07 |
| | $ 9,000.00 | $178.21 | $180.34 | $182.49 | $184.65 | $186.83 |
| | $ 10,000.00 | $198.01 | $200.38 | $202.76 | $205.17 | $207.58 |
neacy
