Financial Statement Modeling and Analysis in Excel
Accounting and Finance
Training
Provided by Vair Training, LLC
Financial Statement Modeling and Analysis in Excel demonstrates how financial models guide commercial discussions. Participants will learn how to negotiate off the financial model.
This course will utilize a Discounted Cash Flow ("DCF") pro forma approach derived from a full suite of financial statements: 1) Income Statement, 2) Statement of Retained Earnings, 3) Balance Sheet and, 4) Statement of Cash Flow. Participants use "hot keys" and page-setup techniques to build a fully integrated pro forma DCF model from a list of assumptions. The "mouseless" Excel techniques employed dramatically reduce model coding time. Next, delegates learn how to integrate all financial statements to produce a correctly-balanced Balance Sheet, without circularities. The class will use this model as a guide to review commercial issues, negotiate strategies and analyze financial ratios. Finally, the course demonstrates the power of Monte Carlo simulation analysis creating a dynamic decision-making tool and elevating beyond simple static input and output spreadsheets.
Related Jobs or Careers: Financial Analysts, Investment & Evaluation Professionals, Business Development Planners, Mergers & Acquisitions Specialists, Ac
|
|
||||||||||
Financial Statement Modeling and Analysis in Excel
Training Program Details
Part 1 - Introduction to Excel
Part 2 - Introduction to Financial Statements
Part 3 - Introduction of a Pro Forma Model
Part 4 - Assets: Purchasing versus Leasing
Part 5 - Operational Worksheets
Part 6 - Debt
Part 7 - Coding Full Financial Statements
Part 8 - Discussion on Valuation
Part 9 - Discounted Cash-Flow Modeling
Part 10 - Using the Model to Price the Asset
Part 11 - Monte Carlo Simulation Analysis
Part 2 - Introduction to Financial Statements
Part 3 - Introduction of a Pro Forma Model
Part 4 - Assets: Purchasing versus Leasing
Part 5 - Operational Worksheets
Part 6 - Debt
Part 7 - Coding Full Financial Statements
Part 8 - Discussion on Valuation
Part 9 - Discounted Cash-Flow Modeling
Part 10 - Using the Model to Price the Asset
Part 11 - Monte Carlo Simulation Analysis
About The Training Provider: Vair Training, LLC
Vair Training, LLC - Vair Training offers open-enrollment and in-house Financial Modeling courses to the international energy/ infrastructure and financial communities. Courses include general Financial Modeling and advanced master classes for Project Finance, Infrastructure, P3, Renewables and Asset Management.
Vair takes a very quantitative approach to training - these are not PowerPoint-based presentations...
