Phase 1 Questions Flashcards
(121 cards)
What are the three main financial statements?
Income Statement, Balance Sheet, Cash Flow Statement.
How are the three financial statements linked?
Net income flows into retained earnings and operating cash flow; changes in working capital, capex, and financing flow through cash.
What is working capital?
Current assets minus current liabilities; a measure of short-term liquidity.
How does depreciation impact all three statements?
Reduces net income (IS), increases accumulated depreciation (BS), added back in operating cash flow (CF).
What’s the formula for enterprise value?
EV = Equity Value + Debt + Minority Interest + Preferred Equity – Cash.
Walk me through a DCF.
Project FCFs, calculate terminal value, discount both to present using WACC, sum for enterprise value.
What are common DCF terminal value methods?
Gordon Growth (Perpetuity) and Exit Multiple methods.
What is WACC and why is it used?
Weighted Average Cost of Capital; discount rate reflecting opportunity cost of capital for all investors.
Name 3 key valuation multiples.
EV/EBITDA, EV/Revenue, P/E.
What is precedent transaction analysis?
Compares valuation multiples from recent similar M&A deals.
What is comparable company analysis (Comps)?
Values a company using multiples of similar public peers.
What is sensitivity analysis?
Adjusts key assumptions (e.g., revenue growth, margins) to see effect on valuation or output.
What is a scenario analysis?
Evaluates outcomes across base, upside, and downside cases.
How do you calculate FCF?
FCF = EBIT (1–Tax) + D&A – CapEx – Change in NWC.
What is the purpose of an LBO model?
To assess returns from buying a company using significant debt.
What are the key drivers of IRR in an LBO?
Entry/exit multiples, EBITDA growth, debt paydown.
What’s a good target IRR in PE?
Typically 20%+ depending on risk.
What is the debt service coverage ratio?
EBITDA ÷ (Interest + Principal Payments); shows ability to cover debt.
How does equity value differ from enterprise value?
Equity value is value to shareholders; EV includes debt and cash neutrality.
What is circular referencing in Excel models?
When a formula indirectly refers to its own result; often seen in interest or revolver calculations.
How do you resolve circular references in Excel?
Use iteration settings, or calculate interest with prior-period values.
What are common Excel shortcuts for modeling?
Ctrl + Arrows (navigation), Alt + E S V (paste values), F4 (anchor cell), Ctrl + 1 (format).
What is model audit best practice?
Color coding inputs/outputs, avoiding hardcoding, separating assumptions, using clear labeling.
What is the purpose of a balance check?
Ensures assets = liabilities + equity in every period.