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) 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)