ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
https://powerfulpython.com/bootcamp/
2
Download/copy this spreadsheet and customize model inputs to your situation.
3
Look up median and 90th %ile salary on https://salary.com
4
For methodology, read the 'Income Model' section of the Guide:
5
How To Thrive As A Pythonista And Finally Get Paid What You Are Worth
6
7
Model Inputs
Projection Of Earnings
8
Job title
Web Developer II
Year
Inflation (Cumulative)
Median SalaryRamp-upBootcampAdded EarningsRatio
9
LocationUSA01.00$94,5890.0$94,589$01.00
10
Median salary$94,58911.06$99,7910.6$131,204$31,4131.31
11
90th %ile salary$115,92421.11$105,2800.8$152,018$46,7381.44
12
Consulting hours/mo531.17$111,0701.0$169,552$58,4821.53
13
Consulting hourly rate$20041.24$117,1791.1$186,008$68,8291.59
14
Inflation rate5.50%51.31$123,6241.2$202,197$78,5721.64
15
Outputs
Ramp-up factor (logarithmic)2.961.38$130,4231.3$218,523$88,1001.68
16
71.45$137,5971.3$235,229$97,6321.71
17
81.53$145,1641.4$252,479$107,3151.74
18
Projected salary (99th %ile)$133,31291.62$153,1491.4$270,400$117,2521.77
19
Consulting revenue$12,000101.71$161,5721.5$289,096$127,5241.79
20
Total annual$145,312111.80$170,4581.5$308,658$138,2001.81
21
Excess over median salary$50,723121.90$179,8331.5$329,171$149,3371.83
22
Percentage earnings increase53.6%132.01$189,7241.6$350,716$160,9911.85
23
142.12$200,1591.6$373,372$173,2131.87
24
Cumuative Projected Additional Earnings (20 yr):
152.23$211,1681.6$397,221$186,0531.88
25
$2,516,375.12162.36$222,7821.7$422,343$199,5611.90
26
172.48$235,0351.7$448,821$213,7861.91
27
182.62$247,9621.7$476,742$228,7811.92
28
192.77$261,6001.7$506,196$244,5961.94
29
202.92$275,9881.8$537,276$261,2881.95
30
31
32
NOTE: This model underestimates the income increase, because it does not account for the rise in employment fraction (i.e. the percentage of time you are employed and thus earning). For details, see the Guide linked above.

Salary ramp-up is modeled as a logarthmic increase to the 99th %ile salary by year 3, and continuing to rise from that point.

The calculations herein are based on model assumptions, as documented in the Guide, and there is no express or implied promise or guarantee of any specific outcome.
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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100