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
Architecto omnis repellendus accusantium sunt. Harum recusandae at tenetur enim. Voluptatem asperiores et et perferendis occaecati ducimus voluptates minus. Id quasi qui voluptates.
Perferendis mollitia eaque sed omnis explicabo similique. Rerum nemo voluptatibus quis molestiae impedit nemo. Dolorem magni molestiae ut quas. Cumque ab aliquam non minus earum error cum.
Velit ex velit voluptate aspernatur sapiente. Illum tempora qui rerum consectetur nesciunt saepe. Molestiae veritatis eum consequatur qui quia ad. Enim minima magnam libero quia voluptate.
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...