I need help with the figuring out the correct excel formula I should be using in the attached template, my class text did not give any similar examples and I am coming up short with internet searches. Thanks

Pay all of the interest (8% per year) and principal in one lump sum at the end of 5 years Amount $ Period (years) Interes rate 300,000 5 8% FV= PV (1 + r)n Answer- Total Payment Interest Paid Refer to the Solved Example 6 on Page 84 of your text. Pay interest at the rate of 8% per year for 4 years and then a final payment of interest and principal at the end of the 5 Amount $ 300,000 Period (years) 5 Interes rate 8% Answer Annual Interest PaymentYear 5 Payment Total PaymentInterest Paid- Refer to the Solved Example 6 on Page 84 of your text. cipal at the end of the 5th year; Scenario #1 Scenario #2 Total Payment Interest paid $ - $ $ - $ - Which of the scenarios is the best option? Answer: Refer to the Solved Example 6 on Page 84 of your text