Introduction to Financial Modeling for Beginners
4.3 (1,173 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
16,206 students enrolled

Introduction to Financial Modeling for Beginners

Learn how to build your first financial models in Excel from scratch.
4.3 (1,173 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
16,206 students enrolled
Last updated 5/2020
English
English [Auto-generated]
Current price: $72.99 Original price: $104.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6 hours on-demand video
  • 3 articles
  • 18 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Understand the essentials of financial modeling using Excel
  • Understand the financial modeling process
  • Be able to build their first financial forecast model in Excel
  • Be able to build their first financial reporting model in Excel
  • Be able to build their first financial decision making model in Excel
  • Be proficient in financial model design
  • Understand core concepts in finance
  • Know the business of lemonade stands inside out!
Requirements
  • Microsoft Excel 2010 or newer
Description

Arun Mohan - 5 Stars

“The experience was an enlightening one as I was a novice in Finance and Excel and this Class was best fit for me. I could understand everything as the instructor took time to explain at a good pace and patiently introduced excel as well as accounting methods. Looking forward to getting acquainted with more of Finance.”

 

Ethan Wong - 5 Stars

“The course was designed very well, with clear explanations of the topic matter. Having the instructor show you everything step-by-step was very useful for learning. Also, having the excel spreadsheets to practice on was perhaps the most useful thing for me.”

 

There are THREE things you need to do in order to learn financial modeling:

            1.         You need to understand the key concepts of Finance

            2.         You need to understand the relevant features & techniques in Excel

            3.         You need to be able to put both of those together in practice.

 

 

You're reading this because you have an interest in learning financial modeling for your work or a desire to get into corporate finance.

 

We did too many years ago.

 

But when we first started out, we wasted a lot of time and effort learning useless and unnecessary information and techniques.

 

It didn't have to be as painful and time-consuming as it was.

 

That's why we created this course,  so you can avoid making the same mistakes that we made and learn financial modeling fast with no wasted effort. 

 

You DON’T have to learn everything about finance or Excel to become proficient at financial modeling.

 

You just need to know the RIGHT concepts and the RIGHT tools in each to get started.

 

Now why should you learn from us?

 

I’m proud to say that I have an MBA from Stanford University and have worked on many commercial real estate properties across a dozen asset types in multiple markets. I even helped create the underwriting standards for a 2000-store private restaurant chain, helping them open new locations around the world.

 

And as a licensed broker and real estate consultant, I've helped many private clients with locating, evaluating, and structuring investment opportunities including multi-million dollar commercial property acquisitions and 1031 exchanges.

 

My co-instructor, Brandon Young, has a Masters in Real Estate Finance & Development from the University of North Carolina Charlotte as well as a Masters in Finance from Tulane University. He has over a decade of combined financial and real estate experience, including acquisitions and development.

 

We've been living and breathing in financial models for practically our entire careers.

 

Andrés Soto - 5 Stars

A really good course for beginners. Right now I understand everything.” 


Henry Taatjes - 5 Stars

"great instructors, great content”


Brady Burba - 5 Stars

“After reaching this point I see the training is going deeper into Excel and how to utilize the many tools and formulas Excel offers, without training on topics that are not relevant to my needs. Thank you!”

 

What if I don't have any Finance or Excel background?

 

No worries! This is an introductory course and it assumes ZERO prior knowledge or experience.  It is condensed because we've curated only the most relevant and useful topics to get you going fast.  

 

What will I be able to do after I take your course?

 

After taking our course, you will be:

•           Able to confidently speak to key finance, accounting, and modeling concepts

•           Able to use over a dozen of the most useful Excel features & techniques

•           Able to construct three distinct financial models from scratch

 

What’s with the lemonade stand?

 

Learning Excel or finance on their own is tough enough, and learning them at the same time can be extra challenging.  To further muddy the waters by asking students to learn an arbitrary business model would be unnecessarily confusing and a waste of time.   


But even with a simple business model such as a lemonade stand, you'll be surprised by how complex and sophisticated the analysis can become.

 

What’s holding you back?

 

Are you afraid this course won’t work?  I promise you it will.

 

Are you afraid this course will work and you’ll actually have to start investing? I think that’s a pretty good problem to have.

 

Are you afraid it will take time and effort? It will. Real estate isn’t an easy business, if it was everyone would do it. But if you put in the work I promise you’ll see results.

 

Best of all, there is absolutely ZERO risk. Udemy gives you a 30-day money back guarantee to ensure you get what you pay for.

 

So go ahead, sign up and let’s get to work right away!

Who this course is for:
  • Meant for students who want to become proficient in financial model but have little to no experience in Finance and/or EXCEL.
  • Want to learn financial modeling without worrying about whether they're learning unnecessary stuff
  • Want to learn from instructors who have relevant industry experience who understands the concepts AND knows what is relevant in practice
  • People who want to learn Financial Modeling from accessible instructors
Course content
Expand all 59 lectures 06:14:24
+ Intro to the Course
3 lectures 21:05

Quick message for students

Preview 00:57
Udemy Technical Issues
00:55

Overview of some useful Udemy features like speeding up lectures, bookmarking, downloading files, and how to to ask questions to the Q&A forum.

Preview 19:13
+ Jumpstart
6 lectures 23:58

Take the course in order and don't skip around unless you have a existing background in finance and have some moderate skill level in Excel already.  

Preview 01:20

Welcome to the course, this section introduces you to financial modeling. Learn about the financial modeling process, financial model design, and complete a short case study!

Preview 00:45

Learn about the financial modeling process and how to identify the different types of financial models.

Preview 02:20

Learn about financial model design and best practices for building financial models. 

Jumpstart - Financial Model Design
03:24

Learn how to create a mortgage calculation model in Excel. You'll also learn how to create an amortization schedule that shows how the mortgage loan amortizes over time.

Jumpstart - Introduction Case Study - Part 1
07:55

This is part 2 of the introduction case study on building a mortgage calculation model.

Jumpstart - Introduction Case Study - Part 2
08:14
+ Important Finance & Accounting Principles
10 lectures 35:05

Taking this section is like eating veggies--it might not always taste the best, but it'll be good for you.  Promise!

Preview 01:37

This lecture discusses the balance sheet, accounting equation, and capital structure.

Preview 02:40

Learn how to read and interpret the information contained on the income statement. 

Income Statement
02:05

This lecture covers the primary elements of the statement of cash flows.

Statement of Cash Flows
02:11

This lecture covers the financial forecasting process and the important items you should take into consideration when developing a financial projection.

Financial Forecasting Process
01:42

Here we cover the time value of money and how to calculate the value of a payment or series of payments at different points in time. 

Time Value of Money
06:15
Capital Asset Pricing Model
00:13

Learn about the cost of debt and equity and how those two items are combined to calculate the weighted average cost of capital (WACC).

Weighted Average Cost of Capital
09:59

Learn about the various investment return metrics like internal rate of return (IRR), net present value (NVP), return on equity (ROE), equity multiple, and peak capital. 

Investment Return Metrics
07:43

This section summarizes what you learned in the finance and accounting section. Congratulations, you're now ready for Excel!

SUMMARY: Finance & Accounting Priciples
00:40
Finance & Accounting Concepts
5 questions
+ Important Excel Features & Techniques
16 lectures 01:31:50

Don't skip this section!  All the case studies assume you have a solid understanding of these Excel features & techniques.

Preview 01:53

Learn how to anchor or lock in cells, rows, and columns in order to create more efficient formulas. This is important, we'll use these techniques a lot in the case studies!

Preview 05:04

Learn how to create drop-down lists in Excel using data validation. This is a neat trick that will enable to expand the functionality of your financial models.

Preview 06:16

Learn to use conditional functions in Excel like SUMIF, COUNTIF, and AVERAGEIF.

Conditional Functions
03:18

This lecture covers how to create and utilize named ranges. Named ranges are a big help when you're using lookup and reference functions.

Named Ranges
03:23

Learn to create conditional statements using the IF, AND, and OR functions.

Conditional Statements
09:20

Learn how to use the most important financial functions like IRR, PV, and NPV. You'll also learn how to calculate various payments using the PMT, IPMT, and PPMT functions.

Financial Functions
08:45

In this section we cover how to use the VLOOKUP, HLOOKUP, and MATCH functions. This is a really important lecture that will take your skills to the next level!

Reference and Lookup Functions
15:09

Tired of getting formula errors? I'll show you how to manage those errors and track down the root cause. 

Dealing with Formula Errors
04:44

Here we cover how to import data from external sources like databases, websites, and text files. 

Importing External Data
05:42

PivotTables and PivotCharts are very powerful Excel tools and I'll show you how to use both. 

Leveraging PivotTables & PivotCharts
08:26

Use solver to quickly manipulate decision variables to reach your desired outcome. We'll cover how to set solver up within Excel and teach you how to use it. 

Using Solver
02:45

In this lecture you'll learn about data tables and how to set up a sensitivity analysis. Both one and two variable data tables are covered.

Data Tables
05:18

Tired of doing the same thing over and over? Learn how to record a macro and automate your work tasks. 

Recording Macros
06:38

Security is important! Learn how to secure your workbooks, worksheets, and manage the user input process. 

Workbook and Worksheet Security
04:35

This section summarizes what you learned in the finance and accounting section. Congratulations, you're now ready for the first case study!

SUMMARY: EXCEL Features & Techniques
00:34
Excel Features & Techniques
5 questions
+ Building a Financial Forecast Model
7 lectures 01:02:01

Meet Lucy, teen entrepreneur looking to build her lemonade empire.  And now she needs your help.

Preview 01:24

This case study teaches you how to create a financial forecasting model. You'll learn how to develop a proforma income statement, balance sheet, and statement of cash flows for Lucy and her lemonade stand.

Financial Forecasting Example Part 1
09:39

Part 2 of the financial forecasting case study. 

Financial Forecasting Example Part 2
13:39

Part 3 of the financial forecasting case study. 

Financial Forecasting Example Part 3
11:54

Part 4 of the financial forecasting case study. 

Financial Forecasting Example Part 4
12:55

Part 5 of the financial forecasting case study. Last section!

Financial Forecasting Example Part 5
11:57

This section summarizes what you learned in the financial forecasting case study. Congratulations, you're now ready for the second case study on financial reporting!

SUMMARY: Financial Forecasting Model
00:33
+ Building a Financial Reporting Model
6 lectures 41:45

Overview of Financial Reporting case study exercise.

Preview 00:38

This case study teaches you how to create a financial reporting model. You've master the art of financial forecasting, now learn how to create a model that compares Lucy's actual 2016 results to what you projected. 

Financial Reporting Example Part 1
12:58

Part 2 of the financial reporting case study. 

Financial Reporting Example Part 2
08:04

Part 3 of the financial reporting case study. 

Financial Reporting Example Part 3
07:57

Part 4 of the financial reporting case study. Last section!

Financial Reporting Example Part 4
11:33

This section summarizes what you learned in the financial reporting case study. Congratulations, you're now ready for the third case study on financial decision-making!

SUMMARY: Financial Reporting Model
00:35
+ Building a Financial Decision-Making Model
8 lectures 01:00:29

Quick overview of our third and final case study on Lucy's lemonade business.

Preview 00:51

This case study teaches you how to create a financial decision-making model. You'll learn how to develop an acquisition/valuation model that Lucy can use to start buying out her competitors in the neighborhood!

Financial Decision-Making Example Part 1
12:33

Part 2 of the financial decision-making case study.

Financial Decision-Making Example Part 2
09:11

Part 3 of the financial decision-making case study.

Financial Decision-Making Example Part 3
13:41

Correction to the peak capital calculation in the upcoming lecture.

Peak Capital
00:12

Part 4 of the financial decision-making case study.

Financial Decision-Making Example Part 4
14:26

Part 5 of the financial decision-making case study. Last section!

Financial Decision-Making Example Part 5
09:11
SUMMARY: Financial Decision-Making Model
00:24
+ Congrats
1 lecture 01:42

Well done!  You've finished this course!

Congrats!
01:42