Modeling a real company introductory
Short course
In Banbury
Description
-
Type
Short course
-
Location
Banbury
-
Duration
1 Day
In this program we build a fully integrated financial statement forecast using a real case company. A template is provided with the historical information already embedded and the assumptions already built. This allows the class to concentrate on the development of best practices that can be applied in any modeling context. A strong focus on integrity checking is maintained from the. Suitable for: Anyone who uses Excel to model financial performance
Facilities
Location
Start date
Start date
About this course
Sound knowledge of the fundamentals of financial statement analysis and the basics of financial modeling.
Introduction to Financial Modeling is advised
Reviews
Course programme
A template is provided with the historical information already embedded and the assumptions already built. This allows the class to concentrate on the development of best practices that can be applied in any modeling context. A strong focus on integrity checking is maintained from the first session throughout. Minimizing error rate is the key to developing efficiency improving the reliability of your modeling in Excel.
- Keyboard shortcuts
- Multiple years'' historical information
- More complex assumptions, income statement and balance sheet accounts
- Creating and using reasonably complex models for revenues
- Analyzing and making reasonable projections for a company''s operating costs, non-recurring items, and other income and expense
- Detailing the debt schedule for notes payable, revolver (financing gap) and each of the separate debt items with beginning balance, scheduled issuance, repayments, interest rate and interest amount
- Effective tax rate, income tax provision, taxes payable and the various deferred tax items
- Thorough review of circularity and iteration
- Using IFISERROR to protect your model from blow ups
- Building a detailed cash flow statement with complex line items
- Learning troubleshooting techniques for cash flow statements
- Key links between financial statements
- Integrity checking tools and techniques
- Solving for errors quickly and efficiently in forecast models
Modeling a real company introductory