rent growth - smarthelping.com.xlsx

	A	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA
1	Rent Growth Calculation Options			If you have suggestions or questions, email:	jason@smarthelping.com
2	Hit File and Make a Copy for your own editable version.
3	smarthelping.com
4					1	2	3	4	5	6	7	8	9	10
5		STYLE 1	Year 1 Rent		0.0%	3.0%	3.0%	3.0%	3.0%	3.0%	3.0%	3.0%	3.0%	3.0%
6			250,000	Annual Rent	250,000	257,500	265,225	273,182	281,377	289,819	298,513	307,468	316,693	326,193
7
8
9					1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48
10		STYLE 2			0	0	0	0	1	1	1	1	1	1	1	1	1	1	1	1	2	2	2	2	2	2	2	2	2	2	2	2	3	3	3	3	3	3	3	3	3	3	3	3	4	4	4	4	4	4	4	4
11		Month 1 Start Date	5		0	0	0	0	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44
12		Month 1 Rent	8,000	Monthly Rent	0	0	0	0	8,000	8,000	8,000	8,000	8,000	8,000	8,000	8,000	8,000	8,000	8,000	8,000	8,240	8,240	8,240	8,240	8,240	8,240	8,240	8,240	8,240	8,240	8,240	8,240	8,487	8,487	8,487	8,487	8,487	8,487	8,487	8,487	8,487	8,487	8,487	8,487	8,742	8,742	8,742	8,742	8,742	8,742	8,742	8,742
13
14
15
16		Year	Rent Growth
17		1	0.0%	8,000
18		2	3.0%	8,240
19		3	3.0%	8,487
20		4	3.0%	8,742
21		5	3.0%	9,004
22		6	3.0%	9,274
23		7	3.0%	9,552
24		8	3.0%	9,839
25		9	3.0%	10,134
26
27		STYLE 3
28		Year	Rent Growth	Monthly CAGR
29		1	3.0%	0.25%
30		2	3.0%	0.25%
31		3	3.0%	0.25%
32		4	3.0%	0.25%
33		5	3.0%	0.25%
34		6	3.0%	0.25%
35		7	3.0%	0.25%
36		8	3.0%	0.25%
37		9	3.0%	0.25%
38
39			Monthly Rent		0	0	0	0	8,000	8,020	8,040	8,059	8,079	8,099	8,119	8,139	8,159	8,179	8,200	8,220	8,240	8,260	8,281	8,301	8,322	8,342	8,363	8,383	8,404	8,425	8,445	8,466	8,487	8,508	8,529	8,550	8,571	8,592	8,614	8,635	8,656	8,677	8,699	8,720	8,742	8,763	8,785	8,807	8,828	8,850	8,872	8,894
40
41
42
43		Check out all my financial models, templates, trackers, and tools:
44		The Super Smart Bundle (All Models)	https://www.smarthelping.com/p/excel.html
45		Subscription / Membership Models	https://www.smarthelping.com/p/as-service-business-models.html
46		Joint Venture Cash Flow Waterfalls	https://www.smarthelping.com/p/joint-venture.html
47		Real Estate	https://www.smarthelping.com/p/real-estate.html
48		Inventory	https://www.smarthelping.com/p/inventory.html
49		Accounting	https://www.smarthelping.com/p/accounting.html
50		Industry-specific	https://www.smarthelping.com/p/industries.html
51		HR	https://www.smarthelping.com/p/hr.html
52		Lending	https://www.smarthelping.com/p/lending.html
53		Google Sheet Architectures	https://www.smarthelping.com/p/google-sheet-database-structures.html
54		Service Businesses	https://www.smarthelping.com/p/financial-models-for-service-businesses.html
55		Sales Pipeline Trackers and Dashboards	https://www.smarthelping.com/p/sales-and-customer-pipeline-management.html
56		General Valuation	https://www.smarthelping.com/p/valuation-spreadsheets.html
57
58
59
60
61
62
63		How to Calculate Growth Factor
64		Compounded Annual Growth Rate	3.00%
65		n' Period	5
66		Growth factor (apply to starting rent)	1.159
67
68		Starting Rent	3,500
69		Rent in Period 'n'	4,057
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