For the following Excel Goal Seek and Scenario Manager is used to calculate values that corresponds to part A (Note for B and C)

A) Use an Excel sheet that calculates the bond proceeds for a $2,500,000,10-year, 4 percent stated interest bond issued, when the market interest rate is 5% percent. Include a bond amortization schedule

B) Use the Scenario Manager to create a scenario using stated rates of 3%, 3.5%, 4.5%, and 6% percent to calculate alternative annual interest payments and bond proceeds.

c) Use Excels goal seek feature to calculate the stated interest rate it would have to pay under the original bond analysis ((in part a)) to achieve bond proceeds of $2,600,000.