Synergy Training Group qr code

We're waiting to talk to you
07843 381 688




Course Topics

Financial Analysis & Modeling Using Excel

Course Overview:

Too often, finance courses stop short of making a connection between the theory and practice of real-world business. Financial Analysis & Modeling using Excel® bridges this gap by providing a hands-on approach to solving common financial analysis & modeling using Excel®. This seminar will challenge you to:

  • Learn how to use financial statements to evaluate the financial / strategic performance of an organization
  • Understand discounted cash flow (DCF) techniques and their application to financial decision-making
  • Use ratios to quickly pinpoint areas of concern
  • Identify key success factors, weak financial signals, and strong financial signals in your own industry sector
  • Understand & use both financial & operating leverage
  • Learn the metrics used by the world’ leading companies, how to use them, & why
  • Create financial models from scratch that give you answers immediately
  • Confidently project your firm’s future performance through real-world modeling
  • Learn new, advanced modeling techniques to improve results

This is a very “hands-on” course with significant time spent working on the computer.

Who Should Attend:

Professionals who wish to work on improving their skills with other similar individuals will find they need, and use, everything they learn in this program. Functional managers who have recognized their need for a bigger picture and a more integrative financial view will benefit. Professionals who wish to have a better “hands-on” knowledge & understanding of the relationship between analysis & modeling.

Specifically:
  • Finance
  • Accounting
  • Planning
  • Operations
  • Strategy
  • Marketing
Organizational Impact:
  • Encourages best and brightest managers to stretch themselves integrating finance, planning and strategy
  • Provides an opportunity to apply important financial theories to real-world applications so they can be used in the work place immediately
  • Builds practical problem solving skills for immediate use to build models to test alternatives
  • Improves recognition and implementation of financial management principles
Personal Impact:
  • Personal life-long learning philosophy enhanced and clarified
  • Permits testing of financial impact of strategic options
  • Builds financial and analytical skills in a complex and changing environment
  • Ability to take theory into practice in your firm immediately for improved results
  • Long lasting relationships built for future professional relationships
Course Content: Seminar Outline: The Structured topics
Day 1 - Financial Modeling Principals
  • Using Financial Models to Solve Business Problems
  • Learn the 10 steps to create good Financial Models
  • The 13 steps to Improving traditional Financial Models
    • Define the Terms Model and Financial Model
    • Learn to use Flowcharting Tools & Techniques in Excel©

Financial Functions and Time Value of Money Considerations

  • Overview of the Time Value of Money
  • Apply Time Value Concepts to Financial Models
  • Learn Why the Weighted Average Cost of Capital (WACC) Is Used in Capital Budgeting Models (Excel case study)
  • Use Net Present Value (NPV) and Internal Rate of Return (IRR) Models in Making Capital Expenditure Decisions
  • Why is Profitability Index (PI) & MIRR (Modified Internal Rate of Return) are good alternatives
  • Learn to use the built-in functions to calculate NPV & IRR
  • Automatic Functions: (Excel case study)
    • FV Function
    • Rate Function
    • Payment Function
    • NPER Function
Day 2 - Sensitivity Analysis
  • Overview: How to Use Data Tools
  • Goal Seek
  • Data Tables
    • One Way (Input)
    • Two Way (Input) (Excel case study)
  • Scenario Manager: 3 ways to use this tool
  • Using the Forms Toolbar: (1) Spinners; (2); Scroll Bars; (3) More

Optimization with Excel’s Solver

  • Overview: How to Use Solver
  • Specific Examples: (1)  Optimal Product Mix;  (2) Profits; (3)  Breakeven (Excel case study)
Day 3 - Simulation Analysis
  • Overview
  • Simulating the Profit Scenario
  • Monte Carlo Simulation
  • Random number generation

Case study to build a Monte Carlo Model

Financial Modeling for Cost of Capital & Capital Structure Considerations

  • Estimating the Cost of Capital
  • Choosing the Method of Project Financings: 3 Options
  • Establishing the Firm’s Optimal Capital Structure (Excel case study)
  • Estimating the Firm’s Discount Rate
  • Calculating the Weighted After-Tax Cost of Capital (WACC)
Day 4 - Modeling the Project Investment Decision
  • The Capital Budgeting Process: Five Steps (Excel case study)
    1. Creating the Pro forma income statement
    2. Calculating the Cash Flow From Assets (CFFA)
    3. Estimating Cash Flows
    4. Evaluating Capital Expenditures
    5. Making the decision
  • Discounted Cash Flow Methods (Using Excel)
  • Internal Rate of Return (IRR) and Modified IRR (Using Excel)
  • Evaluating Projects with Different Lives using an Equivalent Annual Cost (EAC) method (Excel case study)

Valuation Models

  • Overview (Excel case study)
  • Discounted Cash Flow Valuation Model
  • Market Comparable Approach
  • Merger & Acquisition model
  • Weighted valuation
  • Overview of M&A Issues
DAY 5 - Financial analysis & beyond
  • Deciding on Benchmarks & industry standards
  • Ratios, trends, & more
  • Breakeven analysis & options
  • Leverage: Operating versus Financial
  • Altman’s Z-Score & its application
  • Case study –Analyze a public firm

Principles & application in building a financial model:

  • What to look for in projected performance
  • Building a ratio driven model
  • Building a break even model with more uses
  • Lease versus buy calculations
  • Case study –build a financial model for your firm

Each participant should bring their own laptop loaded with Microsoft Excel® 2007 or newer version

Training Methodology

The training process is based on a carefully planned mix of succinct tutor input - with practical illustration of tools and concepts, group work on case studies (all video based - and lively), feedback, and selective work on individual issues in pairs. Team involvement and working enable a strategy to be created from start to finish. The Training is based on the 4 mat systems to enable complete learning. There will also be some opportunity for role play. You will receive an electronic toolkit within the material for subsequent everyday use.

The Facilitator:

Daniel Feiman, MBA, CMC©, Consultant, Trainer, Author, Reviewer. Mr. Feiman is based in Redondo Beach, CA, USA. He consults in three areas: Strategy: Planning & Implementation; Finance: Modeling & Analysis; Process: Continuous Process Improvement & Certified Supplier Programs.

Mr. Feiman is an internationally recognized leader in these areas; working with firms such as ADNOC (United Arab Emirates), American Management Association (AMA); Apple, ARAMCO (Saudi Arabia), California Institute of International Business & Economics, Credit Suisse, Hilton Hotels, Institute for Supply Management (ISM), Mattel, PEMEX (México), PDO, (Oman), Promigas (Colombia) Reliance (India), TRW, UEM (Malaysia) & the University of Manchester (UK) among others.

Over the past 37 years he has worked with firms in many industries including: automotive, aerospace, consumer products, distribution, education, legal, hospitality healthcare, manufacturing, medical, oil & gas, production & telecom.

He has published whitepapers, articles, SlideShare presentations (10,000+ views), YouTube videos & books on these subjects. His 3rd book in the Build It Backwards series (THE Book on Business from A to Z: The 260 Answers You Need to Know), was published in November, 2011 & was nominated for a Thought Leader of the Year award by the AM&AA & selected as a Finalist for a Global eBook of the Year Award.

He is adjunct faculty at the University of California, Los Angeles (UCLA) Extension Department (since 1990) and was formerly The Visiting Professor in the University of Huddersfield’s (UK) Business School.

Mr. Feiman has over 18 years’ experience in all facets of both the traditional & nontraditional banking industry. He has been interviewed on various television and radio shows. He is also a reviewer for the New York Journal of Books

He has been awarded the CMC© designation by Institute of Management Consultants which is awarded to less than 1% of management consultants.

Follow on Courses:
Recommended Books:
  • Financial Statements: A Step-by-Step Guide to Understanding and Creating Financial Reports; Thomas R. Ittelson; Career Press Inc; August 15, 2009; ISBN: 978-1601630230
  • Accounting Basics: Complete Guide; Michael A. Celender; CreateSpace Independent Publishing Platform; (May 22, 2013); ISBN: 978-1482324815
  • The Book on Business from A to Z: The 260 Most Important Answers You Need to Know; Daniel Feiman MBA CMC®; Build It Backwards Publishing; September 1, 2011; ISBN: 978-0981977379
We can come to you !

Did you know Synergy can come to you and deliver this workshop ‘In Company’ at your own venue or location. If you have three or more people who you would like to benefit from attending this workshop our trainer can travel to you and deliver the same specification of course for your staff at a fraction of the overall cost.

If you’d like to know more about this option please contact us on 0121 605 7533 or email us at operations@groupsynergy.co.uk – our operations team manages all of our ‘In Company’ events and we can talk you though the logistics, pricing and whether you’d like the workshop as advertised here or something tailor made just for your business.

We have several packages on offer so contact us today.

What is Continuing Professional Development (CPD)?

Continuing Professional Development (CPD) is a personal commitment to keeping your professional knowledge up to date, improving your capabilities, proving commitment and competency in your profession. It focuses on what you learn and how you progress throughout your career, helping you gain more credibility within your industry, with your employer, clients and gain competitive edge over your peers.

Being actively committed to CPD may in the future:
  • Improve your Resume
  • Maintain professional recognition
  • Showcase your achievements, attributes and your brand
  • Accelerate your career prospects
  • Deliver job satisfaction: ensuring you are Career focused
  • Reassure your Employers and Stakeholders that you are upto date and competent
How do I gain CPD recognition

By attending Synergy Courses you can be assured that attendance, completion and certification will be rewarded by CPD points. To help advance your professional status CPD recognition is awarded on both public workshops and in-house courses, being dependent on the number of hours spent learning. On request Synergy Training Group will provide a certificate of attendance for you to use as evidence and to attach to your record card.

A number of our courses are accredited, endorsed or approved by a number of Learning & Development and Professional Bodies and Associations for more detail please contact us at mail@groupsynergy.co.uk.

Title:*
Contact Name:*
Position in Company:*
Name of Company:*
Business Activities /
Business Sector:*
Email:*
Direct Telephone:*
Number of Employees in Organisation:*
Budget for Training Project:* £

Any additional courses of interest? (to select multiple courses hold Ctrl and click on the courses)

How did you hear about us?

Enquiry Details

CAPTCHA Image
Refresh Image

would like to inform you about the "Financial Analysis & Modeling Using Excel" course.

Enter email address of the person to forward this course to: