Calculating After-Tax Cash Flows for Investment Projects

1. The Anatomy of an After-Tax Cash Flow Calculation

To build an after-tax cash flow statement, we need to be precise with our terminology. Some figures are actual cash movements, while others are accounting constructs used to calculate taxes. Your experience with business P&L statements will be helpful here, as we are essentially formalizing that process for project evaluation.

Let's begin by defining the key components.

Let's summarize the key relationships from the resource:

• Cash Flow Before Taxes (CFBT): This represents the actual cash generated by a project's operations before considering taxes. $$\text{CFBT}=\text{Gross Income (GI)}-\text{Operating Expenses (E)}$$
• Taxable Income (TI): This is the accounting figure used to calculate tax liability. It is not a cash flow. It's the CFBT adjusted for the non-cash depreciation deduction. $$\text{TI}=\text{GI}-\text{E}-\text{Depreciation (D)}=\text{CFBT}-\text{D}$$
• Taxes: This is the actual cash outflow paid to the government. $$\text{Taxes}=\text{TI}\times \text{tax rate (t)}$$
• Cash Flow After Taxes (CFAT or ATCF): This is the bottom line—the net cash flow remaining after taxes have been paid. This is the figure that truly matters for project evaluation. $$\text{CFAT}=\text{CFBT}-\text{Taxes}$$

2. The Tabular Method: A Step-by-Step Guide

The most straightforward way to calculate the ATCF for a project is to build a table, tracking each component year by year. This is exactly how you would model a project in a spreadsheet. The process follows the definitions we just established.

For each year of the project's life, you would set up columns for:

1. Gross Income (GI)
2. Operating Expenses (E)
3. Depreciation (D)
4. Taxable Income (TI = GI - E - D)
5. Taxes (Taxes = TI × t)
6. Cash Flow After Taxes (CFAT = (GI - E) - Taxes)

The image below shows a professional example of this structure in an Excel model. While it includes more complex details like recapture tax and capital gains (which we'll touch on later), the fundamental structure of columns for revenue, expenses, depreciation, taxable income, and taxes is the same.

3. Worked Example: A New Facility Project

Let's apply this tabular method to a concrete example. This exercise will walk us through calculating the ATCF stream for a new capital project from start to finish.

Let's break down the calculations from that example step-by-step.

Project Data:

• Initial Cost (P): $550,000
• Salvage Value (S): $150,000
• Recovery Period (n): 5 years
• Depreciation Method: Straight-Line
• Annual Gross Income (GI): $200,000
• Annual Operating Expenses (E): $90,000
• Tax Rate (t): 35%

Step 1: Calculate Annual Depreciation
Using the straight-line formula:

Step 2: Construct the ATCF Table

• Year 0: The only cash flow is the initial investment (a cash outflow).
• Years 1-4: The ATCF is calculated as GI - E - Taxes. So, $200k - $90k - $10.5k = $99.5k.
• Year 5: The ATCF includes the operating cash flow plus the cash inflow from the salvage value. $200k - $90k - $10.5k + $150k = $249.5k.

The final ATCF stream for this project is: {-$550k, $99.5k, $99.5k, $99.5k, $99.5k, $249.5k}. This is the data we'll use for evaluation.

4. An Alternative View: The "Add-Back" Method

Another common way to calculate ATCF, especially in finance and business management, is the "add-back" method. This method starts with the net profit and adds back the non-cash depreciation charge.

This is the approach outlined in the MIT Project Management resource (LINK).

1. Calculate Net Profit After Taxes (NPAT), also known as Net Income. $$\text{NPAT}=\text{Taxable Income}\times (1-t)$$
2. Add back the depreciation amount to get the ATCF. $$\text{ATCF}=\text{NPAT}+\text{Depreciation}$$

Let's check this for Year 1 of our example:

• NPAT = $30,000 × (1 - 0.35) = $30,000 × 0.65 = $19,500
• ATCF = $19,500 (NPAT) + $80,000 (D) = $99,500

This gives the exact same result. It's just a different way of arranging the same calculation, but it usefully separates the after-tax profit from the cash-flow effect of the non-cash depreciation charge.

Conclusion

Today we've assembled all the pieces of an after-tax analysis into a cohesive whole. By methodically stepping through each year of a project's life, we can construct the full after-tax cash flow stream, which is the most accurate representation of a project's financial impact.

• Key Takeaways:
  • The calculation of After-Tax Cash Flow (ATCF) requires carefully distinguishing between actual cash flows (like revenue and operating expenses) and non-cash accounting items (like depreciation).
  • The tabular method provides a clear, structured way to calculate the ATCF stream for a project's entire life: ATCF = (Gross Income - Expenses) - (Taxable Income × tax rate).
  • An equivalent "add-back" method calculates ATCF as (Net Profit After Tax) + Depreciation.
  • The final ATCF stream must account for the initial investment, operating years, and any terminal cash flows like salvage value.

Preview of the Next Lesson

We have successfully generated the complete ATCF stream for an investment project: {-$550k, $99.5k, $99.5k, $99.5k, $99.5k, $249.5k}. But what does this stream of numbers mean? Is this a good investment? In our next lesson, we will finally answer that question. We will learn how to evaluate projects on an after-tax basis using Net Present Worth analysis, bringing these future cash flows back to today's value to make a definitive decision.