Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

School Finance Elections

Authors: Don E. Lifto, Bradford J. Senden, Daniel A. Domenech

2nd Edition

1607091488, 978-1607091486

More Books

Students also viewed these Finance questions

Question

dy dx Find the derivative of the function y=(4x+3)5(2x+1)2.

Answered: 1 week ago

Question

Draw and explain the operation of LVDT for pressure measurement

Answered: 1 week ago