Question: *please show solutions using excel formulas* 123 Inc. is considering purchasing a new machine. The machine will cost $3,250,000. The machine will be used for


*please show solutions using excel formulas*
123 Inc. is considering purchasing a new machine. The machine will cost $3,250,000. The machine will be used for a project that lasts 3 years. The expected salvage of the machine at the end of the project is $800,000. The machine will be used to produce widgets. The marketing department has forecasted that the company will be able to sell 280,000 widgets per year. The marketing department believes that the company will be able to charge $22 per widget. The production department, has indicated that the variable cost per widget will be $9. The company has forecasted that the incremental fixed costs associated with the project are $120,000 per year. The company believes that the project will require an initial investment in operating networking capital of $160,000. Thereafter, the investment in operating networking capital will be 8% of sales. Assume the asset class remains open. The CCA rate is 30%, the tax rate is 24%, and the required rate of return is 8%. 123 Inc. is considering purchasing a new machine. The machine will cost $3,250,000. The machine will be used for a project that lasts 3 years. The expected salvage of the machine at the end of the project is $800,000. The machine will be used to produce widgets. The marketing department has forecasted that the company will be able to sell 280,000 widgets per year. The marketing department believes that the company will be able to charge $22 per widget. The production department, has indicated that the variable cost per widget will be $9. The company has forecasted that the incremental fixed costs associated with the project are $120,000 per year. The company believes that the project will require an initial investment in operating networking capital of $160,000. Thereafter, the investment in operating networking capital will be 8% of sales. Assume the asset class remains open. The CCA rate is 30%, the tax rate is 24%, and the required rate of return is 8%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
