3 Statement Model Query - Need Some Expert Advice
Hi all,
I am seeking some advice from some more experienced chimps while I practice building 3-statement models in preparation for modeling tests during the interview process.
After successfully building out all 3 statements' historicals (with correct balance in historical years) I've arrived at a query regarding the linking between the balance sheet and the cash flow and subsequently achieving the balance of the balance sheet in the first projected year.
After ensuring all changes in balance sheet line items are accounted for in the cash flow statement, I've found that 2 line items in my cash flow statement (which was downloaded from Factset) aren't linked to any line items in the balance sheet.
Balance Sheet For Reference:
Assets:
- Cash & Short-Term Investments
- Accounts Receivables
- Inventories
- Other Current Assets
- Net PP&E, Intagibles
- Deferred Tax Assets
Liabilities + Equity:
- Total Debt
- Accounts Payable
- Income Tax Payable
- Deferred Tax Liabilities
- Other Liabilities
The following items that do not have a clear direct link to the balance sheet are as follows:
Operation Activities:
Other funds: 27.1
Investing Activities:
Acquisitions & Other: (19.5)
As a result, the balance sheet is unbalanced by 7.6, as these cash flow line items aren't accounted for in the balance sheet. ////// 7.6 = 27.1 + (19.5)
In summary, how should one account for these cash flow line items in the balance sheet in order to achieve balance? Should they be incorporated into "Common Equity" as a catch-all adjustment?
P.S. Keep in mind - the context of this exercise is in a time-pressure test situation
Thanks for your help,
- Aspiring Chimp
Would need to take a proper look at the model / file to understand the Q but generally, you don't have to model and link historical statements together. Just start modeling & linking from first projection year. This way you avoid the need to project / model one-off line items appearing in historicals. For example, if in FY-1 theres a line item in CFS on acquisitions, you can assume this does not occur in the future (i.e. don't include it going fwd). Same for Other Funds line. Don't model historicals, that's key.
Are you holding these 2 items constant in your first projected year? For modeling test purposes these one-off line items are typically held constant going forward in my experience. Edit: thought these were b/s items, if CFS items would just zero out i think.
Include it in shareholders equity like you said, as a catch all adjustment
Sit autem aspernatur qui et ad earum ut numquam. Sit vel animi animi non doloremque est vero. Dolorem quo dolorem deserunt impedit distinctio.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...