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;
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 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.