Financial Model Fundamentals-Learn the Essential Skills
Learn to create full financial models including cash flow, working capital, debt and equity calculations.
4.40 (25 reviews)
164
students
2.5 hours
content
May 2015
last update
$39.99
regular price
What you will learn
Create full financial models
Understand debt and equity calculations
Understand the Excel formulas essential for models
Use best practice for user-friendly and robust models
Why take this course?
This course is for business owners, managers, finance professionals or business students who want to learn to build financial models.
If you have basic Excel skills and a basic understanding of financial concepts, you will be able to follow the course.
I teach step-by-step, from simple steps like creating our input sheet to advanced calculations like cost of capital and share buy backs.
Only essential skills are taught; I don't waste time on skills you don't need.
The course is great value for money and it's far easier to learn to build financial models with my video course than trying to learn from a book.
Content
How to Use This Course
Introduction
Debt Equity Model
Debt Equity Model Introduction
Input Sheet for Debt Equity Model
Name Ranges
Input Sheet Name Ranges for Debt Equity Model
Calculation Sheet for Debt Equity Model
Debt and Equity Calculations
Debt Calculations
Capital Expenditure and Depreciation
Equity Calculations Introduction
Equity Calculations for Debt Equity Model
Balance Sheet, Working Capital and Cash Flows
Balance Sheets Introduction
Working Capital Introduction
Balance Sheet for Debt Equity Model
Cash Flow Introduction
Cash Flow for Debt Equity Model
Fixing a Model and the Output Sheet
Auditing and Fixing Formulas
Challenge - Balance the Balance Sheet
Output Sheet for Debt Equity Model
Challenge - Summary Balance Sheet & Cash Flow
Ratio Analysis
Financial Ratios and Debt Covenants
Adding Ratios to the Financial Model
Dividends, Cost of Capital and Share Buy Backs
Dividends
Weighted Average Cost of Capital
Introduction to Share Buy Backs
Adding Share Buy Backs to the Financial Model
Challenge - WACC Table
Conclusion
Conclusion
Screenshots
Charts
Price
Rating
Enrollment distribution
Related Topics
476880
udemy ID
4/15/2015
course created date
6/12/2020
course indexed date
Bot
course submited by