Question

The Barnett Corporation is analyzing the proposed purchase of a new machine for $2,750,000. The proposed...

The Barnett Corporation is analyzing the proposed purchase of a new machine for $2,750,000. The proposed machine has an estimated economic life of four years but will be treated as three-year MACRS property for depreciation purposes. The machine will increase the firm's capacity, and it is expected to contribute $1,100,000 annually to earnings before depreciation and taxes. The firm is in a 32% tax bracket and estimates its cost of capital to be 16%.

***The numbers above should be hard entered somewhere on your spreadsheet as given variables. The spreadsheet itself should be comprised of formulas, so that you can change a variable (such as asset cost, tax rate or discount rate) and the spreadsheet will automatically recalculate NPV and IRR.

Calculate the NPV of this investment using an Excel spreadsheet. Please show all work using excel, including what you used for formulas.

Calculate the IRR, also in Excel. Please show all work/formulas you used.

Homework Answers

Answer #1
0 1 2 3 4
MACRS % 33.33% 44.45% 14.81% 7.41%
Investment -2,750,000
EBDT 1,100,000 1,100,000 1,100,000 1,100,000
Depreciation -916,575 -1,222,375 -407,275 -203,775
EBT 183,425 -122,375 692,725 896,225
Tax (32%) -58,696 39,160 -221,672 -286,792
Net Income 124,729 -83,215 471,053 609,433
Cash Flows -2,750,000 1,041,304 1,139,160 878,328 813,208
NPV $6,092
IRR 16.12%

Depreciation = Investment x MACRS %

Cash Flows = Investment + Net Income + Depreciation

NPV and IRR can be calculated using the same function in excel with 16% discount rate.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Purchase price of a new machine is $84000 and the useful life of the machine is...
Purchase price of a new machine is $84000 and the useful life of the machine is 6 years. At the end of 6 years, salvage value of machine is zero. Before tax earning from the new machine is $ 23000. The effective income tax rate is %40 and the after tax MARR %12. Using SL depreciation method, show the before tax and after tax cash flow in a table. ( Including depreciation, taxable income and tax payments for each year)...
A company is evaluating the purchase of a machine to improve product quality and output levels....
A company is evaluating the purchase of a machine to improve product quality and output levels. The new machine would cost $1.4 million and would be depreciated for tax purposes using the straight-line method over an estimated seven-year life to its expected salvage value of $100,000. The new machine would require an addition of $90,000 to working capital at the beginning of the project, which will of course be returned to the firm at the end of the project. In...
please show work and formulas, thank you XYZ Machining Inc. is considering the purchase of a...
please show work and formulas, thank you XYZ Machining Inc. is considering the purchase of a new milling machine at a cost of $18,000. The machine is expected to have a service life of eight years and a salvage value of $2,500. Develop the complete depreciation schedule for the machine showing year-by-year depreciation charges and book values, using: (a) Straight line depreciation, (b) SOYD depreciation. (c) DDB depreciation, (d) MACRS depreciation.
Quip Corporation wants to purchase a new machine for $500,000. Management predicts that the machine will...
Quip Corporation wants to purchase a new machine for $500,000. Management predicts that the machine will produce sales of $210,000 each year for the next 6 years. Expenses are expected to include direct materials, direct labor, and factory overhead (excluding depreciation) totaling $80,000 per year. The firm uses straight-line depreciation with an assumed residual (salvage) value of $35,000 and no gain on sale of the equipment at the end of it's life. Quip's combined income tax rate, t, is 35%....
A company is considering the purchase of a new machine that will enable it to increase...
A company is considering the purchase of a new machine that will enable it to increase its expected sales. The machine will have a price of $100,000. In addition, the machine must be installed and tested. The costs of installation and testing will amount to $10,000. The machine will be depreciated using 3-years MACRS. (Use MACRS table from class excel exercise by copying the table and pasting it) The equipment will be operated for 5 years. The sales in the...
The Clouse Company is evaluating the proposed acquisition of a new milling machine. The machine's price...
The Clouse Company is evaluating the proposed acquisition of a new milling machine. The machine's price is $180,000. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $50,000. The machine would require an increase in net working capital of $7,000. The milling machine would have no effect on revenues, but it is expected to save the firm $50,000 per year in before-tax operating costs, mainly labor. Clouse's marginal tax rate is 30%...
Arc Enterprise is analyzing two machines to determine which one it should purchase. Whichever machine is...
Arc Enterprise is analyzing two machines to determine which one it should purchase. Whichever machine is purchased will be replaced at the end of its useful life. The company requires a 14 percent rate of return and uses straight-line depreciation to a zero book value over the life of the machine. Machine A has a cost of $651,000, annual operating costs of $32,000, and a 5-year life. Machine B costs $472,000, has annual operating costs of $41,000, and a 3-year...
Please explain each step thoroughly Redden-Bensimon Avionics Corp is considering the purchase of a new machine...
Please explain each step thoroughly Redden-Bensimon Avionics Corp is considering the purchase of a new machine which will reduce manufacturing and operating costs by $5,000 annually and increase revenues by $6,000 annually. Depreciation and taxes are excluded. Finance.com will use the MACRS method to depreciate the machine, and it expects to sell the machine at the end of its 5-year operating life for $10,000 before taxes. The 5-year MACRS depreciation rates are 20%, 32%, 19%, 12%, 12%, and 5%. Finance.com's...
Canal Company is contemplating the purchase of a new leather sewing machine to replace the existing...
Canal Company is contemplating the purchase of a new leather sewing machine to replace the existing machine. The existing machine was purchased four years ago at an installed cost of $115,000; it was being depreciated under MACRS using a 5-year recovery period. The existing machine is expected to have a useful life of 5 more years. The new machine costs $203,000 and requires $8,000 in installation costs; it has a five-year useable life and would be depreciated under MACRS using...
The research and development division of a large corporation is considering the purchase of a new...
The research and development division of a large corporation is considering the purchase of a new tunneling X-ray microscope for $320,125. The projected net benefits from gains in materials engineering is projected to be $127,000 in today’s real dollars for the first year, increasing by an arithmetic gradient of $20,000 per year in real dollars for years 2 to 4. The unit will be depreciated under MACRS. Due to increasing advances in tunneling X-ray microscope technology, the unit will have...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT