Spreadsheet: 489556d1479321681-trouble-with-errors-example4
Sheet: Sheet1

 |  |  | Required Minimum Distributions (RMD) Calculations Starting At Age 70 1/2 |  |  |  |  |  |  |  |  |  |  | Required Minimum Distributions (RMD) Calculations Starting At Age 70 1/2
Year | Age |  | [NAME] to RMD With Growth Factor | RMD  "Life Expectency Factor" Divisor | Required Minimum Distribution (RMD) |  | Roth Balances With Growth Factor |  | Total Retirement Portfolio Balance On Dec. 31 Of Current Year |  | Year | Age |  | [NAME] to RMD With Growth Factor | RMD  "Life Expectency Factor" Divisor | Required Minimum Distribution (RMD) |  | Roth Balances With Growth Factor |  | Total Retirement Portfolio Balance On Dec. 31 Of Current Year |  | Combined RMD | Other Savings Account Balances (Includes 1% Interest) | Withdrawal to Cover Income Shortfall | Combined Total Portfolio Balance |  | Growth Factor
2016 | 58 |  | 10000 |  |  |  | 5000 |  |  |  | 2016 | 63 |  | 25000 |  |  |  | 2000 |  |  |  |  | 1000 | 13487 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | 27.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13568 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71 | 26.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13975 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 72 | 25.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14394 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 73 | 24.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14826 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 74 | 23.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15270 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75 | 22.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15728 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76 | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16200 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 77 | 21.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16686 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 78 | 20.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17187 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 79 | 19.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17703 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 | 18.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18234 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81 | 17.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18781 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 82 | 17.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19344 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 83 | 16.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19924 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 84 | 15.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18126 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 85 | 14.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18551 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 86 | 14.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18987 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 87 | 13.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19422 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88 | 12.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19851 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20272 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90 | 11.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20680 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 91 | 10.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21104 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 92 | 10.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21509 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 93 | 9.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21897 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 94 | 9.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22256 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 95 | 8.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22632 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 96 | 8.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22977 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 97 | 7.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23281 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 98 | 7.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23581 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 99 | 6.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23721 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 6.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23939 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101 | 5.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24086 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 102 | 5.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34937 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 103 | 5.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35986 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 104 | 4.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37065 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 105 | 4.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38177 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 106 | 4.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39322 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 107 | 3.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40502 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 108 | 3.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41717 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 109 | 3.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42969 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 110 | 3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44258 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 111 | 2.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45585 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 112 | 2.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46953 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 113 | 2.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48362 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 114 | 2.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49812 |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 115 | 1.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 116 | 1.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 117 | 1.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 118 | 1.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 119 | 1.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120 | 1.9