Reference no: EM13948578
The Discounted Free Cash Flow Model for Total Equity Initial capital investment = $5,000,000 and NWC Investment = $500,000 Barking Dog Corporation Years Ending December 31 First Year |------------------------------------------------------------------------------------ Forecast ----------------------------------------------------------------------------------| 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 Total revenue $14,500,000 Cost of Goods Sold 7,250,000 Gross profit 7,250,000 Selling, general and administrative expenses 2,900,000 Earnings before interest, taxes, depr. & amort. (EBITDA) 4,350,000 Depreciation and amortization (MACRS) 1,000,000 Earnings before Interest and taxes (EBIT) 3,350,000 Federal and State Income Taxes 1,172,500 Net Operating Profit After-Tax (NOPAT) 2,177,500 Equipment Salvage Value in 2024, column K Equipment Salvage Value 1,000,000 Capital Gain/Loss in column K Capital Gain/Loss Federal Capital Gain/Loss Tax Rate 20% in column K Federal Capital Gain/Loss Tax Rate 20% Terminal value, 2024 in column K Add back Net Working Capital Terminal value, 2024 Present Value of Free Cash Flows (K Expenditures informational) (5,000,000) Initital Increase in Net Working Capital (informational) (500,000) Add back depreciation and amortization 1,000,000 Subtract sum of Capital Expenditures AND (5,000,000) New Net Working Capital (500,000) Free Cash Flow 2015 (See Ch 3-15 on PowerPoint) ($2,322,500) PV of Discounted Free Cash Flow Cumulative Discounted Free Cash Flow NPV IRR MIRR @ Reinvestment Rate of 10% Discounted FCF Payback
|
NPV and profitability index of the truck purchase decision
: Lowell Trucking Corporation is planning to purchase a new truck. The cost of the new truck will be $100,000. The new truck will be used for six years, but will require major repairs every two years at a cost of $25,000 each time. What is the NPV and ..
|
|
What is the profitability index of project
: Scrooge Inc. has two mutually exclusive projects available whose cash flows are: Year 0 1 2 3 4 5 Project A -20,000 12,000 8,000 6,000 4,000 2,000 Project B -20,000 9,000 6,000 6,000 8,000 6,000 The required rate of return is 14% What is the NPV of P..
|
|
Concepts associated with making capital investment decisions
: Identify and define up to three concepts associated with making capital investment decisions such as cash flows, sunk costs, opportunity costs, or others. Discuss why your selected concepts are important for the investor to factor into the decision-m..
|
|
What is the current market value of the stock
: Test Sales, Inc. (TSI) just paid a common stock dividend of $2.50 per share. Its sales are expected to grow at a rate of 20% for the years 1 to 3, at 16% for years 4 and 5, and at 6% per year indefinitely thereafter. Dividend growth is expected to ma..
|
|
The discounted free cash flow model
: The Discounted Free Cash Flow Model for Total Equity Initial capital investment = $5,000,000 and NWC Investment = $500,000 Barking Dog Corporation Years Ending December 31 First Year
|
|
Define the various capital budgeting methods
: Define the various capital budgeting methods such as net present value (NPV), internal rate of return (IRR), and so on, and explain how they differ from one another. Identify which, if any, of the methods discussed might be superior to the others and..
|
|
Find the amount of rent that end of each year to break even
: David Beckham has bought a house for $250,000, of which $50,000 is the value of the land. Beckham expects that the value of the property will increase at the compound rate of 4% per year. He will rent the house for the next five years and then sell i..
|
|
Expected rate of return-bond valuation
: Holiday Hiatus, a luxury vacation rental company, issued 15 year bonds to raise the capital needed to construct a five-star, all-inclusive tropical resort on the island of Bermuda. Those bonds are selling in the open market for $1,405, a premium in ..
|
|
Normally distributed with an average historical return
: Assume that annual returns on small-company stocks are normally distributed with an average historical return of 17.1% and a standard deviation of 32.6%. What is the probability that annual return on small-company stocks is positive?
|