Scribd Logo
Upload

Welcome to Scribd!

  • 71 views

    Ventura, Mary Mickaella R - Retirementplan

    Uploaded by

    Mary Ventura
    This document contains a retirement plan timeline and calculations for Mary Mickaella Ventura. It outlines an annual investment of $24,740.34 into mutual funds from ages 21 to 64, with a 10% annual rate of return. It then calculates the beginning and ending balances each year, factoring in a 3% annual inflation rate. By age 65, the total mutual fund balance is projected to be $17,761,206.64. It also models monthly living expenses increasing from $20,000 at age 65 to over $60,000 by age 80 due to inflation.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Ventura, Mary Mickaella R - Retirementplan

    Uploaded by

    Mary Ventura
    71 views6 pages
    This document contains a retirement plan timeline and calculations for Mary Mickaella Ventura. It outlines an annual investment of $24,740.34 into mutual funds from ages 21 to 64, with a 10% annual rate of return. It then calculates the beginning and ending balances each year, factoring in a 3% annual inflation rate. By age 65, the total mutual fund balance is projected to be $17,761,206.64. It also models monthly living expenses increasing from $20,000 at age 65 to over $60,000 by age 80 due to inflation.

    Original Description:

    20

    Original Title

    Ventura, Mary Mickaella R_retirementplan

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains a retirement plan timeline and calculations for Mary Mickaella Ventura. It outlines an annual investment of $24,740.34 into mutual funds from ages 21 to 64, with a 10% annual rate of return. It then calculates the beginning and ending balances each year, factoring in a 3% annual inflation rate. By age 65, the total mutual fund balance is projected to be $17,761,206.64. It also models monthly living expenses increasing from $20,000 at age 65 to over $60,000 by age 80 due to inflation.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    71 views6 pages

    Ventura, Mary Mickaella R - Retirementplan

    Uploaded by

    Mary Ventura
    This document contains a retirement plan timeline and calculations for Mary Mickaella Ventura. It outlines an annual investment of $24,740.34 into mutual funds from ages 21 to 64, with a 10% annual rate of return. It then calculates the beginning and ending balances each year, factoring in a 3% annual inflation rate. By age 65, the total mutual fund balance is projected to be $17,761,206.64. It also models monthly living expenses increasing from $20,000 at age 65 to over $60,000 by age 80 due to inflation.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 6

    VENTURA,MARY MICKAELLA R

    BSA 3-A
    Retirement Plan 65-80
    Timeline 21-80
    Inflation rate (annual0) 3%
    Monthly Expense 20,000.00
    Annual Expense 20,000 x 12 240,000.00

    0 21 240,000.00
    1 22 1.03 247,200.00
    2 23 1.0609 254,616.00
    3 24 1.092727 262,254.48
    4 25 1.12550881 270,122.11
    5 26 1.1592740743 278,225.78
    6 27 1.1940522965 286,572.55
    7 28 1.2298738654 295,169.73
    8 29 1.2667700814 304,024.82
    9 30 1.3047731838 313,145.56
    10 31 1.3439163793 322,539.93
    11 32 1.3842338707 332,216.13
    12 33 1.4257608868 342,182.61
    13 34 1.4685337135 352,448.09
    14 35 1.5125897249 363,021.53
    15 36 1.5579674166 373,912.18
    16 37 1.6047064391 385,129.55
    17 38 1.6528476323 396,683.43
    18 39 1.7024330612 408,583.93
    19 40 1.7535060531 420,841.45
    20 41 1.8061112347 433,466.70
    21 42 1.8602945717 446,470.70
    22 43 1.9161034089 459,864.82
    23 44 1.9735865111 473,660.76
    24 45 2.0327941065 487,870.59
    25 46 2.0937779297 502,506.70
    26 47 2.1565912675 517,581.90
    27 48 2.2212890056 533,109.36
    28 49 2.2879276757 549,102.64
    29 50 2.356565506 565,575.72
    30 51 2.4272624712 582,542.99
    31 52 2.5000803453 600,019.28
    32 53 2.5750827557 618,019.86
    33 54 2.6523352384 636,560.46
    34 55 2.7319052955 655,657.27
    35 56 2.8138624544 675,326.99
    36 57 2.898278328 695,586.80
    37 58 2.9852266778 716,454.40
    38 59 3.0747834782 737,948.03
    39 60 3.1670269825 760,086.48
    40 61 3.262037792 782,889.07
    41 62 3.3598989258 806,375.74
    42 63 3.4606958935 830,567.01
    43 64 3.5645167703 855,484.02
    44 65 3.6714522734 881,148.55
    45 66 3.7815958417 907,583.00
    46 67 3.8950437169 934,810.49
    47 68 4.0118950284 962,854.81
    48 69 4.1322518793 991,740.45
    49 70 4.2562194356 1,021,492.66
    50 71 4.3839060187 1,052,137.44
    51 72 4.5154231993 1,083,701.57
    52 73 4.6508858952 1,116,212.61
    53 74 4.7904124721 1,149,698.99
    54 75 4.9341248463 1,184,189.96
    55 76 5.0821485917 1,219,715.66
    56 77 5.2346130494 1,256,307.13
    57 78 5.3916514409 1,293,996.35
    58 79 5.5534009841 1,332,816.24
    59 80 5.7200030136 1,372,800.72 17,761,206.64
    60 81 5.891603104 1,413,984.74

    Year Age Investment Beg. Balance Interest


    0 21 24,740.34 0 2,474.03
    1 22 24,740.34 27,214.37 5,195.47
    2 23 24,740.34 57,150.18 8,189.05
    3 24 24,740.34 90,079.56 11,481.99
    4 25 24,740.34 126,301.89 15,104.22
    5 26 24,740.34 166,146.45 19,088.68
    6 27 24,740.34 209,975.46 23,471.58
    7 28 24,740.34 258,187.37 28,292.77
    8 29 24,740.34 311,220.48 33,596.08
    9 30 24,740.34 369,556.90 39,429.72
    10 31 24,740.34 433,726.96 45,846.73
    11 32 24,740.34 504,314.02 52,905.44
    12 33 24,740.34 581,959.79 60,670.01
    13 34 24,740.34 667,370.14 69,211.05
    14 35 24,740.34 761,321.53 78,606.19
    15 36 24,740.34 864,668.05 88,940.84
    16 37 24,740.34 978,349.22 100,308.96
    17 38 24,740.34 1,103,398.51 112,813.88
    18 39 24,740.34 1,240,952.73 126,569.31
    19 40 24,740.34 1,392,262.38 141,700.27
    20 41 24,740.34 1,558,702.98 158,344.33
    21 42 24,740.34 1,741,787.65 176,652.80
    22 43 24,740.34 1,943,180.79 196,792.11
    23 44 24,740.34 2,164,713.23 218,945.36
    24 45 24,740.34 2,408,398.93 243,313.93
    25 46 24,740.34 2,676,453.19 270,119.35
    26 47 24,740.34 2,971,312.88 299,605.32
    27 48 24,740.34 3,295,658.53 332,039.89
    28 49 24,740.34 3,652,438.76 367,717.91
    29 50 24,740.34 4,044,897.00 406,963.73
    30 51 24,740.34 4,476,601.07 450,134.14
    31 52 24,740.34 4,951,475.55 497,621.59
    32 53 24,740.34 5,473,837.47 549,857.78
    33 54 24,740.34 6,048,435.59 607,317.59
    34 55 24,740.34 6,680,493.52 670,523.39
    35 56 24,740.34 7,375,757.24 740,049.76
    36 57 24,740.34 8,140,547.33 816,528.77
    37 58 24,740.34 8,981,816.43 900,655.68
    38 59 24,740.34 9,907,212.44 993,195.28
    39 60 24,740.34 10,925,148.06 1,094,988.84
    40 61 24,740.34 12,044,877.23 1,206,961.76
    41 62 24,740.34 13,276,579.33 1,330,131.97
    42 63 24,740.34 14,631,451.63 1,465,619.20
    43 64 24,740.34 16,121,811.16 1,614,655.15
    44 65 17,761,206.64
    45 66 16,880,058.10
    46 67 15,972,475.10
    47 68 15,037,664.61
    48 69 14,074,809.80
    49 70 13,083,069.35
    50 71 12,061,576.68
    51 72 11,009,439.24
    52 73 9,925,737.67
    53 74 8,809,525.06
    54 75 7,659,826.06
    55 76 6,475,636.10
    56 77 5,255,920.44
    57 78 3,999,613.31
    58 79 2,705,616.96
    59 80 1,372,800.72
    Mutual funds 10%
    Timeline 21-64

    24,740.34

    Total Deduction Balance


    27,214.37 0 27,214.37
    57,150.18 0 57,150.18
    90,079.56 0 90,079.56
    126,301.89 0 126,301.89
    166,146.45 0 166,146.45
    209,975.46 0 209,975.46
    258,187.37 0 258,187.37
    311,220.48 0 311,220.48
    369,556.90 0 369,556.90
    433,726.96 0 433,726.96
    504,314.02 0 504,314.02
    581,959.79 0 581,959.79
    667,370.14 0 667,370.14
    761,321.53 0 761,321.53
    864,668.05 0 864,668.05
    978,349.22 0 978,349.22
    1,103,398.51 0 1,103,398.51
    1,240,952.73 0 1,240,952.73
    1,392,262.38 0 1,392,262.38
    1,558,702.98 0 1,558,702.98
    1,741,787.65 0 1,741,787.65
    1,943,180.79 0 1,943,180.79
    2,164,713.23 0 2,164,713.23
    2,408,398.93 0 2,408,398.93
    2,676,453.19 0 2,676,453.19
    2,971,312.88 0 2,971,312.88
    3,295,658.53 0 3,295,658.53
    3,652,438.76 0 3,652,438.76
    4,044,897.00 0 4,044,897.00
    4,476,601.07 0 4,476,601.07
    4,951,475.55 0 4,951,475.55
    5,473,837.47 0 5,473,837.47
    6,048,435.59 0 6,048,435.59
    6,680,493.52 0 6,680,493.52
    7,375,757.24 0 7,375,757.24
    8,140,547.33 0 8,140,547.33
    8,981,816.43 0 8,981,816.43
    9,907,212.44 0 9,907,212.44
    10,925,148.06 0 10,925,148.06
    12,044,877.23 0 12,044,877.23
    13,276,579.33 0 13,276,579.33
    14,631,451.63 0 14,631,451.63
    16,121,811.16 0 16,121,811.16
    17,761,206.64 0 17,761,206.64
    17,761,206.64 881,148.55 16,880,058.10
    16,880,058.10 907,583.00 15,972,475.10
    15,972,475.10 934,810.49 15,037,664.61
    15,037,664.61 962,854.81 14,074,809.80
    14,074,809.80 991,740.45 13,083,069.35
    13,083,069.35 1,021,492.66 12,061,576.68
    12,061,576.68 1,052,137.44 11,009,439.24
    11,009,439.24 1,083,701.57 9,925,737.67
    9,925,737.67 1,116,212.61 8,809,525.06
    8,809,525.06 1,149,698.99 7,659,826.06
    7,659,826.06 1,184,189.96 6,475,636.10
    6,475,636.10 1,219,715.66 5,255,920.44
    5,255,920.44 1,256,307.13 3,999,613.31
    3,999,613.31 1,293,996.35 2,705,616.96
    2,705,616.96 1,332,816.24 1,372,800.72
    1,372,800.72 1,372,800.72 0.00
    c

    You might also like