Question: 3) Refer to the data sheet DCF from BlackBoard. Complete the calculations in the yellow shaded areas. The Discounted Free Cash Flow Model for Total

 3) Refer to the data sheet DCF from BlackBoard. Complete the
calculations in the yellow shaded areas. The Discounted Free Cash Flow Model

3) Refer to the data sheet DCF from BlackBoard. Complete the calculations in the yellow shaded areas. The Discounted Free Cash Flow Model for Total Equity Initial capital investment = $5,000,000 and ANOWC = $500,000 Barking Dog Corporation Years Ending December 31 - Forecasfirst-Year- 2020 2021 2022 Initial year outlay Capital Expenditure ($5,000,000) ANOWC ($500,000) 2023 10% Growth in Revenues per year $14,500,000 2,900,000 5,000,000 Total revenue Cost of Goods Sold 60% of revenues Gross profit Selling, general and administrative expenses constant each year Earnings before interest, taxes, depr. & amort. (EBITDA) Depreciation and amortization 100% bonus first year all others Earnings before Interest and taxes (EBIT) Federal and State Income Taxes on new capital EBIT*(1-T) = Net Operating Profit After-Tax (NOPAT) **FCF2020 Year of Purchase Equipment Salvage Value in 2023, column E Capital Gain/Loss in column E Tax Rate 25% in column E Net salvage value, 2023 in column E Add back depreciation and amortization Add back ANOWC **FCF2023 PV of Discounted Free Cash Flow Cumulative Discounted Free Cash Flow 1.250.000 (3,750,000) (4,250,000) 1,000,000 5,000,000 500,000 NPV IRR MIRR @ Reinvestment Rate of 10% Discounted FCF Payback **FCF = EBIT "(1-T) + Dep - (CapExpenditure + ANOWC)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!