Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started