Page 68 - Mumme Booklet

DRAFT

DOUG AND MARIE MUMME

CASH FLOW ANALYSIS AT DOUG'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 56 3,328,821 3,555,000 0 3,555,000 0 3,555,000 226,179

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 57 281,721 0 336,683 336,683 54,963 281,721 0
2023 58 291,141 0 347,829 347,829 56,688 291,141 0
2024 59 300,912 0 359,380 359,380 58,469 300,912 0
2025 60 311,048 0 371,353 371,353 60,305 311,048 0
2026 61 289,819 0 361,458 361,458 71,640 289,819 0
2027 62 298,513 0 372,496 372,496 73,983 298,513 0
2028 63 307,468 0 383,858 383,858 76,389 307,468 0
2029 64 316,693 0 395,552 395,552 78,860 316,693 0
2030 65 326,193 0 407,589 407,589 81,396 326,193 0
2031 66 335,979 0 419,978 419,978 83,999 335,979 0
2032 67* 346,058 0 399,834 399,834 53,776 346,058 0
2033 68 356,440 0 417,071 417,071 60,631 356,440 0
2034 69 367,133 0 432,667 432,667 65,534 367,133 0
2035 70 378,147 4,650 441,431 446,081 67,933 378,147 0
2036 71 389,492 56,914 412,898 469,812 80,320 389,492 0
2037 72 401,177 58,052 433,589 491,641 90,465 401,177 0
2038 73 413,212 59,213 446,755 505,968 92,756 413,212 0
2039 74 425,608 60,398 460,301 520,698 95,090 425,608 0
2040 75 438,377 61,606 474,238 535,844 97,467 438,377 0
2041 76 451,528 62,838 488,578 551,416 99,888 451,528 0
2042 77 465,074 64,094 512,745 576,840 111,766 465,074 0
2043 78 479,026 65,376 529,159 594,535 115,509 479,026 0
2044 79 493,397 66,684 545,500 612,184 118,787 493,397 0
2045 80 508,199 68,018 562,321 630,339 122,140 508,199 0
2046 81 523,444 69,378 579,636 649,014 125,569 523,444 0
2047 82 539,148 70,766 597,458 668,223 129,075 539,148 0
2048 83 555,322 72,181 615,801 687,982 132,659 555,322 0
2049 84 571,982 73,624 634,679 708,303 136,321 571,982 0
2050 85 589,141 75,097 654,035 729,132 139,990 589,141 0
2051 86 606,816 76,599 673,949 750,548 143,732 606,816 0
2052 87 625,020 78,131 694,437 772,568 147,548 625,020 0
2053 88 643,771 79,693 715,512 795,206 151,435 643,771 0
2054 89 663,084 81,287 737,191 818,479 155,395 663,084 0
2055 90 682,976 82,913 759,390 842,303 159,327 682,976 0
2056 91 703,466 84,571 782,219 866,790 163,325 703,466 0
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
This plan is not complete without the Assumptions and Disclosures pages appearing at the end.
3170326-1-4 January 29, 2021 Page 68 of 108