WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home ยป Financial Modeling and Valuation Workshop

Financial Modeling And Valuation Workshop Live Class

Our financial and valuation modeling training is a 2-day accelerated workshop specially designed to help you master spreadsheet financial models and business valuation techniques. By attending this 2-day workshop, you will be able to effectively build financial models, prepare and forecast schedules, understand and analyze business drivers, in addition to conducting thorough analysis of financial information. The workshop will also feature real-life case studies and use hands-on application of financial and valuation modeling in Excel.

Includes:

Live Online Classes (2 days)

  • 4.9
  • 32,322 ratings

Key Features

2 days of Intensive Training
Industry Expert & Instructors
Excel Model Templates
Query Resolution
Verifiable Certificate
Access to Workshop Recordings
  • Live Online Classes (2 Days)
    • Financial Modeling
    • 3 Statement Forecast
    • Business Valuations
    • DCF Modeling
    • Valuation Multiples

Early Bird Offer Ends in:

$1999

TAKE THIS BUNDLE

Have a coupon code?

GET OFFER

Live Online Course Fees

Batch Starts on:

Saturday - Sunday 9.00am IST to 5.00pm IST
TAKE THIS BUNDLE

Overview

Our Financial and Valuation Modeling Live Online Training covers more than 12 hours of comprehensive, interactive, and instructor-led training with real-life case studies, thus imparting working knowledge of crucial financial modeling and business valuation principles.

Live Online Classes Curriculum Download Curriculum

  • Module 01 โ€“ Financial Modeling

    Introduction to Modeling

    • Introduction to financial modeling
      • Why financial models are used?
      • What skills are needed for financial modeling?
      • General structure and model design
    • Historical data
      • Sources of information
      • Presentation of historical data
      • Analysis of historical data
    • Building the model
    • Core statements

    Projecting Schedules

    • Revenues
    • Costs
    • Fixed asset, capital expenditure, and depreciation schedule
    • Capital lease schedule
    • Amortization schedule
    • Working capital and change in working capital schedule
    • Completion of income statement logic
    • Shareholdersโ€™ equity schedule
    • Shares outstanding schedule
    • Individual schedules of inventory, receivables, and other working capital categories
    • Other long-term items schedule
    • Debt and debt repayment schedule
    • Interest schedule
    • Income tax schedule
    • Schedules of investments and dividends received

    Drivers

    • Income statement drivers
      • Revenues
      • Costs
      • Operating expenses
      • Other income statement items
      • Income taxes
    • Balance sheet drivers - assets
      • Working capital
      • Cash and cash equivalents
      • Accounts receivables
      • Inventories
      • Fixed assets (PPE, depreciation and net fixed assets)
    • Balance sheet drivers โ€“ liabilities
      • Short term debt
      • Accounts payable
      • Accrued liabilities, and other current Liabilities
      • Minority interest
      • Equity

    Balancing Act

    • Balancing the balance sheet
      • Calculating cash flow from operations
      • Calculating cash flow from investing activities
      • Calculating cash from financing activities
      • Calculating net cash flows
  • Module 02 โ€“ Business Valuations

      Valuation Overview

    • Valuation overview
      • Why valuation?
      • Importance of valuation
      • Valuation approach
      • Key valuation tools
      • Valuation summary table
      • Key valuation questions
      • Valuation โ€“ subjectivity versus objectivity
    • Introduction to discounted cash flow
    • Discounted cash flow
      • Overview of discounted cash flow
      • Steps in a Discounted cash flow (DCF)
    • Discounted Cash Flows

    • Free cash flow
      • Valuing a firm using free cash flow to firm (FCFF)
      • Valuing a Firm using free cash flow to equity (FCFE)
      • Suitability of FCFF and FCFE
    • Discounted cash flow projections
      • Sales
      • Operating expenses
      • Depreciation
      • Capital expenditure
      • Income tax
      • Working capital
      • Projections โ€“ some questions?
    • Terminal Value

    • Terminal value overview
    • Exit value method
    • Exit multiple exercise
    • Perpetuity growth method
    • Perpetuity growth exercise
    • Terminal value spot check
    • Terminal value concerns
    • Discount Rate

    • Discount rate overview
    • Discount rate โ€“ cost of debt
      • Yield to maturity method
      • Credit rating method
      • Synthetic rating method
      • Company report method (spot check!)
    • Risks
      • Unsystematic risk
      • Systematic risk
    • Capital Asset Pricing Model

    • Introduction to capital asset pricing model (CAPM)
    • Risk-free rate
    • Beta
      • Calculation of regression beta
      • Calculation of bottom-up beta โ€“ levered and unlevered beta
      • Beta concern
      • Preferred beta methodology
    • Market risk premium
      • Historical risk premium method
      • Forecast risk premium method
      • Market risk premium: size premium
    • DCF Synthesis

    • DCF โ€“ present value
      • Discounting
      • Mid-year discounting
      • Valuation
    • DCF โ€“ adjustments
    • Sensitivity analysis
      • FCF and terminal value using growth rate and WACC as inputs
      • Enterprise value using growth rate and WACC as inputs
      • Price/share using growth and WACC as inputs
      • Effect on EPS by changing the value drivers
    • Valuation Multiple

    • What is a multiple?
    • Why multiples vary
    • Advantages and disadvantages of Multiples
    • Identifying comparables
      • Operational parameters
      • Financial parameters
    • Equity value
    • Enterprise value
    • Advantages of equity value and enterprise value
    • Introduction to equity value multiples
    • Introduction to enterprise value multiples
    • Equity and Enterprise Multiple

    • Calculation of valuation multiples
    • Enterprise value multiples
      • EV/Sales
      • EV/EBITDA
      • EV/EBIT
      • EV/FCF
      • EV/Capacity
    • Equity value multiples
      • P/E
      • P/CF
      • P/BV
      • PEG
      • Dividend Yield
    • Letโ€™s put it together!
    • Other Valuation Approaches

    • Asset-based valuation
    • Sum of parts
    • Mergers and acquisitions comparables
    • Replacement cost method
    • Qualitative factors in valuation - Management Quality
Call Our Course Advisors

IN : +91-8800880140

Certificate of Completion

Financial Modeling Course

Industry Growth Trend

The Financial Services Application Market is expected to grow from $66.92 billion in 2014 to $103.66 billion to 2019, at a Compound Annual Growth Rate (CAGR) of 9.1% during the forecast period 2014-2019.
[Source - MarketsandMarkets]

Average Salary

Average Salary$83,000 per year
The average salary for a Modeling Analyst is $83,000 per year in the United States. Salary estimates are based on 57 salaries. The typical tenure for a Modeling Analyst is less than 1 year.
[Source - Indeed]

Pre-Requisites

  • The most important pre-requisite for this financial modeling course is your desire and passion to learn this most important skill in Finance.
  • Second, if you know basic accounting, then it should help a lot. In this course on Financial Modeling, we start with the assumption that you know financial statements and financial statement analysis.
  • The third which I feel is equally important is about your excel know-how. Basic excel knowledge is required to proceed in this course.

Target Audience for Financial Modeling and Valuation Course

    If you wish to make a career in Finance, then you must master Financial Modeling. This Online Financial Modeling course can be taken by you if you are one of the following –

  • Passionate about Finance and want to learn to become Pro in this.
  • Executives, Business Planning and Strategy Executives.
  • Managers working in Banks
  • Equity Research Analysts
  • Investment Bankers
  • Portfolio Managers
  • Commercial Bankers
  • Risk Managers
  • Itโ€™s an added advantage for those people who are pursuing CPA, ACCA, MBA, CFA, FRM and Commerce graduates.
  • Also the candidates having Degree, Diploma, in technical fields like B. Techย or Engineering who wants to make a career in finance

FAQs โ€“ General questions

Would this course add value to my profession?

You should not doubt this one. Financial Modeling skill is a core skill that each student in Finance should master. Financial Modeling when added to your resume as core skills should invite shortlists from Investment Banking and research firms.

If Iโ€™m already in the profession, should I do these online financial modelingย courses?

Yes, this course on Financial Modeling can be a refresher course for you. In addition, we have taken companies from different sectors and countries to provide you a variety of analyses. This online financial modeling course will help you to brush the basics but also will provide you with detailed knowledge of Best Practices in Financial Modeling.

Can professionals from other domains enroll for this online financial modeling course?

Yes. If you are in another profession then also you can look forward to learning Financial Modeling. As iterated earlier, Financial Modeling can be used in the organization for decision making, budgeting, forecasting, and planning.

Is it a quick-fix or I need to keep on practicing the skills I would learn from this course on Financial Modeling?

Youโ€™ve already answered the question yourself. You will learn a great deal and many skills from this course on Financial modeling. But to maintain it, you need to be constantly in touch. You need to set out some time to practice whatever you learn from this course to get the maximum benefits.

Where do learners come from?

WallStreetMojo’s online financial modeling courses are taken by professionals and students across the globe. Some of the top cities and countries where our students come from are Hong Kong, New York, San Francisco, Singapore, New Jersey, Dubai, UAE, Riyadh, Bahrain, Lagos, Houston, Seattle, Toronto, London, Berlin, UK, New Delhi, Pune, Mumbai, Bangalore, Kolkatta, Hyderabad, Gurgaon, India, Sydney, Australia, New Zealand etc.

Can i see the Demo Videos?

Yes, you can view the demo videos above.

What are the Payment Options?

You can pay by Credit Card, Debit Card or Net Banking from all the leading banks. Additional payment options include pay by PayPal and 2checkout.

Course Reviews / Testimonials

  1. Seyni Souley Boubacar

    Course Reviews

    Financial modeling, in this case, is a well explained and very comprehensive for Financial analyst. this will help you understand what exactly financial model means and the basics for real-life applying. this course in financial modeling is structured so that you will master it as if you are an expert. I like financial modeling, I like the course done here. Thank you Dheeraj Sir for bringing such courses. You are always the best.!!
    Linked

  1. Tornidis Ioannis

    Course Reviews

    A financial modeling training course focusing on the banking Sector. This includes many methodologies of calculating and forecasting different line items like deposits and loans using macroeconomic approaches but also other items using industry analysis. The key item is how to link the different forecasts between the 3 financial statements and how to improve our valuation.
    Linked

  1. Vignesh Varatharajan Sivamani

    Course Reviews

    Excellent financial modeling certification course, I will recommend it to anyone. Clear step by step instructions and the good thing is you can redo the sessions until you are confident. I completed that certificate program and I think that is the best way to understand real estate financial modeling easily. All concepts and applications are supported by examples in Excel. Thank you very much for the clear and beneficial explanations.
    Linked

  1. Leikantsemang Renewang

    Course Reviews

    Investment banking bundle is a very rich and well-structured course. It is very illuminating and informative, and it prepares you to find a needle in a haystack. Even though some of the topics are challenging and requires extended time, it really worth the time a spent on these videos.
    Linked

  1. Josรฉ Agostinho Pedro

    Course Reviews

    Good Financial modeling training. I liked the examples. The Instructor is best, He communicates information exceptionally clearly and efficiently, adds humor, and uses relevant examples to make connections between course material and the real world. I have nothing bad that I can think of to say about his style of and proficiency at teaching. I would recommend this course to those looking to take this course.
    Linked

  1. Cheng Zhongyi

    Course Reviews

    The financial modeling certification course layout was structured in a clear, thoughtful manner. The course instructor gave practical examples to illustrate basic accounting concepts (which was a good reminder). Some real-world advice was provided by the instructor, at the beginning (understanding the users of the financial model) and at the end (interview questions, common mistakes). That was a good heads up of what to expect in the real world.
    Linked

0 Shares
Share
Tweet
Share
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFAยฎ And Chartered Financial Analystยฎ Are Registered Trademarks Owned By CFA Institute.
Return to top

Book Your One Instructor : One Learner Free Class
OFFER FOR YOU

*Offer is valid only for next 20 min

Leaving so soon?

Get Additional 10%ย OFF on



Take this Bundle
WallStreetMojo

Download Financial Modeling And Valuation Workshop Curriculum

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Letโ€™s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?