preview

Financial Statement Modeling by Wall Street Prep, Inc.

Better Essays

Financial Statement Modeling
Copyright 2008 © by Wall Street Prep, Inc. | All rights reserved Inc.

***************************** SAMPLE PAGES FROM TUTORIAL GUIDE *****************************

Table of contents
SECTION 1: PREPARING FOR MODELING Welcome letter Introduction Gathering historical documents/information Understanding projections Modeling techniques in Excel Debt schedule Interest expense SECTION 3: ENHANCEMENTS TO A COMPLETE MODEL Balancing the model and circularity Ratio analysis Form toggles, sensitivity and scenario analysis

SECTION 2: BUILDING A FINANCIAL STATEMENT MODEL Income statement – historicals Income statement – projections Balance sheet – historicals Balance sheet – projections Working capital schedule …show more content…

It is easy to forget that you hid the rows

Rows 5-8 are hidden

If you must hide information, “group” the rows or columns so the hidden information shows up on the margin. Shortcut in Excel to group / ungroup rows: Shift + Alt + Right arrow key / Left arrow key

***************************** SAMPLE PAGES FROM TUTORIAL GUIDE For illustrative Purposes Only *****************************

7
Copyright © 2007 by Wall Street Prep, Inc.

Income statement – historicals
Inserting rows in Excel Highlight row: Shift Spacebar Add row: Shift Ctrl = Insert a dynamic header formula in Excel Using the & sign, you can combine text and formulas, so that whatever you type in the company name input area should automatically change the header. Formatting inputs As in all models, inputs are blue and calculations are black. In addition, inputs are designated by the light yellow background color for easier navigation.

***************************** SAMPLE PAGES FROM TUTORIAL GUIDE For illustrative Purposes Only *****************************

8
Copyright © 2007 by Wall Street Prep, Inc.

Income statement – historicals
Adjust historical IS for nonrecurring items Insert lines below reported COGS, SG&A and Other, Non-operating Income, and Taxes that will reference the nonrecurring items input area to calculate pro forma (normalized) historical results.

Also remember to change EBIT, EBT, and net income calculations to reflect ***************************** pro forma (vs.

Get Access