Solve the question using VBA

Assume you purchase a bond for $1000, with a 5% coupon rate and exactly 10 years to maturity. Also assume interest paid at end of period

If you can reinvest the coupon payments at 4%, what is the future value of your investment at maturity?

If you can reinvest the coupon payments at 6%, what is the future value of your investment at maturity.

Assume you purchase a bond for $1000, with a 5% coupon rate and exactly 10 years to maturity. Also assume interest paid at end of period Ifyou can reinvest the coupon payments at 4%, what is the future value of your investment at maturity? investment at maturity Value in 10 Reinvestment rate years 4% 6% 10 10 Function FVBond(reinvestmentrate, n) Dim i As Integer End Function