Sheet1
| Car Loan Amortization |
|
| |
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
| |
Three Year Lease |
|
|
Bank Loan |
| Retail Price |
Interest Rate |
Total Interest |
Monthly Payment |
Resale Value |
Loss |
|
Interest Rate |
Total Interest |
Monthly Payment |
Resale Value |
Loss |
| $ 12,400.00 |
18% |
$2,232.00 |
$ 406.44 |
$5,440.00 |
######### |
|
11% |
$1,364.00 |
$ 382.33 |
$7,440.00 |
$6,324.00 |
| |
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
| Income |
|
|
|
|
|
|
|
|
|
|
|
| Net Pay |
$2,024.80 |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
| Expenses |
|
|
|
|
|
|
|
|
|
|
|
| Rent |
$ 600.00 |
|
|
|
|
|
|
|
|
|
|
| Food |
300 |
|
|
|
|
|
|
|
|
|
|
| Phone |
45 |
|
|
|
|
|
|
|
|
|
|
| Utilities |
100 |
|
|
|
|
|
|
|
|
|
|
| Incidents |
250 |
|
|
|
|
|
|
|
|
|
|
| Car Payment |
$ 382.33 |
|
|
|
|
|
|
|
|
|
|
| Insurance |
$ 91.67 |
|
|
|
|
|
|
|
|
|
|
| Gas |
70 |
|
|
|
|
|
|
|
|
|
|
| Subtotal |
$1,839.00 |
|
|
|
|
|
|
|
|
|
|
| Contingency: 10% |
$ 183.90 |
|
|
|
|
|
|
|
|
|
|
| Total |
$2,022.90 |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
| Surplus |
$ 1.90 |
|
|
|
|
|
|
|
|
|
|
Last Updated on 10/5/99
By lanpherg