Course notes
FINANCIAL MODELING
BUSI 584
Mustafa N. Gültekin
August 25, 2014
Agenda
• Overview of Financial Modeling & Preliminaries I
– Introduction to Capital Market Lab Resources
– External Research Tools
– Excel Basics
Wednesday:
– Overview of Financial Modeling with Excel
Next Week:
– September 3, Wednesday: Case Discussion – O.M. Scott & Sons
Company
– See questions posted at the end of class notes
Readings
– Survival Accounting for Financial Modeling (Income Statement, Balance Sheet,
Cash Flow Statements)
– Preparing & Using the Statement of Cash Flows
– Solving the Puzzle of the Cash Flow Statements
– Beware of Accounting Mine Fields
– Financial Statement Analysis
Financial Modeling © Gültekin - 2
CAPITAL MARKETS LAB https://home.kenanflagler.unc.edu/Resources/cml/Pages/default.aspx • Bloomberg
• FactSet
• PerTrack
• Check the calendar for ongoing training sessions…
Financial Modeling © Gültekin - 3
Bloomberg Essentials Online Training
Program
• What is Bloomberg Essentials Online Training
Program?
– Formerly known as Bloomberg University Certification
Program, it is Bloomberg’s online school, teaching the basics of Bloomberg’ system and functionality. This is a self-paced program.
• Where do I take my training?
– At the Bloomberg terminals in the Capital Markets Lab
(CML) on the 2nd (main) floor of the McColl Building at
Kenan-Flagler Business School; the terminals are accessible anytime the CML is open. You cannot remote into the Bloomberg terminal.
Financial Modeling © Gültekin - 4
Bloomberg Training & Certification
• How do I get started?
1. Create a personal username and password
– At the Bloomberg terminal, hit the red CONN/DEFAULT key (upper right on keyboard) or UREG
– Click on Create a New Login” link
– Complete the series of templates.
– Bloomberg will request verification of the validation code that appears on the screen before you can proceed further. – Each time you use Bloomberg
BUSI 584
Mustafa N. Gültekin
August 25, 2014
Agenda
• Overview of Financial Modeling & Preliminaries I
– Introduction to Capital Market Lab Resources
– External Research Tools
– Excel Basics
Wednesday:
– Overview of Financial Modeling with Excel
Next Week:
– September 3, Wednesday: Case Discussion – O.M. Scott & Sons
Company
– See questions posted at the end of class notes
Readings
– Survival Accounting for Financial Modeling (Income Statement, Balance Sheet,
Cash Flow Statements)
– Preparing & Using the Statement of Cash Flows
– Solving the Puzzle of the Cash Flow Statements
– Beware of Accounting Mine Fields
– Financial Statement Analysis
Financial Modeling © Gültekin - 2
CAPITAL MARKETS LAB https://home.kenanflagler.unc.edu/Resources/cml/Pages/default.aspx • Bloomberg
• FactSet
• PerTrack
• Check the calendar for ongoing training sessions…
Financial Modeling © Gültekin - 3
Bloomberg Essentials Online Training
Program
• What is Bloomberg Essentials Online Training
Program?
– Formerly known as Bloomberg University Certification
Program, it is Bloomberg’s online school, teaching the basics of Bloomberg’ system and functionality. This is a self-paced program.
• Where do I take my training?
– At the Bloomberg terminals in the Capital Markets Lab
(CML) on the 2nd (main) floor of the McColl Building at
Kenan-Flagler Business School; the terminals are accessible anytime the CML is open. You cannot remote into the Bloomberg terminal.
Financial Modeling © Gültekin - 4
Bloomberg Training & Certification
• How do I get started?
1. Create a personal username and password
– At the Bloomberg terminal, hit the red CONN/DEFAULT key (upper right on keyboard) or UREG
– Click on Create a New Login” link
– Complete the series of templates.
– Bloomberg will request verification of the validation code that appears on the screen before you can proceed further. – Each time you use Bloomberg