Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. The equipment has a delivered cost of $105,000. An additional $3,100 is required to install and test the new system. 2. The new pumping

1. The equipment has a delivered cost of $105,000. An additional $3,100 is required to install and test the new system.

2. The new pumping system is classified by the IRS as 5-year property, although it has an 8-year estimated service life. For assets classified by the IRS as 5-year property, the Modified Accelerated Cost Recovery System (MACRS) permits the company to depreciate the asset over 6 years at the following rates: Year 1 = 20 percent, Year 2 = 32 percent, Year 3 = 19 percent, Year 4 = 12 percent, Year 5 = 11 percent, Year 6 = 6 percent. At the end of 8 years, the salvage value is expected to be around 5 percent of the original purchase price, so the best estimate of salvage value at the end of the equipment's service life is $5,300, with removal costs of $1,200.

3. The existing pumping system was purchased at $45,000 eight years ago and has been depreciated on a straight-line basis over its economic life of 10 years. If the existing system is removed from the well and crated for pickup, it can be sold for $3,500 before tax. It will cost $1,000 to remove the system and crate it.

4. At the time of replacement, the firm will need to increase its net working capital requirements by $4,500 to support inventories.

5. The new pumping system offers lower maintenance costs and frees personnel who would otherwise have to monitor the system. In addition, it reduces product wastage because of a higher cooling efficiency. In total, it is estimated that the yearly savings will amount to $25,000 if the new pumping system is used.

6. The firm has its target debt ratio of 30 percent, and its cost of new debt is 10 percent. Its expected dividend per share next year, D1, is $2.00 with a future growth rate of 6 percent per year. The firms current stock price, P0, is $40.00. The firm uses its overall weighted average cost of capital in evaluating average risk projects, and the replacement project is perceived to be of average risk.

7. The firms federal-plus-state tax rate is 30 percent, and this rate is projected to remain fairly constant into the future.

QUESTIONS (Please show all your work either through Excel formulas/equations on the Cash Flow Estimation Worksheet or in separate tables at the bottom of your spreadsheet)

1. Compute the firms weighted average cost of capital given the info/data in the case. What other approaches/methods can be used to measure the firms cost of equity and thus its WACC? To that end, what additional info/data would you need? (Hint: A firms weighted average cost of capital is equal to = ()(1 - t) + , where and are the weights of debt and equity in the capital structure; and are the respective costs of debt and equity; and t is the corporate tax rate; Do no round up your WACC figure.)

2. Develop a capital budgeting schedule using the attached Cash Flow Estimation Worksheet (Excel spreadsheet) that should list all relevant cash flow items and amounts related to the replacement project over the 8-year expected life of the new pumping system.

3. Based on the capital budgeting schedule, evaluate the replacement project by computing NV, IRR, MIRR, and Payback Period. Would you recommend to accept or reject the replacement project based solely on your DCF analysis so far? 4. Before you make the final accept/reject decision, what other factors and approaches would you consider further? Discuss also how to PRACTICALLY take into account those factors and approaches in the capital budgeting decision process, whenever applicable

image text in transcribedimage text in transcribed

3 4 5 Input Data (in thousands of dollars) Cost of NEW equipment Salvage value new equipment Cost of old equipment Depreciation of old equipment till date Salvage value of old equipment Tax rate WACC Pago 6 7 Annual dep. of old equipment OLD equipment's depreciable life left Old equipment's depreciated years Annal cost savings Removal cost of old equipment Removal cost of new equipment Net working capital requirement 8 9 10 11 12 t=0 t=1 t=2 t=3 t=5 t=6 t=7 t=8 B C J t=4 t=5 L t=6 M t=7 N t=8 12 15 16 18 A DE F G H 1 t=0 t=1 t=2 t=3 13 7 WVESTMENT OUTLAY 14 1 Cost of New Equipment 2 Maket Value of Old Equipment 3 Tax Savings on Sale of Old Equipment 17 4 Increase in Net Working Capital 5 Total Net Investment 19 6 20 21 / OPERATING CASHFLOWS OVER THE PROJECT'S LIFE 22 7 After tax decrease in costs II 23 8 Depreciation on new machine 9 Depreciation on old machine 25 10 Change in depreciation (8-9) 26 11 Tax Savin from depreciation (0.3x9 27 12 Net operating cash flows (711) 28 29 I TERMINAL YEAR CASH FLOWS 30 13 Estimated polvoge value of new machine 31 14 Tax on salvage value 32 15 Return of net working capital 33 16 Total termination cash flows 34 17 35 36 78 NET CASH FLOWS 37 18 Net cash flow time line 24 Page 2 = 39 RESULTS 40 NPV = 41 IRR 42 MIRR 43 Payback period 44 45 46 DECISION BASED ON YOUR ANALYSIS: 47 Pages 3 4 5 Input Data (in thousands of dollars) Cost of NEW equipment Salvage value new equipment Cost of old equipment Depreciation of old equipment till date Salvage value of old equipment Tax rate WACC Pago 6 7 Annual dep. of old equipment OLD equipment's depreciable life left Old equipment's depreciated years Annal cost savings Removal cost of old equipment Removal cost of new equipment Net working capital requirement 8 9 10 11 12 t=0 t=1 t=2 t=3 t=5 t=6 t=7 t=8 B C J t=4 t=5 L t=6 M t=7 N t=8 12 15 16 18 A DE F G H 1 t=0 t=1 t=2 t=3 13 7 WVESTMENT OUTLAY 14 1 Cost of New Equipment 2 Maket Value of Old Equipment 3 Tax Savings on Sale of Old Equipment 17 4 Increase in Net Working Capital 5 Total Net Investment 19 6 20 21 / OPERATING CASHFLOWS OVER THE PROJECT'S LIFE 22 7 After tax decrease in costs II 23 8 Depreciation on new machine 9 Depreciation on old machine 25 10 Change in depreciation (8-9) 26 11 Tax Savin from depreciation (0.3x9 27 12 Net operating cash flows (711) 28 29 I TERMINAL YEAR CASH FLOWS 30 13 Estimated polvoge value of new machine 31 14 Tax on salvage value 32 15 Return of net working capital 33 16 Total termination cash flows 34 17 35 36 78 NET CASH FLOWS 37 18 Net cash flow time line 24 Page 2 = 39 RESULTS 40 NPV = 41 IRR 42 MIRR 43 Payback period 44 45 46 DECISION BASED ON YOUR ANALYSIS: 47 Pages

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Extinction Governance Finance And Accounting

Authors: Jill Atkins, Martina Macpherson

1st Edition

0367492989, 978-0367492984

More Books

Students also viewed these Finance questions