Answer all these questions ( IF you want to use EXCAL please show the formulas)

THANK YOU

4-

5-

6-

Given the following cash flows for a capital project, calculate the Pl. The cost of capital is 12 percent. Year 0 1 2 3 4 5 Cash flow-50,000 15,000 15,00020,00010,0005,000 1. Given the following cash flows for a capital project, calculate the NPV. The cost of capital is 8 percent. Year 0 1 2 3 4 5 Cash flow-50,00015,000 15,00020,000 10,0005,000 An investment of SAR75,000 is expected to generate an after-tax cash flow of SAR28,000 in year 1, SAR24,000 in year 2, SAR18,000 in year 3, SAR14,000 in year 4 and SAR17,000 in year 5. The cost of capital is 10 percent. What is the Profitability Index of this investment