Business Financial Modeling and Forecasting Course

FraudDetectPrevent
This course seeks to give participants a foundation in building financial model and conducting analysis in excel in the areas of feasibility study and business planning, valuing a company for investment purposes, determining the value of a business before buying or selling it, forecasting and..

Start Date:

10 August, 2020.

End Date:

00 December, 0000.

Amount:

NGN 250,000.00

Category:

Banking and Finance

This course seeks to give participants a foundation in building financial model and conducting analysis in excel in the areas of feasibility study and business planning, valuing a company for investment purposes, determining the value of a business before buying or selling it, forecasting and budgeting for a product, service, business unit or the entire company.

Learning Objectives:

At the end of this session, participants will be able to:

  • Demonstrate practical knowledge and skill in modelling financial statements like Income Statement, Cash flow, Statement of Financial Position; 
  • Create a background into the principles and application of valuation using discounted cash flow method with Microsoft Excel

Course Outline

  • Review of relevant excel functions and formulae
  • Excel formulae and functions useful in building financial models
  • Debugging /evaluating formula errors
  • Building the financial model - income statement - 5 years
  • Step by Step building of a financial model
  • Model presentation - design/layout and structure
  • Best practices in modelling
  • Determining fixed assets
  • Building discounted cash flow models in excel
  • Valuing stocks
  • Overview of valuation models
  • Conducting analysis - Ratios
  • Scenario analysis and Risk Assessment

MORE DETAIL

Phone Number:

+2348033467639

Email:

megaheads@gmail.com

Book for Business Financial Modeling and Forecasting Course