Financial Modeling Boot Camp

2 Days

Description

KTCS can provide this training privately for any group.  If you have 3 or more people needing this training please call 866-444-6548 or email info@ktcs.biz

 

A Powerful Hands-On financial modeling training course for Financial Professionals  Combine your financial knowledge and the power of Excel® to create dependable financial models that work for you.

Master the Art and Science of Building the Financial Model in this financial modeling training course

With today's ever changing and volatile financial landscape  more than ever, the financial and investment industries need the comfort of dependable and accurate forecasting when making critical business decisions. Often, investment professionals have a solid financial background, some Excel skills but limited modeling skills, having learned "as they go" - using modeling techniques and forecasting measures that are less than reliable.

This dynamic two-day financial modeling training course will help to put all of your knowledge to use, allowing you to combine your financial background with improved Microsoft Excel® modeling skills and modeling techniques to give you the tools you need to create workable, flexible and reliable Financial Models. You and your staff will learn to build the solid foundation necessary to create valuations that you can rely upon and skills that will work over time in all aspects of your business.

Combining Financial Knowledge, Excel Skills and Model Building Technique

In two action-packed days you'll gain the skills, knowledge and "know how" to create solid and robust financial models. You'll examine the components of a good model, review accounting principles incorporated in a model, learn what information you'll need to create accurate results, and how Excel can be used to your advantage to develop a great valuation tool.

Step-by-Step  Your Modeling Skills Come Together With Ease

This rigorous, hands-on financial modeling training will cover the essentials step-by-step, and you will quickly discover how to put the power of what you know into building a dynamic, robust financial model. Confidently, you'll know how to:

  • Logically plan, design and layout a model that works in your environment
  • Use Excel to it's fullest potential to help in the building process
  • Build a financial model, integrating financial statements
  • Create financial forecasts based on your model
  • Analyze and value a company or project
  • Test and retest your results for robustness and accuracy
  • Confidently present your results to management and make informed decisions

Key skills you'll take away immediately:

  • Learn to logically arrange the parts of your model and understand the design principles behind good modeling
  • Learn how to create and record Excel macros for your repetitive modeling functions
  • Understand how to use Excel macros to their fullest potential in your model building to save you time and frustration
  • Gain the comprehensive skills sets you need to become a capable Financial Modeler
  • Know what toolbox functions you'll need and which to customize to suit your needs
  • Understand scenario testing and other testing techniques you will need before you go "live" with any model
  • Accurately record historical and projected operating assumptions into your model
  • Easily link your income statement, balance sheet and statement of cash flows
  • Know how to quickly detect errors in formulas and correct them without adverse effects
  • Incorporate the best designs for usable spreadsheets, using input cells, cell names and financial functions
  • Create a flexible and robust financial model that can easily incorporate your own needs, changes and modifications over time
  • Become a pro at sensitivity analysis using the data tools available to you
  • Incorporate graphics and logical layout to create a "Presentable" model to professionally communicate results to others
  • Know how to link all of your worksheets for interactive modeling and valuation
  • Master the skills to create a model that will work for all types of valuations in all types of business and industry
  • Learn from a renowned course developer and course instructor with years of successful investment experience and solid teaching abilities
  • Quickly get up to speed as you "learn by doing" in this hands-on class  enjoy a fast-paced, boot camp approach to learning

Who Should Attend Financial Modeling Boot Camp

Anyone using Excel to create Financial models for decision making will benefit from this course, including:

  • Financial Analysts/ Sr. Financial Analysts
  • Valuation Professionals
  • Investment Professionals
  • Mergers & Acquisitions Specialists
  • Controllers
  • CFOs

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Financial Modeling Boot Camp class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

1. Course Overview and Introductions

In this important course introduction, we'll discuss why financial modeling is important, the strategies you need to incorporate to create a solid financial model, how you need to "think" and what tools you will need to construct a complete working model.

  • Instructor/Student Introductions
  •          Determining skill levels
  •          Student's goals
  •          Course goals and direction
  • What is Financial Modeling and Why Use It?
  •          Linked/Integrated Financial Statements
  •          Historical/Future Projections
  •          Operating and Financial Assumptions
  • The Art and Science of Accurate Financial Modeling
  •          Model like an Analyst, think like a Managing Director
  •          Financial Market Awareness
  •          Clients Needs
  •          Strategic Analysis
  •          "Outside the box" Due Diligence
  •          Original/Thoughtful Research
  • Relevant Financial Websites and Support Groups
  •          Yahoo Finance
  •          SmartMoney Marketmap
  •          Google Alerts
  •          Relevant industry websites
  •          Bookmark file

2. A Thorough Review of Accounting Principles Implied in Financial Modeling

A financial model is an interactive representation of financial statements, interwoven into a seamless, interactive valuation tool, providing you an automated method for calculating accurate assumptions. In this segment, we'll review all of the key financial concepts and accounting principles that you need to understand, what each represents and how each piece interacts and affects your modeling techniques and valuations.

  • Balance Sheet Components
  • Income Statement Components Review
  • Statement of Cash Flows
  • Ratio Calculation and Analysis
  • EBITDA vs. Earnings vs. Cash Flow
  • Market Capitalization vs. Book Value
  • Key SEC filings and Source Documents
  • Importance of Footnotes

3. Excel Functions/Skills and Financial Modeling

In this hands-on section, working with the instructor, you'll cover key Excel functions, understanding what modeling tools are available in Excel, short cuts you can use, customizations that you'll want to make. You'll end by knowing the capabilities of Excel and how to navigate and work comfortably.

  • Color coding  making spreadsheets understandable
  • Using cumulative checks and SUM bars to avoid errors
  • Yes/No triggers for alternate transaction scenarios
  • Working with circular references
  • Catching errors in formulas
  • Using MIN and MAX for optional debt repayment formulas
  • Using custom number formats
  • Formatting numeric values as text
  • Mixing links and text via '&' function
  • Converting numeric values using the TEXT function
  • Tracking precedents/dependents in native Excel
  • Jumping to newly defining names
  • Creating data tables to automate repetitive calculations
  • Using OFFSET to run scenario analyses

4. Building the Financial Model

It's time to incorporate your skills and financial knowledge. In this segment, you'll create a working model in class. With the instructor, you'll incorporate your financial statements, find the "bugs", problem solve, enhance your model, use polishing techniques and ultimately create a presentable and reliable model.

  • Setting up and building the integrated financial model from scratch
  •          Linking of income statement, balance sheet, statement of cash flows
  • Establishing the Flow of a Financial Model
  •          Historical & projected operating assumptions
  •          Computing revenue growth
  •          Calculating cost of goods sold
  •          Depreciation of capital expenditures
  •          Amortization of intangibles and financial costs
  •          Capital expenditures of long term assets
  •          Analysis of working capital assumptions
  •          Accounts receivable % of sales, as a measure of collection prowess
  •          Days receivable, and its relation to sales growth
  •          Inventory % of COGS, measuring inventory obsolescence
  •          Inventory turns, measuring management efficiency
  •          Calculating prepaid expenses % of COGS
  •          Accounts payable % of COGS, and its relation to financial float
  •          Calculating accrued expenses % of COGS
  •          Latest balance sheet
  •          Income statement (historical and projected without average interest)
  •          Forecasting the balance sheet  up to debt & cash
  •          Creating a cash flow statement
  •          Understanding and creating a debt schedule  sources and uses of funds
  •          Completed forecast, balance sheet, income statement, cash flow statement
  • Valuation
  •          Discounted Cash Flow (DCF) valuation using Excel's Table function to calculate    valuation ranges
  •          Using comparable company analysis as a method of relative evaluation
  •          Using precedent transactions as a basis for takeover values
  •          Calculating enterprise value for valuing firms according to the indirect method
  •          Computing free cash flow for use in enterprise valuation
  •          Using the Capital Asset Pricing Model to estimate equity discount rates
  •          Calculating weighted average cost of capital to properly estimate enterprise value discount rates
  •          Using implied multiple analysis to develop valuation intuition
  • Advanced modeling/valuation techniques
  •          Using Scenario Analysis To model best, worst and standard business cases
  •          Using Operating Buildup to create detailed revenue and expense projections
  •          Average interest  the only valid circular reference in a financial model
  •          Sensitivity analysis to determine model robustness
  • Checks and balances to eliminate errors and "rookie" mistakes
  • Creating a summary/creating cover page
  • Recap of websites and support groups

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Financial Modeling Boot Camp class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

None stated

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Financial Modeling Boot Camp class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Comments

KTCS can provide this training privately for any group.  If you have 3 or more people needing this training please call 866-444-6548 or email info@ktcs.biz

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Financial Modeling Boot Camp class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date