The chart below shows the initial investment and expected yearly payback for Project A and Project B Project A Project B Initial Investment $ 300,000 $ 450,000 Expected Yearly PayBack $ 45,000 $ 90,000 For Project A, There has been a change in the expected yearly payback. Years 1 and 2 – you are expecting $45,000 each year. For the next three years, you are expecting $70,000 each year. What would be the average ROI for this alternative?

The chart below shows the initial investment and expected yearly payback for Project A and Project B Project A Project B Initial Investment $ 300,000 $ 450,000 Expected Yearly PayBack $ 45,000 $ 90,000 For Project A, There has been a change in the expected yearly payback. Years 1 and 2 – you are expecting $45,000 each year. For the next three years, you are expecting $70,000 each year. What would be the average ROI for this alternative?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 21P

See similar textbooks

Similar questions

Two new Internet site projects are proposed to a young start -up company. Project A will cost $250,000 to implement and is expected to have annual net cash flows of $75,000. Project B will cost $150,000 to implement and should generate annual net cash flows of $52,000. The compnay is very concerned about their cash flow. Using the payback period, which project is better, from a cash flow standpoint?
You are the project manager for a railroad construction project. Your sponsor has asked you for a forecast for the cost of project completion. The project has a total budget of $80,000 and CPI of .95. The project has spent $25,000 of its budget so far. How much more money do you plan to spend on the project? A. $80000 B. $84,210 C. $59,210 D. $109,210
Kiley Electronics is considering a project that has the following cash flow data. What is the project's IRR, and should the firm accept the project based on IRR if its WACC is 13.00%? Year 0 1 2 3 Cash flows -$1,100 $450 $470 $490 13.31%; Accept 13.31%; Reject -14.64%; Reject 11.98%; Accept 11.98%; Reject
Investment timing option: left Table shows the investment made now (year 0); right Table shows the investment made 1 year later. Discount rate is r = 10%. Probability Year 0 0.50 -$28 0.50 -$10 $11 None of the others is correct $10 Year 1 $55 $22 If this project's uncertainty in Year 0 (two scenarios with 50% chance each) is completely gone right after the end of year 0, i.e., you will know which scenario turns out to be true right after Year 0, then what is the value of this investment timing option today? [Hint: value of the option = E[NPV with option] - E[NPV] =?] 3 Year 2 $0 Probability Year 0 0.50 $0 0.50 Year 1 -$28 -$28 Year 2 $55 $22
Randall Systems in considering four projects A, B, C and D that have risks associated with the producing benefits. Based on the information given in the table below, which project is more desirable for the company? Project A Project B Project C Project D EUAW Prob. EUAW Prob. EUAW Prob. EUAW Prob. $2,000 0.2 $3,000 0.1 -$5,000 0.2 $4,000 0.4 $1,500 0.5 -$2,500 0.4 $6,500 0.5 $2,500 0.3 $3,000 0.3 $3,500 0.5 $1,000 0.3 -$2,000 0.3
4. Using a discounted rate of 12 percent, INITIAL COST NET CASH FLOW YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 PROJECT A (BROILER) K100,000 (20,000) 10,000 40.000 40.000 150.000 PROJECT B (LAYERS) K100,000 33,000 33,000 33,000 33,000 33,000 a. Determine the net present value of project A and B b. Calculate the IRR on mutually exclusive investment of project A and B. C. Which project must the farm undertake and why?
Recently, you were assigned to manage a project for your company. You have constructed a network diagram depicting the various activities in the project (shown below to the right). In addition, you have asked your team to estimate the amount of time that they would expect each of the activities to take. Their responses are shown in the following table: example Activity A B C D Get more help. E Time Estimates (days) Most Likely Optimistic 4 5 4 1 3 8 8 5 4 8 Pessimistic 12 12 7 5 a. What is the expected completion time of the project? The expected completion time is 19 days. (Enter your response as an integer.) b. What is the probability of completing the project in 21 days? Refer to the standard normal table. The probability of completing the project in 21 days is 9 MacBook Pro Start (Enter your response rounded to four decimal places.) 0 Finish Q Q Clear all Check answer
Create a risk matrix for this project:Event Cost ($000) ProbabilityEquipment breakdown 40 .20Vendor is late with key segment 200 .60Subcontractor has labor issues 140 .30Weather problems 15 UnknownFunding delays 50 .40 to .60Testing delays 20 .40Explain your reasoning for your placement of the events Weather problems and Funding delays.
In a recent review meeting, the client has insisted you complete the project on time. You would like to get the Estimate at Completion for your project, so you perform Earned Value analysis and get the following data: the value of the completed work is $176,500; you have spent $223,500; and the planned value is $229,100. The initial budget of the project is $419,500. What is EAC? Your answer should be rounded to the nearest whole number, for example 123,456.73 should be rounded to 123,457. A
Using your results from Problem 6,(a) Calculate the probability that the project will be completedin 38 weeks.(b) Calculate the probability that the project will be completedin 42 weeks
You are working on a manufacturing project having a budget of PKR 3,600,000 and expected time of its completion is one year. There is an ideal condition that your budget and work are evenly spread across the duration of the project that is twelve month. At the end of forth month, the senior management has called a meeting and invited all the stakeholders to brief about the status of the project. You being the PM of this project is giving the presentation to all the attendees and informed that project is on schedule and PKR 1,800,000 have already been spent on the project. Required: Calculate Cost and Schedule Variance What is SPI and CPI of the project? Estimate at completion and Estimated time to complete?
Your vice president asked you what the Estimate at Completion (EAC) will be for a small project you are working on. You were given a budget of S50,000, and to date you have spent $40,000 but only completed $30,000 worth of work. You are sure the future work will be accomplished at the planned rate. What is the EAC ?