ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Cap Rate
2
Hit File > Make a Copy for editable version
3
smarthelping.com
4
5
Capitalization Rate (cap rate) Calculator
Check out all my financial models, templates, trackers, and tools:
6
The Super Smart Bundle (All Models)
https://www.smarthelping.com/p/excel.html
7
Annual PeriodSubscription / Membership Models
https://www.smarthelping.com/p/as-service-business-models.html
8
Gross Rental Income 33,333 Joint Venture Cash Flow Waterfalls
https://www.smarthelping.com/p/joint-venture.html
9
Real Estate
https://www.smarthelping.com/p/real-estate.html
10
Operating Expenses 2,222 Inventory
https://www.smarthelping.com/p/inventory.html
11
Accounting
https://www.smarthelping.com/p/accounting.html
12
Net Operating Income (NOI) 31,111 Industry-specific
https://www.smarthelping.com/p/industries.html
13
HR
https://www.smarthelping.com/p/hr.html
14
Lending
https://www.smarthelping.com/p/lending.html
15
Purchase Price 500,000 Google Sheet Architectures
https://www.smarthelping.com/p/google-sheet-database-structures.html
16
Service Businesses
https://www.smarthelping.com/p/financial-models-for-service-businesses.html
17
Cap Rate6.22%Sales Pipeline Trackers and Dashboards
https://www.smarthelping.com/p/sales-and-customer-pipeline-management.html
18
General Valuation
https://www.smarthelping.com/p/valuation-spreadsheets.html
19
Years for NOI to Repay Purchase Price
16.07
20
21
22
23
Alternative Inputs
24
25
Desired Cap Rate8.00%
26
27
Resulting Purchase Price 388,888
28
29
Years for NOI to Repay Purchase Price
12.50
30
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