About Course
The objective of financial modeling is to combine accounting, finance, and business metrics to create an abstract representation of a company in Excel, forecasted into the future. In other words; financial modeling is a representation in numbers of a company’s operations in the past, present, and the forecasted future. Such models are intended to be used as decision-making tools. Financial models are used to estimate the valuation of a business or to compare businesses to their peers in the industry.
Course Content
Financial Modeling Tutorials by CFI – Corporate Finance Institute
-
Lesson-1: Link the 3 Financial Statements in Excel
41:42 -
Lesson-2: Discounted Cash Flow (DCF) Formula
04:15 -
Lesson-3: Enterprise Value vs Equity Value
02:40 -
Lesson-4: Overview of the Capital Markets: Key Players
03:26 -
Lesson-5: Learn Accounting Fundamentals
01:57 -
Lesson-6: How to Read a Financial Statement
03:05 -
Lesson-7: Financial Analysis Fundamentals
02:08 -
Lesson-8: How to Build a Financial Model in Excel
22:47 -
Lesson-9: Fixed Income Fundamentals
02:20 -
Lesson-10: Behavioral Finance Fundamentals
02:03 -
Lesson-11: Sensitivity Analysis for Financial Modeling
34:17 -
Lesson-12: How to Build a Forecasting Model in Excel
19:24 -
Lesson-13: Excel Crash Course for Finance Professionals
01:15:58 -
Lesson-14: Mining Financial Modeling & Valuation Course
26:57 -
Lesson-15: eCommerce Startup Valuation
28:47 -
Lesson-16: How to Write Macros in Excel – VBA Tutorial
27:33 -
Lesson-17: How to Calculate Net Present Value, Annuity & Perpetuity
17:46 -
Lesson-18: Introduction to Corporate Finance
01:07:41 -
Lesson-19: Advanced Excel Formulas
02:08 -
Lesson-20: Goal Seek Function for What If Analysis – Excel Tutorial
03:01 -
Lesson-21: Audit Financial Models in Excel with GO TO SPECIAL
02:24 -
Lesson-22: Learn About All the Steps in an M&A Deal
03:06
