Financial Modeling
Overview
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.
Description
“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”
Course Content
Unit 1: Create reports from multiple sources
- Creating a pivot table to use as a database
- Consolidating multiple pivot tables
- Updating multiple pivot tables
Unit 2: Converting multiple columns into a database format
- Converting multiple columns into a database format
Unit 3: Simplifying reporting
- Introduction
- Setting up the structure
- Checking source data
- Consolidating source data
- Creating a mapping table, mapping data and validating mapping
- Complete the report
Unit 4: Automatic reconciliations
- Introduction
- Numbering data automatically and making it unique
- Steps in reconciling data (one list)
- Reconciling two lists
Unit 5: Reporting by using the indirect formula
- Introduction
- Using indirect formula to report on column format data
Unit 6: Compiling an age analysis
- Introduction
- Fixing the dates and calculating the number of days old
- Creating the mapping table
- Finishing the age analysis and reporting
Unit 7: Amortisation tables
- Amortisation table where the rates stay consistent
- Amortisation tables where the rates and capital payments can change
Unit 8: Cash flows
- Introduction
- Fixing the signage
- Creating adjustment columns
- Creating a mapping table
- Finishing the cash flow statement
Accreditation
- Non-accredited: Short course only
- Duration: 1h 30m
- Delivery: Classroom/Online/Blended
- Access Period: 12 Months
