Question: can you help me inputing the exact inputs into excel, I Know the hardcode formula but not how to exactly input in excel. The problem

can you help me inputing the exact inputs into excel, I Know the hardcode formula but not how to exactly input in excel. The problem in excel is modified from the book. Thank you

 can you help me inputing the exact inputs into excel, I

M P6-21 Modified (use the modified numbers in bold below) You've just bought a new 85 inch QLED Smart TV for $2,819.59 and the store you bought it from offers to let you finance the entire package at an annual rate of 13% compounded monthly. If you take the financing and make monthly payments of $95, how long in years) will it take to pay off the loan? How much will you pay in interest over the life of the loan? Hint: Use the NPER function in Excel to solve the problem. The PV figure is the amount you are financing PV 1 m nper pmt FV months years + 3 9 0 Total payments PV Interest Paid 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 49

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!