A B D E F G 4 6 a. 1 2 2. Given the cash flow vector below and the interest 3 rate, if the first cash flow occurs in period 'n', then compute the Present Value of the cash flows (value 5 Solve the problem using cell formulas below on the 7 spreadsheet. Work out in steps (NOT VBA!) 8 9 b. Create a FUNCTION that computes the PV of the 10 cash flow given the periodic rate below. Have 11 your function get the data directly from the green 12 13 Pd CF i 14 11 -195 5.70% 11 15 12 -105 16 13 -5 The correct answer is $24.9324 17 14 70 CF Excel Solution 18 15 80 Function Solution 19 16 90 20 17 100 21 | 18 120 22 n 23