A real estate deal is only as strong as the assumptions holding it together.
Learn how to support the rent, vacancy, expenses, capital costs, financing and exit assumptions in a real estate model—and see how changing them can turn a promising investment into a reprice or a pass.
The most useful underwriting question is not just “What is the projected return?” It is “What must happen to earn that return, how much evidence supports it, and what happens if we are wrong?”
A model connects those questions. A lower rent assumption reduces operating income, weakens debt coverage, lowers potential refinance proceeds and can reduce the sale price. A construction delay changes when revenue starts and how much cash is needed before the property can support itself.
This guide follows the main assumption groups from evidence to investment decision. The worked example is a hypothetical U.S. multifamily acquisition; the same process can be adapted to other property types. All interest rates, cap rates, growth rates and approval thresholds below are illustrative inputs, not current market quotes or universal investment standards.
Give every important assumption a source, a range and a consequence.
Build an assumption register alongside the model. Record the selected input, supporting document, date, calculation, plausible downside and unresolved question. An unsupported input does not become reliable because the spreadsheet calculates it precisely.
Start with what actually happened.
Collect the current rent roll, executed leases and amendments, tenant ledger, collections, trailing operating statements, invoices, tax bills, service contracts and capital spending history. Reconcile them before projecting forward.
Document what changes under your ownership.
Obtain current leasing comparables, insurance quotes, tax estimates, contractor scopes, a property condition assessment and lender terms. A seller’s historical cost or broker’s pro forma may not describe your future cash obligations.
| Input | Evidence and method | Uncertainty to resolve | Decision consequence |
|---|---|---|---|
| Achievable rent | Executed comparable leases, adjusted for concessions, unit quality and location. | Can the subject achieve that rent without additional work? | Lower NOI, debt support and exit value. |
| Insurance | Property-specific quote matching lender coverage requirements. | Deductibles, exclusions and renewal exposure. | Higher recurring cost or an unfundable closing condition. |
| Renovation cost | Inspected scope, quantities, contractor pricing and contingency. | Hidden conditions and out-of-service time. | More equity, delayed rent and lower returns. |
| Exit cap rate | Comparable sales with consistent NOI definitions and property risk. | Future market conditions and remaining lease term. | Less equity recovered at sale or refinance. |
Use a hierarchy of evidence: property-specific executed documents and verified collections usually deserve more weight than asking rents, marketing materials or broad market averages. However, historical documents can become stale. Triangulate actual results with current property-specific quotes and market evidence.
Compare trailing 12 months (T12) with the latest three or six months. The shorter period helps identify a trend; the full year captures seasonality. Explain every material adjustment between reported results and your normalized starting point. Do not annualize the strongest month or remove a recurring repair simply because the seller calls it unusual.
Separate known facts from judgment. A signed lease is evidence of contractual rent; it does not guarantee collection. A quote can support a cost estimate; it may expire or exclude part of the scope. Show the confidence in each input and prioritize diligence where a small error could change the decision.
Build the rent forecast from the space, the leases and the customer.
Use achieved effective rent, with comparable properties that are actually comparable.
Compare unit size, layout, condition, renovation level, amenities, parking, location and tenant-paid utilities. For commercial space, also compare lease structure, usable versus rentable area, tenant improvements and term. Record when the comparable was leased; a quote from a different market period can mislead.
Separate in-place contractual rent, loss-to-lease, renewal increases, turnover resets, renovation premiums and future market growth. Loss-to-lease is the gap between supported market rent and existing contractual rent. You cannot necessarily close that gap immediately: lease expirations, turnover, regulation and the renovation schedule determine when it becomes collectible.
For a value-add plan, support the premium using comparable renovated units or completed units at the subject property. Link each rent increase to the required spending, downtime and leasing date. Do not add a renovation premium to a market-rent assumption that already represents renovated units.
Separate occupancy from the ability to collect.
- Physical vacancy: units or space without a tenant, including normal turnover and any separately identified downtime.
- Concessions: free rent, discounts and incentives needed to secure or retain tenants.
- Credit loss: delinquency and nonpayment on occupied space. Reconcile write-offs, arrears and collections to the correct period.
- Renovation or construction downtime: inventory unavailable to lease. Avoid subtracting it again if it is already in vacancy.
Security deposits are generally obligations to tenants, not rental revenue. Likewise, prepaid rent or collection of an old balance can make a single month’s cash receipts look stronger than its recurring earnings.
Estimate lease-up from demand and available inventory.
Use recent applications, qualified prospects, conversion rates, renewals and net move-ins. Cross-check competing projects, concessions, affordability, employment and new supply in the relevant submarket. Distinguish gross leases signed from net occupied-unit additions after move-outs. Model delivered units, rentable units and occupied units separately.
For commercial leases, review tenant credit and concentration, expirations, options, renewal probability, downtime, free rent, tenant improvements and leasing commissions. A large tenant expiration can create a cash-flow cliff that an average vacancy assumption conceals. Review termination, co-tenancy and reimbursement provisions where applicable.
Other income needs its own driver. Parking, storage, pet fees and utility reimbursements should follow eligible occupied units, actual adoption, contractual rights and collection history. For expense recoveries, model recoverable costs, tenant shares, caps, base years and collection leakage. A triple-net label does not prove that every owner cost is recoverable.
The Multifamily Acquisition Financial Model combines historical operating analysis, up to 20 unit types, monthly value-add assumptions, financing, reserves and partnership returns.
Explore the Multifamily Acquisition Financial Model →Growth is a separate assumption from fixing today’s rent roll.
First estimate the income supported by existing leases and today’s market. Then forecast how the market may change. Closing an existing loss-to-lease gap is different from assuming rents rise 3% every year. Applying both without tracking individual lease timing can count the same upside twice.
Build growth by year and segment where useful. Check recent effective-rent trends, income affordability, competing deliveries, local demand and leasing restrictions. A temporary supply wave may justify flat rents and larger concessions before a later recovery. A five-year average can conceal the cash shortage in the first two years.
Keep linked assumptions economically consistent. A higher asking rent can slow leasing or increase concessions. Faster occupancy can require more marketing, staffing and incentives. Test those relationships together instead of treating every input as independent upside.
Do not automatically give expenses the same growth rate as rent. Insurance, property taxes, payroll, repairs and utilities have different drivers. A model that grows revenue faster than expenses indefinitely needs a reason that can survive scrutiny.
Underwrite the costs you will pay after closing.
| Expense | Best starting evidence | What can change the deal |
|---|---|---|
| Property taxes | Assessor records, current bills and a local estimate of post-sale assessment and applicable rates. | Reassessment, expiring abatements, special assessments and appeal timing. Do not assume the seller’s bill carries forward. |
| Insurance | Current property-specific quotes, claims history and required coverage. | Deductibles, exclusions, replacement values, flood/wind exposure and renewal costs. |
| Repairs, maintenance and turnover | Invoices, work orders, unit turns, age and condition. | Deferred maintenance disguised as unusually low expense; turnover costs rising with the business plan. |
| Payroll and management | Staffing plan, compensation, benefits and management proposals. | Necessary on-site coverage, payroll burden and a realistic management cost even if initially self-managed. |
| Utilities and services | Usage, tariffs, service contracts and metering arrangements. | Fixed charges versus occupied-unit usage, contract resets and incomplete tenant recovery. |
| Other recurring costs | Actual contracts and the operating plan. | Licenses, administration, marketing, security, grounds, technology, ground rent and compliance work. |
Use per-unit or per-square-foot comparisons as a cross-check, then explain material differences. An expense ratio alone can hide a missing line item. Separate fixed costs from variable costs: losing tenants does not proportionately reduce property taxes, insurance or most staffing requirements.
Normalize owner-related and nonrecurring items carefully. Removing a seller’s personal expense may be reasonable. Removing management expense when you still need management overstates economic performance. Replace unsupported add-backs with the cost of operating the property under the proposed plan.
Keep three measures distinct: NOI is property operating income after operating expenses; lender-underwritten net cash flow may include further adjustments or replacement deductions; equity cash flow also reflects capital spending, financing, fees and reserve movements. Define the numerator before quoting a DSCR or cap rate.
Lender reference: Fannie Mae’s Underwritten Net Cash Flow guidance illustrates why lender cash flow, insurance and expense treatment need their own review. Apply the requirements of the actual financing being considered.
A strong stabilized NOI does not fund the months before stabilization.
Build a capital schedule from inspections and scope: roof, structure, mechanical systems, electrical, plumbing, paving, interiors, accessibility and other required work. Use remaining useful life, quantities, contractor bids, permits, design fees, taxes, escalation and scope-specific contingency. A flat dollar amount per unit is a check, not a substitute for this work.
Separate immediate repairs, planned improvements, recurring replacements and tenant improvements/leasing commissions. Show when cash is paid and when the improvement starts producing rent. Reconcile reserve funding and actual spending so a dollar deposited into a reserve and later paid to a contractor is not treated as two separate economic costs.
For development, make the schedule control the economics.
Connect entitlements, permits, utility capacity, site work, construction milestones, inspections, certificates of occupancy and tenant delivery requirements. Model the monthly draw schedule, lender retainage, reimbursement lag, equity-first requirements, interest reserve, extension fees and permanent-loan conversion conditions.
If the delay moves the sale date back, recalculate returns using the revised cash-flow dates. If the sale date stays fixed, the shorter operating period affects proceeds differently. Do not charge both lost cash flow and a timing shift for the same effect without defining the counterfactual.
Determine the peak cash requirement from the full monthly funding schedule, not the annual income statement. Add a liquidity buffer suited to the identified risks. Confirm who can fund overruns, whether the capital is committed, and whether reserve cash is restricted or actually available.
For development, also calculate stabilized yield on cost = stabilized annual NOI ÷ total project cost, using a complete, consistently defined cost basis. Compare it with supported market cap rates to assess the value-creation margin. A positive spread does not remove completion, lease-up or financing risk; verify it with unlevered project cash flows and the timing of every investment.
The Retail Construction Financial Model supports land, construction, tenant buildouts, lease-up, tenant improvements, commissions and monthly funding timing.
Explore the Retail Construction Financial Model →“The lender will provide 65%” is only the start.
Obtain terms for the specific property and business plan. Record rate or index plus spread, rate floors, amortization, interest-only periods, term, fees, escrows, rate-cap costs, recourse, covenants, cash sweeps, extension tests and prepayment terms. Identify whether the quote is indicative, approved or subject to unresolved conditions.
| Test | Illustrative calculation |
|---|---|
| LTV-supported debt | Lender-accepted property value × maximum LTV. |
| DSCR-supported debt | Lender-underwritten annual cash flow ÷ required DSCR ÷ annual mortgage constant. |
| Debt-yield-supported debt | Eligible NOI ÷ minimum debt yield, using the lender’s definition. |
The mortgage constant is annual scheduled debt service divided by initial loan principal. For an amortizing loan, it includes principal repayment; using only the interest rate overstates loan support. Interest-only can improve early distributions while leaving a larger payoff and a payment increase when amortization starts.
Less leverage may improve coverage but increase the equity requirement and change returns. More leverage can increase returns in a successful case while magnifying losses and funding risk. Recalculate all three: loan proceeds, required equity and investor returns.
Underwrite the refinance as a new loan.
At maturity, use the future property income, a supportable value, stressed financing terms and applicable sizing limits. Subtract refinancing costs and the old debt payoff. A cash-out forecast must emerge from those calculations; it should not be a fixed percentage of the original equity.
Official context: the OCC Commercial Real Estate Lending handbook discusses income analysis, debt coverage, debt yield and value. The OCC’s refinance-risk guidance explains why a remaining balance at maturity requires a credible repayment plan. These are lender resources, not a universal investor approval formula.
The exit is a future transaction with its own risks and costs.
Start with recent closed sales of comparable assets. Reconcile property quality, location, occupancy, tenant credit, remaining lease term, capital needs and how NOI was measured. An asking price is not a completed transaction. A cap rate calculated on trailing NOI is not directly comparable to one using a substantially higher stabilized forecast.
Consider the property’s age and condition at sale, the remaining lease term, buyer demand and the financing environment. Cap-rate expansion can be an appropriate stress; a fixed expansion rule is not automatically right for every asset. Underwrite both higher cap rates and weaker income.
Match the convention in the chosen model and the comparable evidence. Some models use trailing-12-month exit NOI. A forward-NOI approach is appropriate only if it represents what the buyer would reasonably underwrite; it cannot quietly assume an uncompleted renovation or ignore an imminent lease expiration.
Set the investor’s required return before optimizing the deal. Consider alternative investments, illiquidity, leverage, execution risk and the investor’s cash-income needs. Review IRR together with equity multiple, net present value, annual distributions and capital exposure. A quick capital return can improve IRR without producing a large total profit.
Finally, include sponsor and transaction fees, preferred equity, promote tiers and investor-specific taxes where relevant. A project-level return is not automatically the LP’s return. Depreciation-related tax benefits belong in a separate, usable after-tax cash-flow analysis; they do not increase property NOI.
A $6 million property can produce positive cash flow and still miss the return target.
Consider a stabilized 40-unit acquisition. To make the relationships visible, this example uses annual operating cash flows, monthly loan amortization and a five-year hold. Immediate repair spending does not create a separate rent premium or additional downtime in this simplified case.
| Assumption | Base case |
|---|---|
| Purchase price | $6,000,000 |
| Closing and financing costs / immediate repairs / initial cash reserve | $120,000 / $200,000 / $80,000 |
| Total initial uses | $6,400,000 |
| Loan / initial equity | $3,900,000 / $2,500,000 |
| Loan terms | 65% of price; 6.50% fixed; 30-year amortization; five-year term |
| Units × monthly potential rent | 40 × $1,500 |
| Combined rent loss: vacancy, concessions and credit loss | 5% of gross potential rent |
| Year 1 other income / operating expenses | $24,000 / $288,000 |
| Year 1 recurring replacement spending | $20,000, below NOI |
| Annual growth from Year 2 | 3% in rent, other income, operating expenses and replacements |
| Exit cap / selling costs | 7.25% / 2% of sale price |
The combined 5% rent-loss assumption is a simplification for this example. In a detailed model, build and reconcile its individual components. Other income is assumed to be net collectible income and remains unchanged from the base forecast in the isolated rent-loss tests.
| Year 1 cash-flow bridge | Amount |
|---|---|
| Gross potential rent: 40 × $1,500 × 12 | $720,000 |
| Less combined rent loss at 5% | −$36,000 |
| Plus other income | $24,000 |
| Effective gross income | $708,000 |
| Less operating expenses | −$288,000 |
| Net operating income | $420,000 |
| Less recurring replacement spending | −$20,000 |
| Cash flow used for this example’s DSCR | $400,000 |
| Less scheduled principal and interest | −$295,808 |
| Year 1 cash available to equity | $104,192 |
DSCR convention: every example DSCR here deducts recurring replacement spending from NOI before dividing by debt service. The base calculation is $400,000 ÷ $295,808 = 1.35×. The NOI-only calculation would be 1.42×. Actual lender underwriting and covenant definitions must be checked.
With 3% annual growth in the operating lines, Year 6 NOI is approximately $486,895. At a 7.25% cap rate, gross sale value is about $6.716 million. Subtract 2% selling costs and the roughly $3.651 million remaining loan balance, then return the unused $80,000 reserve.
See the cash flows and return methodology
| Timing | Operating distribution | Sale and reserve proceeds | Total equity cash flow |
|---|---|---|---|
| Closing | — | — | −$2,500,000 |
| Year 1 | $104,192 | — | $104,192 |
| Year 2 | $116,192 | — | $116,192 |
| Year 3 | $128,552 | — | $128,552 |
| Year 4 | $141,283 | — | $141,283 |
| Year 5 | $154,396 | $3,010,651 | $3,165,046 |
Equity is contributed at closing; distributions and the sale occur at annual period-end. The loan uses 360 monthly payments for amortization and is repaid after payment 60. The initial cash reserve earns no interest; it funds deficits if necessary, and only the remaining reserve is returned at sale. Recurring replacement spending is paid each year and is separate from that cash reserve. Returns are before investor income taxes and exclude sponsor fees, promotes and prepayment penalties. Closing and financing costs are combined at 2% of purchase price. Figures are rounded independently; returns use unrounded cash flows. A transaction model should use the actual items and dates.
Go or no-go? Suppose this buyer requires a 10% before-tax equity IRR and at least 1.25× coverage under the stated cash-flow definition. The property passes the initial coverage test but misses the return target. Its NPV at 10% is approximately negative $151,000. Positive distributions alone do not justify the asking price.
Some small input changes have large effects on equity returns.
Each row below starts from the base case and changes only the stated assumption. Rent and expense level changes persist through the hold and into exit NOI. The loan stays at $3.9 million to isolate the effect; a lender may require a smaller loan where coverage fails.
| Change from base case | Year 1 NOI | Year 1 cash to equity | Year 1 DSCR | 5-year equity IRR |
|---|---|---|---|---|
| Base case | $420,000 | $104,192 | 1.35× | 8.52% |
| Starting rent 5% lower | $385,800 | $69,992 | 1.24× | 3.48% |
| Combined rent loss: 5% → 8% | $398,400 | $82,592 | 1.28× | 5.43% |
| Operating expenses 10% higher | $391,200 | $75,392 | 1.25× | 4.33% |
| Loan rate: 6.5% → 7.5% | $420,000 | $72,768 | 1.22× | 7.10% |
| Exit cap: 7.25% → 8.25% | $420,000 | $104,192 | 1.35× | 2.96% |
| $100,000 additional upfront repairs | $420,000 | $104,192 | 1.35× | 7.60% |
| Annual rent growth: 3% → 1% | $420,000 | $104,192 | 1.35× | 0.10% |
Rounded results; cash to equity is after scheduled debt service and recurring replacement spending. The $100,000 repair overrun is funded by extra equity at closing. In the rent-growth test, only rent growth falls to 1%; other income, operating expenses and replacement spending still grow 3%. The higher-rate case is an alternative origination quote, not a rate reset on the base case’s fixed-rate loan.
Why a 5% rent miss cuts first-year equity cash by about one-third
A 5% reduction in starting rent, with the same 5% rent-loss factor, reduces annual collected rent by $34,200. Expenses and debt service do not fall in this isolated test. The entire decline flows through to equity cash, reducing it from $104,192 to about $69,992—a 32.8% reduction. The lower ongoing income also reduces the sale value.
Why the growth assumption deserves its own test
Reducing annual rent growth from 3% to 1% leaves Year 1 unchanged. Yet five-year equity IRR falls from 8.52% to approximately 0.10%. Lower rents accumulate over time while costs continue growing, and the lower Year 6 NOI reduces the exit value. A deal can therefore pass its first-year coverage test while producing a weak total return.
Why the exit cap can dominate the result
Raising only the exit cap from 7.25% to 8.25% reduces gross sale value by approximately $814,000, from $6.716 million to $5.902 million. First-year cash flow is unchanged, but equity IRR falls to approximately 2.96%.
| Year 6 NOI | 6.75% cap | 7.25% cap | 7.75% cap | 8.25% cap |
|---|---|---|---|---|
| 10% below base | $6.492m | $6.044m | $5.654m | $5.312m |
| Base exit NOI | $7.213m | $6.716m | $6.283m | $5.902m |
| 10% above base | $7.935m | $7.387m | $6.911m | $6.492m |
Property values in millions, before selling costs and debt repayment. The center income row uses approximately $486,895 of Year 6 NOI. These are scenario values, not appraisals or probability estimates.
The Real Estate IRR Sensitivity template compares vacancy with exit cap rate, leverage and interest rate, alongside cash-flow and coverage outputs.
Explore the Real Estate IRR Sensitivity Model →Test the combination that can actually break the business plan.
A weak leasing market can mean lower rents, more vacancy and concessions, slower growth and a less favorable exit. One-variable sensitivities identify important drivers; a coherent combined scenario shows whether the financing and capital plan survive. Do not simply add separate IRR changes together.
Combined downside: starting rent falls 5%, combined rent loss rises from 5% to 8%, operating expenses rise 10%, the acquisition loan costs 7.5%, and the exit cap is 8.25%. Year 1 NOI falls to $336,480; DSCR falls to 0.97×; and operations have an approximately $10,752 deficit after replacement spending and debt service. With deficits funded from the initial reserve, five-year equity IRR is approximately −15.73% and the equity multiple is about 0.43×.
This combined case assumes the same initial loan is available solely to illustrate the exposure. A loan sized to the example’s 1.25× test would not support those terms at closing. The investor must evaluate a lower loan, more equity or a lower price—not assume the lender will overlook the shortfall.
The combined case retains 3% annual growth and excludes the separate $100,000 overrun. Its operating deficits consume approximately $12,010 of the initial reserve across Years 1 and 2, leaving $67,990 for release at sale. Investor distributions in those deficit years are zero. This annual illustration does not establish that cash is sufficient in every month.
Calculate the break point, not just a few scenarios.
Holding the base rent, expenses, replacement spending and debt service constant, the combined rent-loss rate can rise from 5% to about 9.2% before coverage falls below 1.25×. It reaches cash break-even after replacement spending at about 19.5%. The underwriting coverage threshold is reached well before the property runs out of annual operating cash.
Those are combined economic-loss rates, not physical vacancy alone. They also hold expenses and other income fixed. A detailed model should calculate the break point with its actual occupancy-linked expenses, reimbursements and lender adjustments.
Check loan sizing and the maturity gap.
At the base terms, the annual mortgage constant is approximately 7.585%. Using illustrative limits of 65% LTV, 1.25× DSCR and 9% debt yield gives these maximum loans:
| Constraint | Maximum loan |
|---|---|
| 65% × $6.0 million accepted value | $3.900 million |
| $400,000 ÷ 1.25 ÷ 7.585% mortgage constant | $4.219 million |
| $420,000 NOI ÷ 9% debt yield | $4.667 million |
The LTV constraint is binding here. In a separate Year 5 refinance stress, assume the lender accepts only $360,000 of NOI, deducts $20,000 for replacements, values the property at an 8.25% cap and quotes 7.5% interest with 30-year amortization. Keeping the same illustrative sizing limits, LTV permits about $2.836 million, DSCR about $3.242 million and debt yield $4.000 million.
The lowest amount is $2.836 million. After 2% refinancing costs, only about $2.780 million remains against the base loan’s $3.651 million payoff: an approximately $871,000 funding gap before applying any remaining available cash. That is a required capital solution at maturity, not simply a disappointing return percentage.
Solve for the purchase price the evidence can support.
Holding the base operating and exit assumptions constant, keeping debt at 65% of purchase price and closing costs at 2%, the price that produces a 10% equity IRR is approximately $5.839 million, compared with the $6.0 million asking price. Initial equity becomes approximately $2.440 million.
A return-based bid is a ceiling for that scenario. It is not an automatic recommendation to buy. The deal must also meet the investor’s downside, liquidity, financing and diligence requirements. A lower price cannot cure an uninsurable building, missing legal access or a business plan that cannot be executed.
Make the go/no-go decision with separate gates.
Define the criteria before negotiating around the spreadsheet. An investor may choose a minimum IRR, equity multiple, cash yield, coverage cushion, maximum capital exposure and tolerable downside. The thresholds must fit that investor and property; none of the example percentages above is a universal rule.
| Gate | Question to answer | If the answer is weak |
|---|---|---|
| Evidence | Are the material inputs supported, reconciled and current? | Pause for specific documents or use a justified lower assumption. |
| Legal and physical feasibility | Are title, access, permitted use, leases, condition, utilities and environmental issues acceptable? | Require a documented solution before an unconditional commitment; pass if the issue cannot be resolved. |
| Operating economics | Does the property earn an acceptable return after realistic operating and capital costs? | Reprice, revise a supportable business plan or pass. |
| Financing and liquidity | Can the deal close, cover its cash needs and repay or refinance debt under credible stresses? | Resize debt, secure capital or revise the structure. Do not leave a funding gap unassigned. |
| Investor outcome | Do actual investor cash flows meet the objective after fees, waterfall terms and relevant taxes? | Renegotiate economics or decline despite an attractive property-level IRR. |
| Execution capacity | Can the team deliver the work, leasing and reporting plan within the budget and schedule? | Add accountable resources and cost them, or reduce the scope of the plan. |
Environmental review may require a qualified professional and follow-up investigations. The EPA’s All Appropriate Inquiries resources explain the environmental assessment framework; a Phase I report is not a blanket guarantee that a property has no issues or that every liability protection applies.
Use the FEMA Flood Map Service Center as a starting point for flood-hazard diligence, then assess property-specific exposure and insurability. Review claims, drainage, business-interruption exposure, deductibles and the required mitigation budget with the relevant professionals.
The supported case meets the mandate.
Diligence is complete enough for the commitment, financing is workable, funding is available and the downside fits the investor’s limits.
A specific remaining condition has an owner.
Identify exactly what must be resolved, by whom and before which deadline. Examples include an insurance binder, lender approval or an acceptable engineering scope.
The asset may work on different terms.
Quantify the price, debt, reserve or capital change required, then rerun the entire deal. A seller credit, lower price and deferred payment do not have identical effects.
The return or risk cannot be justified.
The supported economics fail, necessary capital is unavailable, or a material legal, physical or execution problem has no acceptable solution.
Write the decision in one paragraph: “At this price and capital structure, the supported base case produces these returns. These assumptions have the most influence. This downside requires this much cash. These conditions must be satisfied before proceeding.” Keep that paragraph with the model and update it as diligence changes the facts.
Choose a model that follows how the real estate earns and spends cash.
The evidence process stays consistent, but the operating drivers change. Commercial properties need lease-by-lease timing; hotels need monthly rate, occupancy and labor assumptions; mixed-use properties need distinct assumptions for each component.
Strip Mall Acquisition Model
Analyze tenant expirations, rent commencement, gross versus NNN leases, reimbursements, capital spending and financing. Useful when lease rollover and tenant costs drive the risk.
Explore the Strip Mall Acquisition Model →Mixed-Use Real Estate
Separate rents, occupancy, costs and exit assumptions across multiple property uses. Avoid applying one blended rent or cap-rate assumption to components with different risks.
Explore the Mixed-Use Real Estate Model →Apartment & Self-Storage Underwriting
Connect unit types, rent assumptions, staggered openings, occupancy, acquisition or construction funding, refinance and investor returns. Check the model’s trailing-NOI exit convention.
Explore the Apartment & Self-Storage Model →Hotel Investment Financial Model
Underwrite monthly room rates and occupancy alongside staffing and ancillary operations. Test rate and occupancy together, including the labor and service costs required to deliver the revenue.
Explore the Hotel Investment Financial Model →Cash Flow Waterfall: 3 IRR Hurdles
Allocate contributions and distributions across LP/GP hurdle tiers. Use it to test whether the investor’s outcome matches the attractive return shown at the project level.
Explore the Cash Flow Waterfall Template →Development Budget vs. Actual
Track the budget against actual spending as a project advances. Update the remaining cost, schedule and funding requirement when new information changes the original assumptions.
Explore the Development Budget vs. Actual Model →The article’s numerical example was calculated independently for illustration. Individual templates use different structures and conventions and may require adaptation to reproduce it or implement every diligence item discussed.
No comments:
Post a Comment