You must use formulas in the spreadsheet to show your work. Use excel to do the work.

6.1. Future value with multiple cash flows: Konerko, Inc., expects to earn cash flows of $13,227, $15,611, $18,970, and $19,114 over the next four years. If the company uses an 8 percent discount rate, what is the future value of these cash flows at the end of year 4