An after-tax underwriting model is a decision tool, not a promise about what a property will earn. It shows how operating results, financing, depreciation, income taxes, and the eventual sale interact for a particular investor and entity. The point is to make the assumptions visible before you commit capital.
Why After-Tax Underwriting Matters
A property can look attractive on a pre-tax spreadsheet and still produce a different cash result after federal and California taxes. That difference is not a single haircut applied to a projected return. It depends on the investor's tax profile, the type of income, the property's basis, the financing, and the timing of each transaction.
Keep three questions separate:
- What cash does the property generate from operations?
- What taxable income or loss does the activity report?
- How much cash remains after debt service and the investor's tax payments?
An income statement, a tax return, and a cash forecast are not the same thing. Treating them as one is how deals get mispriced.
Start With The Deal And Tax Facts
Begin with facts you can document. Record the purchase price, land allocation, closing costs, planned improvements, expected rent, vacancy, operating costs, loan terms, ownership percentage, and intended hold period. Note whether the property is a rental, a development, a short-term rental, or part of an operating business. Those facts drive both the business case and the tax treatment.
Then identify the taxpayer. An individual, partnership, S corporation, C corporation, and trust can report the same property differently. Confirm the entity's state filing obligations, ownership percentages, outside basis, debt basis, and whether losses are limited by basis, at-risk, or passive-activity rules. If the deal will be syndicated, include the partnership agreement and allocation provisions rather than assuming every owner receives the same tax items.
A model built without the investor's actual tax facts may be mathematically neat but not decision-ready. That is where a conversation with the CPA earns its keep.
Build The Operating Case
Project the property before taxes. Start with scheduled rent or other revenue, then make explicit adjustments for vacancy, concessions, bad debt, and collection timing. List ordinary operating expenses such as repairs, insurance, property taxes, utilities, management, supplies, and reserves. Keep capital expenditures and tenant improvements visible instead of blending them into recurring expenses.
Use a year-by-year schedule. A flat growth rate can be a placeholder, but label it as an assumption and test it. If a rent increase depends on a lease renewal, a renovation, or a market estimate, show that dependency. A conservative base case is easier to review than a polished forecast that hides its inputs.
The result should be net operating income, cash needed for reserves, and cash available before financing and taxes. That operating view stays useful even if the investor's tax situation changes.
Layer In Depreciation And Taxable Income
Taxable income usually does not equal cash flow. Allocate the building and land correctly, establish the depreciable basis, and identify the recovery periods that apply to the property and its components. If a cost segregation study or other accelerated depreciation method is being considered, model it as a separate assumption and confirm eligibility before relying on it.
A practical tax schedule reconciles the operating case to taxable income. Include depreciation, interest expense, repairs, improvements, and other deductions, with separate lines for items deductible now and items that are capitalized. Track suspended passive losses rather than treating them as current cash savings. Also identify whether the investor has outside passive income or other facts that could change when a loss becomes usable.
For California taxpayers, include the state treatment rather than assuming the federal result carries over. State conformity, entity-level taxes, minimum taxes, and filing requirements can affect the cash-tax estimate. Flag items that need a tax conclusion. Do not quietly hard-code them.
Model Financing And Cash Taxes Separately
Debt changes cash flow, but principal repayment is not generally a deduction. Show beginning balance, interest, principal, fees, and any required reserves. If the loan has a variable rate, an interest-only period, a balloon payment, or a refinance assumption, put those terms in the schedule and test what happens when they change.
Next, calculate estimated tax cash separately from debt service. The tax payment may be due quarterly, at extension, or with a return, so timing matters even when the annual estimate is correct. Use the owner's marginal facts only when they are known and appropriate. Otherwise, show a range and label it for discussion with the CPA.
The after-tax cash flow line should be a transparent bridge: operating cash, less capital spending, less debt service, less estimated tax cash, plus or minus other documented cash items. It is not a guaranteed return. It is not a substitute for a filed tax calculation.
Handle The Exit Conservatively
The sale often creates the largest tax event in the model. Separate the expected sale price from the selling costs, remaining debt, adjusted tax basis, depreciation recapture, and gain allocated to the investor. A refinance is not a sale, but it can create new debt service and may change the cash available to the owner.
Do not bury exit taxes inside an assumed rate. Identify the character of the gain, the depreciation-related component, state taxes, and any partnership or entity-level effects that require review. If a 1031 exchange is part of the plan, model it as a separate path with its own timing, identification, replacement-property, and intermediary requirements. Treat the exchange as a planning option, not as an automatic answer.
Use a realistic sale date and a range of exit values. A property that works only if the sale price, refinance, or tax treatment is perfect needs to be described that way.
Run Sensitivity Checks
Make uncertainty easy to see. At minimum, test rent or revenue, vacancy, operating expenses, interest rates, capital spending, sale price, selling costs, and the timing of the exit. For taxes, test the assumptions that are most material for the owner: usable losses, depreciation method, federal and California rates, and whether a passive activity is disposed of.
Review the effect on annual cash, cumulative cash, debt coverage, taxable income, and cash taxes. If a small change in one assumption reverses the conclusion, call that out. Sensitivity analysis is more useful than selecting one return metric and asking it to carry the entire decision.
Document Assumptions And Review Items
Keep a short assumptions page with the source and date for each material input. Mark estimates, client-provided information, third-party reports, and items awaiting tax or legal review. Preserve the original purchase documents, loan term sheet, depreciation schedules, prior returns, and entity agreement with the model's workpapers.
Before relying on the result, reconcile the model to the books and the tax return where possible. Confirm who owns each assumption and who will update it. A model you can refresh after a lease change, rate change, or tax-law update is more useful than a one-time presentation.
A Practical Review Sequence
Use this sequence for a new acquisition or an existing property:
- Confirm the taxpayer, entity, ownership, and state filing facts.
- Build the operating forecast without tax benefits.
- Add basis, depreciation, financing, and loss limitations.
- Calculate estimated federal and California cash taxes separately.
- Add the exit schedule and any exchange or refinance scenario.
- Run sensitivities and list the assumptions that need confirmation.
- Compare the after-tax cash picture with the client's liquidity needs and other investments.
The conclusion should state what the model supports, what it does not establish, and which facts could change the decision. That is the value of disciplined after-tax underwriting: a clear record of the tradeoffs, not a sales pitch.
If you are evaluating a real estate purchase, refinance, or sale, LaviCPA can help review the tax assumptions and organize the questions for your investment and tax team. Bring the deal terms and the latest tax information. Test the numbers against your facts before you act.