The spreadsheet starts with evidence
A property can look compelling in a photograph and disappointing in its operating statements. For commercial and investment real estate buyers in Pocatello and beyond, data analysis connects the property’s story with its financial reality. The goal is a decision you can explain: what supports the price, what could change, and which uncertainties remain.
A precise spreadsheet can still produce a poor answer if the inputs are unreliable. Start by separating documented facts, reasonable estimates, and seller projections. A signed lease, a record of collected rent, and an advertised asking rent describe different things. Treating them as interchangeable can overstate a property’s earning capacity.
Build a trail from the source to the model
Request current rent rolls, leases and amendments, operating statements, utility bills, maintenance records, and relevant service contracts. Where available, compare monthly activity across more than one year. A single annual total can hide vacancy, seasonality, unusual repairs, or recent concessions. Reconcile material differences rather than choosing the number that makes the deal look best.
Record the source, date, period covered, and confidence level for each major assumption. Ask whether the figures use cash or accrual accounting, whether tenant reimbursements are shown consistently, and whether all occupied units are actually paying. An unanswered question belongs in an uncertainty log until it is resolved.
An example of why the inputs matter
Consider a hypothetical property with $180,000 of annual operating revenue after vacancy and concessions. At $70,000 of operating expenses, net operating income is $110,000. If a careful review identifies another $20,000 of recurring expenses, NOI falls to $90,000. At an illustrative 7% capitalization rate, those figures imply approximately $1.57 million and $1.29 million respectively. These are arithmetic examples, not Pocatello market valuations.
That difference came from expenses, not a change in the building. A capitalization calculation is also only one lens: lease quality, condition, financing, and comparable transactions still matter. Capital expenditures and debt service should be evaluated separately rather than silently folded into a conventional NOI calculation.
Let the analysis change the decision
Good analysis may support the acquisition, suggest a different price, or show that more investigation is needed. Set decision criteria before becoming emotionally committed. Identify the cash requirements, operating risks, and assumptions the investment must satisfy.
Mark Bitton, CCIM, brings expertise in investment analysis, property management, and marketing to commercial real estate decisions. A useful starting point is simple: gather reliable evidence, make the assumptions visible, and allow the results to influence the next step.