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 Year2019Year to start visualizing wealth building
11
Starting Age23Age 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 Age53
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$0.00Bonus, performance and other benefits enjoyed that may be not always permanent
18
Annual Gross Total$30,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 Rate0.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$50,000.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 %33.33%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 Rate0.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 %0.00%The incremental funding is calculated for you
37
Wealth CAGR6.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$349,970.00Within the years specified, you have funnel this amount to wealth building
41
Total Wealth Built after 30 years$1,077,677.36At the last year, you have build this amount of wealth
42
Total Returns Earned (%)207.93%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
$50,000.00$50,000.00
46
$30,000.00$30,000.00$0.00$0.00$30,000.00$9,999.00$0.00$9,999.00$59,999.00$62,999.00$20,001.0033.33%1201923
47
$30,900.00$30,900.00$0.00$0.00$30,900.00$9,999.00$0.00$9,999.00$69,998.00$76,777.94$20,901.0032.36%2202024
48
$31,827.00$31,827.00$0.00$0.00$31,827.00$9,999.00$0.00$9,999.00$79,997.00$91,383.62$21,828.0031.42%3202125
49
$32,781.81$32,781.81$0.00$0.00$32,781.81$9,999.00$0.00$9,999.00$89,996.00$106,865.63$22,782.8130.50%4202226
50
$33,765.26$33,765.26$0.00$0.00$33,765.26$9,999.00$0.00$9,999.00$99,995.00$123,276.57$23,766.2629.61%5202327
51
$34,778.22$34,778.22$0.00$0.00$34,778.22$9,999.00$0.00$9,999.00$109,994.00$140,672.17$24,779.2228.75%6202428
52
$35,821.57$35,821.57$0.00$0.00$35,821.57$9,999.00$0.00$9,999.00$119,993.00$159,111.50$25,822.5727.91%7202529
53
$36,896.22$36,896.22$0.00$0.00$36,896.22$9,999.00$0.00$9,999.00$129,992.00$178,657.19$26,897.2227.10%8202630
54
$38,003.10$38,003.10$0.00$0.00$38,003.10$9,999.00$0.00$9,999.00$139,991.00$199,375.62$28,004.1026.31%9202731
55
$39,143.20$39,143.20$0.00$0.00$39,143.20$9,999.00$0.00$9,999.00$149,990.00$221,337.15$29,144.2025.54%10202832
56
$40,317.49$40,317.49$0.00$0.00$40,317.49$9,999.00$0.00$9,999.00$159,989.00$244,616.38$30,318.4924.80%11202933
57
$41,527.02$41,527.02$0.00$0.00$41,527.02$9,999.00$0.00$9,999.00$169,988.00$269,292.37$31,528.0224.08%12203034
58
$42,772.83$42,772.83$0.00$0.00$42,772.83$9,999.00$0.00$9,999.00$179,987.00$295,448.91$32,773.8323.38%13203135
59
$44,056.01$44,056.01$0.00$0.00$44,056.01$9,999.00$0.00$9,999.00$189,986.00$323,174.84$34,057.0122.70%14203236
60
$45,377.69$45,377.69$0.00$0.00$45,377.69$9,999.00$0.00$9,999.00$199,985.00$352,564.33$35,378.6922.04%15203337
61
$46,739.02$46,739.02$0.00$0.00$46,739.02$9,999.00$0.00$9,999.00$209,984.00$383,717.19$36,740.0221.39%16203438
62
$48,141.19$48,141.19$0.00$0.00$48,141.19$9,999.00$0.00$9,999.00$219,983.00$416,739.22$38,142.1920.77%17203539
63
$49,585.43$49,585.43$0.00$0.00$49,585.43$9,999.00$0.00$9,999.00$229,982.00$451,742.58$39,586.4320.17%18203640
64
$51,072.99$51,072.99$0.00$0.00$51,072.99$9,999.00$0.00$9,999.00$239,981.00$488,846.13$41,073.9919.58%19203741
65
$52,605.18$52,605.18$0.00$0.00$52,605.18$9,999.00$0.00$9,999.00$249,980.00$528,175.90$42,606.1819.01%20203842
66
$54,183.34$54,183.34$0.00$0.00$54,183.34$9,999.00$0.00$9,999.00$259,979.00$569,865.45$44,184.3418.45%21203943
67
$55,808.84$55,808.84$0.00$0.00$55,808.84$9,999.00$0.00$9,999.00$269,978.00$614,056.38$45,809.8417.92%22204044
68
$57,483.10$57,483.10$0.00$0.00$57,483.10$9,999.00$0.00$9,999.00$279,977.00$660,898.76$47,484.1017.39%23204145
69
$59,207.60$59,207.60$0.00$0.00$59,207.60$9,999.00$0.00$9,999.00$289,976.00$710,551.69$49,208.6016.89%24204246
70
$60,983.82$60,983.82$0.00$0.00$60,983.82$9,999.00$0.00$9,999.00$299,975.00$763,183.79$50,984.8216.40%25204347
71
$62,813.34$62,813.34$0.00$0.00$62,813.34$9,999.00$0.00$9,999.00$309,974.00$818,973.82$52,814.3415.92%26204448
72
$64,697.74$64,697.74$0.00$0.00$64,697.74$9,999.00$0.00$9,999.00$319,973.00$878,111.25$54,698.7415.45%27204549
73
$66,638.67$66,638.67$0.00$0.00$66,638.67$9,999.00$0.00$9,999.00$329,972.00$940,796.92$56,639.6715.00%28204650
74
$68,637.83$68,637.83$0.00$0.00$68,637.83$9,999.00$0.00$9,999.00$339,971.00$1,007,243.74$58,638.8314.57%29204751
75
$70,696.97$70,696.97$0.00$0.00$70,696.97$9,999.00$0.00$9,999.00$349,970.00$1,077,677.36$60,697.9714.14%30204852
76
31204953
77
32205054
78
33205155
79
34205256
80
35205357
81
36205458
82
37205559
83
38205660
84
39205761
85
40205862
86
41205963
87
42206064
88
43206165
89
44206266
90
45206367
91
46206468
92
47206569
93
48206670
94
49206771
95
50206872
96
51206973
97
52207074
98
53207175
99
54207276
100
55207377
Loading...