Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Refer to your cash flow estimation spreadsheet for this question. At the end of Year 4, what is the book value of the capital expenditures

Refer to your cash flow estimation spreadsheet for this question. At the end of Year 4, what is the book value of the capital expenditures required for Project A?image text in transcribed

Cash Flow Estimation and Analysis for Expansion Project A 2 4 Investment Outlays at Time = 0 CAPEX Building and Equipment ANOWC = Additional net operating working -$212,000 capital needed 3,500 Operating Cash Flows Over the Project's Life (Time - 1-4) Unit sales Sales price Variable cost per unit Sales revenues Units Price Variable costs -Units Cost/unit Fixed operating costs except depr'n 4,700 $65.00$65.00$65.00 $65.00 $1.018 $1.078$1.046 $1.046 $162,500 $204,750 $253,500 $305,500 73,12592,138 114,075137,475 35,00035,000 14,840 $178,085 $222,538 $180,875 $187,315 $15,585-$17,788$72,625 $118,185 47,274 -$9,351-$10,673 $43,575 $70,911 14,840 $60,609 $84,728 $75,375$85,751 2,500 3,150 3,900 10 12 13 14 15 35,00035,000 69,96095,400 10Depreciation: Accelerated from table below 31,800 Total operating costs 16 12EBIT (or Operating income) 18 14 | EBIT (1-T) = After-tax project operating income 2016 EBIT (1 - T) Depreciation 13Taxes on operating income 40% -6,234 7,115 29,050 17 19 15 Add back depreciation 69,96095,400 31,800 21 17 Terminal Cash Flows at Time = 4 2218 Salvage value (taxed as ordinary income) $25,000 Tax on salvage value 0.4 x (SV - BV of equipment at t-4) After-tax salvage value $10,000 $15,000 24 20 NOWC = Recovery of net operating working capital 21 $3,500 Project free cash flows = EBIT(1-T) DEP -CAPEX-NOWC 26 $215,500 $60,609 $84,728 $75,375$104,251 23 Text Unit sales

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

Dynamics Of International Finance

Authors: Ruchi Mehrotra Joshi

1st Edition

1685078389, 978-1685078386

More Books

Students also viewed these Finance questions