3.) Please Answer with Excel Formulas***
Posted: Mon Jan 17, 2022 8:08 am
3.) Please Answer with Excel Formulas***
What is the NPV of the following cash flows at a discount rate of zero percent? What if the discount rate is 10 percent? If it is 20 percent? If it is 30 percent?
A B с D E F G H I J K 7 8 Year 1 Year 2 Year 3 A A A $ 6,400 8,700 5,900 9 10 11 12 13 Discount rate Discount rate Discount rate Discount rate 0% 10% 20% 30% 14 15 16 17 Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel function to answer this question. 18 19 NPV at O percent 20 NPV at 10 percent 21 22 23 NPV at 20 percent 24 25 NPV at 30 percent 26 27 28 Sheet1
What is the NPV of the following cash flows at a discount rate of zero percent? What if the discount rate is 10 percent? If it is 20 percent? If it is 30 percent?
A B с D E F G H I J K 7 8 Year 1 Year 2 Year 3 A A A $ 6,400 8,700 5,900 9 10 11 12 13 Discount rate Discount rate Discount rate Discount rate 0% 10% 20% 30% 14 15 16 17 Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel function to answer this question. 18 19 NPV at O percent 20 NPV at 10 percent 21 22 23 NPV at 20 percent 24 25 NPV at 30 percent 26 27 28 Sheet1