Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
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

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

Step: 3

blur-text-image

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

International Financial Reporting And Analysis

Authors: David Alexander, Ann Jorissen, Martin Hoogendoorn

8th Edition

978-1473766853, 1473766850

More Books

Students also viewed these Finance questions

Question

=+b) Is MediaChips manufacturing process in control?

Answered: 1 week ago

Question

L A -r- P[N]

Answered: 1 week ago

Question

Compare different frameworks for HRD evaluation

Answered: 1 week ago