Introduction to Finance Accounting Modeling and Valuation
What you’ll learn
#1 Best Selling Accounting Course on Udemy (Learn Finance and Accounting the Easy Way)!
Analyze and understand an income statement (even if you have no experience with income statements).
Analyze and understand a balance sheet (even if you have no experience with balance sheets).
Analyze and understand a cash flow statement (even if you have no experience with cash flow statements).
Understand and use modeling best practices so you can create financial models.
Know where to get data in order to build a financial model (in depth understanding of identifying and using/navigating the best free websites and sources to build your financial model)!
Create a financial model (projecting the future) for an income statement.
Create a financial model (projecting the future) for a balance sheet.
Create a financial model (projecting the future) for a cash flow statement.
Understand valuation best practices so you can create target prices based on your financial models.
How to use Discounted Cash Flow (DCF) and how to create the Weighted Average Cost of Capital and Terminal values in order to pick target prices.
How to use P/E in order to pick target prices.
How to use P/R in order to pick target prices.
Other valuation methodologies, including EV/Sales, EV/EBITDA, P/B, EV/FCF, etc.
Come up with a target price based on an average of several different valuation methodologies.
Analyze the total addressable market for a company you are doing research on.
Analyze financial statements using profitability ratios: Gross Margin (Cost of Goods Sold / Revenue), Operating Margin (EBITDA/ Revenue), Net Profit Margin (Net Income / Revenue), Return on Assets (Net Income / Assets) and Return on Equity (Net Income / Equity).
Analyze financial statements using debt and inventory formulas: Debt to Assets (Total Liabilities/ Total Assets), Debt to Equity (Total Liabilities/ Total Equity), Interest Coverage Ratio (EBITDA / Interest) and Inventory Days on Hand (Inventory / Cost of Good Sold) * 365.
Analyze and compare companies using the following formulas: Price / Earnings, PEG (P/E / Growth), Price / Revenue, EV/EBITDA, EV/Sales, Price/Free Cash Flow and Price / Book.
We will do an extremely in depth professional accounting, finance, modeling and valuation analysis of LinkedIn using the accounting and finance methodologies used in this course (you will also have many exercises to complete that will help you understand accounting, finance, valuation and modeling).
You don’t need to have any accounting or finance experience as we will cover all of the concepts from scratch. A requirement is that you have access to and a very basic understanding of how to use Microsoft Excel as we will use Microsoft Excel in the course as we will be analyzing and creating a Balance Sheet, Income Statement and Cash Flow Statement. We will also learn how to create the following from scratch using Microsoft Excel: financial models so we can come up with target prices using Discounted Cash Flow, the Weighted Average Cost of Capital, Price to Earnings, Price to Revenue, etc. – again all from scratch (assuming you have no or some accounting/finance knowledge).
Section 1: Course Introduction
Lecture 1 Thank You Message from Chris
Lecture 2 Course Introduction & Who is this Course For?
Lecture 3 How to Ask me Questions Live on my Weekly Webcast (Includes Zoom)
Section 2: Accounting Part 1 of 3: Income Statement Analysis
Lecture 4 Why is the Income Statement Important & How Can It Help You Achieve Your Goals
Lecture 5 Income Statement Explanation
Lecture 6 Income Statement Example and Analysis
Lecture 7 Income Statement Analysis Exercise
Lecture 8 Income Statement Analysis Exercise Answers Explanations
Section 3: Accounting Part 2 of 3: Balance Sheet Analysis
Lecture 9 Why is the Balance Sheet Important & How Can It Help You Achieve Your Goals
Lecture 10 Balance Sheet Explanation
Lecture 11 Balance Sheet Example and Analysis
Lecture 12 Balance Sheet Analysis Exercise
Lecture 13 Balance Sheet Analysis Exercise Answer Explanations
Section 4: Accounting Part 3 of 3: Cash Flow Statement Analysis
Lecture 14 Why is the Cash Flow Statement Important+How Can It Help You Achieve Your Goals
Lecture 15 Cash Flow Statement Explanation
Lecture 16 Cash Flow Statement Example and Analysis
Lecture 17 Cash Flow Statement Analysis Exercise
Lecture 18 Cash Flow Statement Analysis Exercise Answer Explanations
Lecture 19 Financial Statement Analysis Conclusion (How All 3 Statements Are Related)
Section 5: Financial Modeling Part 1 of 4: Introduction and Best Practices
Lecture 20 Why is Financial Modeling Important & How Can It Help You Achieve Your Goals
Lecture 21 Financial Modeling Best Practices
Section 6: Financial Modeling Part 2 of 4: Where Do I Get Historical Data From?
Lecture 22 Why is Investor Relations+SEC.Gov Important & How Can It Help Me Build Models?
Lecture 23 Introduction to Investor Relations (A Great Model Data Source)
Lecture 24 SEC.gov is Another Great Model Resource
Lecture 25 Yahoo Finance is Also a Great Model Resource
Lecture 26 What Quarterly Earnings Call & Why Is It Important for Modeling Purposes?
Section 7: Financial Modeling Part 3 of 4: Case Study: Building a Model for LinkedIn
Lecture 27 Case Study Introduction and What You Will Learn in this Section
Lecture 28 Qualitative Analysis on LinkedIn
Lecture 29 What is the Total Addressable Market for LinkedIn and Why is this Important?
Lecture 30 LinkedIn Model Introduction
Lecture 31 LinkedIn Model Discussion in More Detail (Historical Data Only)
Lecture 32 Forecasting the LinkedIn Model
Section 8: Financial Modeling Part 4 of 4: Financial Model Exercise
Lecture 33 Financial Modeling Exercises Introduction
Lecture 34 Financial Modeling Exercise
Lecture 35 Modeling Exercise Answer Explanations
Section 9: Valuation Part 1 of 6: Introduction and Best Practices
Lecture 36 Introduction to Valuation
Lecture 37 More Detail on Growth Versus Value and P/E + P/R + DCF Overview
Lecture 38 25 Valuation and Modeling Best Practices
Section 10: Valuation Part 2 of 6: Discounted Cash Flow (DCF)
Lecture 39 What is DCF, Why is it Important and How Does it Work?
Lecture 40 Calculating the Terminal Value
Lecture 41 Calculating the Weighted Average Cost of Capital (WACC)
Lecture 42 DCF Example
Lecture 43 DCF Exercise
Lecture 44 DCF Exercise Answer Explanations Part 1 of 2
Lecture 45 DCF Exercise Answer Explanations Part 2 of 2
Section 11: Valuation Part 3 of 6: Price to Revenue
Lecture 46 What is Price / Revenue and Why Do We Need to Base a Target Price on this Ratio?
Lecture 47 Price to Revenue Example
Lecture 48 Price to Revenue Valuation Exercise
Lecture 49 Price to Revenue Exercise Answer Explanations
Section 12: Valuation Part 4 of 6: Price to Earnings & Additional Valuation Methodologies
Lecture 50 Introduction to P/E and Why it Matters
Lecture 51 Price to Earnings Example
Lecture 52 Price to Earnings Valuation Exercise
Lecture 53 Price to Earnings Exercise Answer Explanations
Lecture 54 Additional Valuation Methodologies
Section 13: Valuation Part 5 of 6: Final Target Price Calculation & “TAM Sanity Check”
Lecture 55 Our Final Price Target Calculation
Section 14: Valuation Part 6 of 6: Valuation Part 6 of 6 Comparing TAM to the Target Price
Lecture 56 Using the TAM to Verify How Realistic Our Target Price Is
Section 15: Assessing Financials with Formulas
Lecture 57 Introduction to Formulas
Lecture 58 Amazing Formulas to Assess Financials
Lecture 59 Exercise on Using Formulas
Lecture 60 Discussion of the Answers to the Formulas Exercise
Section 16: Bonus Materials
Lecture 61 Bonus Items
Section 17: Course Conclusion
Lecture 62 Conclusion
Anyone interested in how accounting works (no prior accounting experience is needed).,Anyone interested in how finance works (no prior finance experience is needed).,Anyone interested in how modeling works (no prior modeling experience is needed).,Anyone interested in how valuation works (no prior valuation experience is needed).,Anyone interested in how financial ratios works (no prior financial ratios experience is needed).
Udemy | English | 4h 21m | 3.85 GB
Created by: Chris Haroun
You Can See More Courses in the Business >> Greetings from CourseDown.com