Question

In: Finance

Duo Co needs to increase production capacity to meet increasing demand for an existing product, ‘Quago’,...

Duo Co needs to increase production capacity to meet increasing demand for an existing product, ‘Quago’, which is used in food processing. A new machine, with a useful life of four years and a maximum output of 600,000 kg of Quago per year, could be bought for $800,000, payable immediately. The scrap value of the machine after four years would be $30,000. Forecast demand and production of Quago over the next four years is as follows: Year 1 2 3 4 Demand (kg) 1·4 million 1·5 million 1·6 million 1·7 million Existing production capacity for Quago is limited to one million kilograms per year and the new machine would only be used for demand additional to this. The current selling price of Quago is $8·00 per kilogram and the variable cost of materials is $5·00 per kilogram. Other variable costs of production are $1·90 per kilogram. Fixed costs of production associated with the new machine would be $240,000 in the first year of production, increasing by $20,000 per year in each subsequent year of operation. Duo Co pays tax one year in arrears at an annual rate of 30% and can claim capital allowances (tax-allowable depreciation) on a 25% reducing balance basis. A balancing allowance is claimed in the final year of operation. Duo Co uses its after-tax weighted average cost of capital when appraising investment projects. It has a cost of equity of 11% and a before-tax cost of debt of 8·6%. The long-term finance of the company, on a market-value basis, consists of 80% equity and 20% debt. Required: (a) Calculate the net present value of buying the new machine and advise on the acceptability of the proposed purchase (work to the nearest $1,000). (b) Calculate the internal rate of return of buying the new machine and advise on the acceptability of the proposed purchase (work to the nearest $1,000).

Solutions

Expert Solution

A Initial Cash flow ($800,000)
Annual Operating cash flows:
Year 0 1 2 3 4
B Demand (Kg)          1,400,000          1,500,000          1,600,000          1,700,000
C Existing machine capacity          1,000,000          1,000,000          1,000,000          1,000,000
D=B-C Production and sales from new machine              400,000              500,000              600,000              700,000
E Contribution per Kg($8-$5-$1.9) $1.10 $1.10 $1.10 $1.10
F=D*E TotalContribution Margin $         440,000 $         550,000 $         660,000 $         770,000
G Fixed cost $240,000 $260,000 $280,000 $300,000
H=F-G Before tax operating cash flow $         200,000 $         290,000 $         380,000 $         470,000
I=H*(1-0.3) After tax operating Cashflow $         140,000 $         203,000 $         266,000 $         329,000
Depreciation Tax Shield:
J Book Value at the beginning of year $800,000 $600,000 $450,000 $337,500
K=J*0.25 Depreciation expenses $200,000 $150,000 $112,500 $84,375
L=J-K Book Value at the end of year $600,000 $450,000 $337,500 $253,125
M=K*0.3 Annual Depreciation Tax Shield $60,000 $45,000 $33,750 $25,313
P=I+M Total annualAfter tax Cash Flow $         200,000 $         248,000 $         299,750 $         354,313
TerminalCash Flow
Q Salvage Value $30,000
R=L-Q Balancing allowance $223,125
S=R*0.3 Tax shield due to balancing allowance $66,938
T=Q+S Total TerminalCash Flow $96,938
N YEAR 0 1 2 3 4
U=A+P+T Net Annual After Tax Cash Flow ($800,000) $         200,000 $         248,000 $         299,750 $         451,250
Internal Rate of Return 15.89% (Using excelIRR function over the Net AnnualAfter Tax Cash flow)
COST OF CAPITAL:
After tax cost of debt=8.6*(1-0.3)= 6.02% 6.02
Cost of Equity 11%
Weighted Average Cost of Capital(WACC) 10% (0.8*11+0.2*6.02)
Present Value (PV) of Cash Flow:
(Cash Flow)/((1+i)^N)
i=Discount Rate=WACC=10%=0.1
N=Year of Cash Flow
SUM
PV=U/(1.1^N) Present Value of Net Annual aftertax Cashflow $       (800,000) $         200,000 $         248,000 $         299,750 $         451,250 $ 399,000
NPV Net Present Value=Sumof PV of Cash flows $          399,000
(a) Based on NPV, the purchase of new machine is recommended because NPV is positive
(b) Based on IRR, the purchase of new machine is recommended because IRR is greater thanWACC

Related Solutions

A production manager needs to develop a production schedule to meet the following demand: Period 1...
A production manager needs to develop a production schedule to meet the following demand: Period 1 2 3 4 5 6 Demand 600 600 800 1000 1200 600 Productions costs are as follows: (a) regular time: $3 per unit. (b) over-time: $5 per unit. (c) subcontract: $7 per unit. (d) Inventory carrying cost = $2 per unit per period (e) Back-order costs = $5 per unit per period. Suppose some workers have retired, and the regular production rate can be...
Tata Corp. needs to purchase new plastic moulding machines to meet the demand for its product....
Tata Corp. needs to purchase new plastic moulding machines to meet the demand for its product. The cost of the equipment is $8,927,000. It is estimated that the firm will increase after tax cash flow (ATCF) by $1,894,864 annually for the next 3 years. The firm is financed with 40% debt and 60% equity, both based on current market values, though the firm has announced that it wants to quickly change its debt to equity ratio to 1.5. The firm's...
Palestine Corp. needs to purchase new plastic moulding machines to meet the demand for its product....
Palestine Corp. needs to purchase new plastic moulding machines to meet the demand for its product. The cost of the equipment is $3,724,000. It is estimated that the firm will increase after tax cash flow (ATCF) by $700,601 annually for the next 6 years. The firm is financed with 40% debt and 60% equity, both based on current market values, though the firm has announced that it wants to quickly change its debt to equity ratio to 1.5. The firm's...
Julie Resler’s company is considering expansion of its current facility to meet increasing demand. If demand...
Julie Resler’s company is considering expansion of its current facility to meet increasing demand. If demand is high in the future, a major expansion will result in an additional profit of $800,000, but if demand is low there will be a loss of $500,000. If demand is high, a minor expansion will result in an increase in profits of $200,000, but if demand is low, there will be a loss of $100,000. The company has the option of not expanding....
A company needs to purchase several new machines to meet its future production needs. It can...
A company needs to purchase several new machines to meet its future production needs. It can purchase three different types of machines A,B,andC. Each machine A costs $80,000 and requires 2,000 square feet of floor space. Each machine B costs$50,000 and requires 3,000 square feet of floor space. Each machine C costs $40,000 and requires 5,000 square feet of floor space. The machines can produce 200, 250 and 350 units per day respectively. The plant can only afford $500,000 for...
A province needs to decide on the number of residency openings required to meet the demand...
A province needs to decide on the number of residency openings required to meet the demand of active physicians in practice. It was determined that physicians have an active professional life of 26 years; the currently the province needs 29000 doctors to be actively practicing. In equilibrium, on average, the number of doctors retiring every year is equal to the number of doctors admitted to residency. (Round your final answer to the nearest two places of decimal) (1) How many...
Dysxa Co is looking to expand the capacity of an existing factory in its Alpha Division...
Dysxa Co is looking to expand the capacity of an existing factory in its Alpha Division by 850,000 units per year in order to meet increased demand for one of its products. The expansion will cost $3.2 million. The selling price of the product is $3.10 per unit and variable costs of production are $1.10 per unit, both in current price terms. Selling price inflation of 3% per year and variable cost inflation of 6% per year are expected. Nominal...
During exercise, blood flow to skeletal muscles must increase to meet the increase in oxygen demand...
During exercise, blood flow to skeletal muscles must increase to meet the increase in oxygen demand for ATP (energy) production. The initial response that increases blood flow to the muscle cells is automatic and independent of the nervous and endocrine systems. Which type of homeostatic regulation is this? Explain.
In order to meet the rising demand from an increasing global population, the United Nations Food...
In order to meet the rising demand from an increasing global population, the United Nations Food and Agriculture Organization had estimated that food production would have to increase by 70 percent to cope with demand. Given the finite supply of arable land and water, producing higher yields through increased farm productivity was seen by many as the only viable option. Biotechnology (Biotech) crops offered one means to increase productivity by offering greater yields while potentially using fewer natural resources such...
ANSWER ASAP In order to meet the rising demand from an increasing global population, the United...
ANSWER ASAP In order to meet the rising demand from an increasing global population, the United Nations Food and Agriculture Organization had estimated that food production would have to increase by 70 percent to cope with demand. Given the finite supply of arable land and water, producing higher yields through increased farm productivity was seen by many as the only viable option. Biotechnology (Biotech) crops offered one means to increase productivity by offering greater yields while potentially using fewer natural...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT