TAP> Financial Modeling

Course Purpose:

Build comprehensive financial models using Excel or specialised software, covering topics like forecasting, budgeting, valuation, and scenario analysis. Additionally, you’ll explore advanced techniques for modeling financial statements, performing sensitivity analysis, and making informed business decisions based on these models.

What you’ll learn

“While there is a lot of value in mastering the basic and intermediate array of functions offered by Microsoft Excel, for some, simply automating the day-to-day arithmetic functions involved in a simple balance sheet will not be enough to meet the financial accounting needs of a large company and a more in-depth knowledge is required. This course will equip you with the skills to significantly improve your company’s control of its financials. The following topics are covered: • Creating reports from multiple sources • Simplifying reporting • Reconciliation model • Creating reports where actuals, budgets and prior years change with lists • Compiling an age analysis in five minutes • Amortisation tables”

Duration: 1 Day

Featured Course

Basic Microsoft Excel

Course Curriculum