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
 
 
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 Year2018Year to start visualizing wealth building
11
Starting Age28Age when weatlh building starts
12
Years to build wealth30Number of years to visualize. You can do a 40 year project or a 10 year near term visualization
13
Ending Age58
14
15
Your Main Salary
16
Monthly Component$2,500.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$5,000.00Bonus, performance and other benefits enjoyed that may be not always permanent
18
Annual Gross Total$35,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 %10.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 Rate50.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 %1.50%The incremental funding is calculated for you
37
Wealth CAGR5.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 30 years$330,055.82Within the years specified, you have funnel this amount to wealth building
41
Total Wealth Built after 30 years$582,160.84At the last year, you have build this amount of wealth
42
Total Returns Earned (%)76.38%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
$35,000.00$28,000.00$0.00$0.00$28,000.00$2,800.00$0.00$2,800.00$2,800.00$2,800.00$25,200.0010.00%1201828
47
$36,050.00$28,840.00$0.00$0.00$28,840.00$2,800.00$420.00$3,220.00$6,020.00$6,160.00$25,620.0011.17%2201929
48
$37,131.50$29,705.20$0.00$0.00$29,705.20$2,800.00$432.60$3,652.60$9,672.60$10,120.60$26,052.6012.30%3202030
49
$38,245.45$30,596.36$0.00$0.00$30,596.36$2,800.00$445.58$4,098.18$13,770.78$14,724.81$26,498.1813.39%4202131
50
$39,392.81$31,514.25$0.00$0.00$31,514.25$2,800.00$458.95$4,557.12$18,327.90$20,018.17$26,957.1214.46%5202232
51
$40,574.59$32,459.67$0.00$0.00$32,459.67$2,800.00$472.71$5,029.84$23,357.74$26,048.92$27,429.8415.50%6202333
52
$41,791.83$33,433.46$0.00$0.00$33,433.46$2,800.00$486.90$5,516.73$28,874.47$32,868.10$27,916.7316.50%7202434
53
$43,045.59$34,436.47$0.00$0.00$34,436.47$2,800.00$501.50$6,018.23$34,892.70$40,529.73$28,418.2317.48%8202535
54
$44,336.95$35,469.56$0.00$0.00$35,469.56$2,800.00$516.55$6,534.78$41,427.49$49,091.00$28,934.7818.42%9202636
55
$45,667.06$36,533.65$0.00$0.00$36,533.65$2,800.00$532.04$7,066.82$48,494.31$58,612.38$29,466.8219.34%10202737
56
$47,037.07$37,629.66$0.00$0.00$37,629.66$2,800.00$548.00$7,614.83$56,109.14$69,157.82$30,014.8320.24%11202838
57
$48,448.19$38,758.55$0.00$0.00$38,758.55$2,800.00$564.44$8,179.27$64,288.41$80,794.99$30,579.2721.10%12202939
58
$49,901.63$39,921.30$0.00$0.00$39,921.30$2,800.00$581.38$8,760.65$73,049.07$93,595.39$31,160.6521.94%13203040
59
$51,398.68$41,118.94$0.00$0.00$41,118.94$2,800.00$598.82$9,359.47$82,408.54$107,634.63$31,759.4722.76%14203141
60
$52,940.64$42,352.51$0.00$0.00$42,352.51$2,800.00$616.78$9,976.26$92,384.79$122,992.62$32,376.2623.56%15203242
61
$54,528.86$43,623.09$0.00$0.00$43,623.09$2,800.00$635.29$10,611.54$102,996.34$139,753.80$33,011.5424.33%16203343
62
$56,164.73$44,931.78$0.00$0.00$44,931.78$2,800.00$654.35$11,265.89$114,262.23$158,007.38$33,665.8925.07%17203444
63
$57,849.67$46,279.73$0.00$0.00$46,279.73$2,800.00$673.98$11,939.87$126,202.10$177,847.61$34,339.8725.80%18203545
64
$59,585.16$47,668.13$0.00$0.00$47,668.13$2,800.00$694.20$12,634.06$138,836.16$199,374.06$35,034.0626.50%19203646
65
$61,372.71$49,098.17$0.00$0.00$49,098.17$2,800.00$715.02$13,349.08$152,185.24$222,691.84$35,749.0827.19%20203747
66
$63,213.89$50,571.11$0.00$0.00$50,571.11$2,800.00$736.47$14,085.56$166,270.80$247,911.99$36,485.5627.85%21203848
67
$65,110.31$52,088.25$0.00$0.00$52,088.25$2,800.00$758.57$14,844.12$181,114.92$275,151.72$37,244.1228.50%22203949
68
$67,063.62$53,650.90$0.00$0.00$53,650.90$2,800.00$781.32$15,625.45$196,740.37$304,534.75$38,025.4529.12%23204050
69
$69,075.53$55,260.42$0.00$0.00$55,260.42$2,800.00$804.76$16,430.21$213,170.58$336,191.70$38,830.2129.73%24204151
70
$71,147.79$56,918.23$0.00$0.00$56,918.23$2,800.00$828.91$17,259.12$230,429.70$370,260.40$39,659.1230.32%25204252
71
$73,282.23$58,625.78$0.00$0.00$58,625.78$2,800.00$853.77$18,112.89$248,542.59$406,886.31$40,512.8930.90%26204353
72
$75,480.69$60,384.56$0.00$0.00$60,384.56$2,800.00$879.39$18,992.28$267,534.87$446,222.91$41,392.2831.45%27204454
73
$77,745.12$62,196.09$0.00$0.00$62,196.09$2,800.00$905.77$19,898.05$287,432.92$488,432.10$42,298.0531.99%28204555
74
$80,077.47$64,061.97$0.00$0.00$64,061.97$2,800.00$932.94$20,830.99$308,263.90$533,684.69$43,230.9932.52%29204656
75
$82,479.79$65,983.83$0.00$0.00$65,983.83$2,800.00$960.93$21,791.92$330,055.82$582,160.84$44,191.9233.03%30204757
76
31204858
77
32204959
78
33205060
79
34205161
80
35205262
81
36205363
82
37205464
83
38205565
84
39205666
85
40205767
86
41205868
87
42205969
88
43206070
89
44206171
90
45206272
91
46206373
92
47206474
93
48206575
94
49206676
95
50206777
96
51206878
97
52206979
98
53207080
99
54207181
100
55207282
Loading...
Main menu