Spreadsheet: 42915d1241541135-multiple-separate-if-forumlas-in-one-cell-sauder-cash-flow-projection-template
Sheet: Cash Flow Projection

Year |  |  |  | Retirement Funding |  |  |  |  |  |  |  | Cash Flow |  |  |  |  |  |  |  |  |  | Insurance
calendar | retirement | age |  | Gauranteed Minimum Income Benefit Bucket Four |  | Qualified Savings Bucket Three |  | Non Qualified Savings Bucket Two |  | Cash Bucket One |  | Annual  Savings Withdrawal |  | Pension Distribution |  | Social Security |  | Annual Income Need |  | After Tax Income Need |  | Disability Premium |  | Long Term Care Premium |  | Life Insurance Premium |  | Disability Benefit |  | Long Term Care Benefit |  | Life Insurance
2009 | 0 |  |  | 158003 |  | 1067162 |  | 343460 |  | 43278 |  | 0 | + | 0 | + | 0 | = |  |  | 0 |  | 0 | - | 0 | - | 0 |  | 0 |  | 0 |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | + | 0 | + | 0 | = |  |  | 0 |  | 0 | - | 0 | - | 0
 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | + | 0 | + | 0 | = |  |  | 0 |  | 0 | - | 0 | - | 0
 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | + | 0 | + | 0 | = |  |  | 0 |  | 0 | - | 0 | - | 0
 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | + | 0 | + | 0 | = |  |  | 0 |  | 0 | - | 0 | - | 0
 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | + | 0 | + | 0 | = |  |  | 0 |  | 0 | - | 0 | - | 0
 | 1 |  |  |  |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  | 140000 |  | 0 | - | 0 | - | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0 |  | 0 |  | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0 |  | 0 |  | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0 |  | 0 |  | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0 |  | 0 |  | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0 |  | 0 |  | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0 |  | 0 |  | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 |  | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0 |  | 0 |  | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0 |  | 0 |  | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0 |  | 0 |  | 0
 |  |  |  | 299937 |  |  |  |  |  |  |  |  | + | 12520 | + | 40800 | = |  |  |  |  | 0 | - | 0 | - | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =