Question: We are evaluating a project that costs $1,160,000, has a life of 10 years, and has no salvage value. Assume that depreciation is straight-line to
| We are evaluating a project that costs $1,160,000, has a life of 10 years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 44,000 units per year. Price per unit is $45, variable cost per unit is $20, and fixed costs are $645,000 per year. The tax rate is 24 percent and we require a return of 13 percent on this project. |
| a. | Calculate the accounting break-even point. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) |
| b-1. | Calculate the base-case cash flow and NPV. (Do not round intermediate calculations and round your NPV answer to 2 decimal places, e.g., 32.16.) |
| b-2. | What is the sensitivity of NPV to changes in the sales figure? (Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161.) |
| c. | What is the sensitivity of OCF to changes in the variable cost figure? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)
***Please use excel and show your work. Thank you! I was having a hard time with the last part. |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
