EXCEL ASSIGNMENT FOR LADY HAWKINS ONLY
hbggiwsm2
ex_k-5.xlsxVehicle Loan
| Cape Medical | |||
| Annual Interest Rate | 5.75% | ||
| Term in Months | 48 | ||
| Van | Sedan | Compact | |
| Price | $ 42,000 | $ 23,000 | $ 15,000 |
| Vehicle Capacity (cubic feet) | 210 | 125 | 95 |
| Quantity to Purchase | 2 | 2 | 2 |
| Loan Amount | $ 84,000 | $ 46,000 | $ 30,000 |
| Monthly Payment | $1,963.13 | $1,075.05 | $701.12 |
| Delivery Capacity | 420 | 250 | 190 |
| Total Loan Amount | $ 160,000 | ||
| Total Monthly Payments | $3,739.29 | ||
| Total Delivery Capacity | 860 |
