Independent CRE financial modeling
Commercial real estate financial modeling for developers, investors and brokers. Cost escalation on its own line, sensitivities on every driver that moves the answer, and assumptions you can defend in the room.
| Exit cap / rent growth | 2.0% | 2.5% | 3.0% | 3.5% | 4.0% |
|---|---|---|---|---|---|
| 5.25% | 18.9 | 20.1 | 21.3 | 22.4 | 23.5 |
| 5.50% | 17.2 | 18.4 | 19.3 | 20.5 | 21.6 |
| 5.75% | 15.4 | 16.5 | 17.4 | 18.6 | 19.7 |
| 6.00% | 13.7 | 14.8 | 15.9 | 16.9 | 18.0 |
| 6.25% | 12.0 | 13.1 | 14.2 | 15.2 | 16.3 |
Services
Every engagement is scoped to a fixed fee, built in unlocked Excel, and delivered with the assumptions documented. Your lender, your LPs and your future self can all follow the math.
Inside a model
Four views from a ground-up development model, in the order they get built. Each one feeds the next, and every figure traces back to an input you control.
Development budget
| Land and acquisition | $3,200,000 |
|---|---|
| Hard costs | $26,400,000 |
| Soft costs and fees | $3,950,000 |
| Financing and carry | $2,310,000 |
| Contingency at 5% of hard cost | $1,320,000 |
| Escalation allowance, 20 monthsPriced on its own line, against contingency rather than inside it | $1,620,000 |
| Total development cost | $38,800,000 |
Most budgets bury cost inflation inside the contingency, then spend the contingency on something else. Escalation gets its own line and its own assumption.
Construction draw schedule$35.6M drawn over 20 months
Draws follow the build, not a straight line. Interest is capitalized on the balance outstanding in each month, which is where a flat-average model understates the carry.
Stabilized coverageMonthly net operating income against debt service
Coverage is tested every month, not once on a stabilized average. A lender sizes to the worst twelve months, so that is the number the model has to produce.
ReturnsEvery figure traces back to an input on the tabs above
| Stress applied to the base case | Project IRR | Equity multiple | Spread |
|---|---|---|---|
| Base case | 34.2% | 3.38x | 182 bps |
| Hard cost 6% over budget | 29.4% | 3.02x | 149 bps |
| Exit cap 25 bps wider | 31.9% | 3.09x | 157 bps |
| Lease-up three months slower | 31.6% | 3.21x | 182 bps |
| All three together | 24.1% | 2.58x | 124 bps |
Change one assumption and all four headline numbers move. That is the point of building it this way: the output is never a figure typed into a summary tab.
Process
OM, T-12 and rent roll for acquisitions; budget and plans for development. A messy broker PDF is fine, since normalizing it is the job. Mutual NDA signed the same day if you need one.
A fixed fee and a delivery date come back in writing within hours. No hourly meter running, no surprise invoice at the end.
The draft lands on schedule. We walk through it together on a call, covering every assumption and every driver, until you can defend it without me in the room.
Unlocked, formula-transparent Excel. No black boxes, no locked tabs, no subscription. Two revision rounds included.
The analyst behind the models
I am Joel Taglianetti, a commercial real estate analyst with three years underwriting acquisitions and development across the capital stack, currently at a Providence-based development firm. I have modeled $450M+ in transactions across multifamily, mixed-use and commercial deals, and I spent two summers inside a commercial bank's credit process. That experience is why I know what a lender looks for long before a memo reaches committee.
Real estate has been the dinner-table conversation in my family for many years now, and numbers have always been the part I was good at. This practice is where those two things meet. Every model is built start to finish by me: no outsourced help, no entry-level staff, no automated shortcuts.
Questions
Completely. A mutual NDA is signed before any documents change hands, using a standard form or yours. Files are stored encrypted, never shared, and purged after the engagement on request. I never work both sides of the same deal.
For acquisitions: the OM, trailing-12 financials and rent roll. For development: land basis, budget and plans at whatever stage exists. The full institutional checklist lives on the Process page. Messy broker PDFs are normal, and cleaning them up is part of the fee.
Excel, natively. Every deliverable is an unlocked workbook with transparent formulas and no required plug-ins.
Deal Reviews arrive 48 hours from documents-in-hand, guaranteed. Acquisition Models run 3 to 5 business days, development models 5 to 8, market studies 5 to 7. Retainer clients get 48-hour priority on everything. If a date cannot be hit, you hear it before committing rather than after.
You pay for work performed, capped at 50% of the quoted fee, and that amount credits toward your next deal within 90 days. A dead deal should not cost you twice.
Two full rounds on every fixed-fee engagement, open for 30 days, covering updated debt quotes, new assumptions and revised business plans. Structural scope changes are quoted in writing before work continues.
A 50% deposit begins the work, with the balance invoiced net-7 at delivery. Retainers invoice monthly in advance. ACH, check or card. Deal Review fees always credit toward an Acquisition Model on the same deal.
Contact
Share the basics and a fixed quote and delivery date follow within one business day, usually within hours. No sales call required unless you want one.
Your deal details are in. Expect a fixed quote and a delivery date within one business day. If it is time-sensitive, email directly and say so.