Trending Content - Investment Banking Forum
| +311 | UBS Tech MD hires Son (from no-name college) as an Intern | 53 | 18h |
| +89 | [Official] 2026 IB Analyst Bonus Megathread (with 2025 Consolidated Pay and Perks/Benefits) | 12 | 22h |
| +52 | Is DCM actually underrated ? | 18 | 5h |
| +46 | Are all Tech / TMT groups sweaty? | 31 | 5h |
| +41 | UBS Groups Ranked by Future Outlook | 20 | 4d |
| +40 | JPM M&A is Gone??? Purely Coverage Banking??? | 20 | 5h |
| +37 | Am I behind? 31 Year Old Analyst | 10 | 8h |
| +32 | UVA McIntire vs Cornell Dyson for IB | 19 | 3d |
| +32 | Losing my personality in Banking | 5 | 20h |
| +31 | Incoming IB Analyst: Best Ways to Prepare? | 8 | 20h |
Career Resources
Do you know how the three statements are connected? This is not going to be high level unless you can answer that question.
Yes I do. I am looking for the language where you talk about calculating ratios based on the historical data, take the historic average or median, then project the future numbers for the I/S and B/S (PP&E）etc. Any input is highly appreciated
3-Statement Model (Originally Posted: 09/13/2012)
I ran a search and didn't come up with anything conclusive. Does anybody have a working 3 statement model they could send me or a link to a website that has a free one (something similiar to macabus)?
Also, while I'm asking, anybody have any suggestions on creating a model from scratch?
Look for a company that does not have debt and/or a lot of non-recurrings when you are starting out. PM me for a model that is "easy" to follow.
Agree with VTech. Go for EBITDA based consumer/industrial companies that do not have multiple divisions. No debt is good, also try to find ones without hedging operations or pension plans. Basically the "widget company" from accounting textbooks. I would start with a small-cap consumer or tech stock.
I don't have any I can send, sorry to say. When building the model, stay organized. It helps if you color-code your cells to indicate whether they are hard-coded, linked, or formulas. I prefer using multiple tabs, but you could potentially put it all on one sheet. It might be easier that way.
Hi VTech - I'd really appreciate if you could pls fwd me a copy of the 3 statement model. Many thanks!
Check PM
any way I could get a copy as well? I'd be happy to reciprocate somehow. Thanks in advance.
captainkoolaid, would you please send me a copy of the template as well. thanks in advance
Hi Captainkoolaid - I'd really appreciate if you could pls fwd me a copy of the 3 statement model. Many thanks!
captainkoolaid/anyone else can I possibly get it as well? Will SB.
vtech243, any chance you can PM me a model? Unfortunately, I'm new to forum and subsequently, it appears I don't have the requisite number of "banana" points to send you a message.
Thanks!
Hi sammo1215 - I'd really appreciate if you could pls fwd me a copy of the 3 statement model. Many thanks!
Re: 3-statement modeling (Originally Posted: 03/02/2014)
Hey,
For historical cash-flow statement, should much of these numbers (except for sums) be hard-coded? If I try to calculate the change in A/R or other balance sheet accounts using the difference, it does not match what was reported on the 10-k. Sorry if this is a rudimentary question. I was thinking to hard-code the historical statements, but then make the projected statements link, is that correct?
Regards
It's not uncommon that things don't match exactly (however the deviations should not be dramatic, maybe check again). What you propose is quite common, usually you should be able to reconcile the last financial year but it's also acceptable to do as you suggested and only link the projected accounts. In that case it of course helps if you can at least point to where accounts don't match so you'll have to check all the small print in the notes...
Often the historicals are just too time-consuming to reconcile, they're full of hidden adjustments. For the sake of sanity, I recommend hard-coding the historical years, and focusing your CF calculations on the future years.
3 Statement Model (Originally Posted: 03/12/2014)
Can someone please help me on balancing the three statements? I will PM you over my model. I cant get the CF statement to tie to balance sheet cash. I was given balance sheet and income statement, and I made Cf statement but cant get the ending cash to tie. You will see a check at the bottom of the Cf statement.
Please let me know if you could help. Thanks!
Most common errors generally involve PP&E (confusing gross vs. net, not factoring in capex, etc.) or stock based compensation. Feel free to send it over if you want me to take a look.
If duffmt6 hasn't solved your issue yet (I'm guessing he has, if you sent it to him), I am happy to take a look as well
Help with basic 3-statement model (Originally Posted: 06/12/2014)
Working through a basic three-statement exercise but can't get my balance sheet to balance. Does anyone have a few mins to review and discuss offline? I can send the full description as needed. Thanks.
Dolorum eligendi unde et a. Omnis voluptatem ipsa sunt culpa. Et minus alias saepe tempora repellendus inventore. Quia voluptas dolore tempora quod saepe ex itaque. Corporis molestias et sunt molestias blanditiis illum ut. Et in omnis sint ad beatae omnis magni.
Rerum quaerat veritatis eos aut. Aperiam perferendis repellendus magni quae iste. Consequatur exercitationem aspernatur autem unde vel occaecati voluptates. Ipsum aliquid et aut maiores corrupti eos. Cupiditate ipsum qui excepturi magnam quisquam et atque. Architecto sit non sint magni ut iusto. Minus dignissimos minus saepe.
Omnis nemo occaecati vero. Quidem quos aut et earum sint nemo. Excepturi aperiam officiis rem dolorem quidem.
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...
Sequi quia dolores cupiditate ipsam accusamus optio et. Tempora nesciunt sint expedita nihil voluptas delectus.
Voluptate dicta quo reprehenderit error. Facere natus vel voluptas consequatur quo accusamus unde nobis. Nihil minus voluptatem sint eveniet quos quia.
Unde maxime quo debitis amet. Rerum exercitationem quisquam saepe autem libero et ut. Dolore veritatis explicabo doloremque eveniet quae voluptatem. Possimus numquam perferendis labore at. Est molestiae quidem et sed asperiores atque qui expedita. Totam sint pariatur et distinctio.