3-Statement Model Forecasting
Hi,
I am learning the 3-Statement Model by myself and I have some difficulty making projections for some line items such as "marketable securities," "share-based compensation expense," and "common stock." I was wondering if someone who had already done some 3-Statement Models on big companies like Apple, Walmart, etc. could send some Excel files of them so I could use these spreadsheets as reference.
Thanks in advance
Just keep them flat
.
I think often it will have a line for cash and marketable securities (which are cash like I believe).
Yes commercial paper can go in debt, since it is debt. You could separate it out or not.
.
Cash and Marketable Securities are generally interchangeable. Marketable Securities are really just short-term assets like money market funds where corporates will put the excess cash they don't need immediately so that it isn't earning 0% interest. You could hold Marketable Securities flat or (probably better), just create a single line item "Cash and Marketable Securities".
Stock-based Compensation is a bit trickier as it is a component as it is a strategic decision by the company whether to pay employees in cash or shares. Overall you'll have a driver for your total salaries and a split between cash and share-based.
Common Stock should be impacted by and share buybacks you're modelling or equity issuances, but also (to the point above) stock-based compensation. Recall that because Stock-Based Compensation is an expense on your income statement, it reduces your net income. To make the balance sheet balance, you need to increase paid-upp capital (/ common stock)
.
For the purposes of your modelling, I'd just consolidate the two line items and think of marketable securities like cash. Entries on the Cash Flow Statement reflect purchases or sales of marketable securities (which reduce (increase) cash, which is one current asset, and increase (reduce) marketable securities, another current asset). If we combine the line items, the net result is zero, so you don't need any future entries in your cash flow statement
Qui beatae consequuntur commodi quod quis. Impedit iste neque enim ea enim cum aliquid. Omnis et molestiae blanditiis est occaecati odio provident. Ad esse reiciendis nemo velit.
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...