Using excel formula to
Project E | A | B | C | D | E | F | |
1 | Time | 0 | 1 | 2 | 3 | 4 | 5 |
2 | Cash Flow | -2800 | 870 | 870 | 780 | 560 | 360 |
3 | IRR | 8.42% | |||||
Excel formula | IRR(A2:F2) |
IRR =8.42%
lomework Chapter 13 Help Save & Exit Submit Check my work Compute the IRR static for...
Week 4 Homework Assignment Saved Help Save & Exit Submit Check my work Compute the IRR statistic for Project E. The appropriate cost of capital is 9 percent. (Do not round intermediate calculations and round your final answer to 2 decimal places.) 2.16 points Project E Time: Cash flow 0 -$1,500 1 $550 2 $630 3 $620 4 $400 5 $200 eBook IRR % Print References Week 4 Homework Assignment A Saved Help Save & Exit Submit Check my work...
Homework Chapter 13 Help Save & Exit Submit Check my work Compute the NPV statistic for Project if the appropriate cost of capital is 9 percent. (Negative amount should be indicated by a minus sign. Do not round Intermediate calculations and round your final answer to 2 decimal places.) Project TIR Cash tlovi -$1,500 $550 $1,980 -5620 $500 $200 2 NPV References
Homework Chapter 13 Help Save & Exit Submit Check my work 00 Compute the discounted payback statistic for Project Dif the appropriate cost of capital is 10 percent and the maximum allowable discounted payback is four years. (Do not round intermediate calculations and round your final answer to 2 decimal places. If the project does not pay back, then enter a "0" (zero).) 1.5 points Project D Timet Cam to 512,900 33.560 Wisco ..... 2004 . 1 Discounted payback period
Homework Chapter 13 Help Save & Exit Submit Check my work Compute the NPV for Project Kif the appropriate cost of capital is 6 percent. (Negative amount should be indicated by a minus sign. Do not round Intermediate calculations and round your final answer to 2 decimal places.) Project Time Cash flow -$10,900 $5,450 $6,450 $6,450 $5,450-510,900 NPV
Homework Chapter 13 6 Help Save & Exit Subm Check my work Compute the NPV for Project M if the appropriate cost of capital is 9 percent. (Negative amount should we indicated by a minus sign. Do not round intermediate calculations and round your final answer to 2 decimal places.) points Project M Time: Cash flow 0 -$2,100 1 $570 2 5700 3 5740 4 5020 5 $320 04:16:11 Skipped NPV
Compute the IRR statistic for Project E. The appropriate cost of capital is 7 percent. (Do not round intermediate calculations and round your final answer to 2 decimal places.) Project E Time: 0 1 2 3 4 5 Cash flow −$2,800 $870 $870 $780 $560 $360
Save Help Save & Exit Submit Check my work Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 8 percent, and that the maximum allowable payback and discounted payback statistics for the project are 2.0 and 3.0 years, respectively. Time! 1 2 Cash flow: -$6,500 $1,020 $2,220 $1,420 $1,420 $1,220 $1 Use the IRR decision rule to evaluate this project. (Negative...
-ork 6 Saved Help Save & Exit Subn Check my work he following are the cash flows of two projects: Year Project A Project B $(360) $(360) 190 260 2 190 260 190 260 190 m + If the opportunity cost of capital is 12%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.) Project Profitability Index B < Prev 3 of 9 !!! Next > Saved Help Save...
Chapter 1 Problems Saved Help Save & Exit Submit Check my work 10 An owner can lease her building for $120,000 per year for three years. The explicit cost of maintaining the building is $40,000, and the implicit cost is $55,000. All revenues are received, and costs borne, at the end of each year. If the interest rate is 5 percent, determine the present value of the stream of 10 points Instructions: Do not round intermediate calculations. Round your final...
Chapter 18 Saved Help Save & Exit Submit Check my work MF Corp. has an ROE of 15% and a plowback ratio of 40%. The market capitalization rate is 13%. a. If the coming year's earnings are expected to be $2.10 per share, at what price will the stock sell? (Do not round intermediate calculations. Round your answer to 2 decimal places.) points Price eBook Print References b. What price do you expect MF shares to sell for in three...