Wealthy Calculator (Blueprint)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOP
1
2
3
Wealth Building helps you answer some of the questions an individual or a couple have when planning to build wealth for their retirement or to reach financial flexibility. They help to answer the following questions:
1) Does starting to build wealth younger help me build greater wealth? How much more?
2) Should I allocate more funding to building wealth at the start of my career? Whats the impact?
3) What if I cannot allocate so much to building wealth? What are my alternatives?
4) Would taking on more jobs on the side help my situation?
5) How different rate of return, risks impact my wealth building goals
6) I want a realistic view of my wealth X number of years later

To use this: Have a Google Account, Login to it. Go to File > Make a Copy... There! You can start having fun with it. No need to ask me to share it.
4
5
LegendVisit InvestmentMoats.com (click here) to find out how to build your wealth
6
Cells you need to enter value
7
Cells spreadsheet auto-calculates for you. Do not enter values into blue cells!
8
9
Time Frame
10
Starting Year2013Year to start visualizing wealth building
11
Starting Age25Age when weatlh building starts
12
Years to build wealth21Number of years to visualize. You can do a 40 year project or a 10 year near term visualization
13
Ending Age46
14
15
Your Main Salary
16
Monthly Component$6,000.00Salary are usually paid to you monthly. If your salary is weekly, aggregate it. If your salary is ad-hoc, you may want to use the last 12 months salary and take the average. This amount is before tax.
17
Additional Component$18,000.00Bonus, performance and other benefits enjoyed that may be not always permanent
18
Annual Gross Total$90,000.00Aggregate gross of your monthly & additional compnent
19
Growth Rate3.00%Over time, through experience & switching jobs, your salary will grow. Apply a long term salary growth rate. Conservative figures are 2-5%.
20
Tax Rate20.00%Salary are taxable or partially channelled to forced government scheme. We are more concerned about planning for disposable income, so specify a tax rate applicable.
21
22
Side Jobs / Overtime / Temp Work
23
Monthly Component$0.00You may work ideas that generate income, overtime that is not permanent, a second job or temp assignment that brings in more income. Apply a monthly figure here.
24
Additional Component$0.00If your side job income is little per year or not recurring, you may apply a one time figure here.
25
Gross Total$0.00
26
Growth Rate1.00%Side jobs may not grow over time, but if your part time endeavor is expected to grow overtime do apply a growth rate here.
27
Tax Rate20.00%Side jobs may be subjected to tax as well.
28
29
Income Growth Rate
30
Main + Side Jobs3.00%Depending on the proportion of Main Salary to Side Jobs, this growth rate will be automatially calculated.
31
32
Funding your Wealth Building
33
Initial Investment$0.00You may have some investments, cash that you would like to classify as your wealth fund to be part of this projection as well. This is where you enter them
34
First Year Wealth Funding %70.00%Most decide on either a fix amount to be channel to wealth building (e.g. $500 or $1000) or a %. Here, we use % and you apply the first year funding from your disposable income boxed out for wealth building.
35
Increment Wealth Funding as a % of Main Salary Growth Rate70.00%As you received increments in income from salary and side jobs, you can channel a certain % of it to add to your first year wealth funding contribution. This is capped by your Income Growth Rate (meaning your additional funding cannot be more than how fast your income grows) E.g. if your Income growth rate is 4% and you apply 50% here, you will contribute 2% per year additional to last year's contribution. Overtime your wealth funding contribution will increase (E.g. 2% + 2% + 2% .....)
36
Increment Wealth Funding %2.10%The incremental funding is calculated for you
37
Wealth CAGR3.00%You specify a long term compounded average growth rate for the funds you channel to wealth building. This will depend on the assets that you use to build wealth. If you put it in fixed deposit, and expect it to grow at 2% over time, specify 2%. Advice here is to have quantifable data or just be conservative to avoid unreasonable estimates.
38
39
Wealth Summary
40
Total Wealth Funding after 21 years$1,445,294.88Within the years specified, you have funnel this amount to wealth building
41
Total Wealth Built after 21 years$1,911,588.13At the last year, you have build this amount of wealth
42
Total Returns Earned (%)32.26%The value add from channelling funding to higher yielding assets
43
44
Annual Main SalaryAnnual Main Salary (Aft Tax)Annual Side JobAnnual Side Job (Aft Tax)Annual Total (Main + Side)Wealth Funding (1st Yr)Wealth Funding (Increment)Wealth Funding (Yrly Total)Wealth Funding (Cumulative)Wealth Networth (Yrly Total)Leftover for Spending AllocationWealth Funding as a % of Annual Total (Main + Side)YearAge
45
$0.00$0.00
46
$90,000.00$72,000.00$0.00$0.00$72,000.00$50,400.00$0.00$50,400.00$50,400.00$50,400.00$21,600.0070.00%1201325
47
$92,700.00$74,160.00$0.00$0.00$74,160.00$50,400.00$1,512.00$51,912.00$102,312.00$103,824.00$22,248.0070.00%2201426
48
$95,481.00$76,384.80$0.00$0.00$76,384.80$50,400.00$1,557.36$53,469.36$155,781.36$160,408.08$22,915.4470.00%3201527
49
$98,345.43$78,676.34$0.00$0.00$78,676.34$50,400.00$1,604.08$55,073.44$210,854.80$220,293.76$23,602.9070.00%4201628
50
$101,295.79$81,036.63$0.00$0.00$81,036.63$50,400.00$1,652.20$56,725.64$267,580.44$283,628.22$24,310.9970.00%5201729
51
$104,334.67$83,467.73$0.00$0.00$83,467.73$50,400.00$1,701.77$58,427.41$326,007.86$350,564.48$25,040.3270.00%6201830
52
$107,464.71$85,971.77$0.00$0.00$85,971.77$50,400.00$1,752.82$60,180.24$386,188.09$421,261.65$25,791.5370.00%7201931
53
$110,688.65$88,550.92$0.00$0.00$88,550.92$50,400.00$1,805.41$61,985.64$448,173.74$495,885.14$26,565.2870.00%8202032
54
$114,009.31$91,207.45$0.00$0.00$91,207.45$50,400.00$1,859.57$63,845.21$512,018.95$574,606.91$27,362.2370.00%9202133
55
$117,429.59$93,943.67$0.00$0.00$93,943.67$50,400.00$1,915.36$65,760.57$577,779.52$657,605.68$28,183.1070.00%10202234
56
$120,952.47$96,761.98$0.00$0.00$96,761.98$50,400.00$1,972.82$67,733.39$645,512.90$745,067.24$29,028.5970.00%11202335
57
$124,581.05$99,664.84$0.00$0.00$99,664.84$50,400.00$2,032.00$69,765.39$715,278.29$837,184.65$29,899.4570.00%12202436
58
$128,318.48$102,654.78$0.00$0.00$102,654.78$50,400.00$2,092.96$71,858.35$787,136.64$934,158.53$30,796.4470.00%13202537
59
$132,168.03$105,734.43$0.00$0.00$105,734.43$50,400.00$2,155.75$74,014.10$861,150.74$1,036,197.39$31,720.3370.00%14202638
60
$136,133.08$108,906.46$0.00$0.00$108,906.46$50,400.00$2,220.42$76,234.52$937,385.26$1,143,517.83$32,671.9470.00%15202739
61
$140,217.07$112,173.65$0.00$0.00$112,173.65$50,400.00$2,287.04$78,521.56$1,015,906.82$1,256,344.92$33,652.1070.00%16202840
62
$144,423.58$115,538.86$0.00$0.00$115,538.86$50,400.00$2,355.65$80,877.20$1,096,784.02$1,374,912.48$34,661.6670.00%17202941
63
$148,756.29$119,005.03$0.00$0.00$119,005.03$50,400.00$2,426.32$83,303.52$1,180,087.54$1,499,463.37$35,701.5170.00%18203042
64
$153,218.98$122,575.18$0.00$0.00$122,575.18$50,400.00$2,499.11$85,802.63$1,265,890.17$1,630,249.90$36,772.5570.00%19203143
65
$157,815.54$126,252.44$0.00$0.00$126,252.44$50,400.00$2,574.08$88,376.71$1,354,266.87$1,767,534.10$37,875.7370.00%20203244
66
$162,550.01$130,040.01$0.00$0.00$130,040.01$50,400.00$2,651.30$91,028.01$1,445,294.88$1,911,588.13$39,012.0070.00%21203345
67
22203446
68
23203547
69
24203648
70
25203749
71
26203850
72
27203951
73
28204052
74
29204153
75
30204254
76
31204355
77
32204456
78
33204557
79
34204658
80
35204759
81
36204860
82
37204961
83
38205062
84
39205163
85
40205264
86
41205365
87
42205466
88
43205567
89
44205668
90
45205769
91
46205870
92
47205971
93
48206072
94
49206173
95
50206274
96
51206375
97
52206476
98
53206577
99
54206678
100
55206779
Loading...
 
 
 
Wealth Building