Formatted Completed Book1 With Budgeting and Investment

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 21

Personal Information

Information

Name

Gender

Current Age

Retirement Age

Life Expectancy

Current Monthly Income

Annual Salary Increase

Rent Expense Percentage

Other Living Expenses

Salary, Expenses, Savings, and Investments Over


Age

21

22

23

24
25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46
47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

Monthly and Annual Living Expenses After Retir


Assuming the monthly living expenses in the first year after retirement are 80% of the curr
Living expenses after retirement increase by 7% annually.
Age

65

66

67

68

69

70

71

Total Annual Living Expenses from Age 65 to 71


1,163,100,434.84
Value

Trần Nam Quốc

Male

21

65

71

14,000,000 VND

5%

30%

Groceries and Essentials (18.75%)


Transportation and Travel (6.25%)
Entertainment and Personal Hobbies (7.5%)
Healthcare and Insurance (12.5%)
Utilities (Electricity, Water, Internet) (5%)
Clothing and Other Essentials (5%)
Other Expenses (Dining Out, Gifts, etc.) (5%)

ings, and Investments Over the Years


Salaries

14,000,000.00

14,700,000.00

15,435,000.00

16,206,750.00
17,017,087.50

17,867,941.88

18,761,338.97

19,699,405.92

20,684,376.21

21,718,595.02

22,804,524.77

23,944,751.01

25,141,988.56

26,399,087.99

27,719,042.39

29,104,994.51

30,560,244.24

32,088,256.45

33,692,669.27

35,377,302.74

37,146,167.87

39,003,476.27

40,953,650.08

43,001,332.58

45,151,399.21

47,408,969.17
49,779,417.63

52,268,388.51

54,881,807.94

57,625,898.34

60,507,193.25

63,532,552.91

66,709,180.56

70,044,639.59

73,546,871.57

77,224,215.15

81,085,425.90

85,139,697.20

89,396,682.06

93,866,516.16

98,559,841.97

103,487,834.07

108,662,225.77

114,095,337.06

119,800,103.91

Living Expenses After Retirement


n the first year after retirement are 80% of the current income. (14,000,000*0.8=12,200,000)
e by 7% annually.
Monthly Living Expenses

11,200,000.00

11,984,000.00

12,822,880.00

13,720,481.60

14,680,915.31

15,708,579.38

16,808,179.94

1,163,100,434.84
er the Years
Expenses/month

12,600,000.00

13,230,000.00

13,891,500.00

14,586,075.00
15,315,378.75

16,081,147.69

16,885,205.07

17,729,465.33

18,615,938.59

19,546,735.52

20,524,072.30

21,550,275.91

22,627,789.71

23,759,179.19

24,947,138.15

26,194,495.06

27,504,219.81

28,879,430.80

30,323,402.34

31,839,572.46

33,431,551.08

35,103,128.64

36,858,285.07

38,701,199.32

40,636,259.29

42,668,072.26
44,801,475.87

47,041,549.66

49,393,627.14

51,863,308.50

54,456,473.93

57,179,297.62

60,038,262.50

63,040,175.63

66,192,184.41

69,501,793.63

72,976,883.31

76,625,727.48

80,457,013.85

84,479,864.55

88,703,857.77

93,139,050.66

97,796,003.19

102,685,803.35

107,820,093.52

rement
rent income. (14,000,000*0.8=12,200,000)
Annual Living Expenses

134,400,000.00

143,808,000.00

153,874,560.00

164,645,779.20

176,170,983.74

188,502,952.61

201,698,159.29
Savings/month

1,400,000.00

1,470,000.00

1,543,500.00

1,620,675.00
1,701,708.75

1,786,794.19

1,876,133.90

1,969,940.59

2,068,437.62

2,171,859.50

2,280,452.48

2,394,475.10

2,514,198.86

2,639,908.80

2,771,904.24

2,910,499.45

3,056,024.42

3,208,825.64

3,369,266.93

3,537,730.27

3,714,616.79

3,900,347.63

4,095,365.01

4,300,133.26

4,515,139.92

4,740,896.92
4,977,941.76

5,226,838.85

5,488,180.79

5,762,589.83

6,050,719.33

6,353,255.29

6,670,918.06

7,004,463.96

7,354,687.16

7,722,421.51

8,108,542.59

8,513,969.72

8,939,668.21

9,386,651.62

9,855,984.20

10,348,783.41

10,866,222.58

11,409,533.71

11,980,010.39
Annual savings

16,800,000.00

17,640,000.00

18,522,000.00

19,448,100.00
20,420,505.00

21,441,530.25

22,513,606.76

23,639,287.10

24,821,251.46

26,062,314.03

27,365,429.73

28,733,701.22

30,170,386.28

31,678,905.59

33,262,850.87

34,925,993.41

36,672,293.08

38,505,907.74

40,431,203.13

42,452,763.28

44,575,401.45

46,804,171.52

49,144,380.09

51,601,599.10

54,181,679.05

56,890,763.01
59,735,301.16

62,722,066.22

65,858,169.53

69,151,078.00

72,608,631.90

76,239,063.50

80,051,016.67

84,053,567.51

88,256,245.88

92,669,058.18

97,302,511.08

102,167,636.64

107,276,018.47

112,639,819.39

118,271,810.36

124,185,400.88

130,394,670.93

136,914,404.47

143,760,124.70
Monthly Living Expenses

Expense
Monthly Type
Cost (Assumption)
Rent 700
Utilities 100
Groceries 250
Transportation 150
Healthcare 75
Insurance 50
Miscellaneous 100
Investment Plan

Annual
Year
Investment
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
WARR Calculation

Asset Type Weight (%)


ReturnWeighted
(%) Return
Large-Cap Equity 40 7 2.8
Small-Cap Equity 20 10 2
International Equity15 8 1.2
Fixed Incomes 20 3 0.6
Cash Investments 5 1 0.05

You might also like