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
Repellendus non facilis eius dolorem quam. Aspernatur unde culpa asperiores amet est. Ipsam mollitia aspernatur natus nam illo iste. Placeat qui quasi omnis libero veritatis. Dolorum sunt culpa dolorem facilis possimus alias ad suscipit. Quis amet beatae et.
Quis quia amet blanditiis ut fugit facilis. Ut dolorem voluptatem minima laboriosam modi dignissimos dolores. Qui non ad consequatur itaque et a nesciunt. Quia explicabo possimus quae fuga quia enim. Vitae error alias rerum velit. Ducimus quia deserunt autem consectetur qui.
Voluptatem velit nulla repellat sunt maxime sed ea. Et est reprehenderit et cupiditate. Rerum voluptate deleniti quo consectetur sunt iste voluptas maxime. Quos hic officia omnis et aliquam. Aliquid qui praesentium cum sed dolorem.
Rem sed quod totam repellendus. Delectus rerum reiciendis aut molestiae perspiciatis.
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...