# Wine Depot is considering several alternative means of financing an expansion. One alternative is to borrow \$500,000 from a local bank, but another alternative is

Wine Depot is considering several alternative means of financing an expansion. One alternative is to borrow \$500,000 from a local bank, but another alternative is to borrow this amount from investors by issuing bonds. Both alternatives involve a 3-year debt period with quarterly payments. Modify the workbook ch5-06 to compute a loan and bond analysis, naming and formatting cell ranges as appropriate. Assume an annual loan rate of 3 percent, an annual bond stated rate of 3 percent, and a market annual interest rate of 3.5 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 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.5 percent and the loan amount would be \$550,000; in the Worst Case, the rate would be 3.5 percent and the loan amount would be \$450,000. The resulting comparison values you’re trying to predict are Payment, Total Payments, and Total Interest. Print the resulting summary worksheet. 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 market rate would be 4.0 percent and the stated rate would be 3.9 percent. (Again, you’ll need to place two cell references, separated by a 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 the company would have to negotiate under the original loan analysis (in part a) to achieve a quarterly payment of \$42,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. Use Excel’s goal seek feature to calculate the market rate necessary to achieve bond proceeds of \$495,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.

(550 words)

Approximate price: \$22

## How it Works

1

It only takes a couple of minutes to fill in your details, select the type of paper you need (essay, term paper, etc.), give us all necessary information regarding your assignment.

2

Once we receive your request, one of our customer support representatives will contact you within 24 hours with more specific information about how much it'll cost for this particular project.

3

After receiving payment confirmation via PayPal or credit card – we begin working on your detailed outline, which is based on the requirements given by yourself upon ordering.

4

Once approved, your order is complete and will be emailed directly to the email address provided before payment was made!