文档介绍：Eqqyuity Research
For more info contact us at wechat : synergy007
Why learn to model (page 2)
Mod e ling is the int egrati on of skill with busi ness/ acad emi c skill s
to create useable tools to make decisions
To successffllully moddlel you must have a good bblalance of
qualitative and quantitative skills.
4/27/2017
Financial Modeling (page 3)
MdliModeling bas ics
I. Modeling discipline
II. Setting up the mode l
Building a model
I. Revenue and cost segments
II. Working capital and depreciation schedules
III. Income, cash flow and balance sheet
Stressing the model
Valuation
4/27/2017
Things to remember (page 4)
Simp le des ign
Never hardcode
Inpu ts sh ould be in a different co lor
Do not enter formula with hardcoded numbers
Ie. =b3*7
Formatting is important
4/27/2017
Basics of modeling (page 5)
When crea ting a mod el , it is impor tan t to mak e sure the mod el is:
1. Dynamic
2. Flexible
3. Easy to use
4/27/2017
Formatting (page 6)
PE ROE
Price Market Cap Debt/EBITDA LTM 2017 LTM 2017
Company 
Company 1
Company 2
Company 3 35. 69 256. 3655 0. 666 14. 669 17. 8 0. 175 0. 1422
Company 4
Company 5