Scribd Logo
Upload

Welcome to Scribd!

  • 3 views

    Completed Book1 With Budgeting and Investment Final

    Uploaded by

    hieu quan

    Copyright:

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

    Completed Book1 With Budgeting and Investment Final

    Uploaded by

    hieu quan
    3 views6 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

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

    Completed Book1 With Budgeting and Investment Final

    Uploaded by

    hieu quan

    Copyright:

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

    Unnamed: Unnamed:

    0 Unnamed:
    1 Unnamed:
    2 Unnamed:
    3 Unnamed:
    4 5
    Personal Information
    InformatioValue
    Name Trần Nam Quốc
    Gender Male
    Current Ag21
    Retirement65
    Life Expec 71
    Current Mo14,000,000 VND
    Annual Sala5%
    Rent Expen30%
    Clothing and Other Essentials (5%)
    Other Livi Other Expenses (Dining Out, Gifts, etc.) (5%)

    Salary, Expenses, Savings, and Investments Over the Years


    Age Salaries Expenses/ Savings/m Annual savings
    21 14000000 12600000 1400000 16800000
    22 14700000 13230000 1470000 17640000
    23 15435000 13891500 1543500 18522000
    24 16206750 14586075 1620675 19448100
    25 17017088 15315379 1701709 20420505
    26 17867942 16081148 1786794 21441530
    27 18761339 16885205 1876134 22513607
    28 19699406 17729465 1969941 23639287
    29 20684376 18615939 2068438 24821251
    30 21718595 19546736 2171860 26062314
    31 22804525 20524072 2280452 27365430
    32 23944751 21550276 2394475 28733701
    33 25141989 22627790 2514199 30170386
    34 26399088 23759179 2639909 31678906
    35 27719042 24947138 2771904 33262851
    36 29104995 26194495 2910499 34925993
    37 30560244 27504220 3056024 36672293
    38 32088256 28879431 3208826 38505908
    39 33692669 30323402 3369267 40431203
    40 35377303 31839572 3537730 42452763
    41 37146168 33431551 3714617 44575401
    42 39003476 35103129 3900348 46804172
    43 40953650 36858285 4095365 49144380
    44 43001333 38701199 4300133 51601599
    45 45151399 40636259 4515140 54181679
    46 47408969 42668072 4740897 56890763
    47 49779418 44801476 4977942 59735301
    48 52268389 47041550 5226839 62722066
    49 54881808 49393627 5488181 65858170
    50 57625898 51863309 5762590 69151078
    51 60507193 54456474 6050719 72608632
    52 63532553 57179298 6353255 76239063
    53 66709181 60038263 6670918 80051017
    54 70044640 63040176 7004464 84053568
    55 73546872 66192184 7354687 88256246
    56 77224215 69501794 7722422 92669058
    57 81085426 72976883 8108543 97302511
    58 85139697 76625727 8513970 1.02E+08
    59 89396682 80457014 8939668 1.07E+08
    60 93866516 84479865 9386652 1.13E+08
    61 98559842 88703858 9855984 1.18E+08
    62 1.03E+08 93139051 10348783 1.24E+08
    63 1.09E+08 97796003 10866223 1.3E+08
    64 1.14E+08 1.03E+08 11409534 1.37E+08
    65 1.2E+08 1.08E+08 11980010 1.44E+08

    Monthly and Annual Living Expenses After Retirement


    Assuming the monthly living expenses in the first year after retirement are 80% of the current income. (14,000,000
    Living expenses after retirement increase by 7% annually.
    Age Monthly Li Annual Living Expenses
    65 11200000 1.34E+08
    66 11984000 1.44E+08
    67 12822880 1.54E+08
    68 13720482 1.65E+08
    69 14680915 1.76E+08
    70 15708579 1.89E+08
    71 16808180 2.02E+08

    Total Annual Living Expenses from Age 65 to 71


    1.16E+09
    e current income. (14,000,000*0.8=12,200,000)
    Expense
    Monthly
    TypeCost (Assumption)
    Rent 700
    Utilities 100
    Groceries 250
    Transporta 150
    Healthcare 75
    Insurance 50
    Miscellane 100
    Annual
    YearInvestment
    Expected
    (Assumption)
    Rate of Return (%)
    1 2000 5
    2 2000 5
    3 2000 5
    4 2000 5
    5 2000 5
    6 2000 5
    7 2000 5
    8 2000 5
    9 2000 5
    10 2000 5
    11 2000 5
    12 2000 5
    13 2000 5
    14 2000 5
    15 2000 5
    16 2000 5
    17 2000 5
    18 2000 5
    19 2000 5
    20 2000 5
    21 2000 5
    22 2000 5
    23 2000 5
    24 2000 5
    25 2000 5
    26 2000 5
    27 2000 5
    28 2000 5
    29 2000 5
    30 2000 5
    31 2000 5
    32 2000 5
    33 2000 5
    34 2000 5
    35 2000 5
    Asset TypeWeight (%)Return Weighted
    (%) Return
    Large-Cap 40 7 2.8
    Small-Cap 20 10 2
    Internation 15 8 1.2
    Fixed Inco 20 3 0.6
    Cash Inves 5 1 0.05

    You might also like