Question

In: Finance

Company X is planning to add another project, which will generate $125,000 annual revenue for the...

Company X is planning to add another project, which will generate $125,000 annual revenue for the company in the next 6 years, with operating costs of $50,500 per year. To take this new project, the company has to purchase a new equipment with a price of $168,000 and add additional $40,000 in net working capital. The equipment will be depreciated using 7-year MACRS depreciation method (7-year MACRS depreciation rates are showing below). The company thinks the equipment could be sold out by the end of year 6 for $20,000. With a tax rate of 35% and required return of 18%, should the company take this project or not? Why? (Please show both NPV and IRR decisions). 7-year MACRS 1. 14.29% 2. 24.49% 3. 17.49% 4. 12.49% 5. 8.93% 6. 8.92% 7. 8.93% 8. 4.46%

Solutions

Expert Solution

NPV

Time line 0 1 2 3 4 5 6
Cost of new machine -168000
Initial working capital -40000
=Initial Investment outlay -208000
7 years MACR rate 14.29% 24.49% 17.49% 12.49% 8.93% 8.92% 13.39%
Sales 125000 125000 125000 125000 125000 125000
Profits Sales-variable cost 74500 74500 74500 74500 74500 74500
-Depreciation =Cost of machine*MACR% -24007.2 -41143.2 -29383.2 -20983.2 -15002.4 -14985.6 22495.2
=Pretax cash flows 50492.8 33356.8 45116.8 53516.8 59497.6 59514.4
-taxes =(Pretax cash flows)*(1-tax) 32820.32 21681.92 29325.92 34785.92 38673.44 38684.36
+Depreciation 24007.2 41143.2 29383.2 20983.2 15002.4 14985.6
=after tax operating cash flow 56827.52 62825.12 58709.12 55769.12 53675.84 53669.96
reversal of working capital 40000
+Proceeds from sale of equipment after tax =selling price* ( 1 -tax rate) 13000
+Tax shield on salvage book value =Salvage value * tax rate 7873.32
=Terminal year after tax cash flows 60873.32
Total Cash flow for the period -208000 56827.52 62825.12 58709.12 55769.12 53675.84 114543.28
Discount factor= (1+discount rate)^corresponding period 1 1.18 1.3924 1.643032 1.9387778 2.2877578 2.6995542
Discounted CF= Cashflow/discount factor -208000 48158.915 45120.023 35732.183 28765.092 23462.204 42430.444
NPV= Sum of discounted CF= 15668.86071

IRR

Total Cash flow for the period -208000 56827.52 62825.12 58709.12 55769.12 53675.84 114543.28
Discount factor= (1+discount rate)^corresponding period 1 1.2067588 1.45626687 1.7573629 2.1207132 2.5591894 3.0883244
Discounted CF= Cashflow/discount factor -208000 47091.033 43141.2134 33407.511 26297.342 20973.766 37089.135
NPV= Sum of discounted CF= 2.93876E-08
IRR is discount rate at which NPV = 0 = 20.68%

Accept project as NPV is positive and IRR is more than required rate

jeff jeffy answered 10 months ago
Next > < Previous

Related Solutions

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...
19. A firm is considering a new project that will generate cash revenue of $1,300,000 and...
19. A firm is considering a new project that will generate cash revenue of $1,300,000 and cash expenses of $700,000 per year for five years. The equipment necessary for the project will cost $300,000 and will be depreciated straight line over four years. What is the expected free cash flow in the second year of the project if the firm's marginal tax rate is 35%? a. $374,625 b. $341,250 c. $416,250 d. $499,500
Suppose an investor invested $400 in a project that is expected to generate revenue of $440...
Suppose an investor invested $400 in a project that is expected to generate revenue of $440 a year later. The required rate of return is the minimum return an investor expects to achieve by investing in a project. The required rate of return is influenced by the following factors: the risk-free rate of return is 4% , the expected return from the market is 8%, and beta is 1.5. 5-     How much is the residual earnings? 6-     If the required rate of...
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
a project with an initial cost of $73,600 is expected to generate annual cash flows of...
a project with an initial cost of $73,600 is expected to generate annual cash flows of $16,360 for the next 8 years. what is the projects internal rate of retu
19) A firm is considering a project that is expected to generate annual cash flows of...
19) A firm is considering a project that is expected to generate annual cash flows of $24,000 for 15 years. The project requires an initial investment of $247,103.44. The cost of capital is 8.13%. What is the IRR of the project?
Company XYZ is a high technology company. It is planning on acquiring another company in the...
Company XYZ is a high technology company. It is planning on acquiring another company in the high technology sector. Company XYZ dose not have enough cash to acquire the company and is planning on financing the acquisition through a bond offering. Which of the following measures is company XYZ MOST LIKEY to use in its analysis of operating profits considering it is a high debt transaction? A. LONG-TERM DEBT TO CAPITAL B. EBITDA margin C.Net profit margin D.return on equity...
A proposed project will generate £150,000 in revenue a year for 20 years (starting next year),...
A proposed project will generate £150,000 in revenue a year for 20 years (starting next year), but will cause another product line to lose £60,000 in revenue a year during that time. The project will make use of 50% of an already leased warehouse with total annual rent of£50,000 (the contract does not prohibit sub-leasing). The discount rate for this project is 6%. Should the firm undertake this project if the required investment is £250,000? What is the Payback Period...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT