You are planning your retirement in 10 years. You currently have $160,000 in a bond account and $600,000 in a stock account. You plan to add $8,000 per year at the end of each of the next 10 years to your bond account. The stock account will earn a return of 10.5 percent and the bond account will earn a return of 7 percent. When you retire, you plan to withdraw an equal amount for each of the next 25 years at the end of each year and have nothing left. Additionally, when you retire you will transfer your money to an account that earns 6.25 percent. Required:
How much can you withdraw each year in your retirement?

Dr. sperry, a biologist, is using excel to track growth rates of different populations of bacteria. she has a very complex formula in one cell. it begins with “round”. dr. sperry would like to see exactly how excel’s calculation reached the final rounded value that she sees in the cell. what could dr. sperry do to best understand how the calculation was made? try different formulas on her own until she reaches the value shown in excel click on the evaluate formula button in the formulas tab and then click “step in” select the cell and then look at the formula in the formula field of the ribbon remove “round” from the formula in order to see the actual value before rounding