SensitivityTableExample.xlsx

	C	D	E	F	G	H	I	J	K	L	M
1
2
3
4	Inputs			Pro Forma
5	Purchase Price	1,200,000			Year 0	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6
6	Inflation	3%		Purchase Price	(1,200,000)
7	Exit Year	Year 5		NOI		100,000	103,000	106,090	109,273	112,551	115,927
8	Exit Cap Rate	6%		Sale Price		-	-	-	-	1,932,123	-
9				Cash Flow	(1,200,000)	100,000	103,000	106,090	109,273	2,044,674
10	Returns
11	IRR	17.4%				8%	9%	9%	9%
12	Equity Multiple	2.05x
13	AVG Cash on Cash	8.72%
14
15
16
17
18			Returns - IRR / EM / CoC
19			Exit Cap Rate	Purchase Price
20				17.4% / 2.1x / 8.7%	500,000	700,000	800,000	1,000,000	1,200,000	1,500,000	2,000,000
21				3%	61.9% / 8.8x / 20.9%	49.5% / 6.3x / 14.9%	44.9% / 5.5x / 13.1%	37.7% / 4.4x / 10.5%	32.2% / 3.7x / 8.7%	25.9% / 2.9x / 7.0%	18.2% / 2.2x / 5.2%
22				4%	54.3% / 6.9x / 20.9%	42.3% / 4.9x / 14.9%	37.9% / 4.3x / 13.1%	31.0% / 3.4x / 10.5%	25.7% / 2.9x / 8.7%	19.6% / 2.3x / 7.0%	12.3% / 1.7x / 5.2%
23				5%	48.9% / 5.7x / 20.9%	37.2% / 4.1x / 14.9%	32.9% / 3.6x / 13.1%	26.2% / 2.8x / 10.5%	21.0% / 2.4x / 8.7%	15.1% / 1.9x / 7.0%	8.0% / 1.4x / 5.2%
24				6%	44.7% / 4.9x / 20.9%	33.2% / 3.5x / 14.9%	29.0% / 3.1x / 13.1%	22.4% / 2.5x / 10.5%	17.4% / 2.1x / 8.7%	11.6% / 1.6x / 7.0%	4.7% / 1.2x / 5.2%
25				7%	41.4% / 4.4x / 20.9%	30.0% / 3.1x / 14.9%	25.9% / 2.7x / 13.1%	19.4% / 2.2x / 10.5%	14.5% / 1.8x / 8.7%	8.8% / 1.5x / 7.0%	2.0% / 1.1x / 5.2%
26
27
28			Returns - IRR / EM / CoC
29			Exit Year	Purchase Price
30				17.4% / 2.1x / 8.7%	500,000	700,000	800,000	1,000,000	1,200,000	1,500,000	2,000,000
31				1	263.3% / 3.6x / 20.9%	159.5% / 2.6x / 14.9%	127.1% / 2.3x / 13.1%	81.7% / 1.8x / 10.5%	51.4% / 1.5x / 8.7%	21.1% / 1.2x / 7.0%	-9.2% / 0.9x / 5.2%
32				2	103.7% / 3.9x / 20.9%	70.8% / 2.8x / 14.9%	59.3% / 2.5x / 13.1%	41.9% / 2.0x / 10.5%	29.1% / 1.6x / 8.7%	15.1% / 1.3x / 7.0%	-0.7% / 1.0x / 5.2%
33				3	68.3% / 4.3x / 20.9%	48.7% / 3.0x / 14.9%	41.7% / 2.7x / 13.1%	30.7% / 2.1x / 10.5%	22.5% / 1.8x / 8.7%	13.1% / 1.4x / 7.0%	2.2% / 1.1x / 5.2%
34				4	53.1% / 4.6x / 20.9%	38.8% / 3.3x / 14.9%	33.6% / 2.9x / 13.1%	25.5% / 2.3x / 10.5%	19.3% / 1.9x / 8.7%	12.2% / 1.5x / 7.0%	3.8% / 1.1x / 5.2%
35				5	44.7% / 4.9x / 20.9%	33.2% / 3.5x / 14.9%	29.0% / 3.1x / 13.1%	22.4% / 2.5x / 10.5%	17.4% / 2.1x / 8.7%	11.6% / 1.6x / 7.0%	4.7% / 1.2x / 5.2%
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