Question: Please explain in EXCEL, using functions. Thanks. Vandalay Industries is considering the purchase of a new machine for the production of latex. Machine A costs

Please explain in EXCEL, using functions. Thanks.

Vandalay Industries is considering the purchase of a new machine for the production of latex. Machine A costs $3,048,000 and will last for six years. Variable costs are 40 percent of sales, and fixed costs are $195,000 per year. Machine B costs $5,229,000 and will last for nine years. Variable costs for this machine are 35 percent of sales and fixed costs are $130,000 per year. The sales for each machine will be $10.1 million per year. The required return is 11 percent, and the tax rate is 24 percent. Both machines will be depreciated on a straight-line basis. The company plans to replace the machine when it wears out on a perpetual basis.

Calculate the EAC for each machine. (Your answers should be negative values and indicated by minus signs. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!