Excel Intermediate
Shavone05
vehicle_purchase.xlsxVehicle Loan
| Poppies | |||
| Annual Interest Rate | 6.75% | ||
| Term in Months | 48 | ||
| Van | Sedan | Compact | |
| Price | $ 30,000 | $ 21,000 | $ 17,000 |
| Vehicle Capacity | 20 | 10 | 6 |
| Quantity to Purchase | 2 | 2 | 2 |
| Loan Amount | $ 60,000 | $ 42,000 | $ 34,000 |
| Monthly Payment | $1,429.83 | $1,000.88 | $810.23 |
| Delivery Capacity | 40 | 20 | 12 |
| Total Loan Amount | $ 136,000 | ||
| Total Monthly Payments | $3,240.94 | ||
| Total Delivery Capacity | 72 |
