A Home Cal BI Retirement & Takahone Pioblems () Excel Insert Page Layout Formulis Data Review View Help 18 A A Wap Text General -A- Merge & Center- Tent Agent C D Number 1 How old will I be when I retire? 2 What is my life expectancy? 3 How many years do I need to have a retirement income? 4 How much should my yearly retirement income be? 5 What is my rate of return? Conditional Format Cell Formatting Table Styles- Styles Ale Manko Share: Comments Insert Delete Format CH 10 200 E- 4 Sort & Find & Filter Select Eating Analyze Data Analy H 55 90 years 35 years 80,000 [Current wisdom says to plan for 7 Monthly compounded Number rate of periods a. assume a 2% annual rate of return compounded monthly b. assume a 5% annual rate of return compounded monthly Using Excel functions calculate the amount you will need to have in your retirement account at the 6 time of retirement under both rates of return. troduction Pt1 Balance at retirement Pt 2 Monthly Retirement Savings Type here to search B05 PM 5/1/2001 115%