(8) What is the value at the end of Year 3 of the following cash flow stream if interest is 4% compounded semiannually? USING EXCEL (Hint: You can use the EAR and treat the cash flows as an ordinary annuity or use the periodic rate and compound the cash flows individually.)