This isn’t exactly a physics question, but it does get you deeper into one of th

This isn’t exactly a physics question, but it does get you deeper into one of the most useful financial functions available in Excel.The pmt() function in Excel let’s you calculate what the payment on a load would be. Suppose you finance a car purchase. Take your loan to be $24,000 with an annual interest rate of 16% compounded monthly and financed for 5 years. What would you need to put into the pmt function for rate, nper, and pv in order to correctly calculate your monthly payment? What would you end up paying for the car in the end?
Requirements: 1 page

Leave a comment

Your email address will not be published. Required fields are marked *