Anyone have pro forma income statements/balance sheets created from FS's off yahoo or google finance?
(I know in banking you wouldn't use yahoo/google finance, but this is for an academic model).
Thanks guys,
| +159 | Gifting Bonus to Parents? | 13 | 1d | |
| +114 | Dartmouth Partners Sucks. | 30 | 33m | |
| +94 | BofA Spiraling? | 43 | 13m | |
| +52 | Summer opportunities/suggestions for rising 12th grader | 22 | 3h | |
| +50 | Tips I Wish Someone Gave Me When I was Starting My Analyst Stint | 4 | 4d | |
| +42 | UBS 2024 Groups for Purely Exits | 29 | 1s | |
| +40 | Can anyone provide some insight into Canadian Target Schools | 29 | 3h | |
| +39 | Risks of lateral as a third year analyst | 8 | 1d | |
| +37 | Last minute college decisions (HC IB -> Life Sciences Buyside) | 8 | 8h | |
| +33 | Hearing Santander Doesn’t Care about Finra Licenses Anymore… | 14 | 18h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
better yet, where do all of you get your financials for academic projects?
Use sec.gov (http://sec.gov/edgar/searchedgar/companysearch.html). Type in company name/ticker. Search for 10-K or 10-Q, which are the annual or quarterly filings, and they will have their financials in there for the reported period.
Okay, great, so If I recall, for pro formas IS, the line items should be
Revenues (COGS) Gross Profit Gross Profit Margin (SG&A) D&A Operating Income Operating Margin Nonoperating income Nonoperating expenses Income Before Taxes Income Taxes NI
Thanks!
REVENUES
OPERATING EXPENSES:
Salaries and employee benefits Purchased transportation Rentals and landing fees Depreciation and amortization Fuel Maintenance and repairs Impairment and other charges Other
OPERATING INCOME
OTHER INCOME (EXPENSE):
Interest expense Interest income
Other, net
INCOME BEFORE INCOME TAXES
PROVISION FOR INCOME TAXES
NET INCOME
You should be using public filings.
SEC.gov
so i am supposed to reorganize them in the above mentioned manner?
No, organize them in the manner that makes most sense. If a company/industry is reporting it in a certain format, it most likely is for a specific reason. You can consolidate certain items so its not as granular but generally speaking... stick to the format prescribed by the company in their filings with minimal and only as necessary consolidation and adjustments.
Think about it this way, if you consolidate as described above and come back to the same model 6 months later... are you going to remember how and why you rolled which things into whatever line items? Probably not. Especially since there are multiple 'right' ways to do it.... and commenting in every cell to describe the roll-up/adjustments is not one of them.
got it, so just make every one of the line items in the reported FS a percentage of sales, and work from there?
(with the exception of tax, Operating Income/Ebit, Net Income, interest, etc)
also, i take out any events that are not lilkely to happen in the future, such as equity impairments?
Est non maxime repellendus ab consequatur et voluptatem. Et rerum exercitationem laboriosam corrupti recusandae nihil qui a. Sint at assumenda corporis magni earum culpa.
Dolore quod voluptate voluptatem saepe necessitatibus. Dicta ut sequi quae qui aperiam delectus et. Sapiente deleniti sit ut et quisquam delectus eaque. Aperiam est officia assumenda consequatur ad a. Enim dolorem distinctio distinctio sit ut nulla. Rem dolorum vitae sed minus.
Corrupti eveniet animi eligendi quae dolorem. Officia non aspernatur unde eos neque eaque est. Perspiciatis quibusdam ratione veritatis atque explicabo porro. Est dignissimos eos reprehenderit et. Ab ea voluptate eos. Quaerat voluptatem ipsum et aut 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...