Page 79 - Mumme Booklet

DRAFT

DOUG AND MARIE MUMME

CASH FLOW ANALYSIS AT MARIE'S DEATH

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

IMMEDIATE CASH NEEDS

1 2 3 4 5 6 7
Before-Tax Total Total After- Surplus
Immediate Insurance Assets Inflow Tax Inflow (Shortage)
Year Age Need Benefits Liquidated (2+3) Taxes (4-5) (6-1)
2021 54 3,328,821 580,000 3,231,746 3,811,746 482,925 3,328,821 0

INCOME NEEDS

1 2 3 4 5 6 7
Before-Tax Before-Tax Total Total After- Surplus
Income Income Assets Inflow Tax Inflow (Shortage)
Year Age Needed Available Liquidated (2+3) Taxes (4-5) (6-1)
2022 55 281,721 0 313,839 313,839 32,118 281,721 0
2023 56 291,141 0 324,236 324,236 33,095 291,141 0
2024 57 300,912 0 335,014 335,014 34,102 300,912 0
2025 58 311,048 0 346,189 346,189 35,141 311,048 0
2026 59 289,819 0 338,741 338,741 48,922 289,819 0
2027 60 298,513 0 349,049 349,049 50,536 298,513 0
2028 61 307,468 0 359,663 359,663 52,195 307,468 0
2029 62 316,693 0 370,591 370,591 53,898 316,693 0
2030 63 326,193 0 381,842 381,842 55,649 326,193 0
2031 64 335,979 0 395,427 395,427 59,448 335,979 0
2032 65* 346,058 0 396,429 396,429 50,370 346,058 0
2033 66 356,440 0 408,303 408,303 51,862 356,440 0
2034 67 367,133 0 420,522 420,522 53,389 367,133 0
2035 68 378,147 0 432,630 432,630 54,483 378,147 0
2036 69 389,492 0 444,939 444,939 55,447 389,492 0
2037 70 401,177 47,060 420,263 467,324 66,147 401,177 0
2038 71 413,212 64,002 419,914 483,917 70,705 413,212 0
2039 72 425,608 65,282 440,326 505,609 80,001 425,608 0
2040 73 438,377 66,588 454,126 520,714 82,337 438,377 0
2041 74 451,528 67,920 468,339 536,259 84,731 451,528 0
2042 75 465,074 69,278 482,978 552,256 87,183 465,074 0
2043 76 479,026 70,664 498,056 568,719 89,694 479,026 0
2044 77 493,397 72,077 513,545 585,622 92,225 493,397 0
2045 78 508,199 73,518 529,536 603,055 94,856 508,199 0
2046 79 523,444 74,989 545,959 620,948 97,504 523,444 0
2047 80 539,148 76,489 562,869 639,357 100,209 539,148 0
2048 81 555,322 78,018 580,278 658,296 102,974 555,322 0
2049 82 571,982 79,579 598,201 677,780 105,798 571,982 0
2050 83 589,141 81,170 616,652 697,823 108,681 589,141 0
2051 84 606,816 82,794 635,646 718,440 111,624 606,816 0
2052 85 625,020 84,450 655,129 739,579 114,559 625,020 0
2053 86 643,771 86,139 675,179 761,318 117,547 643,771 0
2054 87 663,084 87,861 695,811 783,673 120,589 663,084 0
2055 88 682,976 89,619 602,525 692,143 9,167 682,976 0
* Retirement Age
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
This plan is not complete without the Assumptions and Disclosures pages appearing at the end.
3170326-1-4 January 29, 2021 Page 79 of 108