P3-4 (similar to) Future value Grand Openìng Bank is offering a one-time investment opportunity for its new customers. A customer opening a new checking account can buy a special savings bond for $200...

Extracted text: P3-4 (similar to) Future value Grand Openìng Bank is offering a one-time investment opportunity for its new customers. A customer opening a new checking account can buy a special savings bond for $200 today, which the bank will compound at 7.5% for the next ten years. The savings bond must be held for at least five years, but can then be cashed in at the end of any year starting with year five. What is the value of the bond at each cash-in date up through year ten? (Use an Excel spreadsheet to solve this problem.) What is the value of the savings bond at the end of year five? (Round to the nearest cent.)