Question

In: Accounting

the company is considering the purchase of machinery and equipment to set up a line to...

the company is considering the purchase of machinery and equipment to set up a line to produce a combination washer-dryer.

They have given you the following information to analyze the project on a 5-year timeline: Initial cash outlay is $150,000, no residual value.

Sales price is expected to be $2,250 per unit, with $595 per unit in labor expense and $795 per unit in materials. Direct fixed costs are estimated to run $20,750 per month.

Cost of capital is 8%, and the required rate of return is 10%.

They will incur all operational costs in Year 1, though sales are expected to be 55% of break-even

. Break-even (considering only direct fixed costs) is expected to occur in Year 2. Variable costs will increase 2% each year, starting in Year 3.

Sales are estimated to grow by 10%, 15%, and 20% for years 3 - 5.

They have asked you to calculate: The product’s contribution margin

Break-even quantity

NPV

IRR

PROVIDE STEP BY STEP ANSWER TO THIS QUESTION WITH EXPLANATION OF WHY steps chosen for each calculation and what each calculated answer means for each .

Please explain why management made the decision based on the calculations above. What other factors should have been considered in managements decisions.

Solutions

Expert Solution

In above calculation management what is break even point of that project break even point is a point on which from have no profit no loss situation.

Management used fixed cost divided by contribution margin. Contribution margin represent the amount of profit after deducting variable cost.

Computation of cash inflow

In about calculation of flow of all variable and fixed costs deducted from the revenue to get net cash inflow from the project.

Npv is considered as NET gain from net cash inflow in present and considered the project is beneficial or not if project have any positive value then it should be considered as favourable otherwise it is adverse for business.

Management calculate npv to evaluate project

Irr is a situation on which npv zero. Management computed IRR to find return from the project

A B 6 Sales price p.u 7 -Labour cost p.u 8 -Material cost p.u 9 Contribution p.u $2250 -$595 -$795 $860 10 11 Contribution Margin 12 =Contribution/Sales price 13 0.382222222 14 38.22% 15 16 Break-Even Quantity 17 =Annual Fixed cost/Contribution p.u 18 289.5348837 19 290 units

Year 2. Sale (units) 159 290 319 367 440 *Sale Price p.u 2250 2250 2250 2250 2250 Total Sales (a) 357750 652500 717750 825750 990000 Variable cost p.u 1390 1390 1417.8 1446.156 1475.07912 -Total Variable cost (b) 221010 403100 452278.2 530739.252 649034.8128 c) -Direct Fixed Costs (20750* 249000 249000 249000 249000 249000 Total Cash Flows (a-b-c) -112260 16471.8 46010.748 400 91965.1872 Tax information is not given so amount of deprecaion deduction will have no impavt

A B 30 31 Computation of NPV 32 Year Amount 150000 33 34 -112260 35 2 400 36 3 16471.8 46010.748 37 4 38 91965.1872 8% 39 Rate 40 NPV formula =NPV(B39,B34:B38)-B33 -144116.43 41 NPV

A B 30 31 Computation of IRR 32 Year Amount 33 -150000 34 -112260 35 2 400 36 16471.8 3 37 4 46010.748 38 5 91965.1872 39 IRRformula =irr(B33:B38) 40 IRR -12% 41


Related Solutions

The company is considering the purchase of machinery and equipment to set up a line to...
The company is considering the purchase of machinery and equipment to set up a line to produce a combination washer-dryer. They have given you the following information to analyze the project on a 5-year timeline: Initial cash outlay is $150,000, no residual value. Sales price is expected to be $2,250 per unit, with $595 per unit in labor expense and $795 per unit in materials. Direct fixed costs are estimated to run $20,750 per month. Cost of capital is 8%,...
the company is considering the purchase of machinery and equipment to set up a line to...
the company is considering the purchase of machinery and equipment to set up a line to produce a combination washer-dryer. They have given you the following information to analyze the project on a 5-year timeline: Initial cash outlay is $150,000, no residual value. Sales price is expected to be $2,250 per unit, with $595 per unit in labor expense and $795 per unit in materials. Direct fixed costs are estimated to run $20,750 per month. Cost of capital is 8%,...
Later, the company is considering the purchase of machinery and equipment to set up a line...
Later, the company is considering the purchase of machinery and equipment to set up a line to produce a combination washer-dryer. They have given you the following information to analyze the project on a 5-year timeline: Initial cash outlay is $150,000, no residual value. Sales price is expected to be $2,250 per unit, with $595 per unit in labor expense and $795 per unit in materials. Direct fixed costs are estimated to run $20,750 per month. Cost of capital is...
To set up the business, you will be required to purchase an equipment costing $40,000.00. You...
To set up the business, you will be required to purchase an equipment costing $40,000.00. You expect inventory will increase by $9,000 and accounts payable will increase by $5000.All the other working capital components will stay the same. So the change in net operating working capital is $4,000.00 at t= 0. You expect to keep the company for 4 years and you expect to sell 7000.00 units of Pickles at a unit price of $5.00 and believe that both prices...
A company is considering purchasing new equipment. The purchase of the equipment is       expected to...
A company is considering purchasing new equipment. The purchase of the equipment is       expected to generate after tax savings of $12,600 each year for 8 years. The company can       borrow money at 6%. Assume annual compounding.         Determine the present value of the future cash inflows. Hint: the $12,600 are your annuity payments
A company is considering the purchase of some equipment. The equipment costs $1,600,000. It lasts for...
A company is considering the purchase of some equipment. The equipment costs $1,600,000. It lasts for 4 years, and would be depreciated straight line to a zero salvage value. Alternatively, the company could lease the equipment for 4 years. The leasing contract would include maintenance, and the lease payments would be due at the end of each of the four years. The company’s before-tax cost of debt is 10%. The tax rate is 40%. What is the breakeven lease payment...
The management of Electronics Company is considering to purchase an equipment to be attached with the...
The management of Electronics Company is considering to purchase an equipment to be attached with the main manufacturing machine. The equipment will cost $8,000. The useful life of the equipment is 4 years. Management projected that annual cash inflow for four(4) years as follow: year-1 $1,000, year-2 $3000, year-3 $3500 and year-4 $4000. There’s maintenance cost for the equipment, and management should expense: $600 on year-2 and $800 on year-4. The management wants a 14% return on all investments. a....
Sinclair Company* A. EQUIPMENT REPLACEMENT Sinclair Company is considering the purchase of new equipment to perform...
Sinclair Company* A. EQUIPMENT REPLACEMENT Sinclair Company is considering the purchase of new equipment to perform operations currently being performed on different, less efficient equipment. The purchase price is $250,000, delivered and installed. A Sinclair production engineer estimates that the new equipment will produce savings of $72,000 in labor and other direct costs annually, as compared with the present equipment. She estimates the proposed equipment’s economic life at five years, with zero salvage value. The present equipment is in good...
Average Rate of Return Lakeland Company is considering the purchase of equipment for $175,000. The equipment...
Average Rate of Return Lakeland Company is considering the purchase of equipment for $175,000. The equipment will expand the Company's production and increase revenue by $40,000 per year. Annual cash operating expenses will increase by $12,000. The equipment's useful life is 10 years with no salvage value. Lakeland uses straight-line depreciation. The income tax rate is 25%. What is the average rate of return on the investment? Round answer to the nearest whole percentage, if applicable. Average rate of return...
A company is considering the purchase of new equipment for its production area. The equipment has...
A company is considering the purchase of new equipment for its production area. The equipment has an initial cost of $ 3,000 with operation and maintenance costs, as well as the market liquidation value as shown in the following table: Year Costs of operation Rescue value 1 $1,000 $1,500 2 $1,700 $1,000 3 $2,400 $500 4 $3,100 $0 Determine the Optimal Economic Life of this investment, if the MARR of the company is 12%
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT