Question

In: Finance

Bourque Enterprises is considering a new project. The project will generate sales of $1.6 million, $2...

Bourque Enterprises is considering a new project. The project will generate sales of $1.6 million, $2 million, $1.9 million, and $1.4 million over the next four years, respectively. The fixed assets required for the project will cost $1.5 million and will be eligible for 100 percent bonus depreciation. At the end of the project, the fixed assets can be sold for $175,000. Variable costs will be 30 percent of sales and fixed costs will be $400,000 per year. The project will require NWC equal to 15 percent of sales that must be accumulated in the year prior to sales. The required return on the project is 11 and the tax rate is 21 percent.

What is the NPV of the project?

Solutions

Expert Solution

Profit & Loss Account for the question can be built as follows:

Values in $Mn Year 1 Year 2 Year 3 Year 4
Sales $1.60 $2.00 $1.90 $1.40
Gain from sale of fixed assets $0.18
(-) Variable Costs - 30% Of Sales $0.48 $0.60 $0.57 $0.42
(-) Fixed Costs $0.40 $0.40 $0.40 $0.40
EBITDA $0.72 $1.00 $0.93 $0.76
(-) Bonus Depreciation $0.72
(-) Depreciation $0.38 $0.38 $0.38 $0.38
PBT ($0.38) $0.63 $0.56 $0.38
(-) Tax - 21% of PBT $0.00 $0.13 $0.12 $0.08
PAT ($0.38) $0.49 $0.44 $0.30

Based on the given sales & variable costs & fixed costs we can reach the EBITDA(Earnings before Interest, Tax, Depreciation & Amortization) reached above. Gain from sale of fixed assets can be removed from profit & loss account, on account of it being an extraordinary expense but bringing it into profit & loss account ensures we don't miss out on tax payment on it. Then, bonus depreciations allows us to get 100% benefit of capital expenses. After taking bonus depreciation in the first year, we are able to follow the normal depreciation schedule for all the years (assumed to be straight line depreciation of $1.5 Mn across 4 years coming up to $0.375 Mn each year).

Using these & tax rate of 21%, we reach every year's PAT.

Going forward, we will need to calculate each year's Free Cash flow to find project NPV.

Free Cash flow can be calculated by multiple ways. Below I have created it by adding Cash flow from Operations & Cash flow from Investment.

Below are the calculations for Cash flow from operations & Cash flow from investment. You will notice that we have removed gain from sale of fixed assets from PAT as it won't be classified as a Cash flow from operations line item but instead cash flow from investment line item.

Values in $Mn Year 0 Year 1 Year 2 Year 3 Year 4
PAT (0.38) 0.49 0.44 0.30
(+) Depreciation 1.10 0.38 0.38 0.38
(-) Gain from sale of fixed assets 0.00 0.00 0.00 0.18
(-) Net Working Capital Change 0.24 0.30 0.29 0.21 (1.04)
Cash Flow From Operations (0.24) 0.42 0.58 0.60 1.54
Cash Flow from Investment (1.50) 0.18
Free Cash Flow (1.74) 0.42 0.58 0.60 1.71
NPV (@11%) 0.68

Hence, we reach NPV of $0.68 Mn for the project.


Related Solutions

Bourque Enterprises is considering a new project. The project will generate sales of $1.6 million, $2.3...
Bourque Enterprises is considering a new project. The project will generate sales of $1.6 million, $2.3 million, $2.2 million, and $1.7 million over the next four years, respectively. The fixed assets required for the project will cost $2.1 million and will be eligible for 100 percent bonus depreciation. At the end of the project, the fixed assets can be sold for $195,000. Variable costs will be 30 percent of sales and fixed costs will be $450,000 per year. The project...
Bourque Enterprises is considering a new project. The project will generate sales of $1.6 million, $2.3...
Bourque Enterprises is considering a new project. The project will generate sales of $1.6 million, $2.3 million, $2.2 million, and $1.7 million over the next four years, respectively. The fixed assets required for the project will cost $2.1 million and will be eligible for 100 percent bonus depreciation. At the end of the project, the fixed assets can be sold for $165,000. Variable costs will be 25 percent of sales and fixed costs will be $540,000 per year. The project...
Bourque Enterprises is considering a new project. The project will generate sales of $1.7 million, $2.4...
Bourque Enterprises is considering a new project. The project will generate sales of $1.7 million, $2.4 million, $2.3 million, and $1.8 million over the next four years, respectively. The fixed assets required for the project will cost $2.7 million and will be eligible for 100 percent bonus depreciation. At the end of the project, the fixed assets can be sold for $185,000. Variable costs will be 25 percent of sales and fixed costs will be $475,000 per year. The project...
Bourque Enterprises is considering a new project. The project will generate sales of $1.3 million, $1.8...
Bourque Enterprises is considering a new project. The project will generate sales of $1.3 million, $1.8 million, $1.7 million, and $1.2 million over the next four years, respectively. The fixed assets required for the project will cost $1.7 million and will be eligible for 100 percent bonus depreciation. At the end of the project, the fixed assets can be sold for $185,000. Variable costs will be 20 percent of sales and fixed costs will be $440,000 per year. The project...
Belan, Inc. is considering a new project. The project will generate sales of $1.8 million, $2.5...
Belan, Inc. is considering a new project. The project will generate sales of $1.8 million, $2.5 million, $2.4 million, and $1.9 million over the next four years, respectively. The fixed assets required for the project will cost $2.75 million and are eligible for 100 percent bonus depreciation. At the end of the project, the fixed assets can be sold for $175,000. Variable costs will be 25 percent of sales and fixed costs will be $500,000 per year. The project will...
ABC Company is considering a new project. The project is expected to generate annual sales of...
ABC Company is considering a new project. The project is expected to generate annual sales of $65476, variable costs of $18689, and fixed costs of $9650. The depreciation expense each year is $10884 and the tax rate is 25 percent. What is the annual operating cash flow
ABC Company is considering a new project. The project is expected to generate annual sales of...
ABC Company is considering a new project. The project is expected to generate annual sales of $65476, variable costs of $18689, and fixed costs of $9650. The depreciation expense each year is $10884 and the tax rate is 25 percent. What is the annual operating cash flow? Enter your answer rounded off to two decimal points. Do not enter $ or comma in the answer box. For example, if your answer is $12.345 then enter as 12.35 in the answer...
4) Your company is considering a project that will generate sales revenue of $90 million in...
4) Your company is considering a project that will generate sales revenue of $90 million in Year 1. Revenue is expected to be flat for subsequent years. The project requires working capital equal to 16% of sales revenue, and has total operating costs excluding depreciation equal to 50% of sales. The equipment has a 3 year MACRS life and can be purchased and installed for $100 million. The project will end in three years. At that time, the equipment can...
Pharma-Corp is considering investing in a new project that will generate revenues of $9 million in...
Pharma-Corp is considering investing in a new project that will generate revenues of $9 million in its first year of operation and these revenues will grow at the rate of 3% per year thereafter. The project also entails R&D expenditures of $3 million in the first year of operation and these expenditures are expected to grow at the rate of 10% per year. The project would be pursued only as long as it yields a positive net cash flow. That...
A new project is expected to generate annual sales of $74 million, annual expenses of $42...
A new project is expected to generate annual sales of $74 million, annual expenses of $42 million, and an annual depreciation expense of $10 million. The firm's tax rate is 35%. Calculate the OCF (Operating Cash flow) for the year by using any of the three methods discussed in the chapter 9
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT