Recently Updated Pages
Linking financial statements
The first step in many financial models is linking the different financial statements together. I...
Foundations of the model
The art of financial modeling, mostly relates to making assumptions about the future performance ...
Excel tips for financial modeling
Financial modeling is really as much an art as it is a science, but there are some basic tips tha...
Getting started with the project
Building a financial model requires getting your hands dirty by actually demonstrating what will ...
Gathering data from FRED for Excel
While many financial models may not require special data, some do. In particular, if you're makin...
Sources of data
Identifying the data you need for a financial model is just the first step. You also need to actu...
Data for a model
Effective financial modeling is driven by data, but different types of models require different k...
Business questions and financial models
Financial modeling lets us evaluate very specific sets of circumstances and make decisions based ...
Why is financial modeling important?
Why should you care about financial modeling? In the next few minutes, I'll explain what financia...
What is financial modeling?
What is Financial Modeling? At its core, financial modeling is really just a business form of wha...
What you should know before watching this course
This course is intended for financial professionals interested in learning more about financial m...
Using Excel for financial modeling
Hi there, I'm Mike McDonald. I'm a professor of finance, a frequent consultant to industry, and a...
How you can use financial statements
You now know about financial statements, the accounting process, important financial accounting t...
Chapter Quiz
Which portion of the DuPont framework shows the amount of sales generated from each dollar of...
Price-earnings (P/E) ratio
Market prices incorporate all kinds of information. For example, the market prices for firms in a...
Operating ratio
A company's operating cycle is the length of time from when the company buys its inventory until ...
Debt ratio
The benefit of financial leverage is that using borrowed money allows a company to be larger with...
DuPont framework
The DuPont Framework is a tool to decompose a company's return on equity into three dimensions, p...
Common size statements
In fiscal 2018, Walmart's net income was $7.17 billion. In that same fiscal 2018 Target's net inc...
Using financial statements
The culmination of the accounting process is the production of the financial statements. And then...