a | Number of possible IRR =Number of sign changes | ||||||||||||||||||
Project | Number of possible IRR | ||||||||||||||||||
A | 3 | ||||||||||||||||||
C | 1 | ||||||||||||||||||
D | 2 | ||||||||||||||||||
E | 3 | ||||||||||||||||||
b | Simple Investments are investments with only one cahnge in sign in the net cash flow | ||||||||||||||||||
Non Simple Investments are investments with more than one cahnge in sign in the net cash flow | |||||||||||||||||||
Project | |||||||||||||||||||
A | Non-Simple | ||||||||||||||||||
C | Simple | ||||||||||||||||||
D | Non-Simple | ||||||||||||||||||
E | Non-Simple | ||||||||||||||||||
Present Value (PV)of Cash Flow=(Cash Flow)/((1+i)^N) | |||||||||||||||||||
i=discount rate , N=Year of cash Flow | |||||||||||||||||||
NPV =Sum of PV | |||||||||||||||||||
Project A | |||||||||||||||||||
N | CF | PV1=CF/(1^N) | PV2=CF/(1.1^N) | PV3 | PV4 | PV5 | PV6 | PV7 | PV8 | PV9 | PV10 | PV11 | PV12 | PV13 | |||||
Year | Cash Flow | PV at 0% | PV at 10% | PV at 20% | PV at 30% | PV at 40% | PV at 50% | PV at 60% | PV at 70% | PV at 80% | PV at 90% | PV at 100% | PV at110% | PV at 120% | |||||
0 | -1500 | -1500 | -1500 | -1500 | -1500 | -1500 | -1500 | -1500 | -1500 | -1500 | -1500 | -1500 | -1500 | -1500 | |||||
1 | 3000 | 3000 | 2727.272727 | 2500 | 2307.692 | 2142.857143 | 2000 | 1875 | 1764.706 | 1666.667 | 1578.947 | 1500 | 1428.5714 | 1363.636 | |||||
2 | -1500 | -1500 | -1239.669421 | -1041.67 | -887.574 | -765.3061224 | -666.667 | -585.938 | -519.031 | -462.963 | -415.512 | -375 | -340.13605 | -309.917 | |||||
3 | 15 | 15 | 11.26972201 | 8.680556 | 6.827492 | 5.466472303 | 4.444444 | 3.662109 | 3.053124 | 2.572016 | 2.186908 | 1.875 | 1.6196955 | 1.408715 | |||||
Discount Rate | 0% | 10% | 20.0% | 30.0% | 40.0% | 50.0% | 60.0% | 70.0% | 80.0% | 90.0% | 100.0% | 110.0% | 120.0% | ||||||
NPV | 15.00 | -1.13 | -32.99 | -73.05 | -116.98 | -162.22 | -207.28 | -251.27 | -293.72 | -334.38 | -373.13 | -409.94 | -444.87 | ||||||
SUM of PV | |||||||||||||||||||
IRR | 10% | ||||||||||||||||||
Project C |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
marr 13% the MARR is 12% Consider the following investment projects: 1 AC DE 0-1500-2000-2100-1000 1...
Question 10: Consider the following cash flow profile and assume MARR is 12%/year. 0 1 2 3 End of Year Cash Flow -1000 3400 -5700 3800 a. What does Descartes' rule of signs tell us about the IRR (8) of this project? b. What does the Norstrom's criterion tell us about the IRR (s) of this project? c. Determine the ERR for this project. Is this project economically attractive?
Consider the investment projects given in the table below. Assume that MARR 13% in the following questions. Click the icon to view the net cash flows for the projects. Click the icon to view the interest factors for discrete compounding when MARR = 13% per year. (a) Computo for each investment. If the problem has more than one / , identify all of them Compute i for Project 1. Select the correct choice below and 0 More Info O A....
Consider the investment projects given in the table below. Assume that MARR = 13% in the following questions. EEClick the icon to view the net cash flows for the projects. Click the icon to view the interest factors for discrete compounding when MARR = 13% per year. (a) Compute i" for each investment. If the problem has more than onei", identify all of them. Compute i for Project 1. Select the correct choice below and, if necessary, fill in the...
14. Consider four projects with the following sequences of cash flows: n 0 NET CASH FLOWS A B C -$25,000|-$23,000-$56,500 $12,000 $32,000 -$2,500 $23,000 $32,000-$6,459 $34,000 $25,000 $88,345 3 (a) Identify all the simple investments. (b) Identify all the non-simple investments. (c) Compute the Internal Rate of Return (IRR) for each project using NPV method and Excel. Note the following: A simple (or conventional) investment is simply when one sign change occurs in the net cash flow series. If the...