Russell Trent was recently tasked with evaluating projects for Stan's No Touch Car Wash. The company recently decided to use NPV as its primary criterion for approving projects. To be selected, a project must have a positive NPV. Russell is currently evaluating a project with the following estimated investment requirements ($ millions) by year (starting in year 0): \ Investment Year Investment 0 16 1 10.1 2 12.5 The estimated revenues ($ millions) from the project, expected to begin at time 2, are given in the table below: Investment Year Investment 0 11.1 1 11.3 2 8.2 3 14.3 4 11.9 To account for the different risk characteristics throughout the project's life, Russell has determined that a hurdle rate of 23% should be used beginning at time 0, while 37% should be used beginning in period 4. Determine the NPV for the project. NPV=

Russell Trent was recently tasked with evaluating projects for Stan's No Touch Car Wash. The company recently decided to use NPV as its primary criterion for approving projects. To be selected, a project must have a positive NPV. Russell is currently evaluating a project with the following estimated investment requirements ($ millions) by year (starting in year 0): \ Investment Year Investment 0 16 1 10.1 2 12.5 The estimated revenues ($ millions) from the project, expected to begin at time 2, are given in the table below: Investment Year Investment 0 11.1 1 11.3 2 8.2 3 14.3 4 11.9 To account for the different risk characteristics throughout the project's life, Russell has determined that a hurdle rate of 23% should be used beginning at time 0, while 37% should be used beginning in period 4. Determine the NPV for the project. NPV=

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

DuraTech Manufacturing is evaluating a process improvement project. The estimated receipts and disbursements associated with the project are shown below. MARR is 6%/year. Solve, a. What is the present worth of this investment? b. What is the decision rule for judging the attractiveness of investments based on present worth? c. Should DuraTech implement the proposed process improvement?
Mace Manufacturing is in the process of analyzing its investment decision-making procedures. Two projects evaluated by the firm recently involved building new facilities in different regions, North and South. The basic variables surrounding each project analysis and the resulting decision actions are summarized in the following table: Basic variables North South Cost $7,000,000 $6,370,000 Life 12 years 12 years Expected return 7.8% 14.7% Least-cost financing Source Debt Equity Cost (after-tax) 5.1% 16.6% Decision Action Invest Don't invest Reason 7.8%>5.1% cost 14.7%<16.6% cost a. An analyst evaluating the North facility expects that the project will be financed by debt that costs the firm 5.1%. What recommendation do you think this analyst will make regarding the investment opportunity? b. Another analyst assigned to study the South facility believes that…
Mace Manufacturing is in the process of analyzing its investment decision-making procedures. Two projects evaluated by the firm recently involved building new facilities in different regions, North and South. The basic variables surrounding each project analysis and the resulting decision actions are summarized in the following table: Basic variables North South Cost $7,000,000 $6,370,000 Life 12 years 12 years Expected return 7.8% 14.7% Least-cost financing Source Debt Equity Cost (after-tax) 5.1% 16.6% Decision Action Invest Don't invest Reason 7.8%>5.1% cost 14.7%<16.6% cost d. If the firm maintains a capital structure containing 40% debt and 60% equity, find its weighted average cost using the data in the table. e. If both analysts had used the weighted average cost calculated in part d, what recommendations would they have made regarding the…
DuraTech Manufacturing is evaluating a process improvement project. The estimated receipts and disbursements associated with the project are shown below. MARR is 6%/yr. Solve, a. What is the internal rate of return of this investment? b. What is the decision rule for judging the attractiveness of investments based on internal rate of return? c. Should DuraTech implement the proposed process improvement?
DuraTech Manufacturing is evaluating a process improvement project. The estimated receipts and disbursements associated with the project are shown below. MARR is 6%/year. Solve, a. What is the annual worth of this investment? b. What is the decision rule for judging the attractiveness of investments based on annual worth? c. Should DuraTech implement the proposed process improvement?
Informics, Inc. is building fifth-generation software. The software quality initiatives will cost $26,800, and $37,000 is for maintenance of quality initiatives. The revenues from the initiatives: What is the cost of software quality? What is the software quality net present value? What is the return on software quality? Year Cash Flow O ($22,500) 1 51,000 2 96,250 3 96,250 4 96,250 5 96,250
EncryptCo is considering a project with a $50,000 first cost that returns $12,000 per year. Assume that it will have a salvage value of $6500 at the end of its service life. The MARR is 12 percent. (a) Calculate the payback period for this project. (b) Calculate the discounted payback period for this project. Use Excel to do this and include the Excel output in your Assignment report.
Calculate the NPV of each project. (Use the NPV function in Excel to solve this problem.) Which of the two projects would you fund if the decision is based only on financial information and you could only choose one of the projects? Omega Alpha Year Inflow YO 0 Y1 0 Outflow 207,000 110,000 Netflow Year Inflow Outflow Netflow (207,000) YO 0 217,000 (217,000) (110,000) Y1 7,000 190,000 (183,000) Y2 150,000 0 150,000 Y2 150,000 0 150,000 Y3 220,000 30,000 190,000 Y3 220,000 30,000 190,000 Y4 161,000 0 161,000 Y4 191,000 0 191,000 Y5 205,000 48,000 157,000 Y5 205,000 38,000 167,000 Y6 197,000 0 197,000 Y6 197,000 0 197,000 Y7 100,000 30,000 70,000 Y7 100,000 30,000 70,000 Total 1,033,000 425,000 608,000 Total 1,070,000 505,000 565,000 The NPV for Omega is The NPV for Alpha is The better project is
Consider an order delivery business that will be a 5-year project. The required net working capital is $6.6 million and it will be returned at the end of the life of the project. Required equipment (net capital spending) will cost $15 and it will be depreciated straight-line to 0 over the 5-year life of the project. The business will have sales of $3 million in year 1, $6 million in year 2, and $10 million in years 3, 4, and 5. Costs are 30% of sales and the tax rate is 20%. (If there is a loss at the EBIT line, assign taxes of 0 for that year and do not carry tax losses forward.) The equipment has no salvage value. Create an income statement for years 1, 2, and 3, 4, and 5 (3, 4, and 5 will have the same income statement). Use the information from the income statement to calculate the operating cash flow using EBIT + depreciation – taxes for each year. Put all cash flows (net working capital, net capital spending, and operating cash flows) on a timeline. Using total cash flows from…
Assume that the capital requirement of "Purchase new equipment" in Year 3 is 3000. Suppose that if basic research is carried out, the advertising campaign must also be conducted. Add this constraint to your model and find the new optimal solution. What is the optimal revenue?
A firm by the name “Modern Nursing Care” is considering two projects for investment in biomedical plant. Based on the payback period method suggest which is a better investment choice.Project –A-Initial investment- 200000$, Cash inflows- 500000$ per year, life of project 8 years.Project-B-Initial investment-250000$, Cash inflows-25000$ per year, life of project 12 years.
ii) The directors of Komfwe’s Bibbentuckers are considering purchasing a new laundry machinery that would improve the quality and productivity of cleaning processing. The initial investment needed for the machinery is ZMW 120, 000. The cost of capital is 12% from Citizen Economic Empowerment Commission With a new machinery in place, the project is expected to generate the following cash flows, ZMW 20 000 in the first year, ZMW 30 000 in the second year, ZMW 40 000 in the third year, ZMW 50 000 in the fourth year, and ZMW 50 000 in the fifth year. • Calculate he Payback period for the project • Calculate the Net present value for the project • Advice if the project should be accepted under Net present value and payback period to Komfwe's Management board?