Question: Refer to your cash flow estimation spreadsheet for this question. What is the after-tax salvage value of the building modifications/equipment purchased for Project A? Cash
Refer to your cash flow estimation spreadsheet for this question. What is the after-tax salvage value of the building modifications/equipment purchased for Project A?
| Cash Flow Estimation and Analysis for Expansion Project A | ||||||||
| 0 | 1 | 2 | 3 | 4 | ||||
| Investment Outlays at Time = 0 | ||||||||
| CAPEX = Building and Equipment | -$212,000 | |||||||
| NOWC = Additional net operating working capital needed | -3,500 | |||||||
| Operating Cash Flows Over the Project's Life (Time = 1 - 4) | ||||||||
| Unit sales | 2,500 | 3,150 | 3,900 | 4,700 | ||||
| Sales price | $65.00 | $65.00 | $65.00 | $65.00 | ||||
| Variable cost per unit | $1.018 | $1.078 | $1.046 | $1.046 | ||||
| Sales revenues = Units Price | $162,500 | $204,750 | $253,500 | $305,500 | ||||
| Variable costs = Units Cost/unit | 73,125 | 92,138 | 114,075 | 137,475 | ||||
| Fixed operating costs except depr'n | 35,000 | 35,000 | 35,000 | 35,000 | ||||
| Depreciation: Accelerated from table below | 69,960 | 95,400 | 31,800 | 14,840 | ||||
| Total operating costs | $178,085 | $222,538 | $180,875 | $187,315 | ||||
| EBIT (or Operating income) | -$15,585 | -$17,788 | $72,625 | $118,185 | ||||
| Taxes on operating income | 40% | -6,234 | -7,115 | 29,050 | 47,274 | |||
| EBIT (1 T) = After-tax project operating income | -$9,351 | -$10,673 | $43,575 | $70,911 | ||||
| Add back depreciation | 69,960 | 95,400 | 31,800 | 14,840 | ||||
| EBIT (1 T) + Depreciation | $60,609 | $84,728 | $75,375 | $85,751 | ||||
| Terminal Cash Flows at Time = 4 | ||||||||
| Salvage value (taxed as ordinary income) | $25,000 | |||||||
| Tax on salvage value = 0.4 (SV BV of equipment at t = 4) | $10,000 | |||||||
| After-tax salvage value | $15,000 | |||||||
| NOWC = Recovery of net operating working capital | $3,500 | |||||||
| Project free cash flows = EBIT(1 T) + DEP CAPEX NOWC | -$215,500 | $60,609 | $84,728 | $75,375 | $104,251 | |||
| Depreciation | Accelerated | 1 | 2 | 3 | 4 | |||
| Cost: | $212,000 | Rate | 33% | 45% | 15% | 7% | ||
| Depreciation | $69,960 | $95,400 | $31,800 | $14,840 | ||||
| Project Evaluation @ WACC = | 9.44% | |||||||
| Accelerated | Formulas | |||||||
| NPV | $40,799.80 | =NPV(D43,F35:I35)+E35 | ||||||
| IRR | 17.194% | =IRR(E35:I35) | ||||||
| MIRR | 14.288% | =MIRR(E35:I35,D43,D43) | ||||||
| Payback | 2.95 | =G12+(-E35-F35-G35)/H35 | ||||||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
