ROI Justification for Powerful Python Bootcamp v3

	A	B	C	F	G	H	I	J	K	L
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
5	Model Inputs			Projection Of Earnings
6		Starting Job Title	Software Engineer I	Year	Inflation (Cumulative)	Median Salary	Ramp-up	Bootcamp	Added Earnings	Ratio
7		Location	San Francisco	0	1.00	$104,349	0.0	$104,349	$37,605	1.00
8		Median salary	$104,349	1	1.03	$107,479	1.0	$182,688	$75,209	1.70
9		90th %ile salary	$125,698	2	1.06	$110,704	1.3	$210,084	$99,381	1.90
10		Enhanced Job Ttile	Software Engineer II	3	1.09	$114,025	1.4	$230,043	$116,018	2.02
11		90% Salary	$158,776	4	1.13	$117,446	1.5	$247,061	$129,615	2.10
12		Inflation rate	3.00%	5	1.16	$120,969	1.6	$262,615	$141,646	2.17
13	Outputs			6	1.19	$124,598	1.7	$277,378	$152,780	2.23
14		Excess over starting salary	$54,427.00	7	1.23	$128,336	1.8	$291,714	$163,378	2.27
15		Percentage earnings increase	52.16%	8	1.27	$132,186	1.8	$305,845	$173,659	2.31
16	Optional Income Opportunities			9	1.30	$136,152	1.9	$319,917	$183,765	2.35
17		Consulting hours/mo	5	10	1.34	$140,236	1.9	$334,032	$193,795	2.38
18		Consulting hourly rate	$200	11	1.38	$144,443	2.0	$348,267	$203,823	2.41
19		Ramp-up factor (logarithmic)	8.6	12	1.43	$148,777	2.0	$362,681	$213,905	2.44
20		Projected base salary	$158,776	13	1.47	$153,240	2.1	$377,323	$224,083	2.46
21		Workshop revenue	$7,939	14	1.51	$157,837	2.1	$392,232	$234,395	2.49
22		Consulting revenue	$12,000	15	1.56	$162,572	2.1	$407,443	$244,871	2.51
23		Total annual	$178,715	16	1.60	$167,450	2.1	$422,986	$255,536	2.53
24		Excess over median salary	$74,366	17	1.65	$172,473	2.2	$438,889	$266,416	2.54
25		Percentage earnings increase	71.3%	18	1.70	$177,647	2.2	$455,178	$277,531	2.56
26				19	1.75	$182,977	2.2	$471,876	$288,899	2.58
27		Cumuative Projected Additional Earnings (20 yr):		20	1.81	$188,466	2.2	$489,006	$300,541	2.59
28		$3,676,310.12
29
30	The calculations herein are predictions based on model assumptions, and there is no guarantee of any specific outcome.
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
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