Loading...

Advanced Excel with Financial Modeling

Course Summary

Advanced Excel with Financial Modeling is a financial spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office.

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives (using pivot tables and the scenario manager).


Course Objectives

By the end of the course, participants will be able to:

  • Prepare effective financial models utilizing powerful Excel functions
  • Use core financial modeling techniques
  • Forecast investments and calculate valuations of projects and companies in an effective manner
  • Develop comprehensive financial models to support investments decisions
  • Recognize special modeling and valuation considerations and best practices

Course Outline

Advanced Excel for financial modeling

  • Excel tips and tricks that will help you speed up your spread sheet
  • Logical tests
  • Protecting your data
  • Database activities
  • Pivot Tables
  • Grouping data
  • Vertical and horizontal lookup tables
  • The magical choose function
  • Interactive formulas to extract data
  • String functions
  • Data tables
  • Interactive Graphs

Fundamentals of financial modeling

  • Time value of money
  • Present Value (PV) Future Value (FV) and Net Present Value (NPV)
  • Internal Rate of Return (IRR) and Multiple IRR (MIRR)
  • Equity IRR and project IRR
  • Using XNPV and XIRR
  • Contradicting NPV and IRR
  • Amortization of loan schedule
  • Enterprise value, market capitalization, firm value and equity value
  • Effective interest rate
  • Compound Annual Growth Rate (CAGR)
  • Investment assumptions and cash flows
  • What needs to be included?
  • Forecasting revenues
  • Forecasting costs and expenses
  • Focusing on income statement or cash flow?

Valuation techniques

  • Analyzing historical information and developing a projection basis
  • Using ratio analysis to prepare projected financial statements
  • Debt capacity and credit analysis for the acquisition
  • Sensitivity analysis on cash flows
  • Weighted Average Cost of Capital (WACC)
  • Adjusted Present Value (APV)
  • Using Capital Assets Pricing Model (CAPM) to determine cost of equity
  • Implied risk premium in the current Price Earnings (PE) multiple
  • Gordon model to determine cost of equity
  • Using PE multiple to determine cost of equity
  • Accrual accounting valuation
  • Valuation using multiples
  • Transaction multiples

Building real life models

  • How financial models work
  • Modeling income statements
  • Modeling balance sheets
  • Sensitivity analysis
  • Developing an integrated financial model
  • Automotive
  • Hospitality
  • Real estate
  • Education

Special modeling and valuation considerations

  • Structured valuations
  • Financial modeling best practices
  • Return on Investment (ROI) and Return on Equity (ROE)
  • Investment structures
  • Direct ownership
  • Partnership and joint venture
  • Build, Operate and Transfer (BOT)

Target Audience

  • Corporate finance professionals
  • Investment professionals 
  • CFOs
  • Financial controllers
  • Finance managers
  • Financial analysts
  • Corporate bankers
  • Business development analysts

Course Objectives

By the end of the course, participants will be able to:

  • Prepare effective financial models utilizing powerful Excel functions
  • Use core financial modeling techniques
  • Forecast investments and calculate valuations of projects and companies in an effective manner
  • Develop comprehensive financial models to support investments decisions
  • Recognize special modeling and valuation considerations and best practices

Course Outline

Advanced Excel for financial modeling

  • Excel tips and tricks that will help you speed up your spread sheet
  • Logical tests
  • Protecting your data
  • Database activities
  • Pivot Tables
  • Grouping data
  • Vertical and horizontal lookup tables
  • The magical choose function
  • Interactive formulas to extract data
  • String functions
  • Data tables
  • Interactive Graphs

Fundamentals of financial modeling

  • Time value of money
  • Present Value (PV) Future Value (FV) and Net Present Value (NPV)
  • Internal Rate of Return (IRR) and Multiple IRR (MIRR)
  • Equity IRR and project IRR
  • Using XNPV and XIRR
  • Contradicting NPV and IRR
  • Amortization of loan schedule
  • Enterprise value, market capitalization, firm value and equity value
  • Effective interest rate
  • Compound Annual Growth Rate (CAGR)
  • Investment assumptions and cash flows
  • What needs to be included?
  • Forecasting revenues
  • Forecasting costs and expenses
  • Focusing on income statement or cash flow?

Valuation techniques

  • Analyzing historical information and developing a projection basis
  • Using ratio analysis to prepare projected financial statements
  • Debt capacity and credit analysis for the acquisition
  • Sensitivity analysis on cash flows
  • Weighted Average Cost of Capital (WACC)
  • Adjusted Present Value (APV)
  • Using Capital Assets Pricing Model (CAPM) to determine cost of equity
  • Implied risk premium in the current Price Earnings (PE) multiple
  • Gordon model to determine cost of equity
  • Using PE multiple to determine cost of equity
  • Accrual accounting valuation
  • Valuation using multiples
  • Transaction multiples

Building real life models

  • How financial models work
  • Modeling income statements
  • Modeling balance sheets
  • Sensitivity analysis
  • Developing an integrated financial model
  • Automotive
  • Hospitality
  • Real estate
  • Education

Special modeling and valuation considerations

  • Structured valuations
  • Financial modeling best practices
  • Return on Investment (ROI) and Return on Equity (ROE)
  • Investment structures
  • Direct ownership
  • Partnership and joint venture
  • Build, Operate and Transfer (BOT)

Target Audience

  • Corporate finance professionals
  • Investment professionals 
  • CFOs
  • Financial controllers
  • Finance managers
  • Financial analysts
  • Corporate bankers
  • Business development analysts

Contact Us

We moved to below new address! Suite 610 - The Business Center, Opp to Burjuman Centre, Adjacent to Burjuman Metro Station Exit 4, Khalid Bin Walid Street. P.O.Box: 94743 Dubai, UAE.

metro learnerspoint

Adjacent Building of Burjuman Center Metro Exit #4.

Follow Us  

News & Events

LearnersPoint is proud to announce that they have been associated with...

Read More

Join now the advance level courses and get trained with our industry e...

Read More

Do you have desire to work, study or migrate to English Speaking Count...

Read More

Locate Us

Map online payment

Make secure payment here