Question: Please show work, prefer excel sheet with the formulas used Thank you!! Answer all You are considering a new product launch. The project will cost

Please show work, prefer excel sheet with the formulas used Thank you!! Answer all

Please show work, prefer excel sheet with the formulas used Thank you!!

You are considering a new product launch. The project will cost $2,075,000, have a four- year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 220 units per year, price per unit will be $18,800, variable cost per unit will be $12,350, and fixed costs will be $610,000 per year. The required return on the project is 11 percent, and the relevant tax rate is 25 percent. Based on your experience, you think the unit sales, variable cost, and fixed cost projections given here are probably accurate to within 10 percent. What are the upper and lower bounds for these projections? What is the base-case NPV? What are the best-case and worst-case scenarios? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Round your NPV answers to 2 decimal places, e.g., 32.16. Round your other answers to the nearest whole number, e.g. 32.) NPV Unit Sales Variable Cost Fixed Costs 220 s 12,350 $ 610,000 Scenario Base Best Worst b. Evaluate the sensitivity of your base-case NPV to changes in fixed costs. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. What is the cash break-even level of output for this project (ignoring taxes)? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) d-1. What is the accounting break-even level of output for this project? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) d-2. What is the degree of operating leverage at the accounting break-even point? (Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161.) b. ANPVIAFC c. Cash break-even d-1. Accounting break-even d-2. Degree of operating leverage

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!