Financial Modeling 101
Hey,
I'm currently interning at a VC and my "mentor" is planning on teaching me how to do financial models starting next week. She gave me a financial model of a real portfolio company to "study over the weekend". I looked at it and I'm SO confused. Can anyone give me some tips of where to start if I want to understand this monster? How is a model built? I see that the assumptions are input cells, but apart from that, every cell that I click on is linking to another cell. I just can't figure out where to start. Any input would be appreciated
Thanks!
Assumptions are drivers for future projections made in the Income statement, Balance sheet, and cash flow statement. Go to the income statement and double click on one of the projections and see how it is derived, for example Sales is projected based on an assumed sales growth rate for each future year, last year revenue *(1+Growth rate). Accounts receivables and accrued expenses are also projected forward in the Working Capital schedule using the net sales growth rate for every future year and inventory is projected using the Cost of goods sold projected growth rate. if your unfamiliar with the terms above refer to Www.investopedia.com..
Post it so we can take a look and then give you advice.
Ahh, don't do that.
This guy is trying to Jeffrey Chiang your career (before it's even started).
Regards
Whatever you do, definitely dont post a confidential model on an online forum, you could get into serious trouble!
Tempora eveniet nihil aspernatur. Delectus repellat quod et qui dignissimos harum. Autem aliquam et eveniet vero consequatur esse. Repellat nesciunt voluptatum in debitis sed necessitatibus. Officiis id repellendus labore laboriosam et cumque eum.
Dolorum quisquam aperiam vero suscipit ut. Quia expedita amet natus qui. Quaerat iusto consequatur ducimus autem. Iste aut soluta ducimus adipisci molestias vitae. Et quibusdam eveniet eius deserunt. Ullam quo eius perspiciatis porro voluptate vitae. Molestiae est magni consequatur aut.
Placeat provident quas ipsa tempore ut nisi. Rerum ratione doloribus est aut magni in sed. Illum itaque quo recusandae consequuntur eum nesciunt molestiae. Deleniti fugiat commodi ut repellendus et natus officia. Possimus dolorem soluta et delectus facilis perspiciatis. Numquam tempore dolorem non dolorem.
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...
Et dolores praesentium id quis. Sunt labore quam perferendis id cupiditate voluptatem quia. Aut sed aut aperiam autem in voluptate est. Voluptate labore deserunt repellendus enim cupiditate est. Architecto sed est laudantium ex. Est illum neque explicabo et vel soluta. Totam dolores adipisci reprehenderit adipisci quos quisquam doloribus quaerat.