Written by students who passed Immediately available after payment Read online or as PDF Wrong document? Swap it for free 4.6 TrustPilot
logo-home
Document preview thumbnail
Preview 4 out of 32 pages
Exam (elaborations)

Financial Statement Modeling Final Actual Verified Exam Higher Education Finance Curriculum / CFI - 2026/2027 Academic Year 2026/2027 Academic Year | Verified Q&A for University-Level Finance and Investment Banking Students | FSM

Document preview thumbnail
Preview 4 out of 32 pages

Financial Statement Modeling Final Actual Verified Exam Higher Education Finance Curriculum / CFI - 2026/2027 Academic Year 2026/2027 Academic Year | Verified Q&A for University-Level Finance and Investment Banking Students | FSM

Content preview

FINANCIAL STATEMENT MODELING FINAL ACTUAL VERIFIED EXAM | CFI / HIGHER ED | 2026/2027
VERIFIED Q&A | UNIVERSITY-LEVEL FINANCE AND INVESTMENT BANKING STUDENTS




FSM FINAL

CFI
2026/2027




Financial Statement Modeling Final Actual Verified Exam

Higher Education Finance Curriculum / CFI - 2026/2027 Academic Year

2026/2027 Academic Year | Verified Q&A for University-Level Finance
and Investment Banking Students | FSM




150Q VERIFIED NEWEST EXAM RATIONALES
FINAL EXAM 2026/2027 CFI FSM




INCLUDES:
• 3-Statement Model, DCF, LBO, M&A, Valuation, WACC, Excel Best Practices
• Financial Analysis, Forecasting, Corporate Finance, Investment Banking
• 150 Verified Questions + Answers + Detailed Rationales | FSM Final
• Professional Study Guide | Borders + Page Numbers | CFI 2026/2027 Edition




Financial Statement Modeling | CFI Corporate Finance Institute | Not affiliated
Confidential Study Guide - Educational Purposes Only | 2026/2027 Edition

,3-Statement Model DCF Valuation LBO Model M&A; Model Financial Statement Modeling
Description: 3-statement model foundation financial statement modeling linking three core financial statements, Income Statement revenues less COGS gross profit less
operating expenses EBITDA EBIT less interest taxes net income, Balance Sheet Assets = Liabilities + Equity, linking net income from Income to Retained Earnings equity,
Cash Flow Statement reconciles accrual net income to cash operating investing financing activities indirect method start net income add back non-cash D&A; Deferred
Taxes stock compensation subtract increase working capital, linking cash ending balance to Balance Sheet cash, model structure historical assumptions forecast, DCF
valuation Discounted Cash Flow intrinsic valuation method, FCFF Free Cash Flow to Firm calculation EBIT*(1-tax rate)+D&A-Depreciation; Amortization-CapEx Capital
Expenditure +/- Change NWC Net Working Capital, FCFE Free Cash Flow to Equity FCFF - interest*(1-tax)+ net borrowing, WACC Weighted Average Cost of Capital
discount rate cost of capital blend Re cost equity CAPM Rd cost debt weight equity market cap weight debt, terminal value two methods Gordon Growth Model TV =
FCFF*(1+g)/(WACC-g) g perpetual growth 2-3%, Exit Multiple Method TV = EBITDA*EV/EBITDA multiple, present value discount, enterprise value to equity value bridge
minus debt plus cash, LBO model Leveraged Buyout private equity acquisition using high leverage debt financing 60-70% debt 30-40% equity, transaction structure
sources uses sources debt senior term loan A B revolving second lien mezzanine equity sponsor equity management rollover uses purchase equity fees, debt schedule
beginning balance mandatory amortization optional prepayment interest expense, returns analysis IRR Internal Rate Return MoM Multiple Money cash-on-cash exit EV -
net debt equity value, M&A; model Merger Acquisition accretion dilution analysis whether acquirer EPS increases accretive or decreases dilutive post transaction, steps
standalone acquirer target forecast synergies pro forma combined, purchase price allocation PPA excess purchase over book goodwill intangible write-up D&A;, synergies
cost savings revenue uplift, consideration cash stock mix, pro forma Income Statement combined revenue expenses synergy.

Valuation Multiples WACC Cost Capital Financial Analysis Forecasting FSM
Description: Valuation methodologies multiples market approach, EV/EBITDA Enterprise Value to EBITDA operating multiple capital structure neutral, EV/Revenue sales
multiple growth companies, P/E Price Earnings equity multiple net income, P/B Price Book, trading comps comparable company analysis steps screen comparable
universe spread metrics, precedent transactions M&A; comps control premium, DCF cross-check, WACC Weighted Average Cost Capital calculation Cost Equity via
CAPM Capital Asset Pricing Model Re = Rf + Beta*(Rm - Rf) Rf risk-free 10-year Treasury, Beta systematic risk levered unlevered Beta = Levered/(1+(1-tax)*D/E), Rm
market return market risk premium 5-6%, Cost Debt Rd yield to maturity debt interest rate, after-tax Rd*(1-tax), weights market value Equity market cap shares price Debt
book or market, formula WACC = Re*E/(D+E)+Rd*(1-tax)*D/(D+E), financial analysis ratio analysis profitability margins gross operating EBITDA net ROE Return Equity
DuPont ROA, liquidity current ratio quick, leverage Debt/Equity Debt/EBITDA interest coverage, efficiency turnover inventory AR AP, forecasting revenue build drivers price
volume market share, expense drivers COGS % revenue SG&A; headcount, working capital NWC Accounts Receivable Days Sales Outstanding DSO Inventory Days DIO
Accounts Payable DPO formula NWC = Current Assets non-cash - Current Liabilities non-debt, Cash Conversion Cycle CCC = DSO+DIO-DPO, CapEx Depreciation
PP&E; Property Plant Equipment schedule, Excel best practices modeling standards avoid hardcoding numbers in formulas separate inputs assumptions sheet blue font
for inputs black for formulas green for links, color coding consistency, formulas best practices VLOOKUP HLOOKUP limitation INDEX MATCH more robust XLOOKUP
new, SUMIFS SUMPRODUCT, data tables sensitivity, shortcuts Ctrl+Shift, circularity handling iterative calculation for interest, error checks balance sheet balances.

Corporate Finance Investment Banking FSM Final Exam Domains University Finance
Description: Corporate finance core finance decisions investment financing dividend, capital budgeting techniques NPV Net Present Value discounted cash flows at WACC
accept if >0, IRR Internal Rate Return rate NPV=0 accept if >WACC, payback period simple discounted, profitability index, working capital management NWC Net Working
Capital current assets minus liabilities operating cycle, Cash Conversion Cycle management, dividend policy theories irrelevant MM, bird-in-hand, tax preference, capital
structure Modigliani Miller, investment banking technical preparation Financial Statement Modeling final exam domains for university-level finance investment banking
students, 3-statement model mechanics walkthrough, DCF valuation build forecast FCFF WACC terminal value sensitivity table, LBO model build sources uses debt
schedule returns, M&A; model accretion dilution merger consequences, valuation comps precedent DCF football field, Excel modeling test modeling best practices
formatting, corporate finance questions enterprise value equity value, WACC CAPM Beta, accounting questions deferred revenue, investment banking interview technicals,
Higher Education Finance Curriculum university finance courses Corporate Finance Financial Statement Analysis Valuation Investment Banking, Corporate Finance
Institute CFI certifications FMVA Financial Modeling Valuation Analyst, Financial Statement Modeling final actual verified exam 2026/2027 academic year 150Q verified
questions answers rationales for university-level finance investment banking students, FMVA exam, study guide borders page numbers improved cover page confidential
educational purposes, finance investment banking students exam preparation, valuation DCF LBO M&A; Excel best practices.




Page 2 - Financial Statement Modeling Final 150Q 2026/2027

,Question 1: Q1: 3-statement model - linking income balance sheet cash flow?
A. 3-statement model Income Statement revenue expenses net income links to Retained Earnings Balance Sheet, Cash Flow Statement reconciles net
income to cash, linking mechanics
B. Only income 3-statement model
C. Only balance sheet 3-statement model
D. No linking 3-statement model
CORRECT ANSWER: A. 3-statement model Income Statement revenue expenses net income links to Retained Earnings Balance Sheet, Cash
Flow Statement reconciles net income to cash, linking mechanics
RATIONALE:
Rationale: 3-statement model Income Statement revenue expenses net income links to Retained Earnings Balance Sheet, Cash Flow Statement reconciles net income to
cash, linking mechanics. Per Corporate Finance Institute CFI Financial Modeling curriculum and higher education finance curriculum for university-level finance and
investment banking students 2026/2027.

Question 2: Q2: DCF valuation - FCFF WACC and terminal value?
A. Only WACC DCF valuation
B. Only FCFF DCF valuation
C. DCF Discounted Cash Flow FCFF Free Cash Flow Firm EBIT*(1-tax)+D&A-CapEx-NWC;, WACC Weighted Average Cost Capital cost equity debt,
terminal value Gordon growth exit multiple
D. No terminal value DCF valuation
CORRECT ANSWER: C. DCF Discounted Cash Flow FCFF Free Cash Flow Firm EBIT*(1-tax)+D&A-CapEx-NWC;, WACC Weighted Average
Cost Capital cost equity debt, terminal value Gordon growth exit multiple
RATIONALE:
Rationale: DCF Discounted Cash Flow FCFF Free Cash Flow Firm EBIT*(1-tax)+D&A-CapEx-NWC;, WACC Weighted Average Cost Capital cost equity debt, terminal
value Gordon growth exit multiple. Per Corporate Finance Institute CFI Financial Modeling curriculum and higher education finance curriculum for university-level finance
and investment banking students 2026/2027.

Question 3: Q3: LBO model - leverage and returns?
A. No debt schedule LBO model
B. Only leverage LBO model
C. Only IRR LBO model
D. LBO Leveraged Buyout model private equity leverage debt 60-70%, sources uses, debt schedule mandatory optional, returns IRR MoM
CORRECT ANSWER: D. LBO Leveraged Buyout model private equity leverage debt 60-70%, sources uses, debt schedule mandatory optional,
returns IRR MoM
RATIONALE:
Rationale: LBO Leveraged Buyout model private equity leverage debt 60-70%, sources uses, debt schedule mandatory optional, returns IRR MoM. Per Corporate
Finance Institute CFI Financial Modeling curriculum and higher education finance curriculum for university-level finance and investment banking students 2026/2027.

Question 4: Q4: M&A; model - accretion dilution and synergies?
A. Only accretion M&A; model
B. M&A; Merger Acquisition accretion dilution analysis, purchase price allocation goodwill, synergies cost revenue, pro forma
C. Only goodwill M&A; model
D. No synergies M&A; model
CORRECT ANSWER: B. M&A; Merger Acquisition accretion dilution analysis, purchase price allocation goodwill, synergies cost revenue, pro
forma
RATIONALE:
Rationale: M&A; Merger Acquisition accretion dilution analysis, purchase price allocation goodwill, synergies cost revenue, pro forma. Per Corporate Finance Institute CFI
Financial Modeling curriculum and higher education finance curriculum for university-level finance and investment banking students 2026/2027.

Question 5: Q5: Valuation - multiples and comps?
A. Valuation multiples EV/EBITDA EV/Revenue P/E, trading comps comparable company analysis, precedent transactions, DCF cross-check
B. Only EV/EBITDA valuation multiples comps
C. Only P/E valuation multiples comps
D. No precedent valuation multiples comps
CORRECT ANSWER: A. Valuation multiples EV/EBITDA EV/Revenue P/E, trading comps comparable company analysis, precedent
transactions, DCF cross-check
RATIONALE:
Rationale: Valuation multiples EV/EBITDA EV/Revenue P/E, trading comps comparable company analysis, precedent transactions, DCF cross-check. Per Corporate
Finance Institute CFI Financial Modeling curriculum and higher education finance curriculum for university-level finance and investment banking students 2026/2027.

Question 6: Q6: WACC and cost of capital - CAPM and capital structure?
A. Only cost debt WACC cost capital
B. Only CAPM WACC cost capital
C. WACC calculation CAPM Capital Asset Pricing Model Re=Rf+Beta*(Rm-Rf), cost debt after tax, capital structure weights market value
D. No weights WACC cost capital
CORRECT ANSWER: C. WACC calculation CAPM Capital Asset Pricing Model Re=Rf+Beta*(Rm-Rf), cost debt after tax, capital structure
weights market value
RATIONALE:
Rationale: WACC calculation CAPM Capital Asset Pricing Model Re=Rf+Beta*(Rm-Rf), cost debt after tax, capital structure weights market value. Per Corporate Finance
Institute CFI Financial Modeling curriculum and higher education finance curriculum for university-level finance and investment banking students 2026/2027.

Question 7: Q7: Financial analysis and forecasting - ratios and drivers?

Page 3 - Financial Statement Modeling Final 150Q 2026/2027

, A. Only revenue drivers financial analysis forecasting
B. Only ratios financial analysis forecasting
C. No working capital financial analysis forecasting
D. Financial analysis ratios profitability liquidity leverage efficiency, forecasting revenue drivers price volume, expense drivers, working capital
CORRECT ANSWER: D. Financial analysis ratios profitability liquidity leverage efficiency, forecasting revenue drivers price volume, expense
drivers, working capital
RATIONALE:
Rationale: Financial analysis ratios profitability liquidity leverage efficiency, forecasting revenue drivers price volume, expense drivers, working capital. Per Corporate
Finance Institute CFI Financial Modeling curriculum and higher education finance curriculum for university-level finance and investment banking students 2026/2027.

Question 8: Q8: Excel best practices - modeling standards and formulas?
A. Hardcoding allowed Excel best practices
B. Excel best practices no hardcoding inputs sheet, color coding blue input black formula green link, formulas VLOOKUP INDEX MATCH SUMIFS,
shortcuts
C. No color coding Excel best practices
D. No VLOOKUP Excel best practices
CORRECT ANSWER: B. Excel best practices no hardcoding inputs sheet, color coding blue input black formula green link, formulas
VLOOKUP INDEX MATCH SUMIFS, shortcuts
RATIONALE:
Rationale: Excel best practices no hardcoding inputs sheet, color coding blue input black formula green link, formulas VLOOKUP INDEX MATCH SUMIFS, shortcuts. Per
Corporate Finance Institute CFI Financial Modeling curriculum and higher education finance curriculum for university-level finance and investment banking students
2026/2027.

Question 9: Q9: Corporate finance - capital budgeting and working capital?
A. Corporate finance capital budgeting NPV IRR payback, working capital NWC Accounts Receivable Inventory Payable CCC, dividend policy
B. Only NPV corporate finance
C. Only NWC corporate finance
D. No dividend corporate finance
CORRECT ANSWER: A. Corporate finance capital budgeting NPV IRR payback, working capital NWC Accounts Receivable Inventory Payable
CCC, dividend policy
RATIONALE:
Rationale: Corporate finance capital budgeting NPV IRR payback, working capital NWC Accounts Receivable Inventory Payable CCC, dividend policy. Per Corporate
Finance Institute CFI Financial Modeling curriculum and higher education finance curriculum for university-level finance and investment banking students 2026/2027.

Question 10: Q10: Investment banking - FSM final exam domains?
A. Only LBO investment banking FSM final
B. Only DCF investment banking FSM final
C. Investment banking FSM Financial Statement Modeling final domains 3-statement DCF LBO M&A; valuation Excel, IB technical interview
D. No IB interview investment banking FSM final
CORRECT ANSWER: C. Investment banking FSM Financial Statement Modeling final domains 3-statement DCF LBO M&A; valuation Excel, IB
technical interview
RATIONALE:
Rationale: Investment banking FSM Financial Statement Modeling final domains 3-statement DCF LBO M&A; valuation Excel, IB technical interview. Per Corporate
Finance Institute CFI Financial Modeling curriculum and higher education finance curriculum for university-level finance and investment banking students 2026/2027.




Page 4 - Financial Statement Modeling Final 150Q 2026/2027

Document information

Uploaded on
August 23, 2026
Number of pages
32
Written in
2026/2027
Type
Exam (elaborations)
Contains
Questions & answers
$25.99

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
Sold
80
Followers
6
Items
6052
Last sold
1 month ago



Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions