Learn Financial Modeling

Liquidity Ratios

Explore the importance and functions of liquidity ratios, including the Current Ratio, Quick Ratio, and Cash Ratio, in evaluating a company's ability to meet...

Stock Options

Explore the fundamentals of stock options, including the concept of calls and puts, the significance of the expiration date and strike price, and the practice...

LBO Capital Structure

Uncover the intricate details and structures of a typical leveraged buyout including insights into senior debt, high yield debt, subordinated debt, mezzanine...

Long and Short Positions

Gain a deeper understanding of long and short positions in stock trading, including what they mean, how they work, and what potential profits or losses they...

Balance Sheet

Learn the importance of a balance sheet, one of the three fundamental financial statements that offers a snapshot of a company's finances and contains three...

Accretion / Dilution

Gain an understanding of how to conduct an accretion/dilution analysis, a crucial tool for evaluating the implications of a prospective merger or acquisition...

Profitability Ratio

Explore the key profitability ratios that measure a company's ability to generate income relative to its revenue, assets, operating costs, and equity,...

LBO

Explore the intricacies of a leveraged buyout, including its definition, the role of private equity firms, the typical debt/equity ratio, the importance of...

IPO Book Building

Learn about book building—the crucial process which underwriters use to ascertain the price at which an Initial Public Offering (IPO) should be offered, along...

IPO Aftermarket Price Stabilization

Explore how the greenshoe option works during the initial public offering process, aiding underwriters in stabilizing share prices and protecting their...

IPO Process

Explore the intricacies of an Initial Public Offering (IPO), including its process, advantages, and drawbacks for a company transitioning from private to...

Consolidated Financials

Explore the intricacies of consolidated financial statements, from their role in representing a corporation's multiple divisions to the criteria for filing,...

DCF Model Overview and Steps

Discover the process of Discounted Cash Flow (DCF) modeling, a valuation method used to estimate a company's value based on its expected future cash flows,...

Exchange Ratio

Delve into the mechanics of the exchange ratio, an important tool in mergers and acquisitions that calculates the number of new shares an existing shareholder...

3 Statement Financial Modeling: Step 4

Explore this insightful video that delves into the intricacies of front-end, back-end, and full-stack development, providing valuable information and guidance...

3 Statement Financial Modeling Overview

Learn about the fundamental components and benefits of a three-statement financial model, which includes the income statement, balance sheet, and cash flow...

Financial Modeling Prerequisites

Stock Indexes

Delve into the critical role of stock market indexes such as the S&P 500, Dow Jones, and Nasdaq Composite in shaping global and country-specific economies, and...

RATE Function in Excel

Discover the most frequently used finance functions with our video series, starting with an in-depth look into the RATE function and its application in...

Future Value

Learn about the FV financial function and how it calculates the future value of an investment based on a constant interest rate, using either periodic,...