Question: Please show all work in excel!! The Magic Company is considering buying a new machine for one of its factories. The machine cost is $125,000,

Please show all work in excel!!

The Magic Company is considering buying a new machine for one of its factories. The machine cost is $125,000, and its expected life span is 8 years. The machine will be depreciated on the straight-line basis to a salvage value of zero; nevertheless, the company anticipates that it can sell the machine at the end of year 8 for $12,000. The machine is expected to reduce the production costs by $35,000 annually. If the appropriate discount rate is 12% and the corporate tax is 40%: a. Calculate the project's NPV b. Calculate the project's IRR

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!

Zambrano Wholesale Corporation maintains its records on a cash basis. At the end of each year the company?s accountant obtains the necessary information to prepare accrual basis financial statements....

***Please use Excel*** The Magic Company is considering buying a new machine for one of its factories. The machine cost is $125,000, and its expected life span is 8 years. The machine will be...

The Magic Company is considering buying a new machine for one of its factories. The machine cost is $125,000, and its expected life span is 8 years. The machine will be depreciated on the...

Please answer the following questions in an excel spreadsheet. The is in regards to NPV, IRR, and cashflows. #7: A company is considering buying a new machine for one of its factories. The cost of...

Please answer the following question attached. It is regarding NPV, cashflows, and IRR. If you could put it in an excel document that would be great. Thanks! #7 A company is considering buying a new...

A company is considering buying a new machine for one of its factories. The cost of the new machine is $60,000, and it's expected life span is 5 years. The machine will save the cost of a worker...

The ABC Company is considering buying a new machine for one of its factories. The cost of the machine is $12,625, the expected life span is nine years, and it is depreciated using the straight-line...

A company is considering buying a new machine for one of its factories. The cost of the machine is $60,000 and its expected life span is 5 years. The machine will save the cost of a worker estimated...

The ABD Company is considering buying a new machine for one of its factories. The machine cost is $100,000 and its expected life span is 8 years. The machine is expected to reduce the production cost...

7. (NPV and cash flows) The ABD Company is considering buying a new machine for one of its factories. The machine cost is $100,000, and its expected life span is 8years. The machine will be...

You work for a Pension Fund. You are considering moving a quarter of your $400 million US equity portfolio into the Japanese stock market. The expected return and standard deviation of returns in the...

In a hypothetical universe, an oil-drop experiment gave the following measurements of charges on oil drops: 5.55 1019 C, 9.25 1019 C, 1.11 1018 C, and 1.48 1018 C. Assume that the smallest...

Which one of the following is NOT an advantape of the cash method for reporting income? The cash method generally simplifies the correulation of income. Taxpeyers heve some control over when income...

Give an example of an element of a product or process design that makes ieasy to do the right thing, and/or difficult or impossible to do the wrong thing, or that immediately detects when a mistake...

Given the following for the Williamsburg Company pension plan: 1/1/18 FV & MRAV 1/1/18 PBO Average Service Life remaining as of 1/1/18 Unrecognized Gain on Plan Assets as of 1/1/18 The 12/31/18...

ament in any country makes a big difference in how of its operating style, is used to dealing directiy with its magine it might not understand that the cultural envi- the hard way that Germany has...

Consider an (n*m)-sized chessboard with numbers on each square. If any frame on this board has a larger number than all of the squares adjacent to it, this square is marked as 'dangerous'. Design a...

Tom sold 100 cases of tomato soup to Louie for $1,500. Louie gave Tom a promissory note, which stated "I promise to pay to the order of Tom the sum of $1,500 three months from date, together with 5%...

Because Jenna is working with interview data, which of the following types of data analysis would be most effective for her project? a . Analysis of variance b . Content analysis c . Standard...

Describe the role that human resources and department managers have in matters of compensation

Be able to discusses statutory benefits such as Workers Compensation and short-term disability

Understand the roles of human resources and department managers regarding benefits