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%...
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...
A company wants to replace old machine by new one. Old is fully depreciated and no...
A company wants to replace old machine by new one. Old is fully depreciated and no salvage value is expected. New will provide annual cash saving by $7.000 before income taxes and without regard to the effect of depreciation. Machine (new) costs $18.000 , estimated useful life is 5 years. No salvage value will be for the n ew one. Straight line depreciation method will be used. Income tax is %40. Desired rate of return is %14. Please evaluate this...
A firm is considering an investment in a new machine with a price of $18.1 million...
A firm is considering an investment in a new machine with a price of $18.1 million to replace its existing machine. The current machine has a book value of $6.1 million and a market value of $4.6 million. The new machine is expected to have a four-year life, and the old machine has four years left in which it can be used. If the firm replaces the old machine with the new machine, it expects to save $6.8 million in...
Advanced Electronics Corporation is considering purchasing a new packaging machine to replace a fully depreciated packaging...
Advanced Electronics Corporation is considering purchasing a new packaging machine to replace a fully depreciated packaging machine that will last five more years. The new machine is expected to have a 5-year life and depreciation charges of $4,000 in year 1; $6,400 in year 2; $3,800 in year 3; $2,400 in both year 4 and year 5; and $1,000 in year 6. The firm’s estimates of revenues and expenses (excluding depreciation) for the new and old packaging machines are shown...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT