Operating Cash Flow

Introduction and Downloads

This page is intended to provide fellow analysts with instructions and examples on calculating Operating Cash Flow for multi-family rental property. It also mentions the MAX, MIN, SUMIFS, and SUMPRODUCT functions and gives an example of displaying numbers as labels.


Step 1: Open the Excel Example

Step 2: Read the White Paper, referring to the Example as a visual

Step 3: Watch the video

Step 4: Answer the practice problems

Step 5: Recreate the Example in a blank workbook

Step 6: Incorporate these techniques anywhere


Operating Cash Flow - White Paper

Operating Cash Flow - Example

Operating Cash Flow - Practice Answers

Video, presented by William Leach

Future Topics


Cash Flow Report Pages


Using Macros to Set Print Areas


Tranche B Loans


Yield Analysis


Residual Value Analysis