In cell B15, insert the RATE function to calculate the necessary monthly rate given the NPER, proposed monthly payment, and loan. Make sure the result is positive. Finally, you want to convert the...

Extracted text: In cell B15, insert the RATE function to calculate the necessary monthly rate given the NPER, proposed monthly payment, and loan. Make sure the result is positive. Finally, you want to convert the monthly rate to an APR. In cell B16, insert a formula to calculate the APR for the monthly rate in cell B15. 22 Insert a footer on all sheets with your name on the left side, the sheet name code in the center, and the file name code on the right side. 23 Save and close Exp19_Excel_Ch07_CapAssessment_Shipping.xlsx. Exit Excel. Submit the file as directed. 21


Extracted text: A E F G H 1 Loan Information Payment # Beg Balance Interest Principal End Balance 2 Loan (PV) 3 АPR 4 Monthly Rate $ 75,000.00 $ 75,000.00 $ $ 1 5.00% 2 0.42% 3 5 Years for Loan 6 4 6 NPER 72 5 $ 7 Monthly Payment $1,207.87 $ 8 9 Cumulative Totals after Year 2 $ 10 Interest $ 11 Principal Paid 10 $ 12 $ $ 11 13 What if the goal is $1,150 monthly payment? 14 Monthly Payment 12 $ 1,150.00 13 15 Monthly Rate Needed 16 APR Needed 14 $ 15 $ 17 16 18 17 $ 19 18 20 19 $ 21 20 2$ 22 21 $ 23 22 24 23 $ 25 24 $ 26 27 28 29 30 31 32 33 34 Week Stats Map Loan LO 6789 B.