In: Finance
|
We are evaluating a project that costs $500,000, has an eight-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 50,000 units per year. Price per unit is $40, variable cost per unit is $25, and fixed costs are $600,000 per year. The tax rate is 35 percent, and we require a return of 12 percent on this project. |
| a-1 |
Calculate the accounting break-even point. (Do not round intermediate calculations. Round your answer to the nearest whole number, e.g., 32.) |
| Break-even point | 44166 units |
| a-2 |
What is the degree of operating leverage at the accounting break-even point? (Do not round intermediate calculations. Round your answer to 3 decimal places, e.g., 32.161.) |
| DOL 10.6 |
| b-1 |
Calculate the base-case cash flow and NPV. (Do not round intermediate calculations. Round your cash flow answer to the nearest whole number, e.g., 32. Round your NPV answer to 2 decimal places, e.g., 32.16.) |
| Cash flow | $119375 | |
| NPV | $93007.25 | |
| b-2 |
What is the sensitivity of NPV to changes in the sales figure? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) |
| ΔNPV/ΔQ | $ _________ |
| c. | What is the sensitivity of OCF to changes in the variable cost figure? (Negative amount should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to the nearest whole number, e.g., 32. ) |
| ΔOCF/ΔVC | $
________ |
Accounting break-even = (FC + Depreciation) / (P - VC) = (600,000 + 62,500) / (40 - 25) = 44,167
At break-even point, DOL = 1 + FC / OCF = 1 + 662,500 / 62,500 = 11.6
| 0 | 1 - 8 | |
| Investment | -500,000 | |
| Sales | 2,000,000 | |
| VC | -1,250,000 | |
| FC | -600,000 | |
| Depreciation | -62,500 | |
| EBT | 87,500 | |
| Tax | -30,625 | |
| Net Income | 56,875 | |
| Cash Flow | -500,000 | 119,375 |
| NPV | $1,093,012.00 |
Cash Flow = Net Income + Depreciation
NPV = PV of cash flows from year 1 to 8 - Initial Investment.
PV can be calculated using PV function in excel or calculator
N = 8, I/Y = 12%, PMT = 119,375, FV = 0
=> Compute PV = $1,593,012
NPV = 1,593,012 - 500,000 = $1,093,012
ΔNPV/ΔQ is the change in NPV when Q is changed by 1 unit.
If Q = 50,001 then NPV = $1,093,060.43 => ΔNPV/ΔQ = 1,093,060.43 - 1,093,012 = $48.43
ΔOCF/ΔVC is the change in OCF when VC is changed by 1 unit.
If VC = $26 per unit, then OCF = $86,875 => ΔOCF/ΔVC = 86,875 - 119,375 = -32,500