An electric power generating project has a first cost of $447,946 and annual operating costs of $30,000. There is a $180,000 overhaul cost in Year 8. The facility will have a salvage value of $75,000 at the end of Year 15. What is the minimum annual revenue for a breakeven PW at i=10%? Answer to the nearest whole dollar, and enter only the number. PLEASE USE EXCEL AND SHOW FORMULA

An electric power generating project has a first cost of $447,946 and annual operating costs of $30,000. There is a $180,000 overhaul cost in Year 8. The facility will have a salvage value of $75,000 at the end of Year 15. What is the minimum annual revenue for a breakeven PW at i=10%? Answer to the nearest whole dollar, and enter only the number. PLEASE USE EXCEL AND SHOW FORMULA

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 5R

See similar textbooks

Similar questions

Caduceus Company is considering the purchase of a new piece of factory equipment that will cost $565,000 and will generate $135,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.
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?
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?
Average rate of returncost savings Maui Fabricators Inc. is considering an investment in equipment that will replace direct labor. The equipment has a cost of 125,000 with a 15,000 residual value and an eight-year life. The equipment will replace one employee who has an average wage of 28,000 per year. In addition, the equipment will have operating and energy costs of 5,150 per year. Determine the average rate of return on the equipment, giving effect to straight-line depreciation on the investment.
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?
The Rodriguez Company is considering an average-risk investment in a mineral water spring project that has an initial after-tax cost of 170,000. The project will produce 1,000 cases of mineral water per year indefinitely, starting at Year 1. The Year-1 sales price will be 138 per case, and the Year-1 cost per case will be 105. The firm is taxed at a rate of 25%. Both prices and costs are expected to rise after Year 1 at a rate of 6% per year due to inflation. The firm uses only equity, and it has a cost of capital of 15%. Assume that cash flows consist only of after-tax profits because the spring has an indefinite life and will not be depreciated. a. What is the present value of future cash flows? (Hint: The project is a growing perpetuity, so you must use the constant growth formula to find its NPV.) What is the NPV? b. Suppose that the company had forgotten to include future inflation. What would they have incorrectly calculated as the projects NPV?
Talbot Industries is considering launching a new product. The new manufacturing equipment will cost $17 million, and production and sales will require an initial $5 million investment in net operating working capital. The company’s tax rate is 25%. What is the initial investment outlay? The company spent and expensed $150,000 on research related to the new product last year. What is the initial investment outlay? Rather than build a new manufacturing facility, the company plans to install the equipment in a building it owns but is not now using. The building could be sold for $1.5 million after taxes and real estate commissions. What is the initial investment outlay?
The Siler Construction Company is about to bid on a new industrial construction project. To formulate their bid, the company needs to estimate the time required for the project. Based on past experience, management expects that the project will require at least 24 months, and could take as long as 48 months if there are complications. The most likely scenario is that the project will require 30 months. a. Assume that the actual time for the project can be approximated using a triangular probability distribution. What is the probability that the project will take less than 30 months? b. What is the probability that the project will take between 28 and 32 months? c. To submit a competitive bid, the company believes that if the project takes more than 36 months, then the company will lose money on the project. Management does not want to bid on the project if there is greater than a 25% chance that they will lose money on this project. Should the company bid on this project?