Ch 10 Advanced Problem 2 Chapter 13 Problem 18 Chapter 12 Problem 17 Ch 11 Advanced problem 1 ADVANCED PROBLEMS FOR SPREADSHEET APPLICATION These problems are available in MyFinanceLab. 1. Erosion costs. Ice Cream City plans to introduce a new flavor, wild berry, to its current set of five flavors, which include vanilla, French vanilla, strawberry, chocolate, and mint chocolate. The new sales of wild berry are projected as follows: The expected sales will come from both new customers and current customers who switch flavors. The current projected sales for the existing flavors (assuming no introduction of the new flavor) are Projected Sales However, if the company introduces wild berry, it will cut into the sales of the original flavors based on the following estimates: Percentage of Sales Erosion Here are the revenue and cost per unit of ice cream for Ice Cream City: Vanilla: current revenue of $3.05 per unit and cost of $1.22 per unit French vanilla: current revenue of $3.15 per unit and cost of $1.38 per unit Strawberry: current revenue of $3.25 per unit and cost of $1.41 per unit Chocolate: current revenue of $3.25 per unit and cost of $1.57 per unit Mint chocolate: current revenue of $3.25 per unit and cost of $1.63 per unit Wild berry: projected revenue of $3.25 per unit and cost of $1.44 per unit Find the annual erosion of revenue, the cost savings, and the net cash flow with the new ice cream. Ch 11 Advanced problem 1 Changing WACC and optimal choice. Austin Enterprises is currently an all-equity firm. The firm is considering selling debt (bonds) and retiring some of the equity. However, at each level of debt, debt becomes more expensive (cost of debt is rising), and the riskiness of the equity also rises with more and more debt. Using a spreadsheet, determine the best combination of debt and equity for Austin Enterprises if · � The current beta of Austin Enterprises is 0.85. · � The current market return is 12%. · � The current risk-free rate is 3%. · � The total equity is 20,000,000 shares at $25 per share. · � Debt is sold in units of $2,000,000. · � The first unit of debt has a cost of 7.5%. · � The tax rate of Austin Enterprises is 40%. · � For each additional unit of debt (each additional $2,000,000), the cost of debt rises by 0.85%, and the beta of Austin Enterprises rises by 0.025. Where is the WACC the lowest? Graph the results of the changing WACC Chapter 12 Problem 17 Working capital and capital budgeting. Farbuck’s Tea Shops is thinking about opening another tea shop. The incremental cash flow for the first five years is as follows: · � Initial capital cost = $3,500,000 Operating cash flow for each year = $1,000,000 Recovery of capital assets after five years = $250,000 The hurdle rate for this project is 12%. If the initial cost of working capital is $500,000 for items such as teapots, teacups, saucers, and napkins, should Farbuck’s open this new shop if it will be in business for only five years? What is the most it can invest in working capital and still have a positive net present value? Chapter 13 Problem 18 Working capital and capital budgeting. Working capital investment is 25% of the anticipated first year sales for Wally’s Waffle House. The first-year sales are currently projected at $4,300,000. The incremental cash flow (not including working capital investment) is · � Initial cash flow = $13,700,000 outflow Cash flow years 1 through 10 = $2,850,000 What is the internal rate of return of the ten-year project with working capital factored into the cash flow? What is the net present value at a 15% weighted average cost of capital? What is the maximum investment in working capital for an acceptable project with a 15% weighted average cost of capital?
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer