If I deposit $100,000 in a retirement account that gives 8% paid annually, what will be balance after 25 years? 1. Select the cell that is to contain the answer highlighted YELLOW. 2. Type in =FV( OR Use Two alternative methods listed below: Click the Fx button or Select Insert->Function from the menu bar 3. Select the cell to contain Formula. 4. Type in Text format (begin with apostrophe) Problem Bank is offering to pay me $1 million after 25 years. If the interest rate is 8% paid annually, how much should I pay for this investment