0 1 2 13 15 16 17 P6 21 Modified use the modified numbers in...

90.2K

Verified Solution

Question

Basic Math

image

0 1 2 13 15 16 17 P6 21 Modified use the modified numbers in bold below You ve just bought a new 85 inch flat screen TV for 2 499 and the store you bought it from offers to let you finance the entire package at an annual rate of 12 compounded monthly If you take the financing and make monthly payments of 83 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 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 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 Total payments PV Interest Paid 2 499 12 00 12 36 00 months 83 00 800 8 33 2 499 2 490 67 number of payme 489 3 00 years 1836 50 4150 36

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students