3 min read
WACC
Explore the concept of Weighted Average Cost of Capital (WACC), an important factor in performing Discounted Cash Flow Analysis for company valuation.
Learn Financial Modeling
Learn Financial Modeling with Training Resources & Articles
99 articles in Financial Modeling
5 min read
Working Capital
Gain insight into the concept of working capital, including the definition, calculations, and implications for a company's financial health, growth potential,...
2 min read
Free Cash Flow
Learn about the significance of Free Cash Flow (FCF), how it represents the actual amount of cash a company has at its disposal, and its importance in...
2 min read
Terminal Value
Discover the concept of Terminal Value and explore the two primary methods used to calculate it—the Perpetual Growth (Gordon Growth Model) and Exit Multiple...
5 min read
Deferred Tax Assets and Liabilities
Explore the intricacies of deferred tax assets and liabilities, and understand how they affect balance sheets, including common examples such as depreciation...
2 min read
Synergies to prevent Dilution
Explore the concept of synergy in mergers and acquisitions, where the combined value and performance of two companies exceeds that of their individual parts,...
3 min read
Strategic v. Financial Buyer
Discover the difference between strategic and financial buyers, their unique approaches to business acquisitions, and how they generate returns on investment.
4 min read
Stress Testing Financial Models
Discover the importance of stress testing in improving the quality of a financial model and learn about various checks that can be placed within an Excel model...
5 min read
Journal Entry Examples
Gain a deeper understanding of the accounting process by learning how to create journal entries, a crucial element in recording business transactions, and...
2 min read
Discount Factor
Dive into the process of calculating an investment's net present value by determining its discount factor and applying it to Free Cash Flow and Terminal Value...
2 min read
Balance Sheet Consolidation
Learn about the process of balance sheet consolidation, where a parent company integrates and combines its financial statements into standard-form income,...
3 min read
Consolidated Financials
Explore the intricacies of consolidated financial statements, from their role in representing a corporation's multiple divisions to the criteria for filing,...
2 min read
Trading Comps - Model 1
Explore our in-depth analysis of the financials and value drivers of three major beverage companies: Coca-Cola, Monster Beverage Corporation, and PepsiCo, with...
7 min read
FIFO and LIFO
Discover the intricacies of inventory valuation and understand how different methods can significantly impact a company's gross profit and financial position,...
3 min read
Mergers and Acquisitions Financing
Explore the complex world of M&A financing, including primary sources such as equity financing, debt financing, and the utilization of existing cash reserves.
2 min read
Accretion / Dilution in Excel
Explore the calculations behind financial processes through our instructional video and accompanying visual aids.
4 min read
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,...
3 min read
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 min read
Mergers and Acquisitions Model Overview
Learn the step-by-step process of building a mergers and acquisitions model in Excel and conducting an accretion/dilution analysis, using Google and Motorola...
3 min read
Equity Method Accounting
Learn about the equity method, a technique used to assess a company's investment in another company when significant influence is held, understanding the...
3 min read
FM Intro and Best Practices
Delve into an informative guide on the most widely used financial models and discover essential tips for reducing errors in your financial modelling process.
3 min read
Efficiency Ratios
Explore the importance of efficiency ratios such as Asset Turnover ratio, Inventory Turnover ratio, and Day Sales in Inventory, which are key measures of a...
4 min read
Market Value Ratios
Gain deeper insights into stock investing by understanding market value ratios such as Earnings Per Share and Price-Earnings Ratio, and find out how they can...
2 min read
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...
3 min read
Internal Rate of Return (IRR)
Gain a deeper understanding of the Internal Rate of Return (IRR), a crucial metric in financial analysis for determining the profitability of potential...
2 min read
NPV
Gain insight into the concept of Net Present Value (NPV), its calculation, and its significant role in capital budgeting and investment planning.
1 min read
Present Value
Discover the practical application of the financial function PV, which calculates the present value of a loan or investment based on a constant interest rate,...
2 min read
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,...
1 min read
DCF Step 1: Historical Data
Explore our comprehensive guide that gives an insight into the nuances of web development, detailing its importance in today's digital world.
1 min read
DCF Step 2: Historical Value Drivers
Explore the intricacies of coding and web development with this compelling video tutorial.
1 min read
DCF Step 3: Projected Value Drivers
Explore the intricacies of software development with our immersive training program, designed to equip you with the skills to excel in both front-end and...
1 min read
DCF Step 4: Projected Line Items
Explore our informative video to gain insight into our comprehensive training program.
1 min read
DCF Step 5: EPS
Explore how the embedded video provides a comprehensive understanding of web development concepts.
3 min read
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...
1 min read
3 Statement Financial Modeling: Step 1
Discover the intricacies of web development with our comprehensive training program that covers both front-end and back-end concepts.
1 min read
3 Statement Financial Modeling: Step 2
Explore our engaging and in-depth video tutorial on the intricacies of front-end, back-end, and full-stack development.
1 min read
3 Statement Financial Modeling: Step 3
Explore this informative video discussing key concepts in programming, providing insight into the world of front-end, back-end, and full-stack development.
1 min read
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...
1 min read
3 Statement Financial Modeling: Step 5
Explore this comprehensive video guide to understand the intricacies of front-end, back-end, and full-stack development.
1 min read
3 Statement Financial Modeling: Step 6
Explore the technological landscape with our immersive video content designed to provide a comprehensive understanding of front-end, back-end, and full-stack...
1 min read
3 Statement Financial Modeling: Step 7
Discover valuable insights about front-end, back-end, and full-stack technologies through this informative video.
1 min read
3 Statement Financial Modeling: Step 8
Explore the insightful video embedded below that presents comprehensive content for tech enthusiasts and aspirants.
4 min read
LBO Model Overview and Steps
Learn how to build a Leveraged Buyout (LBO) model in Excel, taking into account the acquisition of another company using borrowed money, the specific mix of...
1 min read
LBO Model - Step 1
Explore the comprehensive guide to web development through this enlightening video tutorial.
1 min read
LBO Model - Step 2
Explore our informative video to learn more about our innovative programs in front-end, back-end, and full-stack development.
1 min read
LBO Model - Step 3
Explore the compelling features of our comprehensive front-end, back-end, and full-stack training program in this informative video.
1 min read
Mergers and Acquisitions Model - Step 1
Explore the enriching world of coding with our comprehensive training program, designed to equip you with essential front-end, back-end, and full-stack...
1 min read
Mergers and Acquisitions Model - Step 2
Explore our insightful video that delves into the intricate details of front-end, back-end, and full-stack development.
1 min read
Mergers and Acquisitions Model - Step 3
Explore the informative video we have embedded for an in-depth understanding of our comprehensive programming resources.
1 min read
Mergers and Acquisitions Model - Step 4
Explore front-end, back-end, and full-stack development with this informative video tutorial.
3 min read
Comparables Approach
Dive into the intricacies of comparable valuation methods, including trading comps and transaction comps, and understand why valuation is as much an art as it...
4 min read
Trading Comps
Learn about the principle behind trading comparables, the process of performing trading comparables analysis, and its relevance in providing a current...
1 min read
Trading Comps - Model 2
Explore a comprehensive video guide to understand the basics of front-end, back-end, and full-stack development.
4 min read
Transaction Comps
Explore the transaction comparables model, a relative valuation methodology used in equity valuation, which involves comparing unaffected share price to the...
3 min read
Credit Rating
Dive into the complexities of credit rating, understanding its impact and significance in the global financial market, and learn how to identify potential...
4 min read
Business Risk
Explore the factors that influence a company's business risk, including country risk, industry dynamics, company position, and profitability analysis.
4 min read
Financial Risk
Explore the different types of warning signs, business and financial risk, that are considered in credit rating calculation and delve into the common financial...
4 min read
Capital Markets
Explore the intricate workings of capital markets, including the distinctions between primary and secondary markets, and understand how they differ from the...
4 min read
ECM v. DCM
Gain a thorough understanding of the equity and debt markets, their nature, risk factors, and how they operate.
4 min read
Stock Market Introduction
Explore the critical role of stock markets in a free-market economy, their functions, and the potential impact of emerging technologies such as blockchain.
5 min read
Stock Market Participants
Explore the diverse roles within the stock market ecosystem, ranging from brokers and dealers to investment bankers and arbitrageurs, and understand how they...
4 min read
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...
5 min read
Stock Exchanges
Explore the functions and varieties of stock exchanges, including auction-based exchanges like the NYSE, electronic exchanges like the Nasdaq, Electronic...
2 min read
Bid-Ask Prices
Gain a comprehensive understanding of the bid-ask spread in the stock market, how it benefits market makers, and factors that influence its size and liquidity.
3 min read
Liquid Market
Gain a comprehensive understanding of liquid markets, how they operate, and their advantages, including efficient trading and low transaction costs.
3 min read
Foreign Exchange
Discover the intricacies of the world's largest financial market, Forex, which operates 24 hours a day and handles over $5 trillion in daily transactions,...
4 min read
Spot, Forward, and Futures Markets
Discover the key contrasts and similarities among spot, forward, and futures markets, and understand the vital roles they play in financial trading and hedging...
3 min read
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...
4 min read
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...
6 min read
Stock Movements
Explore the complex factors that determine stock prices, including fundamental factors like a company's earnings, technical factors relating to market trends,...
4 min read
Black-Scholes Model
Explore the Black-Scholes model, its workings, assumptions, and limitations, as well as its application in pricing European options contracts.
4 min read
Credit Default Swaps
Explore the intricate workings of Credit Default Swaps (CDS), how they're traded, their roles in hedging risk, and how their value is determined over time.
3 min read
Interest Rates and Fed
Explore the role of the Federal Reserve in controlling the country's monetary policy, its influence on interest rates, and the reasons behind the changes in...
2 min read
Mergers and Acquisitions Accounting Overview
Dive into the complex world of acquisition accounting and learn about the two different methods, Equity Method and Consolidation, used in M&A accounting.
3 min read
Cash v. Accrual Accounting
Explore the fundamental differences between cash-based and accrual accounting methods, including their advantages and disadvantages, while being guided by the...
4 min read
Marginal v. Effective Tax Rate
Understand the difference between the effective and marginal tax rates for corporations, and explore the reasons for the discrepancy between these two rates.
5 min read
How Three Financial Statements are Linked
Gain a deeper understanding of how the three essential financial statements – income statement, balance sheet, and cash flow statement – are interconnected and...
2 min read
YOY and QOQ Comparison
Explore the importance of Year-Over-Year (YOY) and Quarter-Over-Quarter (QOQ) comparisons in evaluating a company's financial performance.
5 min read
The nature of Mergers and Acquisitions
Explore the world of mergers and acquisitions (M&A), understand the difference between the terms, and delve into examples of the biggest and most successful...
3 min read
Sources and Uses of Funds
Explore the intricacies of the Sources and Uses table in M&A transactions, including its role in detailing the total cost of a target acquisition and the...
3 min read
Income Statement Consolidation
Explore the concept of finance consolidation and its impact on income statements, with a focus on incorporating financial statements of all subsidiaries into...
3 min read
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...
2 min read
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...
4 min read
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...
4 min read
Hedge Funds, Private Equity Funds, and Investment Banks
Explore the intricacies of hedge funds, private equity funds, and investment banks, understanding their key functions, benefits, and drawbacks, to make...
4 min read
IPO Process
Explore the intricacies of an Initial Public Offering (IPO), including its process, advantages, and drawbacks for a company transitioning from private to...
3 min read
IPO Underwriting Syndicate
Delve into the roles and mechanics of an underwriting syndicate, learn about the selection of the lead left book runner, and understand how the offering price...
3 min read
IPO Roadshow
Learn about the role of an IPO roadshow, where underwriting firms and a company's executive team present an upcoming initial public offering to potential...
3 min read
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...
4 min read
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...
4 min read
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...
3 min read
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,...
4 min read
Leverage Ratios
Discover the power of leverage ratios, including the debt ratio, debt-to-equity ratio, and interest coverage ratio, and how they can inform your investment...
4 min read
Income Statement
Delve into the essential components of an income statement, from revenue/sales and cost of sales to operating expenses and net income, to better understand a...
6 min read
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...
4 min read
Cash Flow Statement
Gain a comprehensive understanding of the key aspects of a Cash Flow Statement, its three critical sections—Operating Activities, Investing Activities, and...
5 min read
Depreciation and Amortization
Gain in-depth knowledge about depreciation and amortization, their meaning, calculation, and practical implications in financial statements through this...
4 min read
GAAP v. IFRS
Understand the differences and nuances between GAAP and IFRS accounting principles and standards as they apply in the U.S. and internationally.
4 min read
Normalized Net Income
Learn about the process of normalizing net income, its importance in understanding business trends and valuation, the common non-recurring items, and detailed...