Lesson 5
Excel Exercise - Modeling the Cash Flow Statement
The Cash Flow statement is the final piece that ties our model together. We need it to project the Cash, Debt and Equity balances previously skipped.
Modeling the cash-flow statement is slightly different from the Balance Sheet and P&L. Specifically, one doesn’t usually start with a historical cash-flow statement, then project each line-item going forward. Rather we use the Cash Flow Statement to reconcile cash changes in the other two statements.
Instructions
Download Exercise 5 and PDF Guide to Cash Flow Modeling
See below for download links
Complete Exercise 5
Apply the concepts covered in Part IV to model the Cash Flow Statement, including Debt & Cash schedules.
Optional Step-by-Step Excel Demonstration (Video)
If you require additional assistance with the Excel Exercise, please go to Lesson 4.5.5 for a Step-by-Step Excel Demonstration Video (See bottom of page for link)
Optional Guide to Refining the Model
The interested analyst is encouraged to “refine his or her model” incorporating management guidance from the annual report, investor presentation and conference call (See bottom of page for download link)
Exercise 5
Fill in the red cells and blue cells as indicated in the model exercise and refer back to the video lecture & presentation as needed. You will get green checks once you’ve calculated/input the right data. You can also un-hide a solutions sheet within the file to check your answers.
Time Commitment: 45 Minutes
Refining the Model (Bonus Material)
The interested analyst is encouraged to “refine his model” incorporating management guidance from the annual report, investor presentation and conference call.
© 2026 REIT Modeling. All rights reserved.