Financial Modeling Using Excel

Overview:

In this course, we are going to learn how to financially model a business using Excel. Financial models underpin strategic and business planning, solicitations for financing, budgeting and forecasting, business valuations, cash budgeting, capital budgeting, and so many other corporate finance purposes. In this course, we are going to concentrate on the preparation of a financial projection of the income statement, balance sheet, and statement of cash flow. We will use an approach that keeps model integrity and credibility top of mind throughout development.  

Course Content:

In this course you will gain knowledge about the following topics:     

• Planning Your Financial Model
• Building a Model Template
• Modeling the Income Statement
• Modeling the Balance Sheet
• Modelling Cash Flows
• Advanced Financial Modeling
• Excel Features For Financial Modeling
• Course Resources
• Financial Modeling Knowledge Check
• Financial Modeling Final Exam

Who Will Benefit: 

Financial professionals, financial analysts, controllers, and finance advisors. This is a hands-on session and participants should have access to their laptops.