Course Hive

Master Financial Modeling: Excel Tips & Business Valuation

Master Financial Modeling: Your Complete 2024 Guide to Excel, Valuation & Analysis!

4.4 (46)
320 learners

What you'll learn

Develop proficiency in building 3-statement financial models using Excel.
Master the concepts of discounted cash flow models and company valuation analysis.
Gain skills in automating accounting processes and preparing financial statements in Excel.
Learn to create dynamic financial models that automatically update with changes.

This course includes

  • 33 hours of video
  • Certificate of completion
  • Access on mobile and TV

Course content

1 modules • 43 lessons • 33 hours of video

Advanced Financial Modeling and Analysis in Excel
43 lessons • 33 hours
  • Build A 3-Statement Financial Model Like A Pro In 2024 | Excel Tips and Tricks01:35:47
  • Financial Planning and Analysis (FP&A): Budgeting and Forecasting in Excel 101:15:56
  • How to Build Discounted Cash Flow (DCF) Models From Scratch | Excel | Step By Step Guide01:49:19
  • Part 1: Financial Modeling & Business Valuation Full Course | Introduction to the Financial Model51:59
  • Interpretation and Analysis of Financial Statements: Part1 (Interpretation)01:12:00
  • How to Automate Accounting Ledgers, Extract a Trial Balance & Prepare Financial Statements in Excel02:10:45
  • Financial Planning & Analysis (FP&A): Building a 12-month Rolling Cash Flow Forecast01:18:40
  • How To Prepare Financial Statements in Excel | Financial Accounting | ACCA | CA01:36:25
  • Discounted Cash Flow (DCF) Model | Company Valuation Analysis | Financial Modeling Full Course01:22:54
  • How To Build a World-Class Financial Model In 2024 | Step by Step Tutorial14:19
  • Build A Dynamic Financial Model That Updates With One Click | Step By Step Guide58:47
  • Part 2: Modeling the Income Statement | Financial Modeling & Valuation Full Course01:09:09
  • Part 3: Modeling the Cash Flow Statement | Financial Modeling & Valuation Full Course52:12
  • Methods of Business Valuation (Part 1) | Advanced Accounting & Financial Management33:10
  • Become A Data Analyst Vs Financial Analyst | 2024 Career Roadmap18:38
  • Regression Analysis in Excel with ChatGPT | Step by Step Tutorial | Statistics Course27:43
  • Financial Planning and Analysis (FP&A): The Cash Budget and Master Budget Tutorial01:09:08
  • Methods of Business Valuation (Part 2): Practical Scenario with Solution Guide41:48
  • Build A 3-Statement Model Like a Pro | Adding Visualizations to Your Financial Models36:21
  • Differentiate Constants from Formulas in your Financial Model with a Single Click #exceltips #shorts02:35
  • Part 5: How to Build the PP&E/Depreciation Schedule | Supporting Schedules for Financial Models36:10
  • Introduction to Company Valuation: Multiples, Enterprise & Equity Values, Comps, DCF & Precedent01:11:02
  • Build the Football Field Chart | Company Valuation Summary | Financial Modeling Full Course 202531:33
  • DCF Tutorial: How to Calculate the WACC & Growth Rate for A Financial Model33:04
  • Part 4: Introduction to Modeling the Balance Sheet | Financial Modeling Full Course22:56
  • Income Statement Standard Elements for Financial Modeling #corporatefinance #finance #shorts02:57
  • Part 8: Finalizing the 3-Statement Model, Build the Debt Schedule & Deal with Circular References01:04:59
  • Discounted Cash Flow Analysis - Net Present Value | Investment Appraisal Techniques01:09:59
  • Comparable Company Analysis (Comps) | Financial Modeling and Valuation Analysis Full Course54:04
  • Build a Professional Looking DCF Model In Excel | Includes a 3 Statement Model26:43
  • Precedent Transactions Analysis (Past M&As) | Financial Modeling and Valuation Analysis Course23:43
  • Part 6: The Working Capital Schedule & Completing the Cash Flow Statement | Financial Modeling45:49
  • Part 7: How To Forecast the Balance Sheet | Completing the 3 Statement Financial Model30:01
  • How to Build a Financial Model with No Historical Data | Overview of Course14:53
  • Step by Step Financial Modeling Guide | Include Excel Tips and Tricks16:03
  • Top 20 Accounting Ratios and their Interpretations: FR | Accounting | Finance | Summary24:17
  • Introduction to Leveraged Buyout (LBO) Modelling | PE & Investment Banking Essentials50:11
  • Becoming a Financial Analyst: Roles, Skills, Top Certifications, Salary Ranges14:16
  • Top 10 Highest Paying Finance & Accounting Jobs In 2024: Minimum Requirements, Top Players17:15
  • Investment Appraisals: Internal Rate of Return (IRR) | Discounted Cash Flow (DCF) Methods | FM43:50
  • Excel Essentials for Finance, Data Analytics & Accounting Part 1 | Microsoft Excel Skills Series33:55
  • How to Use the Accounting Equation to Calculate Enterprise Value and Equity Value10:05
  • Leveraged Buyout (LBO) Modeling - Part 2: Key Players, LBO Candidates & Returns Analyses23:21

Suggest a Youtube Course

Our catalog is built based on the recommendations and interests of students like you.

FAQs