background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for February 2025 for September 2024
:
Private EquityReal Estate InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for February 2025 is Open
Wall Street Prep

Join 750k+ learners today. Learn online from Wall Street Prep — the training firm that prepares new hires at the world's top financial institutions.

Enroll Today

Before-Tax Cash Flow (BTCF)

  Table of Contents

How to Calculate Before-Tax Cash Flow

The before-tax cash flow (BTCF) is a real estate metric that measures the remaining pre-tax profit of a rental property, right after meeting its annual debt service.

Therefore, the before-tax cash flow – or “pre-tax cash flow” – is a levered cash flow metric, since the debt costs, such as mortgage payments, are accounted for.

The before-tax cash flow (BTCF) of a property can be determined by subtracting its annual debt service (ADS), such as mortgage payments, from its stabilized net operating income (NOI).

The process of calculating the before-tax cash flow for a given property investment is a four-step process:

  1. Determine Potential Gross Income (PGI) → The potential gross income (PGI) is the maximum income that could be earned on the rental property, assuming an occupancy rate of 100%, i.e. no vacant units.
  2. Forecast Effective Gross Income (EGI) → From the potential gross income (PGI), subtract vacancy and credit losses, which stem from vacancies (i.e. unoccupied units) and credit losses (i.e. collection issues on rental payments from tenants). The assumptions used must be derived from analyzing market comparables and industry insights relevant to the given property investment.
  3. Calculate Net Operating Income (NOI) → The net operating income (NOI) is calculated by subtracting direct property expenses from the effective gross income (EGI). The most common examples of direct operating expenses in real estate include property taxes, property management fees, maintenance costs, and repair fees.
  4. Compute Before-Tax Cash Flow (BTCF) → By subtracting the annual debt service from net operating income (NOI), we’re left with the property’s before-tax cash flow. The distinction between NOI and BTCF is that the former is an unlevered metric (“capital structure neutral”), while the latter is a levered metric (“post-financing”).
dl

Real Estate Interview Guide | File Download Form

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Submitting...
Property Taxes in Real Estate

While the before-tax income (BTCF) is above the income tax liability on a real estate pro forma model (and thus, not yet taxed), property taxes are subtracted from BTCF because those costs represent operating items in the real estate sector.

Before-Tax Cash Flow Formula (BTCF)

The formula to calculate the before-tax cash flow (BTCF) is the difference between the net operating income (NOI) of a property and the annual debt service.

Before-Tax Cash Flow (BTCF) = Net Operating Income (NOI)  Annual Debt Service (ADS)

Where:

  • Net Operating Income (NOI) = Effective Gross Income (EGI) – Direct Property Expenses
  • Annual Debt Service (ADS) = Principal + Interest

In practice, one of the main use cases of the BTCF metric is to serve as the cash flow metric to calculate the cash on cash return.

The cash on cash return, or “cash yield”, is calculated as the ratio between the before-tax cash flow and initial equity contribution.

Cash on Cash Return (%) = Annual Before-Tax Cash Flow ÷ Equity Contribution

The cash on cash return is thus the yield earned on the original cash contribution paid by the real estate investor, i.e. the down payment.

The Wharton Online
and Wall Street Prep Real Estate Investing & Analysis Certificate Program

Level up your real estate investing career. Enrollment is open for the Feb. 10 - Apr. 6 Wharton Certificate Program cohort.

Enroll Today

Before-Tax Cash Flow Calculator

We’ll now move to a modeling exercise, which you can access by filling out the form below.

dl

Get the Excel Template!

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Submitting...

Before-Tax Cash Flow Calculation Example (BTCF)

Suppose we’re tasked with calculating the before-tax cash flow (BTCF) of a commercial property in 2024.

Year 1 Pro Forma (2024E)

  • Potential Gross Income (PGI) = $5 million
  • Vacancy Loss (6.0% of PGI) = $300k
  • Credit Loss (4.0% of PGI) = $200k
  • Ancillary Income = $500k

Therefore, the effective gross income (EGI) of the property in 2024 is expected to be $4.5 million.

  • Effective Gross Income (EGI) = $5 million – $300k – $200k + $500k = $4.5 million

From the effective gross income (EGI), we’ll subtract operating expenses, which we’ll assume to be 50% of EGI, resulting in a net operating income (NOI) of $2.25 million.

  • Net Operating Income (NOI) = $2.25 million = $1.25 million = $1 million

The before-tax cash flow (BTCF) can be determined by deducting the annual debt service (ADS), which we’ll assume to be $1.25 million, from the stabilized NOI.

Given the net operating income (NOI) at stabilization and annual debt service (ADS), the difference is $1 million, which represents the property’s before-tax cash flow (BTCF).

  • Before-Tax Cash Flow (BTCF) = $2.25 million – $1.25 million = $1 million

In conclusion, we’ll wrap up our quick exercise in Excel by estimating the cash-on-cash return on the real estate investor’s equity investment.

If we assume that the initial equity contribution was $12.5 million, the implied cash-on-cash return is 8.0%.

  • Cash on Cash Return (%) = $1 million ÷ $12.5 million = 8.0%

Before-Tax Cash Flow Calculator (BTCF)


The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.