Question

In: Finance

• A project to replace Dr. Robert Doback’s boat requires an initial investment of $250,000 and...

• A project to replace Dr. Robert Doback’s boat requires an initial investment of $250,000 and is expected to produce operating earnings (before depreciation and tax (EBITDA)) of $60,000 per year for 5 years

• Prestige Worldwide pays corporate taxes at a rate of 22% and can depreciate the initial investment for tax purposes at 25% in each of the first four years

• Their public debt trades at 4% and they estimate their cost of equity at 14%, the debt/equity composition is 30/70

• Calculate WACC, the project NPV and IRR

Solutions

Expert Solution

Answer: Formula for weighted average cost of capital

WACC = Wd * Cost of debt * (1 - tax rate) + We * Cost of equity

Wd = 0.3 , We = 0.7

Cost of Debt = 4% , Cost of equity = 14% , tax rate = 22%

WACC = 0.3 * 4% *(1-0.22) + 0.7 * 14%

WACC = 10.736%

Present value formula = net cash flow / ( 1+ wacc rate ) ^ ( no of years)

Project NPV

Year 0 1 2 3 4 5
Initial Investment -250000
EBITDA 60000 60000 60000 60000 60000
Depreciation 62500 62500 62500 62500 0
EBIT -2500 -2500 -2500 -2500 60000
Tax 0 0 0 0 13200
Net Cash flow -250000 60000 60000 60000 60000 46800
Present value -250000 54183 48930 44186 39902 28106
NPV -34693
IRR -5%

As you can see in this for the first 4 years our net cash flow is in negative after removing depreciation so there will be no tax

In the fifth when depreciation is 0 we will have 60000 cash flow which will be taxed at 22%

As both the NPV and IRR are in negative which tells us that this project is not beneficial for us


Related Solutions

A firm is considering a project that requires an initial investment of $250,000. The life of...
A firm is considering a project that requires an initial investment of $250,000. The life of this project is five years. Cash flows for each year are estimated as follows: Year 1 Year 2 Year 3 Year 4 Year 5 $80,000 $120,000 $160,000 $40,000 -$90,000 The cost of capital of this project is 8%. Calculate the profitability index and make a decision.
Dr. Chan is considering a four year project. The project requires an initial investment of $10,000,000...
Dr. Chan is considering a four year project. The project requires an initial investment of $10,000,000 to buy new equipment. The equipment will be depreciated straight line to zero over the project’s life. The company believes it can generate $5,000,000 in pretax revenues in year 1. Revenues will increase at 20% per year. Total pretax operating cost would be 40% of the pretax revenues. Net working capital will be 20% of the pretax revenue for the year. Net working capital...
A firm is planning an investment in a project. The initial investment is 250,000. The project...
A firm is planning an investment in a project. The initial investment is 250,000. The project returns $100,000 cash at the end of one year. At the end of second year the project returns cash of amount $F. These are only cash flows from the project. If the IRR for the project is 10%, what is the amount $F?
1).A project requires an initial investment of $973,000. The projects generates cash flows of $250,000 in...
1).A project requires an initial investment of $973,000. The projects generates cash flows of $250,000 in year 1, $300,000 in year 2, $300,000 in year 3, $400,000 in year 4 and $400,000 in year 5. If the required rate of return for the project is 12 percent, the payback period is ____________ and the discounted payback period is _______________. A).3.7 years; 4.5 years B).2.8 years; 3.9 years C). 2.8 years; 4.2 years D).3.3 years; 3.9 years E).3.3 years; 4.2 years...
You are investing in a project that requires an initial investment of $500,000. The project will...
You are investing in a project that requires an initial investment of $500,000. The project will last for 10 years with the following additional cash flows (CF) at the end of each year: If the discount rate is 10%, calculate the payback periods in Excel for both the methods below; Years 1 2 3 4 5 6 7 8 9 10 CF -500,000 80,000 100,000 100,000 120,000 140,000 150,000 150,000 150,000 150,000 a) Payback Method [10] b) Discounted Payback Method...
Q1) A project requires an initial investment of $5,000. It is expected that the project will...
Q1) A project requires an initial investment of $5,000. It is expected that the project will last 3 years and generate net cash flows of $3,500 for each of these years. If the discount rate for the project is 10%, the discounted payback period for the project.is: Select one: a. 1.63 years b. 2.55 years c. 1 year d. More than 3 years Q2) Capital rationing refers to the limiting of capital resources to under-performing divisions. Select one: True False...
A firm is considering a project that requires an initial investment of $55,000. The project is...
A firm is considering a project that requires an initial investment of $55,000. The project is expected to generate revenues of $80,000 per year for three years. Operating expenses will be 65% of revenues. The equipment will be depreciated on a straight-line basis to a zero net salvage value. The equipment will have a life of 3 years. The project feasibility study, which was just completed, cost $35,000. The project requires an initial investment in working capital of $5,000. Further...
An investment requires an initial disbursement of € 2,500,000 and the duration of the project is...
An investment requires an initial disbursement of € 2,500,000 and the duration of the project is 3 years, in the first of which it generates a cash flow of € 1,500,000, in the second € 3,700,000 and the third € 4,100,000. Calculate the Net Present Value of the investment, knowing that inflation is 3% cumulative annually and that the required profitability in the absence of inflation is 8%. Calculate the actual internal rate of return of the previous investment.
A project requires an initial investment of $20,000,000. The life of the project is 3 years....
A project requires an initial investment of $20,000,000. The life of the project is 3 years. The $20,000,000 investment will be depreciated using the three-year modified accelerated cost recovery system (MACRS) class (see the table below). The firm estimates that, in the first year, the revenues and total production costs will be $60,000,000 and $45,000,000, respectively, in nominal terms. After that the sales and production costs are expected to increase at the inflation rate of 4 percent per year over...
Project A: This project requires an initial investment of $20,000,000 in equipment which will cost an...
Project A: This project requires an initial investment of $20,000,000 in equipment which will cost an additional $3,000,000 to install. The firm will use the attached MACRS depreciation schedule to expense this equipment. Once the equipment is installed, the company will need to increase raw goods inventory by $5,000,000, but it will also see an increase in accounts payable for $1,500,000. With this investment, the project will last 6 years at which time the market value for the equipment will...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT