Question

In: Finance

A successful computer business company is considering a new product line that require a new machine....

A successful computer business company is considering a new product line that require a new machine. It will cost $36,000,000. It will be fully depreciated to a zero book value on a straight line basis over 4 years. The project will generate $100,000,000 in sales each year for 4 years. Variable costs are 75% of sales and fixed costs are $8,500,000 per year for 4 years. To get the project started and for each year, net operating working capital (NOWC) is 1% of the next year's sales. The company will have $5,000,000 annually in interest expense as part of the financing. Tax rate is 25%. The company's financial advisor estimates the cost of capital (required return) as 14%. Note: Variable and fixed costs do not include depreciation or interest expense. a) Calculate the net present value (NPV) and internal rate of return (IRR). b) Should they consider the new line? Why? c) The financial manager is concerned about their estimates and conducts a scenario analysis. Variable costs could be 70%, 75% (expected) or 80% of sales and the cost capital could be 10%, 14%(expected) or 16%. Use a data table to analyze the NPV. What can you conclude and why is this important for evaluating the project?                                                                     

Solutions

Expert Solution

Based on the given data, pls find below steps, workings and answers:

The Interest expense is not required to be considered in this workings as the cost of capital already includes the cost of debt with which the Present value is being arrived;

a) The Net Present Value (NPV) for this new line of machine is $ 5613042.45 and the Internal Rate of Return (IRR) is 21.22%;

b) Since the NPV is positive and the IRR is higher than the cost of capital , the project is recommeded for investment.

c) Sensitivity is common among any projects with future projections based on best judgement estimates; However, there are chances that these estimates might get impacted due to internal or external factors. Hence, a sensitivity analysis establish the picture of extremes of risk and positive sides based on the fluctuations in the factors used for estimating the cash flows;

In this case, it is evident that if the variable costs increase to 80% of the total sales, the project's NPV is negative at any given costs of capital %; Hence, in this case, the project feasibility is dependent on the confirmity of the increase in the variable cost %;

Year 1 Year 2 Year 3 Year 4 Year 0 -3,60,00,000 -10,00,000 -10,00,000 -10,00,000 -10,00,000 -10,00,000 75% Project (in $) New Production Line Net Working Capital Increase Change in Working Capital Revenue Variable Costs Fixed Costs EBIDT Depreciation EBT Tax@ 25% Net Income 10,00,00,000 10,00,00,000 7,50,00,000 7,50,00,000 85,00,000 85,00,000 1,65,00,000 1,65,00,000 90,00,000 90,00,000 75,00,000 75,00,000 18,75,000 18,75,000 56,25,000 56,25,000 10,00,00,000 10,00,00,000 7,50,00,000 7,50,00,000 85,00,000 85,00,000 1,65,00,000 1,65,00,000 90,00,000 90,00,000 75,00,000 75,00,000 18,75,000 18,75,000 56,25,000 56,25,000 -3,70,00,000 1 Cash Flows (Net Income add back Depreciation) Discounting Factor Discounted Cash Flow Cumulative Discounted Cash Flow 1,46,25,000 0.8772 1,28,28,947 -2,41,71,053 1,46,25,000 0.7695 1,12,53,463 -1,29,17,590 1,46,25,000 0.6750 98,71,458 -30,46,132 1,46,25,000 0.5921 86,59,174 56,13,042 -3,70,00,000 -3,70,00,000 NPV IRR 56,13,042.45 21.22% Discounting Factor 14.00% Scenario Analysis: Cost of Capital 56,13,042.45 10% Variable Costs 70% 75% 80% 2,12,46,277.58 93,59,282.15 -25,27,713.27 1,65,39,463.60 56,13,042.45 -53,13,378.69 1,44,16,569.23 39,23,391.83 -65,69,785.56 14% 16%


Related Solutions

The company is considering adding a new product line that will require an investment of $1,454,000....
The company is considering adding a new product line that will require an investment of $1,454,000.       Management estimates that this investment will have a 10-year life and generate future net cash       inflows of $310,000 the first year, $280,000 the second year and $240,000 each year thereafter for       eight years. Compute the payback period. (Hint: the payback period does not use the time value                  of money charts.)
A company is considering a 5-year project to open a new product line. A new machine...
A company is considering a 5-year project to open a new product line. A new machine with an installed cost of $90,000 would be required to manufacture their new product, which is estimated to produce sales of $80,000 in new revenues each year. The cost of goods sold to produce these sales (not including depreciation) is estimated at 55% of sales, and the tax rate at this firm is 40%. If straight-line depreciation is used to calculate annual depreciation, what...
Norister Inc. is considering introducing a new product line. This will require the purchase of new...
Norister Inc. is considering introducing a new product line. This will require the purchase of new fixed assets of $2.4 million. The company estimates that demand for the new product will be approximately 15,000 units per year, with a price per unit of $100. The variable cost of producing each unit of the product is $35, and fixed costs per year will be $100,000. Demand for the product will remain constant for six years, after which both demand and production...
Norister Inc. is considering introducing a new product line. This will require the purchase of new...
Norister Inc. is considering introducing a new product line. This will require the purchase of new fixed assets of $2.4 million. The company estimates that demand for the new product will be approximately 15,000 units per year, with a price per unit of $100. The variable cost of producing each unit of the product is $35, and fixed costs per year will be $100,000. Demand for the product is expected to remain constant for six years, after which both demand...
A company is considering of a new product line that is believed to be marketable for...
A company is considering of a new product line that is believed to be marketable for the next 10 years. An initial investment of $215,000 will be required with an estimated salvage value of $40,000 at the end of 10 years. The annual receipts will start at $53,000, the first year and then increase by $2000 each year thereafter. Disbursements will start at $21,000 the first year and increase by $500 each year thereafter. What is the prospective rate of...
Using Excel (if applicable), . A company is considering a new product that would require an...
Using Excel (if applicable), . A company is considering a new product that would require an investment of $10 million now, at t = 0. If the new product is well received, then the project would produce after-tax cash flows of $6 million at the end of each of the next 3 years (t = 1, 2, 3), but if the market did not like the product, then the cash flows would be only $2 million per year. There is...
A Company is considering a new product line to supplement its range line. It is anticipated...
A Company is considering a new product line to supplement its range line. It is anticipated that the new product line will involve cash investment of $700,000 at time 0 and $1.0 million in year 1. After-tax cash inflows of $500,000 are expected in year 2, $300,000 in year 3, $700,000 in year 4, and $400,000 each year thereafter through year 10. Though the product line might be viable after year 10, the company prefers to be conservative and end...
A company is considering an investment of $600,000 in a new product line. The investment will...
A company is considering an investment of $600,000 in a new product line. The investment will be made only if it will result in a rate of return of 20% per year or higher. If the net cash flow is expected to be between $150,000 and $250,000 per year for 6 years. Use present worth analysis to determine if the decision to invest is sensitive to the projected range of revenue. Show how you arrived at your decision
Briarcliff Stove Company is considering a new product line to supplement its range line. It is...
Briarcliff Stove Company is considering a new product line to supplement its range line. It is anticipated that the new product line will involve cash investment of $700,000 at time 0 and $1.0 million in year 1. After tax cash inflows of $250,000 are expected in year 2, $300,000 in year 3, $350,000 in year 4, and $400,000 each year thereafter through year 6. Though the product line might be viable after year 6, the company prefers to be conservative...
MegaWash, Inc., is considering an expansion of their product line to Mexico. This would require a...
MegaWash, Inc., is considering an expansion of their product line to Mexico. This would require a purchase of equipment with a price of 3,000,000MXN and additional installation of 500,000MXN, to be depreciated straight-line to zero over the 5-year life of the asset. They will not be replacing any existing equipment. Their required rate of return is 15% and they are in the 35% tax bracket. The new product line is expected to increase sales by 800,000MXN per year over current...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT