PLEASE SHOW IN EXCEL FORMULAS!

4. Suppose a firm issues a $10 million debenture maturing in 8 years and with an annual rate of 7%. Interest is paid annually at the end of the year. How much will the firm have paid out in total as of year 8, when it pays the interest plus principal? A B D E F 1 2 3 4 Suppose a firm issues a $10 million debenture maturing in 8 years and with an annual rate of 7%. Interest is paid annually at the end of the year. How much will the firm have paid out in total as of year 8, when it pays the interest plus principal? Principal Coupon Maturity (yrs.) FV of coupon pmts. Add debenture Total Value 5 6 7 8 9 10