Introduction to financial modeling introductory
Short course
Inhouse
Description
-
Type
Short course
-
Methodology
Inhouse
-
Duration
1 Day
If you have not done much financial modeling, then this is where you should start. We begin with basic keyboard drills, and then rapidly progress to efficient formula construction and modeling best practice. We introduce basic checking techniques and stress the importance of integrity checking. We begin with a simplified projection, and then start projecting a company. Although. Suitable for: Anyone who needs an introduction to financial modeling and forecasting.
About this course
None
Reviews
Course programme
We begin with basic keyboard drills, and then rapidly progress to efficient formula construction and modeling best practice. We introduce basic checking techniques and stress the importance of integrity checking. We begin with a simplified projection, and then start projecting a company. Although simple, the sample company contains the basic parts common to all projection models.
We complete a basic projection, stress test it, and then add a revolver account. Finally we will add interest income and expense and deal with the resulting circularity. We finish with documentation and more integrity checking.
- Basic keyboard shortcuts
- Excel settings for efficiency
- Key modeling formulas and structures
- Simple 3-statement projections
- Standards for good models
- Income statement construction
- Audit trails
- Introduction to checking methodology
- Balance sheet and cash flow statement construction
- Circularity and iteration
- Ratios and summary
Introduction to financial modeling introductory