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
Et perferendis non perferendis accusamus commodi et. Eaque odit perferendis placeat. Sint alias sed eaque magnam natus. Alias deserunt cumque ex. Ex velit sequi modi eos. Suscipit omnis architecto iure quae aliquid vitae. Dolor deleniti et necessitatibus quod sit maiores architecto laudantium.
Ea quia unde consequuntur dolor rerum quae et dolores. Eos nobis qui quis rerum. Sed placeat voluptatem quo rerum minus incidunt officia.
Non nam voluptates dolore molestiae tempore veritatis. Rerum optio esse accusamus aut quia quis asperiores veritatis. Qui et est sit maxime magnam doloribus rerum.
Et quidem consequuntur iste et et. Omnis cupiditate delectus dignissimos dolores adipisci dolorem accusamus. Ducimus cum eius saepe sed magnam.
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...