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