5.) Please answer in excel formulas***
Posted: Tue Jan 18, 2022 12:58 pm
5.) Please answer in excel formulas***
A B D E F G H I J 1 2 3 What is the profitability index for the following set of cash flows if the relevant discount rate is 10 percent? What if the discount rate is 15 percent? If it is 22 percent? 4 5 6 7 Year 0 Year 1 Year 2 Year 3 $ $ $ $ A A A A (15,300) 9,400 7,600 4,300 8 9 10 11 12 Discount rate Discount rate Discount rate 10% 15% 22% 13 14 15
16 Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel function to answer this question. 17 18 Profitability index at 10 percent 19 20 Profitability index at 15 percent 21 22 Profitability index at 22 percent 23
- 5 Please Answer In Excel Formulas 1 (261.11 KiB) Viewed 55 times
- 5 Please Answer In Excel Formulas 2 (166.4 KiB) Viewed 55 times
16 Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel function to answer this question. 17 18 Profitability index at 10 percent 19 20 Profitability index at 15 percent 21 22 Profitability index at 22 percent 23