Question: ***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

***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 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.

***Please use Excel***

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!

Q:

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...

Q:

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...

Q:

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...

Q:

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...

Q:

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...

Q:

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...

Q:

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...

Q:

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...

Q:

If you can add in excel table with formulas please 6. (NPV and cash flows) A company is considering buying a new machine for one of its factories. The cost of the machine is $60,000, and its expected...

Q:

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...

Q:

What is the difference between the accounting treatment of overhead for a service business and for a manufacturer?

Q:

Delta Company produces a single product. The cost of producing and selling a single unit of this product at the company's normal activity level of 105,600 units per year is: Direct materials. Direct...

Q:

[ 8 ] Which of the following may be deducted as a business bad debt by Mr . Leonard, a taxpayer? A . A worthless corporate security. B . A note evidencing a worthless personal loan to a friend. C . A...

Q:

If a project is undertaken, the first event will be one of two immediate cash flows. either $100 (gain) with probability25% or 3100 (loss) with probability75% A company is tanking and scoring 25...

Q:

Name: 44 LAB 2{ Genetics EXERCISE 2 COMPARING KARYOTYPES Work with a group of your classmates to review the twa karyotypes and answer the questions Note the karyotypes provided depict single...

Q:

QUESTION 6 For an uncharged isotope with 54 protons and 75 neutrons, write the symbol in the form GE, where A is the mass number, Z is the atomic number, and E is the elemental abbreviation on the...

Q:

1. If a 24 cm chord is 5 cm form the center, how long is the radius of the circle? 2. AB and CD are parallel chords on one side of the center O and are 4 cm apart. If AB = 6 cm and CD = 14 cm, find...

Q:

Thermodynamics You want to heat a space that requires 5300KJ / min, by means of an inverted Carnot engine. If the added heat is 4250KJ / min. a) What will be the required power in KW and HP? b) Draw...

Q:

Tori and some other childeen experimented with balls to see which ones rolled. First using a piece of cardboard to use as a ramp, they angled it on a block to the floor to test the balls. Then Tori...

Q:

What two pieces must every FIXML message contain? What do these two elements represent?

Q:

In the following diagram, label the marginal revenue curve, the profit-maximizing price, the profit-maximizing quantity, the profit, and the deadweight loss. p=58 Price Demand Marginal cost Average...

Q:

In the process of creative destruction, what gets destroyed? pg58 Firms Workers Machines Buildings Business plans Valuable relationships Or some combination of these? The chapter itself contains...