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
Get step-by-step solutions from verified subject matter experts
