• No products in the cart.

Certificate in Advanced Financial Modeling and Valuation

5( 14368 REVIEWS )
14368 STUDENTS

INTRODUCTION

Hands-on practical training course to help you learn exactly what is required to do in your daily work.
Up-skill your knowledge to be a Financial Analyst.
Practical assignments, illustration spreadsheets, excel shortcuts- all included and can be downloaded at your end for self-practice.

 

WHO CAN DO?

Any Finance professional like:
• Financial analysts
• Venture capitalists
• Private Equity professionals
• Startup entrepreneurs
• Investment Bankers
• CFA Candidate
• Recent Graduates looking to start their career in Finance

 

WHAT YOU WILL LEARN

Practical applications of accounting, Excel, finance, financial modelling, valuation, presentations, and other critical skills that financial analysts need
• Forecast future financial statements of any company, Budgeting, and planning
• Analyze Cash flows of any company
• Analyse the Annual Report of any company, ratio analysis, key metrics etc.
• Common valuation techniques used in Business valuation
• Understand each valuation method and respective application across sectors
• How to evaluate any Business’s worth (whether a start-up or mature business)
• Learn how to build a three-statement model, LBO model, M&A model, business valuation model etc
• How to perform sensitivity and scenario analysis for financial modelling
• To gather inputs from various sources required for performing Valuations for any Company

COURSE STRUCTURE

Lectures Study Units
1 & 2 • Financial analysis basics: learn how to to undertake a comprehensive financial analysis of any income statement.
• Review the various components of the income statement
• Conduct a comprehensive vertical and horizontal analysis of the income statement
• Benchmark income statement performance against an appropriate peer group
• Profitability analysis
3 & 4 • Budgeting and forecasting
• Learn entire budgeting process from start to finish, the various methods for building budgets, techniques to analyze results, and how to improve organizational performance.
5 • Three statement Financial model will include:
• Forecasting Income statement and balance sheet
• Debt and financing schedule
• Build a free cash flow statement
• DCF modelling
6 • Business Valuation & modeling
• Learn the skills required to perform detailed business valuation modeling using three main methods: Comps, Precedents and DCF Analysis.
• Detailed and step-by-step explanation of how to value a company based on comparable companies, past M&A transactions and a Discounted Cash Flow (DCF) models.
7 • Scenario & sensitivity analysis
• How to build a robust sensitivity analysis system into your Excel financial model.
• Model integration, analyzing results, and presentation  (Tornado charts, gravity sort table etc)
8 • M&A modeling
• Build a structure for financial M&A model
• Set up all the assumptions and drivers required to build out the M&A model
• Calculate all the necessary adjusting entries required to create a post-transaction balance sheet
• Integrate the acquirer and the target into a pro forma model
9 • LBO modeling
• Learn how to build LBO model from scratch
• Step by step including assumptions, financing, forecasting, DCF, IRR, excel functions & formulas
10 • Start-up financial model
• learn to build a startup financial model from scratch complete with assumptions, financials, valuation, and output charts.
• Perform a discounted cash flow DCF valuation of the startup business
11 • Real estate Financial Model
• Learn how to build a dynamic Real Estate Financial Model to evaluate the investment return profile of a development project in Excel.
• Calculate Cap Rate and Net Operating Income (NOI)
• Build an interactive financial model to assess a project’s financial viability
• Calculate Internal Rate of Return (IRR), Return on Sales, Return on Cost
12 • Dashboards & data presentation
• Learn how to build a custom Excel dashboard using professional data visualization techniques.

CHOOSE THE TRAINING OPTION:

LIVE ONLINE
TRAINING

Live online lectures where you interact with the instructor via webinar.

ONE TO ONE
TRAINING

Individually focused and highly interactive training with you and exclusive trainer for you.


Course Curriculum

No curriculum found !

Course Reviews

5

5
14368 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

PRIVATE COURSE
  • 0 Months

Instructors

14368 STUDENTS ENROLLED

    Currency Switcher

    YOU MAY INTEREST IN:

    MIGRATE TO CANADA:

    Read More..

    UNITED ARAB EMIRATES - VAT CONSULTANCY SERVICES:

    Read More..

    JOIN AS TRAINER:

    Apply Now

    Top Rated Courses:

    Copyright © 2020 - Berkeleyme School of Management & Sciences. All rights reserved.
    X