compute for ROI, NPV and Profitability Index I. Create a structural organization of your team. Choose any of the exampled structd assign a designation to cach member. State the qualifications of cach of every team member. I1. Select the most profitable project, using required rate of return of 15% - Project A Initial Investment = 50,000 Cash flow for the next 3 ycars = 25,000 Project B Initial Investment 100,000 Cash flow for the next 4 years = 31,250 - Project C Initial Investment 150,000 Cash flow for the next 5 years = 35,000

compute for ROI, NPV and Profitability Index I. Create a structural organization of your team. Choose any of the exampled structd assign a designation to cach member. State the qualifications of cach of every team member. I1. Select the most profitable project, using required rate of return of 15% - Project A Initial Investment = 50,000 Cash flow for the next 3 ycars = 25,000 Project B Initial Investment 100,000 Cash flow for the next 4 years = 31,250 - Project C Initial Investment 150,000 Cash flow for the next 5 years = 35,000

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 10P: Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year...

See similar textbooks

Similar questions

You have been assigned to perform a project selection based on profitability index. You have collected data on the three project alternatives A1, A2, and A3 and your team has calculated the following (table) present worth equivalent for the benefits, costs, and investments at a social discount rate of 10%. The service life of each alternative is identical. (a) Find the PI(i) for each project alternative (b) Find the best alternative based on incremental PI(i) analysis (c) Why is the profitability index referred to as a measure of capital efficiency?
The Company has three potential projects from which to choose. Selected information on each of the three projects follows: Project A Project B Project C Investment required $44,400 $55,700 $53,100 Net present value of project $49,100 $74,100 $69,100 Using the profitability index, rank the projects from most profitable to least profitable. A, B, C B, A, C B, C, A C, B, A
please help, information technology project management Perform financial analysis for a project using the format provided in Figure 4-5 in your textbook (attached business_case_financials template). Assume that the project costs and benefits for this project are spread over four years as follows: 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. Using the attached business case financials template, calculate 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. Business case financial spreadsheet and paragraph explaining your recommendations for investing or not in the project.
Calculate the profitability index for the below projects and indicate your order of choices. Project Present Value Investment A $145,000 $95,000 $135,000 $80,000 $175,000 $110,000 Select one: a. B, A and C b. A, C and B c. B, C and A d. C, B and A B с
Compute the IRR, NPV, Pi, and payback period for the following two projects. Assume the required return is 10%. Year Project A Project B 0 $-200 $-150 1 $200 $50 2 $800 $100 3 $-800 $150 Please show inputs from the BAII Plus Financial calculator of how to get these answers
Please solve both (a) and (b) in an Excel Spreadsheet and provide formulas you used. a) Use rate of return (ROR) analysis to determine which of the mutually exclusive projects listed below to select given a MARR of 12% per year. b) Confirm your answer to part (a) using Present Worth analysis.
You are evaluating the following two mutually exclusive projects: Project Year 0 Year 1 Year 2 A -$100 $95 $140 B -$50 $50 $120 Both have 15% cost of capital. Using NPV profiles for Projects A and B, determine which project would be chosen under each of IRR rule and NPV rule. (Hint: Draw the NPV profiles.) Group of answer choices A under IRR rule, and B under NPV rule B under IRR rule, and A under NPV rule A under both IRR and NPV rules Cannot be determined. B under both IRR and NPV rules
A firm evaluates all of its projects by applying the IRR rule. If the required return is 14 percent, should the firm accept the following project? Input area: Required Return Year 0 Year 1 Year 2 Year 3 (Use cells A6 to B10 from the given information to complete this question.) Output area: 14% ($41,000) $20,000 $23,000 $14,000 IRR
A firm evaluates all of its projects by applying the IRR rule. The required return for the following project is 21 percent. The IRR is _____ percent and the firm should ______ the project. Year Cashflow 0 -$28,643 1 $21,000 2 $16,000 3 $4,000
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…
Average Rate of Return The following data are accumulated by Watershed Inc. in evaluating two competing capital investment proposals: Amount of investment Useful life Estimated residual value Estimated total income over the useful life Project A Project Z $80,000 $64,000 4 years 9 years 0 0 $6,400 $20,160 Determine the expected average rate of return for each project. Round your answers to one decimal place. Project A Project Z Feedback Check My Work X % X %
An interior design studio is trying to choose between the following two mutually exclusive design projects: Year 0 1 2 3 Cash Flow Cash Flow (0) -$64,000 31,000 31,000 31,000 a-1 If the required return is 10 percent, what is the profitability index for both projects? (Round your answers to 3 decimal places. (e.g., 32.161)) Project I Project II -$18,000 9,700 9,700 9,700 Profitability Index a-2 If the company applies the profitability index decision rule, which project should the firm accept? O Project I O Project II Project I Project II b-1 What is the NPV for both projects? (Round your answers to 2 decimal places. (e.g., 32.16)) O Project I Project II NPV b-2lf the company applies the NPV decision rule, which project should it take?