Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance For Nonfinancial Managers Beginners Handbook For Finance

Authors: Murugesan Ramaswamy

1st Edition

1516973801, 978-1516973804

More Books

Students also viewed these Finance questions

Question

3. Identify the methods used within each of the three approaches.

Answered: 1 week ago