Financial Modeling with Excel

Description

A financial model links assumptions about revenue and costs to cash flow and value. These ten PDF lessons teach modeling in Excel from the basics: how the financial statements connect, how to build a revenue forecast, and how to project expenses and analyze margins.

You go on to working capital, cash flow, dynamic three-statement models, sensitivity analysis and scenario planning, plus time value of money and capital budgeting. The last lesson works through a complete case study. Exercises in most lessons build your skills step by step. By the end you can build a linked model from scratch and test how its results change when assumptions change.

Who it is for: finance students, analysts and business owners with basic Excel skills who want to build financial models.

What’s included
10 PDF lessons · 56 pages · about 19,500 words
One ZIP download that is yours to keep — read on any device, no subscription or app needed.

Course programme

1. Getting Started with Financial Modeling Basics
2. Understanding Financial Statements and Their Connections
3. Building Your First Revenue Forecast Model
4. Expense Projections and Margin Analysis
5. Working Capital and Cash Flow Modeling
6. Creating Dynamic 3-Statement Financial Models
7. Sensitivity Analysis and Scenario Planning
8. Time Value of Money Calculations
9. Capital Budgeting and Investment Decisions
10. Putting It All Together: Complete Case Study

Excel is a trademark of its owner. This course is independent and is not affiliated with, endorsed or sponsored by the trademark owner.