Use the b. ments and bond proceeds. Print the resuld would have to pay under the original bond analysis (in part a) to achieve bond proceeds of $2,600,000. Print the resulting worksheet in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer. 3, 3.5, 4.5, and 6 percent to c. Chapter 5 Case Problem 1: KELLY'S BOUTIQUE Kelly's Boutique is contemplating several alternative means of financing expansion. One alternative is to borrow $425,000 from a local bank; another al- ternative is to borrow this amount from investors by issuing bonds. Both alter- natives involve a 5-year debt period. Modify the workbook file ch5-05 to compute a loan and bond analysis. Name and format cell ranges as Assume an initial loan rate of 3 percent, an initial bond stated rate of 3 percent, and a market interest rate of 3.5 percent. an appropriate. 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 file name in the lower right footer. b. Use the Scenario Manager to create two loan scenarios called Best Case and Worst Case. In the Best Case, the rate would be 2.8 percent and the loan amount would be $450,000; in the Worst Case, the rate would be 3.2 percent and the loan amount would be $400,000. (Hint: You'll need to place two cell references, separated by in the Changing cells: text box.) The resulting comparison values you're trying to predict est. Print the resulting summary worksheet. a comma, Payment, Total Payments, and Total Inter- are c. Use the Scenario Manager to create two bond scenarios called Best Case and Worst Case. In the Best Case, the market rate would be 2.9 percent and the stated rate would be 2 percent; in the Worst Case, the 12-03 24-03 8-ol - ol Loan and Bond Amortization Cl market rate would be 3.8 percent and the stated rate would be 4 per cent. (Again, you'll need to place two cell references, separated by comma, in the Changing cells: text box.) The resulting comparison values you're trying to predict are Proceeds, Total Interest Payments, and Total Interest Expense. Print the resulting summary worksheet. d. Use Excel's goal seek feature to calculate the interest rate that the company would have to negotiate under the original loan analysis (in part a) to achieve a payment of $90,000. Round the interest rate to two decimal pla- ces. Print the resulting worksheet in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer. a Use Excel's goal seek feature to calculate the market rate necessary to achieve bond proceeds of $430,000. Round the interest rate to two decimal places. Print the resulting worksheet in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer. e. hapter 5 Case Problem 2: VINE DEPOT ine Depot is considering several alternative means of financing an expansion. e alternative is to borrow $500,000 from a local bank, but another alternative to borrow this amount from investors by issuing bonds. Both alternatives 3-year debt period with quarterly payments. Modify the workbook olve a 06 to compute a loan and bond analysis, naming and formatting cell ranges Use the b. ments and bond proceeds. Print the resuld would have to pay under the original bond analysis (in part a) to achieve bond proceeds of $2,600,000. Print the resulting worksheet in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer. 3, 3.5, 4.5, and 6 percent to c. Chapter 5 Case Problem 1: KELLY'S BOUTIQUE Kelly's Boutique is contemplating several alternative means of financing expansion. One alternative is to borrow $425,000 from a local bank; another al- ternative is to borrow this amount from investors by issuing bonds. Both alter- natives involve a 5-year debt period. Modify the workbook file ch5-05 to compute a loan and bond analysis. Name and format cell ranges as Assume an initial loan rate of 3 percent, an initial bond stated rate of 3 percent, and a market interest rate of 3.5 percent. an appropriate. 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 file name in the lower right footer. b. Use the Scenario Manager to create two loan scenarios called Best Case and Worst Case. In the Best Case, the rate would be 2.8 percent and the loan amount would be $450,000; in the Worst Case, the rate would be 3.2 percent and the loan amount would be $400,000. (Hint: You'll need to place two cell references, separated by in the Changing cells: text box.) The resulting comparison values you're trying to predict est. Print the resulting summary worksheet. a comma, Payment, Total Payments, and Total Inter- are c. Use the Scenario Manager to create two bond scenarios called Best Case and Worst Case. In the Best Case, the market rate would be 2.9 percent and the stated rate would be 2 percent; in the Worst Case, the 12-03 24-03 8-ol - ol Loan and Bond Amortization Cl market rate would be 3.8 percent and the stated rate would be 4 per cent. (Again, you'll need to place two cell references, separated by comma, in the Changing cells: text box.) The resulting comparison values you're trying to predict are Proceeds, Total Interest Payments, and Total Interest Expense. Print the resulting summary worksheet. d. Use Excel's goal seek feature to calculate the interest rate that the company would have to negotiate under the original loan analysis (in part a) to achieve a payment of $90,000. Round the interest rate to two decimal pla- ces. Print the resulting worksheet in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer. a Use Excel's goal seek feature to calculate the market rate necessary to achieve bond proceeds of $430,000. Round the interest rate to two decimal places. Print the resulting worksheet in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer. e. hapter 5 Case Problem 2: VINE DEPOT ine Depot is considering several alternative means of financing an expansion. e alternative is to borrow $500,000 from a local bank, but another alternative to borrow this amount from investors by issuing bonds. Both alternatives 3-year debt period with quarterly payments. Modify the workbook olve a 06 to compute a loan and bond analysis, naming and formatting cell ranges