In a 3-statement financial model, which financial statement is typically built first?
Financial Modeling
Question · Easy
Would you rather: money now or later
Short
What does WACC stand for in the context of valuation?
Dcf Valuation
Profit metric that starts with operating income and adds back two non-cash expense items.
Guess the Term
Introduction
Current Exam Facts
Study guide
Which Excel function returns the present value of a series of future cash flows at a constant discount rate?
Excel
Read the clue and guess the term in 6 tries.
Game
Which of the following is NOT a component of Enterprise Value (EV)?
Outlay for long-lived physical assets that is recorded on the balance sheet rather than expensed immediately.
Depreciation expense appears on which two financial statements?
Financial Statements
What is the formula for Free Cash Flow to the Firm (FCFF)?
Question · Medium
Day-to-day costs of running a business, such as rent, wages, and utilities.
Program Path and How to Use This Guide
In a DCF model, which method is most commonly used to calculate terminal value?
Swap tiles to line up three of the same term.
Term Match
What is the purpose of a sensitivity analysis in financial modeling?
Balance-sheet measure of short-term liquidity found by subtracting current liabilities from current assets, excluding cash and debt.
Which financial ratio measures a company's ability to pay its short-term obligations?
Financial Analysis
In Excel, which function is generally preferred over VLOOKUP for financial modeling because it can look up values in any direction?
Word after "business" for a key input that causes revenue or cost to change in a model.
Chapter 1: Accounting Foundations
1.1 Accounting Principles
What is the key difference between EBIT and EBITDA?
Flip two cards at a time to find matching terms.
Term Pairs
A company has revenue of $500M, COGS of $300M, and operating expenses of $100M. What is its operating margin?
Word after "profit" for the ratio of earnings to revenue, reported at gross, operating, or net level.
In a 3-statement model, an increase in accounts receivable from one period to the next represents what on the Cash Flow Statement?
Which valuation method compares a company's financial multiples to those of similar publicly traded companies?
Income-statement line for the direct outlays tied to the products a company makes.
Statements and inventory
1.2 Reading Financial Statements
What does the XNPV function in Excel do that the NPV function does not?
Find five hidden terms in a grid of letters.
Term Search
In financial modeling, what is the purpose of a circular reference involving interest expense?
Question · Hard
U.S. rulebook that publicly traded companies must follow when releasing financial statements.
What is the beta coefficient used for in the CAPM formula?
A company's EV/EBITDA multiple is 10x and its EBITDA is $50M. What is the implied Enterprise Value?
Accounting rulebook set by the IASB that companies in more than 140 jurisdictions are required to use.
1.3 Accounting Decisions in Models
Which section of the Cash Flow Statement includes capital expenditures?
Finance Exam Prep Podcast
Listen on Spotify
Podcast
In scenario analysis, what is the typical approach for modeling upside, base, and downside cases?
Inventory method that assumes the earliest units bought are the earliest ones used up.
What is the difference between levered and unlevered free cash flow?
What does the Excel function =IFERROR(A1/B1, 0) do?
Inventory method that charges the newest purchase costs to cost of sales before older layers.
Chapter 2: Time Value and Capital Budgeting
2.1 Time Value of Money
Which of the following best describes the concept of 'Days Sales Outstanding' (DSO)?
In an M&A transaction, what does 'accretion/dilution analysis' measure?
Mergers And Acquisitions
Valuation approach that turns projected future free funds into present value without deducting the initial investment.
Valuation
Loading more…