Handout Financial Modeling with Excel

Course Description
Financial modeling deals with building digital prototypes of business strategies for core business tasks, such as valuation, profit loss analysis, and growth analysis, that are crucial to decision making. Hands-On Financial Modeling with  Excel 2019 explains financial modeling concepts and their implementation with the help of Excel.

What you will learn
Identify the growth drivers derived from processing historical data in Excel
Use discounted cash flow (DCF) for efficient investment analysis
Build a financial model by projecting balance sheets for assessing profit and loss
Apply a Monte Carlo simulation to derive key assumptions for your financial model
Prepare detailed asset and debt schedule models in Excel
Discover the latest and advanced features of Excel 2019
Calculate profitability ratios using various profit parameters


Textbook:
Hands-On Financial Modeling with Microsoft Excel 2019: Build practical models for forecasting, valuation, trading, and growth analysis using Excel 2019Shmuel Oluwa