1. The equipment has a delivered cost of $105,000. An additional $3,000 is required to install...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. The equipment has a delivered cost of $105,000. An additional $3,000 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 5 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 firm's current stock price, PO, 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 firm's 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, whenever applicable. NO WORK SHOWN, NO POINTS.) (8 pts) 1. Compute the firm's weighted average cost of capital given the info/data in the case. What other approaches/methods can be used to measure the firm's cost of equity and thus its WACC? To that end, what additional info/data would you need? (Hint: A firm's weighted average cost of capital is equal to Ka = Wd(Kd)(1 - t) + Weke, where Wd and We are the weights of debt and equity in the capital structure; Kd and Ke are the respective costs of debt and equity; and t is the corporate tax rate; Do no round up your WACC figure.) 6 (34 pts) 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. (Reference Reading: “Cash Flow Analysis Example (RIC Project)", one of required Readings for the course.) (8 pts) 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? (10 pts) 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. (Reference Reading: (1) Textbook Chapter 11; and (2) “Capital Asset Management Process: the Case of Hose & Fittings Corporation" by Bae et al., International Journal of Managerial Finance (IJMF), Vol. 1, No. 3, 2005, pp. 204-220, one of required Readings for the course.) Please use the Excel Format Below: ICE File Home Insert Page Layout Formulas Data Review View Kofax PDF O Tell me what you w. P19 fx A B D E F G H J K L M N 1 FALCONVILLE PUMP COMPANY - CASH FLOW ESTIMATION WORK WORKSHEET Input Data Cost of NEW equipment Salvage value new equipment Cost of old equipment 3 4 Annual dep. of old equipment 5 OLD equipment's depreciable life left 6 Old equipment's depreciated years Depreciation of old equipment till date Annal cost savings Removal cost of old equipment 8 Salvage value of old equipment 9 Tax rate Removal cost of new equipoment 10 WACC Net working capital requirement 11. 12 t=0 t=1 t-2 t=3 t=4 t-5 t-6 t=7 -8 13 I INVESTMENT OUTLAY 14 15 16 17 4 18 19 6 20 21 II OPERATING CASH FLOWS OVER THE PROJECT'S LIFE 22 23 24 9. 25 10 26 11 27 12 28 29 III TERMINAL YEAR CASH FLOWS 30 13 31 14 32 15 33 16 34 17 35 36 IV NET CASH FLOWS 37 18 38 39 V RESULTS 40 NPV 41 IRR %3D 42 MIRR 43 Payback period = 44 45 46 DECISION BASED ON YOUR ANALYSIS: 47 48 Sheet1 Sheet2 Sheet3 1. The equipment has a delivered cost of $105,000. An additional $3,000 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 5 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 firm's current stock price, PO, 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 firm's 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, whenever applicable. NO WORK SHOWN, NO POINTS.) (8 pts) 1. Compute the firm's weighted average cost of capital given the info/data in the case. What other approaches/methods can be used to measure the firm's cost of equity and thus its WACC? To that end, what additional info/data would you need? (Hint: A firm's weighted average cost of capital is equal to Ka = Wd(Kd)(1 - t) + Weke, where Wd and We are the weights of debt and equity in the capital structure; Kd and Ke are the respective costs of debt and equity; and t is the corporate tax rate; Do no round up your WACC figure.) 6 (34 pts) 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. (Reference Reading: “Cash Flow Analysis Example (RIC Project)", one of required Readings for the course.) (8 pts) 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? (10 pts) 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. (Reference Reading: (1) Textbook Chapter 11; and (2) “Capital Asset Management Process: the Case of Hose & Fittings Corporation" by Bae et al., International Journal of Managerial Finance (IJMF), Vol. 1, No. 3, 2005, pp. 204-220, one of required Readings for the course.) Please use the Excel Format Below: ICE File Home Insert Page Layout Formulas Data Review View Kofax PDF O Tell me what you w. P19 fx A B D E F G H J K L M N 1 FALCONVILLE PUMP COMPANY - CASH FLOW ESTIMATION WORK WORKSHEET Input Data Cost of NEW equipment Salvage value new equipment Cost of old equipment 3 4 Annual dep. of old equipment 5 OLD equipment's depreciable life left 6 Old equipment's depreciated years Depreciation of old equipment till date Annal cost savings Removal cost of old equipment 8 Salvage value of old equipment 9 Tax rate Removal cost of new equipoment 10 WACC Net working capital requirement 11. 12 t=0 t=1 t-2 t=3 t=4 t-5 t-6 t=7 -8 13 I INVESTMENT OUTLAY 14 15 16 17 4 18 19 6 20 21 II OPERATING CASH FLOWS OVER THE PROJECT'S LIFE 22 23 24 9. 25 10 26 11 27 12 28 29 III TERMINAL YEAR CASH FLOWS 30 13 31 14 32 15 33 16 34 17 35 36 IV NET CASH FLOWS 37 18 38 39 V RESULTS 40 NPV 41 IRR %3D 42 MIRR 43 Payback period = 44 45 46 DECISION BASED ON YOUR ANALYSIS: 47 48 Sheet1 Sheet2 Sheet3
Expert Answer:
Related Book For
Accounting concepts and applications
ISBN: 978-0538745482
11th Edition
Authors: Albrecht Stice, Stice Swain
Posted Date:
Students also viewed these general management questions
-
The actual stock price is $70 and the return on equity is 18%. The PE ratio is 5.556 and EPS is $12.60. The stock is A. Undervalued B. Overvalued C. Correctly valued D. None of the above
-
Assume ABC Company has chosen to invest in new manufacturing equipment. The initial cost of the equipment is $1,200,000. The equipment has a useful life of 20 years. The company uses straight-line...
-
Are the following functions linearly independent on the interval. show work. 35. sin 2x. cos x sin .x. (0
-
Population increase in northern Virginia requires new road constructions and repairs annually from 2022. More public schools will also be needed by 2035. The state of Virginia is considering an...
-
Bjork Larsen was trying to decide whether to use a new racing wax for cross-country skis. He decided that the wax would be worth the price if he could average less than 55 seconds on a course he knew...
-
Given the following financing project being considered by a venture firm, find the critical path probability of completion by 17 weeks. By 24 weeks. By what date is management 90 percent sure...
-
Several professionals are listed as being part of compliance efforts with regard to participation in the examination of potential compliance violations. Identify at least three other categories of...
-
The Brandilyn Toy Company manufactures a line of dolls and a doll dress sewing kit. Demand for the dolls is increasing, and management requests assistance from you in determining the best sales and...
-
How Safe Are You? Assume one of your favorite activities is mountain climbing. When you go mountain climbing, you have several safety devices to keep you from falling. You notice that attached to one...
-
Your firm has decided to try two approaches to estimating a valuation allowance for sales returns. Required: a. First, your firm decides to estimate that 10% of all sales will eventually be returned....
-
Howie Homeowner has owned his home for 8 years. He purchased it for $250,000 and the insurance company required a policy with 80% minimum coverage so Howie bought a $200,000 HO-3 homeowner's...
-
Provide a definition of a budgets. What roles do they play and what reliable financial information from budgets can be used to ensure organizations operate effectively
-
The owner of a plot of land entered into a contract with a builder to build a house to certain specifications on the land for $200,000, to be paid on completion. The builder expected to spend...
-
A gearbox is needed to provide an exact 36:1 decrease in speed, while minimizing the overall gearbox size. The input and output shafts should be in-line. Specify appropriate teeth numbers. Input...
-
The Revolution at Johnsonville Foods Ralph Stayer joined his family's sausage-making business in Sheboygan, Wisconsin, after graduating from Notre Dame in 1965. In 1978, he replacedRalph Stayer...
-
Janice is an investment advisor who builds client portfolio utilizing Performa ETFs. In a year in which equity and fixed income markets experienced a significant decline, she encouraged her clients...
-
You were hired three years ago by a footwear manufacturer based in a small town in Northern Ontario, to help improve occupational health and safety and boost the employers environmental and corporate...
-
The Place-Plus real estate development firm in Problem 24 is dissatisfied with the economists estimate of the probabilities of future interest rate movement, so it is considering having a financial...
-
The dean of your business school has determined that there are four major drivers of success for her business school. Those success drivers are having outstanding (1) faculty, (2) students, (3)...
-
Using the income statement and balance sheet for Kau and Sons Co., compute the three components of return on equity'profitability, efficiency, and leverage'based on the DuPont framework, for the...
-
The following information is available for Silbermond Company: Assume a tax rate of 30%. Prepare a pro-forma income statement for the coming year forSilbermond. Beginning finished goods inventory. S...
-
10.A company contracted with a marketing firm to construct software and create a business website. A quote was requested and accepted. Sometime later, the business asked for updates and revisions but...
-
George Oppenheimer, an agent for Wellington Farms of Massachusetts, Inc., had contacted Mark Kiriakou from the Capital Area Food Bank regarding an order for frozen turkey meat. In an exchange of...
-
Extreme Machine manufactures machines and parts for various industries; they have an office in Youngstown, Ohio. Avery Dennison manufactures and sells labels from a plant in Mentor, Ohio. They use...
Study smarter with the SolutionInn App