One of two machines in the 3-year MACRS class with no direct revenue (cost only) must be selected long term need in a company with a MARR of 8.0%. Applying current tax law the taxes by year for each machine are shown as well as the yearly cost that stays constant each year. Prepare and report a valid worth measure of the ATCF/CFAT for both machines and clearly in your answer identify the preferred economic choice.
Machine | Life yrs | Purchase Cost | Yearly Cost | Year | 1 | 2 | 3 | 4 | 5 | 6 |
A | 4 | 44,500 | 19,000 | Taxes | -8,820 | -10,221 | -6,486 | -5,554 | ||
B | 6 | 69,000 | 17,000 | Taxes | -8,400 | -10,011 | -5,716 | -4,644 | -3,750 | -3,750 |
First we have to calculate the after tax cash flows and NPV of
both machines, which is shown below:
Equivalent annual cost (EAC) of Mahcine A = NPV / Present value
annuity factor 8% 4 years
= $81269.73 / 3.31213
= $24,537.02
Equivalent annual cost (EAC) of Mahcine B = NPV / Present value
annuity factor 8% 6 years
= $123,466.38 / 4.62288
= $26,707.68
As the EAC of Machine A is lower, it should be preferred.
Needs to be in EXCEL A new engineer who just was hired by Machine Excellence is pushing for a brand new laser machining center. He insists that it is a money maker from the first day. He did not figure the deprecation and the after taxes cash flow (CFAT). Give this rookie engineer a little intelligent guidance here on the CFAT for a ROR analysis of the new laser equipment. Here are the figures for the production machining equipment for...
Case Study Description A $6M investment is considered by an electric bike manufacturing company to add a new production line for its new product, electric skateboards. The company has commissioned an exploratory study of where to place the new production line and which type of equipment to use. There are three types of machines to choose from for the company to install on the new assembly line. The machines have zero salvage value at the end of 10-year planning horizon....
There are 7 steps to the question. Please advise what
can I do to get all questions answered. I am ok with posting more
than 1 questions for this problem as a whole.
Please use excel and demonstrate the excel formule for the
same.
Case Study Description A $6M investment is considered by an electric bike manufacturing company to add a new production line for its new product, electric skateboards. The company has commissioned an exploratory study of where to...