Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Modeling for Financial Reporting and Analysis Course

By: McTimothy Associates Consulting LLC  

Lagos State, Nigeria

18 - 20 Jul, 2022  3 days

Follow Event

  

NGN 94,999

Venue: Group registration of 3-9 attracts 5% discount, 10 and above attracts 10%

Organizations cannot afford to make the wrong investments decisions because such decisions have a long-term impact on the business and could make or break the organization. That is why it is critical to master financial modeling techniques as they are the main basis for investment decisions. By helping you understand and build effective financial models, this course will have a significant impact on the effectiveness and feasibility of your investments decisions.

Course Methodology

This course uses hands-on applications of financial modeling in Excel in addition to demonstrating theoretical core topics. The course also features real-life case studies and presentations by participants.

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

Target Audience

Corporate finance professionals, investment professionals, CFOs, financial controllers, finance managers, financial analysts, corporate bankers, and business development analysts.

Target Competencies

  • Learning advanced Excel
  • Performing capital budgeting analysis
  • Forecasting cash flow
  • Calculating cost of capital
  • Practicing financial modeling
  • Understanding scenario analysis
  • Calculating free cash flow

Note

This is a hands-on training course using laptops, participants need to bring their own laptops equipped with a fully functioning version of MS Excel 2010/2013.

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)
Group registration of 3-9 attracts 5% discount, 10 and above attracts 10% Jul 18 - 20 Jul, 2022

Registration: 10:00:am - 04:00:am

NGN 94,999.00
(Convert Currency)

Patience 07034854045, 09080022449,08058805333

Group registration of 3-9 attracts 5% discount, 10 and above attracts 10%

Related Courses

Financial Modeling and Forecasting Techniques Using Excel Financial Modeling and Forecasting Techniques Using Excel

3 days, 17 - 19 Oct, 2022 

2022-10-17 12:10:00 2022-10-17 12:10:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

Financial modelling is crucial for taking investment decisions that can have a huge financial impact on companies. By attending this course, you will be able to effectively prepare and build ...

Writing HR Policies and Procedures Course Writing HR Policies and Procedures Course

2 day, 22 - 23 Jul, 2022 

2022-07-22 12:07:00 2022-07-22 12:07:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

Writing human resources policies and procedures is both an art and a science. Historically, human resources departments have resorted to outsourcing this function to professionals who have ...

Advanced Administration and Office Management Course: Best Practices and Technologies Advanced Administration and Office Management Course: Best Practices and Technologies

3 days, 14 - 16 Sep, 2022 

2022-09-14 12:09:00 2022-09-14 12:09:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

Administrative managers and assistants are invaluable members of the organization team. They are charged with overseeing and coordinating the day to day operations of a business. Thanks to the advent ...

Maintenance Planning, Scheduling and Control Course Maintenance Planning, Scheduling and Control Course

3 days, 19 - 21 Oct, 2022 

2022-10-19 12:10:00 2022-10-19 12:10:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

Maximizing assets availability and reliability with the optimal cost are two conflicting objectives that each maintenance department needs to achieve. Maintenance planning and scheduling is the first ...