FINANCIAL MODELLING WITH MICROSOFT EXCEL FOR BEGINNERS

on

While many business professionals and students are familiar with the output of financial models (namely Balance sheet, Income Statement, and Statement of Cash Flows) and have a working knowledge of Microsoft Excel, few people are truly adept at building an accurate and effective financial model from the ground up. This course presents step-by-step instructions for building effective financial models using Microsoft excel.

Upon completing this course, participants will be able to use Microsoft Excel to;

  1. Prepare a financial model assumptions worksheet and dashboard
  2. Prepare the operating budget component of a financial model
  3. Prepare the financial budget component of a financial model
  4. Prepare some outputs of a financial model like balance sheet, income statement, statement of cash flows etc.
  5. Analyze a financial model using sensitivity analysis, contribution margin analysis and financial ratios
  6. Use traditional valuation methodologies in relation to a financial model.

This course is targeted at individuals with a beginning to intermediate level of experience with both Microsoft Excel and finance/accounting.


Module 1 Overview of Budgets and Financial Models
Module 2 Operating Budget – Assumptions, Sales and Collections
Module 3 Operating Budget – Cost of Goods Sold, Inventory, and Purchases
Module 4 Operating Budget – Operating Expenses
Module 5 Operating Budget – Income Statement
Module 6 Financial Budget – Capital Budget and Cash Budget
Module 7 Financial Budget – Balance Sheet
Module 8 Statement of Cash Flows
Module 9 Free Cash Flows and Dashboard
Module 10 Sensitivity Analysis
Module 11 Contribution Margin Analysis
Module 12 Financial Ratios Analysis
Module 13 Business Valuation
Module 14 Capitalization Chart

The course instructor employs a hands-on-training approach. Throughout the fourteen modules, each course participant is required to build a financial model for AfroBead Limited – a fictitious Ghanaian company that produces local necklaces. Upon satisfactory completion of the course, a course participant can request for award of certificate at a fee.

Elvis Agbenyegah

Elvis Agbeshi Agbenyega

(Head of Financial Analytics at Wave-2 Analytics Limited)

Elvis is very passionate about social responsible investing and data analytics. He is a charter holder in Financial Economics from the Global Academy of Financial Management. He also holds a Bachelor’s degree in Accounting as well as a Master’s degree in Finance from the University of Ghana Business School. He is a Licensed Dealing Officer of the Ghana Stock Exchange.

Over his professional career, Elvis had acquired valuable experience in using financial models to analyze business activities of companies of all types and sizes. He heads the Financial Analytics Desk at Wave-2 Analytics Limited – Ghana’s foremost data analytics firm with presence in the USA.

Phone/whatsapp: +233 553 655 205
Email: elvisagbey@gmail.com / elvis@wave2analytics.com

Register Now