Dream Car Calculations
Principal (loan amount) = Sale Price – Down Payment
Total Interest = Principal * Annual Interest Rate * Loan Term (in years)
Total Amount Paid = Principal + Total Interest
Number of Monthly Payments = Loan Term * 12
Monthly Payment = Total Amount Paid / Number of Monthly Payments
Use the formulas in Excel to calculate these values