In: Finance
Vandalay Industries is considering the purchase of a new machine for the production of latex.
Machine A costs $2,900,000 and will last for six years. Variable costs are 35% of sales and fixed
costs are $170,000 per year. Machine B costs $5,100,000 and will last for nine years. Variable
costs for this machine are 30% of sales and fixed costs are $130,000 per year. The sales for each
machine will be $10 million per year. The required return is 10% and the tax rate is 35%. Both
machines will be depreciated straight-line over their lifetimes.
a.
What are the equivalent annual costs of each machine?
b. Which machine should Vandalay Industries select?
Please show work in excel with solutions please