Using Excel Your division is considering two investment projects, each of which requires an up-front expenditure of $25 million. You estimate that the cost of capital is 10% and that the investments will produce the following after-tax cash flows (in millions of dollars): What is the regular payback period for each of the projects? What is the discounted payback period for each of the projects? I need the solution in Excel.

Using Excel Your division is considering two investment projects, each of which requires an up-front expenditure of $25 million. You estimate that the cost of capital is 10% and that the investments will produce the following after-tax cash flows (in millions of dollars): What is the regular payback period for each of the projects? What is the discounted payback period for each of the projects? I need the solution in Excel.

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter12: Capital Budgeting: Decision Criteria

Section: Chapter Questions

Problem 7P: Your division is considering two investment projects, each of which requires an up-front expenditure...

See similar textbooks

Similar questions

Your company is currently considering two investment projects. Each project requires an upfront expenditure of $25 million. You estimate that the cost of capital is 10% and the investments will produce the after tax cash flows on the attached image . a)Calculate the payback period for both projects,then compare to identify which project the firm should undertake. b)Evaluate the advantages and disadvantages of using the payback method in investment decisions and assess the situations where it should be used .
Your division is considering two investment projects, each of which requires an up-front expenditure of $25 million. You estimate that the cost of capital is 10% and that the investments will produce the following after-tax cash flows (in millions of dollars): Year Project A Project B 1 5 20 2 10 10 3 15 8 4 20 6 . What is the regular payback period for each of the projects? What is the discounted payback period for each of the projects? If the two projects are independent and the cost of capital is 10%, which project or projects should the firm undertake? If the two projects are mutually exclusive and the cost of capital is 5%, which project should the firm undertake? If the two projects are mutually exclusive and the cost of capital is 15%, which project should the firm undertake? What is the crossover rate? If the cost of capital is 10%, what is the modified IRR (MIRR) of each project?
Your division is considering two investment projects, each of which requires an up-front expenditure of $25 million. You estimate that the cost of capital is 10 percent and that the investments will produce the following after-tax cash flows (in millions of dollars): Year Project A Project B 1 5 20 2 10 10 3 15 8 4 20 6 What is the regular payback period for each of the projects? What is the discounted payback period for each of the projects? What is the accounting rate of return for each of the projects? If the cost of capital is 11 percent, what is the modified IRR (MIRR) of each project?
Your division is considering two investment projects, each of which requires an up-front expenditure of 25 million. You estimate that the cost of capital is 10 percent and that the investments will produce the following after-tax cash flows (in millions of dollars): Year Project A Project B 1 5 20 2 10 10 3 15 8 4 20 6 Required a. What is the regular payback period for project A.
Your division is considering two investment projects, each of which requires an up-front expenditure of 25 million. You estimate that the cost of capital is 10 percent and that the investments will produce the following after-tax cash flows (in millions of dollars): Year Project A Project B 1 5 20 2 10 10 3 15 8 4 20 6 Required a. What is the regular payback period for project B. b. What is the discounted payback period for each of the projects?
Consider the following projects, X and Y where the firm can only choose one. Project X costs $600 and has cash flows of $400 in each of the next 2 years. Project Y also costs $600, and generates cash flows of $500 and $275 for the next 2 years, respectively. Sketch a net present value profile for each of these projects. Which project should the firm choose if the cost of capital is 10 percent? What if the cost of capital is 25 percent? Show all work.
Do the following problems. You must show your work.a) Find the PP and NPV of the following projects. Assume that the projects' cost of capital (or WACC) is 8%.Project A that costs $200 million is expected to generate $50m in year 1, $80m in year 2, and $100m in year 3.Project B that costs $500 million is expected to generate $85 per year for 10 years.
Your division is considering two projects. The required rate of return for both projects is 12%. Below are the cash flows of both the projects: (Note: show all computations) Projects Initial investment Year 1 Year 2 Year 3 Year 4 A -$50 $7 $12 $17 $25 B -$50 $20 $18 $12 $11 Calculate the Payback period and discounted payback period. Why are they different? Calculate the NPV for both the projects Which projects should be accepted on the basis of IRR?
Your division is considering two projects. The required rate of return for both projects is 12%. Below are the cash flows of both the projects: Projects Initial investment Year 1 Year 2 Year 3 Year 4 A -$50 $7 $12 $17 $25 B -$50 $20 $18 $12 $11 a) Calculate the Payback period and discounted payback period. Why are they different? b) Calculate the NPV for both the projects c) Calculate the NPV for both the projec
could you help with this homework question? The project you manage require $10,000 in capital outlay, $30,000 in equipment, and $10,000 in training during the first year. Each subsequent year will incur additional labor cost of $5,000 per year, reduce material costs by $15,000, and increase revenue by $20,000 per year. Assume NPV is discounted by 5%. Please include your formula for the payback method conduct a cost-benefit analysis using the payback method and the net present value method for
Use the format in the figure below to perform a financial analysis. Create a spreadsheet to perform the analysis and show the NPV, ROI, and year in which payback occurs. + Perform a financial analysis for a project using the format provided in Figure 4-5. Assume that the projected costs and benefits for this project are spread over four years as fol- lows: Estimated costs are $200,000 in Year 1 and $30,000 each year in Years 2, 3, and 4. Estimated benefits are $0 in Year 1 and $100,000 each year in Years 2, 3, and 4. Use a 9 percent discount rate, and round the discount factors to two decimal places. Create a spreadsheet or use the business case financials template on the companion website to cal- culate and clearly display the NPV, ROI, and year in which payback occurs. In addition, write a paragraph explaining whether you would recommend investing in this project, based on your financial analysis. Discount rate 8% Assume the project is completed in Year 0 0 Costs Discount factor…
Do the following problems. You must show your work.c) Find the IRR and MIRR of the following project and make your decision. Assume that the project's cost of capital (or WACC) is 4%. Project X that costs $30 million is expected to generate $13m per year for 3 years. Is this project acceptable?