1.5: Lookup Functions

1.6: Data Validation and Conditional Formatting

1.7: Data Visualization

1.8: Dynamic Charts and Interactive Dashboard

1.9: Scenario Manager, Goal Seek and Data Tables

1.10: Financial Functions

1.11: Loan Repayment Schedule

1.12: 1234

2.1: Vertical and Horizontal Income Statement Analysis

2.2: Balance Sheet Analysis and Ratios

2.3: Cash Flow Statement Analysis and Ratios

2.4: Rates of Return and Profitability Analysis

3.1: Financial Modeling Best Practices

3.2: Model Setup and Assumptions

3.3: Forecast Revenues Down to EBITDA

3.4: Forecast Working Capital and PP&E

3.5: Forecast Capital Structure

3.6: Complete Cash Flow Statement

3.7: Review and Audit

3.8:

3.9:

4.1: Model Setup and Assumptions

4.2: Forecast Revenues Down to EBITDA

4.3: Forecast Working Capital and PP&E

4.4: Forecast Capital Structure

4.5: Complete Cash Flow Statement

5.1: Financial Modeling Best Practices

5.2: Modeling Cash Flows (Review)

5.3: Building Your Financial Model in Excel

5.4: Enhancing Your Model

5.5: Final Product

6.1: e-Commerce Business Landscape & Revenue Drivers

6.2: Building Smart Assumptions for Scalable Financial Models

6.3: Crafting a Dynamic Income Statement for Startups

6.4: Designing a Startup-Friendly Balance Sheet

6.5: Integrating Key Financial Schedules Seamlessly

6.6: Startup Cash Flow Modeling & Forecasting Techniques

6.7: Customer Metrics That Drive Growth & Valuation

6.8: Visualizing Financial Insights with Impactful Charts & Dashboards

7.1: Understanding the Gaming App Ecosystem & Revenue Streams

7.2: Building Assumptions for User Growth, Retention & Monetization

7.3: Modeling In-App Revenue, Developer Costs & Platform Fees

7.4: Constructing Financial Statements Tailored to Gaming Startups

7.5: Player Metrics & KPI Dashboards for Performance Tracking

7.6: Completing the Financial Model

7.7:

7.8:

8.1: Understanding the Risk-Free Rate through Real-World Case Studies

8.2: Exploring 4 Practical Methods to Calculate Equity Risk Premium (ERP)

8.3: Deep Dive into the Cost of Capital: Debt, Equity & Blended Rates

8.4: Converting Earnings to Cash Flows: Bridging the Gap

8.5: Forecasting Long-Term Growth with Strategic Assumptions

8.6: Structuring a Complete DCF Framework from Scratch

8.7: Calculating the Cost of Debt with Realistic Inputs

8.8: Estimating Cost of Equity Using Multiple Approaches

8.9: Determining Weighted Average Cost of Capital (WACC)

8.10: Computing Free Cash Flow to the Firm (FCFF)

8.11: Projecting Cash Flows for Forecast Period

8.12: Estimating Terminal Value Using Exit and Perpetuity Approaches

8.13: Applying the Mid-Year Convention in Valuation

8.14: Developing Base, Bull & Bear Case Scenarios

8.15: Deriving Enterprise Value and Equity Value

8.16: Conducting Sensitivity Analysis to Test Assumptions

9.1: Identifying the Right Set of Comparable Companies (Comps Universe)

9.2: Extracting Key Data from Financial Statements Efficiently

9.3: Standardizing and Spreading Financial Metrics Across Comps

9.4: Adjusting & Refining Comparables for Accuracy and Relevance

9.5: Applying EV/EBITDA Multiple for Enterprise-Level Valuation

9.6: Using EV/Revenue Multiple for Early-Stage or High-Growth Firms

9.7: Concluding Relative Valuation and Deriving Target Price Range

9.8:

9.9:

9.10:

10.1: Analyzing Business Segments, Industry Dynamics & Revenue Streams

10.2: Extracting and Cleaning Financial Data from Annual Reports & PSX Filings

10.3: Modeling Income Statement, Balance Sheet & Cash Flow Statement

10.4: Evaluating Profitability, Efficiency & Liquidity Using Ratios

10.5: Forecasting Future Financial Performance Using Market Research

10.6: Valuing the Company Using DCF & Trading Multiples

10.7:

11.1: Applying Professional Color Themes and Visual Consistency

11.2: Formatting Lines, Shapes, and Slide Titles Effectively

11.3: Using Master Slide Layouts for Uniform Design

11.4: Designing Clean Heading Bars and Well-Structured Tables

11.5: Inserting and Linking Tables Seamlessly from Excel

11.6: Importing Dynamic Charts from Excel into Presentations

11.7: Adding Background Images with Color Overlays for Impact

11.8: Using Crop-to-Shape and Image Styling Features

11.9: Animating Objects, Text, and Slides for Visual Appeal

11.10: Applying Transitions and Managing Slide Flow Smoothly

11.11: Creating Hidden Slides for On-Demand Use

11.12: Mastering Presenter View and Delivery Tools

11.13: Adding Comments and Collaborative Edits

11.14: Sharing and Exporting Presentations Professionally

12.1: Learning Best Practices for Professional and Impactful Reports

12.2: Structuring a Clear and Organized Table of Contents

12.3: Writing a Concise and Insightful Executive Summary

12.4: Crafting a Compelling Company Overview Section

12.5: Designing Section Dividers for Better Navigation

12.6: Inserting and Formatting Tables and Charts Effectively

12.7: Mastering Layout, Alignment, and Visual Balance

12.8: Creating Project Timelines with Visual Clarity

12.9: Drafting and Styling the Valuation Summary Section

12.10: Composing a Comprehensive Industry Overview

12.11: Writing a Strong, Insight-Driven Conclusion

12.12: Understanding Disclaimers, Footnotes & Disclosures

13.1: Introduction to M&A Modeling

13.2: M&A Modeling Process

13.3: Acquirer and Target Models

13.4: Transaction Assumptions

13.5:

13.6:

14.1: Introduction of Leveraged Buyouts

14.2: Introduction to LBO Modelling

14.3: LBO Model Bells and Whistles

14.4: LBO Modelling Deep Dive

14.5: LBO Valuation

14.6: LBO Model Design

14.7: LBO Model Sources and Uses

14.8: Building Financing Assumptions

14.9: Model Drivers

14.10: Operations Schedule

14.11: Financial Statements

14.12: Capital Structure

14.13: Debt Schedule – Revolving Credit Line

14.14: Debt Schedule – Term Loans

14.15: Debt Schedule – Subordinated Debt

14.16: Equity Schedule

14.17: Output Schedule – Credit Metrics

14.18: Output Schedule – Equity Returns

14.19: Building Excel Dashboard

14.20: Model Circularity and Checks

15.1: Cap Rates and Net Operating Income (NOI)

15.2: Land Loans and Construction Loans

15.3: Real Estate Development Model

15.4: Joint Ventures and Cash Flow Waterfalls

15.5: Financial Analysis Output

15.6:

15.7:

15.8:

15.9:

16.1: Forecast all Financial line items

16.2: Build a 3-Statement Financial Model

16.3: Calculate WACC, Growth rate, and Key metrics

16.4: Perform Valuation using DCF and Comparables

16.5:

16.6:

16.7:

16.8:

16.9:

17.1: Forecast all Financial line items

17.2: Build a 3-Statement Financial Model

17.3: Calculate WACC, Growth rate, and Key metrics

17.4: Perform Valuation using DCF and Comparables

17.5:

17.6:

18.1: Principles of Effective Presentation

18.2: Amazon Sample Presentation Walkthrough

19.1: Introduction of Leveraged Buyouts

19.2: Introduction to LBO Modelling

19.3: LBO Model Bells and Whistles

19.4: LBO Modelling Deep Dive

19.5: LBO Valuation

19.6: LBO Model Design

19.7: LBO Model Sources and Uses

19.8: Building Financing Assumptions

19.9: Model Drivers

19.10: Operations Schedule

19.11: Financial Statements

19.12: Capital Structure

19.13: Debt Schedule - Revolving Credit Line

19.14: Debt Schedule - Term Loans

19.15: Debt Schedule - Subordinated Debt

19.16: Equity Schedule

19.17: Output Schedule - Credit Metrics

19.18: Output Schedule - Equity Returns

19.19: Building Excel Dashboard

19.20: Model Circularity and Checks

19.21: Model Review and Summary