Modeling a real company introductory

Short course

In Banbury

Price on request

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

Banbury (Oxfordshire)
Linden House, 55 South Bar, OX16 9AB

Start date

On request

About this course

Sound knowledge of the fundamentals of financial statement analysis and the basics of financial modeling.
Introduction to Financial Modeling is advised

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

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

Modeling a real company introductory

Price on request