please note there are several required answers Santana Rey is considering the purchase of equipment for Business Solutions that would allow thecompany to add a new product to its computer furniture line. The equipment is expected to cost$366,240 and to have a six-year life and no salvage value. The equipment is expected to generateincome of $15,039 and net cash flow of $76,836 in each year of its six-year life. Santana requiresan 8% return on all investments. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriatefactor(s) from the tables provided.) (Negative net present values should be indicated with aminus sign. Do not round intermediate calculations. Round your present value factor to 4decimals and final answers to the nearest whole number.)Required:1-a. Compute the payback period for this equipment.1-b. Compute the net present value for this equipment.1-c. Compute internal rate of return for this equipment.2. If Santana requires investments to have payback periods of four years or less, should she investin this equipment?3. If Santana requires investments to have at least an 8% internal rate of return, should she investin this equipment?Complete this question by entering your answers in the tabs below.Req 1AReq 1BReq 1CNumerator:Compute the payback period for this equipment.Req 2 and 31Payback PeriodDenominator:< Req 1A==Payback periodReq 1B >

Payback period The payback period is the amount of time necessary for an investor to achieve a…

Santana Rey is considering the purchase of equipment for Busin company to add a new product to its computer furniture line. The $366,240 and to have a six-year life and no salvage value. The e income of $15,039 and net cash flow of $76,836 in each year of an 8% return on all investments. (PV of $1, FV of $1, PVA of $1, an factor(s) from the tables provided.) (Negative net present valu minus sign. Do not round intermediate calculations. Round you

Santana Rey is considering the purchase of equipment for Busin company to add a new product to its computer furniture line. The $366,240 and to have a six-year life and no salvage value. The e income of $15,039 and net cash flow of $76,836 in each year of an 8% return on all investments. (PV of $1, FV of $1, PVA of $1, an factor(s) from the tables provided.) (Negative net present valu minus sign. Do not round intermediate calculations. Round you

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter26: Capital Budgeting (capbud)

Section: Chapter Questions

Problem 1R

See similar textbooks

Similar questions

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?
The Ham and Egg Restaurant is considering an investment in a new oven that has a cost of $60,000, with annual net cash flows of $9,950 for 8 years. The required rate of return is 6%. Compute the net present value of this investment to determine whether or not you would recommend that Ham and Egg invest in this oven.
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?
Bouvier Restaurant is considering an investment in a grill that costs $140,000, and will produce annual net cash flows of $21,950 for 8 years. The required rate of return is 6%. Compute the net present value of this investment to determine whether Bouvier should invest in the grill.
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.
Cinemar Productions bought a piece of equipment for $55,898 that will last for 5 years. The equipment will generate net operating cash flows of $14,000 per year and will have no salvage value at the end of its life. What is the internal rate of return?
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?
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.
Taos Productions bought a piece of equipment for $79,860 that will last for 5 years. The equipment will generate net operating cash flows of $20,000 per year and will have no salvage value at the end of its life. What is the internal rate of return?
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?