Excel Financial Modeling and Business Analysis Masterclass

Excel Financial Modelling from scratch: Financial Statements, Project Costing, Discounted Cash Flow (DCF), Accounting

Created by: Andreas Exadaktylos
Best Selling Teacher | Msc Computer Scientist

What Will I Learn?

• Design scalable, flexible, and reusable financial models with Excel
• Create a complete range of applicable Excel models from Financial Statement Modeling, Budgeting, Forecasting, Discounted Cash Flow Analysis, What if Analysis
• Build calculations to assist in decision-making
• Learn to structure a Financial Report from scratch
• Understand Financial Modeling Theory: what it is, who uses it, and why it matters
• Plan and Design your Financial Model: how to find the Data for the Model, the steps To Build a Model, and methods for Including Documentation in a Model
• Learn tools and techniques for Financial Modeling: Cell Referencing, Naming and Dynamic Ranges, P&L Calculations, Restricting & Validating Data, Goal Seeking
• Master Excel formulas and functions: SUMPRODUCT, SUMIFS, OFFSET, VLOOKUP, XLOOKUP, PMT, PPMT, IPMT, NPER, PV, NPV, XNPV, INDIRECT, ADDRESS etc
• Build Scenarios to Financial Models: Drop-Down Scenarios, Sensitivity Analysis with Data Tables, Scenario Manager
• Learn Charting for Analysis and Model Output: Trending Column Chart, Bullet chart & Four-Segment Line Chart
• Financial Statements (3-statement) Model
• Project Costing Model
• Discounted Cash Flow (DCF) Modelling
• Activity-Based Costing
• Budgeting
• Forecasting Development
• Learn model construction, assumptions, advanced excel functionality, error trapping, sensitivity analysis, presentation of model output, and pro tips and tricks
• Become a successful Financial Analyst in no time!

Requirements

• You don’t need to have any accounting or finance experience as we will cover all of the concepts from scratch
• You will need Microsoft Excel 2010, 2013, 2016, 2019 or Excel 365

Target audience

• People who want a successful career in Finance
• Graduate students who aspire to become investment bankers, financial advisory professionals, consultants etc.
• Anyone who wants to learn the practical skills of Financial analysis
• Anyone interested in becoming a finance manager