Roseys Roses is considering several alternative means of financing an expan-sion. One alternative is to borrow $100,000 from a local bank, but another alter-native is to borrow this amount from investors by issuing bonds. Bothalternatives involve a 10-year debt period with annual payments. Modify theworkbook ch508 to compute a loan and bond analysis, naming and formattingcell ranges as appropriate. Assume an initial loan rate of 10 percent, an initialbond stated rate of 10 percent, and a market interest rate of 9 percent.a. Print the newly completed loan and bond worksheets in Value view,with your name and date printed in the lower left footer and the filename in the lower right footer.b. Use the Scenario Manager to create two loan scenarios called Best Caseand Worst Case. In the Best Case, the rate would be 9 percent andthe loan amount would be $125,000; in the Worst Case, the rate wouldbe 11 percent and the loan amount would be $90,000. The resultingcomparison values youre trying to predict are Payment, Total Pay-ments, and Total Interest. Print the resulting summary worksheet.c. Use the Scenario Manager to create two bond scenarios called BestCase and Worst Case. In the Best Case, the market rate would be8 percent and the stated rate would be 7 percent. In the Worst Case,the market rate would be 10 percent and the stated rate wouldbe 12 percent. The resulting comparison values youre trying to pre-dict are Proceeds, Total Interest Payments, and Total Interest Expense.Print the resulting summary worksheet.d. Use Excels goal seek feature to calculate the interest rate that thecompany would have to negotiate under the original loan analysis (inpart a) to achieve an annual payment of $15,000. Round the interestrate to two decimal places. Print the resulting worksheet in Valueview, with your name and date printed in the lower left footer and thefile name in the lower right footer.e. Use Excels goal seek feature to calculate the market rate necessary toachieve bond proceeds of $110,000. Round the interest rate to twodecimal places. Print the resulting worksheet in Value view, with yourname and date printed in the lower left footer and the file name in thelower right footer.