right answer with Excel

2. Monthly Payments and Finance Charges, Kimberly Jensen of Storm Lake, Iowa, wants to buy some living room furniture for her new apartment. A local store offered credit at an APR of 16 percent, with a maximum term of four years. The furniture she wishes to purchase costs $4,800, with no down payment required. Make the following calculations: (a) What is the amount of the monthly payment if she borrowed for four years? 4x12 - 48 16/12 = 1.3333 -4,800 PMT CPT N IY JFV (b) What are the total finance charges over that four year period? Hint: (PMT x 48) - 4,800 = (c) How would the payment change if Kimberly reduced the loan term to three years? lir 3 x 12 = 36 16/12 = 1.3333 -4,800 CPT PV PMT FV (d) What are the total finance charges over that three year period? (c) How would the payment change if Kimberly reduced the loan term to three years? I/Y 3 x 12 - 36 16/12 - 1.3333 -4,800 CPT PV PMT FV (d) What are the total finance charges over that three year period? Hint: (PMT x 36) - 4,800 = (c) How would the payment change if she could afford a down payment of $500 with four years of financing? INY 4 x 12 = 48 16/12 = 1.3333 PV (4,800 - 500) -4,300 PMT CPT FV o