Forecasting After-Tax Cash Flow in Real Estate Analysis (Updated May 2022) (2024)

When modeling real estate investments, industry practice is generally to stop at before-tax cash flow. And this makes sense in most instances. No two owners of real estate have the exact same tax situation and no two properties necessarily have the exact same tax treatment. So comparing the projected returns of two properties on an after-tax basis isn’t comparing apples-to-apples.

On top of that, government tax policy is ever-changing, making forecasting tax liability into the future a difficult and somewhat unreliable task. This is exacerbated by the fact that real estate professionals are generally not tax professionals, and thus are not suited to the ever-changing tax nuances that go into after-tax analysis.

However, there are situations where forecasting cash flow on an after-tax basis makes sense. And in those cases, it’s helpful for the real estate professional to perform a quick after-tax analysis to sift through opportunities, before consulting with a tax professional.

In this post, I first discuss why most real estate analysis is performed on a before-tax basis. I then share a few cases where modeling taxes is worthwhile (with the support of tax professionals of course). I finish the post by sharing a very basic After-Tax Analysis Module.

This blog post comes in response to a question raised in the Accelerator forums. Are you an Accelerator member? Check out that forum discussion here. Not yet an Accelerator member? Consider joining the real estate financial modeling training program used by top real estate companies and elite universities to train the next generation of CRE professionals.

Forecasting After-Tax Cash Flow in Real Estate Analysis (Updated May 2022) (1)

Real estate investment professionals analyze real estate cash flows on a before-tax basis.

Before-Tax Analysis – The Real Estate Industry Norm

As real estate investment professionals, we perform analysis on a before-tax basis. This is the industry norm. It’s how real estate analysis is taught in schools, and it’s how real estate investment teams operate in practice.

In fact, looking back on my two decades in residential and commercial real estate. Having underwritten tens of billions of dollars in real estate at both boutique and institutional real estate firms. I can count on one hand the number of deals that we spent significant time thinking about the after-tax consequences of a real estate investment.

There are a variety of reasons for this.

Important Note: Adventures in CRE and its affiliates do not provide tax, legal or accounting advice. This material has been prepared for informational purposes only, and is not intended to provide, and should not be relied on for, tax, legal or accounting advice. You should consult your own tax, legal and accounting advisors before engaging in any real estate transaction.

1. After-tax cash flow modeling distorts the comparison element of real estate analysis.

Real estate analysis is ultimately the practice of comparing one investment against its alternatives. Because no two taxpayers, no two tax years, and quite frankly no two investments have the same tax treatment, performing analysis on an after-tax basis distorts the comparison.

2. Tax law varies from year-to-year and jurisdiction-to-jurisdiction and is regularly changing.

If you live in the United States for instance, the after-tax cash flow of an investment you analyze today will vary greatly depending on who wins the presidential election every four years. This is even more pronounced in other countries, where tax laws change every couple of years.

Likewise, tax law varies from one jurisdiction to the next and depending on the politicians in power in those jurisdictions. Thus, attempting to accurately forecast 10 years of future after-tax cash flow is largely a fool’s errand.

3. Real estate investment professionals are (generally) not accounting and tax professionals.

Every professional has their role. Accounting and tax professionals analyze taxes while real estate investment professionals forecast before-tax cash flow.

In my experience, after-tax cash flow is handled by the accounting team and isn’t a primary driver of the investment decision; if part of the investment decision at all. Furthermore, after-tax analysis most often comes much later in the underwriting process, after a deal has been selected and only to understand how that property fits into the larger tax strategy of the real estate firm.

4. No two taxpayers nor two tax years are the same.

In the United States (and in many other countries), real estate is often held in a pass-through entity (i.e. meaning the cash flow passes through pre-tax to the partners). As a result, the tax due as it relates to a given real estate investment ultimately depends on the profile of the taxpayer to whom that real estate income passes.

Most real estate investments involve multiple partners/investors, each with differing tax profiles. How is a real estate investment professional analyzing the deal supposed to know what the tax profile is of each of its partners/investors for the upcoming year, let alone for each of the next 10 years!

Imagine that one of the partners/investors in a real estate investment is a Doctor, with his/her practice plus a variety of other investments. The income tax due, as it relates to a real estate investment, will depend on where the property is located, where the Doctor lives, how the Doctor’s practice performed in a given year, and how the Doctor’s other investments performed in a given year. And that doesn’t even consider other deductions the Doctor may have, tax loss carryforward the Doctor may have, etc. In short, it’s a near-impossible task to forecast.

Forecasting After-Tax Cash Flow in Real Estate Analysis (Updated May 2022) (2)

No two taxpayers, nor two tax years, are the same.

When You Might Want to Analyze After-Tax Cash Flow in Real Estate

Now with that said, it doesn’t mean that after-tax analysis in real estate isn’t important. If you’re a mom-and-pop investor looking to minimum your tax liability through a real estate investment, obviously after-tax analysis matters. Or if the real estate strategy you’re pursuing relies on a unique element of the tax code (e.g. opportunity zone investments).

So when does it make sense to model taxes? Here are a few situations I can think of when an after-tax analysis is beneficial (and important) to the early phase of analysis.

Comparing a Real Estate Investment to a Tax-Free Investment

A municipal bond is a debt instrumentoriginated by a state or local government for financing public projects. These bonds are generally exempt from federal as well as state and local taxes, and as a result investors demand a lower yield relative to bonds that aren’t tax-exempt.

An investor may be considering purchasing a relatively low risk real estate investment (e.g. absolute NNN credit deal) and wants to compare that investment to a potential muni-bond investment. To attempt to get a fair comparison, the investor would need to model the real estate returns after tax.

Comparing Two Properties with Distinct Depreciation Profiles

Perhaps you want to compare a retail investment, with its 39 year recoverable life to an apartment investment with its 27.5 year recoverable life. Or perhaps you have an investment with heavy capital expenditure requirements and you want tocompare its after tax returns to another property with less CapEx.

Sometimes the final decision between two great investments comes down to the tax benefits of one investment over the other.

Analyzing a Zero Cash Flow Property

Some real estate investments are sold as zero cash flow investments. These properties are generally single-tenant, NNN properties leased to an investment grade tenant. The loan is sized/crafted such that the debt service payments equal the lease payments, and the loan term and amortization match the lease term.

Much of the benefit of owning this type of property comes in the losses, due to depreciation, over the hold period that offset gains on other investments in an investor’s portfolio. Modeling the taxable losses is essential to understanding the yield of such an investment.

Assessing Opportunity Zone and other Tax-Advantaged Investments

Occasionally, governments will incentivize investment through special programs. One example is the opportunity zone tax incentive that was created under the Tax Cuts and Jobs Act of 2017 in the United States. This program allows for large tax deferrals when investments are located with an opportunity zone and meet certain criteria.

Other examples include duty-free or tax-free zones, a common feature found in ports, economic development regions, and even in airports around the world. Assessing the viability and benefits of an investment in a tax-advantaged area can only be done through after-tax analysis.

After Tax Cash Flow Analysis Module

As a companion to this post, I built a quick and dirty module to show you how I learned to model after-tax cash flows. I am not an accountant and I generally don’t model after tax cash flows professionally, so don’t immediately rely on this model for your next investment.

But I think this is a good start and provides some context to the discussion around modeling after-tax cash flows in real estate. I’ve recorded a video that walks you through how to use the model and as always, feel free to reach out if you have any questions, comments, or suggestions.

After Tax Cash Flow Analysis module

  • Excel workbook that models after tax cash flows
  • Analysis on both an unlevered and levered basis
  • Use to calculate potential benefit of 1031 exchange

Compatibility

This version of the module is only compatible with Excel 2013, Excel 2016, and Excel 365.

Download the After Tax Cash Flow Analysis module

To make this module accessible to everyone, it is offered on a “Pay What You’re Able” basis with no minimum (enter $0 if you’d like) or maximum (your support helps keep the content coming – typical modules sell for $100 – $250+ per license). Just enter a price together with an email address to send the download link to, and then click ‘Continue’. If you have any questions about our “Pay What You’re Able” program or why we offer our models on this basis, please reach out to either MikeorSpencer.

We regularly update the file (see version notes). Paid contributors to the module receive a new download link via email each time the module is updated.

Proceed to Download Page

Version Notes

v1.0

  • Initial release

About the Author: Born and raised in the Northwest United States, Spencer Burton has over 20 years of residential and commercial real estate experience. Over his career, he has underwritten $30+ billion of commercial real estate at some of the largest institutional real estate firms in the world. He is currently President and member of the founding team at Stablewood. Spencer holds a BS in International Affairs from Florida State University and a Masters in Real Estate Finance from Cornell University.

Contact Spencer

I am a seasoned real estate investment professional with over two decades of experience in both residential and commercial real estate. Throughout my career, I have underwritten tens of billions of dollars in real estate transactions at both boutique and institutional real estate firms. My expertise extends to various aspects of real estate analysis, including before-tax cash flow modeling. My depth of knowledge is demonstrated by my understanding of the industry norms, practices, and the challenges faced by professionals in the field.

In the realm of real estate analysis, the industry standard is to focus on before-tax cash flow. This is the method taught in schools and adopted by real estate investment teams in practice. Drawing from my extensive experience, I can attest that the majority of real estate professionals rarely delve into after-tax analysis. The reasons for this are multifaceted:

  1. Distorted Comparison Element: After-tax cash flow modeling distorts the comparison element of real estate analysis. Due to the unique tax situations of individual investors, variations in tax years, and different tax treatments for each property, performing analysis on an after-tax basis complicates the comparison process.

  2. Changing Tax Laws: Tax laws are subject to change, both over time and across jurisdictions. Forecasting future after-tax cash flow becomes challenging and unreliable due to the dynamic nature of tax policies.

  3. Specialization of Roles: Real estate investment professionals typically specialize in forecasting before-tax cash flow, while accounting and tax professionals handle after-tax considerations. After-tax analysis is often secondary and comes into play later in the decision-making process.

  4. Diverse Taxpayer Profiles: Real estate investments often involve multiple partners with varying tax profiles. Predicting the tax implications for each partner over the next 10 years is a daunting task, considering factors such as location, professional income, other investments, and various deductions.

Despite these challenges, there are situations where after-tax analysis becomes crucial:

  • Comparing to Tax-Free Investments: When comparing a real estate investment to a tax-free investment, such as municipal bonds, modeling after-tax returns is necessary for a fair comparison.

  • Distinct Depreciation Profiles: Comparing properties with different depreciation profiles, such as retail versus apartment investments, may require after-tax analysis to make an informed decision.

  • Zero Cash Flow Properties: Investments like zero cash flow properties, where the benefit lies in taxable losses due to depreciation, necessitate modeling taxable losses for a comprehensive understanding of yield.

  • Tax-Advantaged Investments: Assessing opportunities in tax-advantaged areas, like opportunity zones, demands after-tax analysis to evaluate benefits under specific tax incentives.

In response to the complexities of after-tax analysis, I have developed an After-Tax Analysis Module. While I am not an accountant, this module provides a starting point for modeling after-tax cash flows in real estate. A video tutorial accompanies the module, offering guidance on its usage. The module covers both unlevered and levered analysis, allowing users to calculate the potential benefits of strategies such as the 1031 exchange.

For those interested in exploring the module, it is available on a "Pay What You're Able" basis, making it accessible to all. Your support helps in maintaining and improving the content.

Feel free to reach out with any questions, comments, or suggestions. Download the After Tax Cash Flow Analysis module [here](module download link).

Forecasting After-Tax Cash Flow in Real Estate Analysis (Updated May 2022) (2024)
Top Articles
Latest Posts
Article information

Author: Rev. Leonie Wyman

Last Updated:

Views: 6365

Rating: 4.9 / 5 (79 voted)

Reviews: 86% of readers found this page helpful

Author information

Name: Rev. Leonie Wyman

Birthday: 1993-07-01

Address: Suite 763 6272 Lang Bypass, New Xochitlport, VT 72704-3308

Phone: +22014484519944

Job: Banking Officer

Hobby: Sailing, Gaming, Basketball, Calligraphy, Mycology, Astronomy, Juggling

Introduction: My name is Rev. Leonie Wyman, I am a colorful, tasty, splendid, fair, witty, gorgeous, splendid person who loves writing and wants to share my knowledge and understanding with you.