Please show excel formulas and answers.

Home Insert Draw Page Layout Formulas Data Review View X Cut Calibri (Body) 11 A- A = = Wrap Text General Ly Copy Paste B I U. Merge & Center $ % .00 .00 Conditional Format Cell Insert Delete Format Format Formatting as Table Styles L41 X V fx A B C D E F G H 1 J K L M N P Q R 5 W NP Instructions: Enter formula to compute value for each blank cell Investment Variable # of Payments Per Year 12 12 12 12 Loan Amount S 100,000.00 100,000.00 $ 100,000.00 Annual Interest Rate 10.00% 10.00% 10.00% Term (years) 20 20 20 Periodic Payment 965.02 $ 965.02 $ 965.02 9 Future Value $ 1,465,614.73 10 11 12 13 14 15Home Insert Draw Page Layout Formulas Data Review View X Cut Calibri (Body) 11 A - A- Copy Paste Format B I U $E J36 X V fx A B C D E F 1 Instructions: Enter formula to compute value for each blank cell 2 3 Investment Variable 4 # of Payments Per Year 12 12 12 12 5 Loan Amount 100,000.00 100,000.00 $ 100,000.00 6 Annual Interest Rate 10.00% 10.00% 10.00% 7 Periodic Rate Term (years) 20 20 20 9 Total # of Payments 10 Periodic Payment 965.02 5 965.02 5 965.02 11 Future Value 5 1,465,614.73 12