About this lesson
A continuation on how the Financial Statements are linked.
Download this lesson’s related exercise files.Linking the Financial Statements Part 2.xlsm
81.1 KB Linking the Financial Statements Part 2 - Solution.xlsm
Linking the Financial Statements Part 2
Discover how to link the Financial Statements
When to use
When constructing a basic Financial Model
- This section will look at linking the Cash balance from the Opening Balance Sheet and the Cash Flow Statement into the Balance Sheet:
- The formula to link the Cash into the Balance Sheet is:
=IF(J$9=1,'Opening Balance Sheet'!$I$14,I14)+'Cash Flow Statement'!J37
Lesson notes are only available for subscribers.