Question

In: Finance

QUESTION 14 A company is considering three independent projects (G, H, and I) that have the...

QUESTION 14 A company is considering three independent projects (G, H, and I) that have the following expected cash flows and risk-adjusted discount rates. Project Discount Rate (k) Initial Investment Year 1 Year 2 Year 3 Year 4 Year 5 G 9.0% ($800) $200 $200 $200 $200 $250 H 5.0% ($500) $300 $50 $50 $50 $200 I 7.0% ($400) $90 $120 $150 $100 $50 The company has a budget constraint of $1,000. Based on NPV, which project(s) should the company choose? 1. Project H 2. Projects H and I 3. Project G 4. None

Solutions

Expert Solution

Solution :

The NPV of project G = $ 10.43 ; Initial Investment = $ 800

The NPV of project H = $ 72.10 ; Initial Investment = $ 500

The NPV of project I = $ 23.31   ; Initial Investment = $ 400

Projects H & I have higher NPV when compared to Project G

Thus Project H & I should be chosen.

Also, the company has a budget constraint of $ 1,000. The total Investment of Project H & Project I is = $ 500 + $ 400 = $ 900, which is within the budget constraint of $ 1000.

Based on NPV the company should choose projects H & I

Thus the solution is Option 2. Project H & I.

Please find the attached screenshot of the excel sheet containing the detailed calculation for the above solution.


Related Solutions

A company is considering three projects (G, H, and I) that have the following expected cash...
A company is considering three projects (G, H, and I) that have the following expected cash flows and risk-adjusted discount rates. Project Discount Rate (k) Initial Investment Year 1 Year 2 Year 3 Year 4 Year 5 G 9.0% ($800) $200 $200 $200 $200 $250 H 5.0% ($500) $300 $50 $50 $50 $200 I 7.0% ($400) $90 $120 $150 $100 $50 The company wants to rank the projects based on PI. Which project has the highest PI? Project G Project...
Jon is considering three independent projects (F, G, and H) for investment with financial information shown...
Jon is considering three independent projects (F, G, and H) for investment with financial information shown in the following table. Use present worth analysis to determine which projects he should choose, if any, if his MARR is 7% and he has no budget limit. MAKE SURE TO SHOW CONVERSION FACTOR NOTATIONS AS WELL! Project Initial investment ($) Annual Net Cash Flow ($) Life (years) F -7,000 1,000 8 G -6,000 1,500 6 H -8,000 2,500 4
Yelp! Company is considering investing in Project G or Project H. The projects generate the following...
Yelp! Company is considering investing in Project G or Project H. The projects generate the following end of year cash flows: Year 0 Year 1 Year 2 Project G -250 246 236 Project H -200 180 100 The MARR is 10% per year, compounded annually. Compute the Internal Rate of Return (IRR) of the BEST project. (note: round your answer to two decimal places and do not include spaces or percentage signs. If the answer is 1.53%, write 1.53 as...
Walsh Company is considering three independent projects, each of which requires a $6 million investment. The...
Walsh Company is considering three independent projects, each of which requires a $6 million investment. The estimated internal rate of return (IRR) and cost of capital for these projects are presented below: Project H (High risk): Cost of capital = 16% IRR = 21% Project M (Medium risk): Cost of capital = 14% IRR = 11% Project L (Low risk): Cost of capital = 7% IRR = 9% Note that the projects' costs of capital vary because the projects have...
Your company is considering three independent projects. Given the following cash flow information, calculate the payback...
Your company is considering three independent projects. Given the following cash flow information, calculate the payback period for each. If your company requires a three-year payback before an investment can be accepted, which project(s) would be accepted? Project D Project E Project F Cost 205,000.00 179,000.00 110,000.00 Inflow year 1 53,000.00 51,000.00 25,000.00 Inflow year 2 50,000.00 87,000.00 55,000.00 Inflow year 3 48,000.00 41,000.00 21,000.00 Inflow year 4 30,000.00 52,000.00 9,000.00 Inflow year 5 24,000.00 40,000.00 35,000.00 Payback Period EXACT...
Your company is considering the following three projects.                                 &nbs
Your company is considering the following three projects.                                            CF0                     CF1                    CF2                       CF3                     CF4 Project Whiskey             -100                     80                     20                         80                       20    Project Tango                  -100                     20                     80                        20                       80 Project Foxtrot                 -100                    50                      50                         50                      50 What is Project Whiskey’s discounted payback period if our WACC is 8%? Should the project be accepted if the maximum payback period is 4.05 years? Show your work to receive full credit.
Yep Company is considering investing in Project G or Project H. Project G generates the following...
Yep Company is considering investing in Project G or Project H. Project G generates the following cash flows: year “zero” = 254 dollars (outflow); year 1 = 244 dollars (inflow); year 2 = 346 dollars (inflow). Project H generates the following cash flows: year “zero” = 200 dollars (outflow); year 1 = 180 dollars (inflow); year 2 = 100 dollars (inflow). The MARR is 10 %. Compute the Internal Rate of Return (IRR) of the BEST project. PLEASE INCLUDE FORMULAS...
You are considering two independent projects that have a required return of 15 percent. Project A...
You are considering two independent projects that have a required return of 15 percent. Project A has an initial cost of $198,700 and cash inflows of $67,200, $109,600, and $88,700 for years 1 to 3 respectively. Project B has an initial cost of $102,000 and cash inflows of $37,600 and $91,200 for years 1 and 2, respectively. Given this information, which one of the following statements is correct based on the NPV and IRR methods of analysis? You should accept...
Lane Industries is considering three independent projects, each of which requires a $2.5 million investment. The...
Lane Industries is considering three independent projects, each of which requires a $2.5 million investment. The estimated internal rate of return (IRR) and cost of capital for these projects are presented here: Project H (high risk): Cost of capital = 15% IRR = 17% Project M (medium risk): Cost of capital = 10% IRR = 8% Project L (low risk): Cost of capital = 7% IRR = 8% Note that the projects' costs of capital vary because the projects have...
Lane Industries is considering three independent projects, each of which requires a $2.5 million investment. The...
Lane Industries is considering three independent projects, each of which requires a $2.5 million investment. The estimated internal rate of return (IRR) and cost of capital for these projects are presented here: Project H (high risk): Cost of capital = 13% IRR = 15% Project M (medium risk): Cost of capital = 10% IRR = 8% Project L (low risk): Cost of capital = 8% IRR = 9% Note that the projects' costs of capital vary because the projects have...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT