fill in yellow

finance answers

12+1 A B D F 6 7 9 11 2023 The Discounted Free Cash Flow Model for Total Equity 8 Initial capital investment = $5,000,000 and ANOWC = $500,000 Barking Dog Corporation 10 Years Ending December 31 First Year 12 2020 2021 2022 13 Initial year outlay 14 Capital Expenditure ($5,000,000) 15 ANOWC ($500,000) 16 17 Growth in Revenues per 18 Total revenue $14,500,000 19 Cost of Goods Sold 60% of revenues 20 Gross profit 21 22 Selling, general and administrative expenses constant each y 2.900.000 23 Earnings before interest, taxes, depr. & amort. (EBITDA) 24 25 Depreciation and amortization 100% bonus first year o all othe 5,000 000 26 Earnings before Interest and taxes (EBIT) 27 28 Federal and State Income Taxes on new capital 1,250,000 29 EBIT*(1-T) = Net Operating Profit After-Tax (NOPAT) (3,750,000) 30 **FCF2020 Year of Purchase (4,250,000) 31 32 Equipment Salvage Value in 2023, column E 33 Capital Gain/Loss in column E 34 Tax Rate 25% in column E 35 Net salvage value, 2023 in column E Question WACC DCF 1,000,000 + Download Share Rice Final F Eat sort Format Help All changes ved at MyFies/Download/tice Final QQ A 12- BLUSA 012-1 F D G H B 1.250,000 (3.750,000) (4.250,000) 1,000,000 28 Federal and State Income Taxes on new capital 29 EBIT*(1-T) = Net Operating Profit After Tax (NOPAT) 30 FCF2020 Year of Purchase 31 22 Equipment Salvage Value in 2023, column E 33 Capital Gain/Loss in column E 34 Tax Rate 25% in column E 35 Net salvage value, 2023 in column E 36 37 Add back depreciation and amortization 38 Add back ANOWC 39 FCF2023 40 PV of Discounted Free Cash Flow 41 Cumulative Discounted Free Cash Flow 5,000,000 500,000 40 45 46 G7 NPV IRR MIRR @ Reinvestment Rate of 10% Discounted FCF Payback 49 **FCF EBIT (1-1) + Dep - (CapExpenditure + ANOWC) 50 52 53 54 55 56 WACO DCF