Description
What You’ll Learn
This Financial Planning and Analysis Course covers the basic theory that every FP&A analyst needs to know and teaches you how to apply it in practice using real-world examples. By the end of the course, you will:
- Understand the major elements in the core financial statements (assets, liabilities, equity, revenue, and expenses)
- Learn the basics of budget preparation, what a Master Budget is, and the major approaches to budgeting
- Build a comprehensive Budget Model in Excel
- Make revenue and various expense predictions (payroll, SG&A, production costs, and overheads)
- Forecast current and non-current assets and liabilities of a fictitious company
- Learn how to prepare Budgeted Financial Statements in Excel—Income Statement, Balance Sheet, and Cash Flow Statement