Consider the following investment cash flows: Year Cash Flow 0 ($240,000) 1 30,000 2 40,000 3 50,000 4 60,000 5 60,000 6 50,000 7 40,000 8 30,000 9 20,000 10 10,000 a. What is the return expected on this investment measured in dollar terms if the opportunity cost (cost of capital) is 8.00% .

pls provide excel formulas and step by step. thank you