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 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...
lomework 6 Saved Help Save & Exit Submit Check my work Exercise 9-13 Revenue and Spending Variances [Lo9-3 Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company's costs: Fixed Cost Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses per Month $1,300 S5,000 Cost per Car Washed S 0.80 0.08 $ 0.25 $ 0.30 $8,300 52.000 $005 1,500 $0.05 For example,...