Search the site search Search

Courses > Financial Modeling > Fully Integrated Financial Statement Forecasts > Modeling A Real Company

Modeling a Real Company1 day Classroom
Introductory


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 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

You can call Matchett on +44 (0)1295 256161 to book a course or simply discuss your training needs OR email us:

Personal information
*
*
*
*
*
*
 
*
*



submit the form

Related Courses

Best practices in financial modeling, including integrity checking

Pre-requisites

Sound knowledge of the fundamentals of financial statement analysis and the basics of financial modeling.

Delegate Profile

Anyone who uses Excel to model financial performance