Excel help!
cla012
exploring_e06_grader_a1.xlsxAuto Loan
| Auto Loan Calculation | One-Variable Data Table: Auto Prices | Two-Variable Data Table: Purchase Price and APR | |||||||||
| $460.41 | |||||||||||
| Income | Auto Loan Information | ||||||||||
| Annual Income | $ 50,000.00 | Purchase price | $ 30,000.00 | ||||||||
| Monthly Income | $ 4,166.67 | Down payment | $ 5,000.00 | ||||||||
| Income tax rate | 6.25% | Amount of loan | $ 25,000.00 | ||||||||
| Monthly take home | $ 3,906.25 | Interest rate | 4.00% | ||||||||
| Periodic rate | 0.33% | ||||||||||
| Fixed Expenses | Total number of payments | 60 | |||||||||
| Rent | $ 1,200.00 | ||||||||||
| Utilities | $ 125.00 | Loan Summary | |||||||||
| Total | $ 1,325.00 | Monthly payment | $460.41 | ||||||||
| Total value repaid | $27,624.78 | ||||||||||
| Variable Expenses | Total interest paid | $2,624.78 | |||||||||
| Dinning out | $ 250.00 | Percentage of available capital | 23% | ||||||||
| Entertainment | $ 150.00 | Insurance rate based on total car price | 6% | ||||||||
| Misc | $ 150.00 | Annual insurance premium | $1,500.00 | ||||||||
| Total | $ 550.00 | ||||||||||
| Available capital | $ 2,031.25 | ||||||||||
| . | |||||||||||
