PLEASE USE EXCEL! Scholastic Co. is evaluating a machine with an initial cost of $300,000 and a five-year life that costs $90,000 per year to operate. The firm uses straight-line depreciation; the applicable discount rate is 9%. The machine will have a salvage value of $100,000 at the end of the project's life. The firm has a tax rate of 21%. 1a. Calculate the operating cash flow in year 1. (Enter a negative value) 1b. Calculate the NPV of the project. (Enter a negative value and round to 2 decimals)

PLEASE USE EXCEL! Scholastic Co. is evaluating a machine with an initial cost of $300,000 and a five-year life that costs $90,000 per year to operate. The firm uses straight-line depreciation; the applicable discount rate is 9%. The machine will have a salvage value of $100,000 at the end of the project's life. The firm has a tax rate of 21%. 1a. Calculate the operating cash flow in year 1. (Enter a negative value) 1b. Calculate the NPV of the project. (Enter a negative value and round to 2 decimals)

Name: Ef 545. PLEASE USE EXCEL! Scholastic Co. is evaluating a machine with
Uploaded: 2024-03-20T06:50:59.000Z
Channel: Bartleby
Description: Ef 545. PLEASE USE EXCEL! Scholastic Co. is evaluating a machine with an initial cost of $300,000 and a five-year life that costs $90,000 per yearto operate. The firm uses straight-line depreciation; the applicable discount rate is 9%. The machine wi

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter9: Capital Budgeting And Cash Flow Analysis

Section: Chapter Questions

Problem 5P

See similar textbooks

Similar questions

Garnette Corp is considering the purchase of a new machine that will cost $342,000 and provide the following cash flows over the next five years: $99,000, $88,000, $92,000. $87,000, and $72,000. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return in Excel. see Appendix C.
Consolidated Aluminum is considering the purchase of a new machine that will cost $308,000 and provide the following cash flows over the next five years: $88,000, 92,000, $91,000, $72,000, and $71,000. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return in Excel, see Appendix C.
Gina Ripley, president of Dearing Company, is considering the purchase of a computer-aided manufacturing system. The annual net cash benefits and savings associated with the system are described as follows: The system will cost 9,000,000 and last 10 years. The companys cost of capital is 12 percent. Required: 1. Calculate the payback period for the system. Assume that the company has a policy of only accepting projects with a payback of five years or less. Would the system be acquired? 2. Calculate the NPV and IRR for the project. Should the system be purchasedeven if it does not meet the payback criterion? 3. The project manager reviewed the projected cash flows and pointed out that two items had been missed. First, the system would have a salvage value, net of any tax effects, of 1,000,000 at the end of 10 years. Second, the increased quality and delivery performance would allow the company to increase its market share by 20 percent. This would produce an additional annual net benefit of 300,000. Recalculate the payback period, NPV, and IRR given this new information. (For the IRR computation, initially ignore salvage value.) Does the decision change? Suppose that the salvage value is only half what is projected. Does this make a difference in the outcome? Does salvage value have any real bearing on the companys decision?
Gallant Sports s considering the purchase of a new rock-climbing facility. The company estimates that the construction will require an initial outlay of $350,000. Other cash flows are estimated as follows: Assuming the company limits its analysis to four years due to economic uncertainties, determine the net present value of the rock-climbing facility. Should the company develop the facility if the required rate of return is 6%?
Each of the following scenarios is independent. All cash flows are after-tax cash flows. Required: 1. Patz Corporation is considering the purchase of a computer-aided manufacturing system. The cash benefits will be 800,000 per year. The system costs 4,000,000 and will last eight years. Compute the NPV assuming a discount rate of 10 percent. Should the company buy the new system? 2. Sterling Wetzel has just invested 270,000 in a restaurant specializing in German food. He expects to receive 43,470 per year for the next eight years. His cost of capital is 5.5 percent. Compute the internal rate of return. Did Sterling make a good decision?
Friedman Company is considering installing a new IT system. The cost of the new system is estimated to be 2,250,000, but it would produce after-tax savings of 450,000 per year in labor costs. The estimated life of the new system is 10 years, with no salvage value expected. Intrigued by the possibility of saving 450,000 per year and having a more reliable information system, the president of Friedman has asked for an analysis of the projects economic viability. All capital projects are required to earn at least the firms cost of capital, which is 12 percent. Required: 1. Calculate the projects internal rate of return. Should the company acquire the new IT system? 2. Suppose that savings are less than claimed. Calculate the minimum annual cash savings that must be realized for the project to earn a rate equal to the firms cost of capital. Comment on the safety margin that exists, if any. 3. Suppose that the life of the IT system is overestimated by two years. Repeat Requirements 1 and 2 under this assumption. Comment on the usefulness of this information.
Dauten is offered a replacement machine which has a cost of 8,000, an estimated useful life of 6 years, and an estimated salvage value of 800. The replacement machine is eligible for 100% bonus depreciation at the time of purchase- The replacement machine would permit an output expansion, so sales would rise by 1,000 per year; even so, the new machines much greater efficiency would cause operating expenses to decline by 1,500 per year The new machine would require that inventories be increased by 2,000, but accounts payable would simultaneously increase by 500. Dautens marginal federal-plus-state tax rate is 25%, and its WACC is 11%. Should it replace the old machine?
The Scampini Supplies Company recently purchased a new delivery truck. The new truck cost $22,500, and it is expected to generate net after-tax operating cash flows, including depreciation, of $6,250 per year. The truck has a 5-year expected life. The expected salvage values after tax adjustments for the truck are given here. The company’s cost of capital is 10%. Should the firm operate the truck until the end of its 5-year physical life? If not, then what is its optimal economic life? Would the introduction of salvage values, in addition to operating cash flows, ever reduce the expected NPV and/or IRR of a project?
Roberts Company is considering an investment in equipment that is capable of producing more efficiently than the current technology. The outlay required is 2,293,200. The equipment is expected to last five years and will have no salvage value. The expected cash flows associated with the project are as follows: Required: 1. Compute the projects payback period. 2. Compute the projects accounting rate of return. 3. Compute the projects net present value, assuming a required rate of return of 10 percent. 4. Compute the projects internal rate of return.
Manzer Enterprises is considering two independent investments: A new automated materials handling system that costs 900,000 and will produce net cash inflows of 300,000 at the end of each year for the next four years. A computer-aided manufacturing system that costs 775,000 and will produce labor savings of 400,000 and 500,000 at the end of the first year and second year, respectively. Manzer has a cost of capital of 8 percent. Required: 1. Calculate the IRR for the first investment and determine if it is acceptable or not. 2. Calculate the IRR of the second investment and comment on its acceptability. Use 12 percent as the first guess. 3. What if the cash flows for the first investment are 250,000 instead of 300,000?
Gardner Denver Company is considering the purchase of a new piece of factory equipment that will cost $420,000 and will generate $95,000 per year for 5 years. Calculate the IRR for this piece of equipment. For further Instructions on internal rate of return in Excel, see Appendix C.
Your company is planning to purchase a new log splitter for is lawn and garden business. The new splitter has an initial investment of $180,000. It is expected to generate $25,000 of annual cash flows, provide incremental cash revenues of $150,000, and incur incremental cash expenses of $100,000 annually. What is the payback period and accounting rate of return (ARR)?