Steps for Building a Financial Model from Scratch in Excel
Steps for Building a Financial Model from Scratch in Excel
Building a high-standard financial model transcends simply knowing how to use Excel and being good at Accounting. What would you need if given a task to build a model from scratch? This webinar will take you through the steps you need to follow to build a well structured three-statement financial model from scratch.
Agenda
1 The corporate Model 00:02;30
2 Create a model template structure; Output Sheet structure, Style Guides 00:03;00
3 Restructure ( Normalize) the P&L 00:04;56
4 Restructure the Balance Sheet 00:07;14
5 Generate Assumptions based on Historical Trends 00:10;16
6 Build the Caculations Sheet, P&L and balance sheet 00:20;08
7 Calculate cash inflow statement 00:24;34
8 link cash to balance; does it balance? 00:25;48
9 add interest caculations iterations 00:32;20
10 Insert Analysis, Sensitivities and scenarios 00:34;28
11 sponsors & end 00:41;39
Videos contain tips, tricks, best practices and methodologies for improving the productivity of analysts in any field using Excel, Financial Modelling and Power BI Technologies.
Please visit our websites and resources below for even more freebies and information
http://dbrownconsulting.net/
http://www.officetraininghub.com/
https://www.meetup.com/Nigeria-Excel-...
https://www.meetup.com/FinancialModeling