Assignment:
Janice opens a money market account that earns 2% per year compounded monthly by depositing $2500. She then deposits $4300 at end of the first 6 months (semi-annually) and keeps depositing $400 more than the previous deposit every 6 months for 8 years. What will be the future value (value at the end of 8 years) for the cash flow stream? Show Excel Spreadsheet and Formulas.