1|Page
Corporate Finance Institute (CFI) Financial Modeling &
Valuation Analyst (FMVA) Final Exam 2026 | Latest
Verified Questions and Detailed Answers
OVERVIEW DESCRIPTION:
This comprehensive set of multiple-choice questions is designed for the Corporate Finance
Institute (CFI) Financial Modeling & Valuation Analyst (FMVA) Final Exam as of 2026. The
questions span the key competency areas of the certification, including financial modeling
(3-statement models, scenario analysis), corporate finance (capital structure, investment
analysis), advanced Excel proficiency (functions, shortcuts, and best practices), valuation
techniques (DCF, comparable analysis, precedent transactions), and budgeting,
presentation, and accounting fundamentals. Each question is structured to test practical
application and theoretical understanding, providing a robust review tool that emphasizes
the dynamic, Excel-based, and decision-oriented skills required to succeed in professional
financial analysis roles.
QUESTION 1
When projecting a company's free cash flow to the firm (FCFF) for a five-year period,
which of the following approaches most accurately reflects the relationship between net
income, non-cash charges, and working capital investments?
A) FCFF = Net Income + Depreciation & Amortization – Change in Net Working Capital
– Capital Expenditures + After-Tax Interest Expense
B) FCFF = Net Income + Depreciation & Amortization – Change in Net Working Capital
– Capital Expenditures
C) FCFF = EBITDA – Taxes – Change in Net Working Capital – Capital Expenditures
D) FCFF = Cash Flow from Operations – Capital Expenditures + After-Tax Interest
Expense
CORRECT ANSWER: A
EXPERT RATIONALE: FCFF starts with net income, adds back non-cash charges, subtracts
,2|Page
increases in working capital and CapEx, and adds back after-tax interest to arrive at cash
available to all investors.
QUESTION 2
In a three-statement financial model, what is the primary purpose of the "revolver" or
revolving credit facility in the debt schedule?
A) To calculate the interest expense on long-term debt
B) To serve as a plug to ensure the balance sheet balances when cash would otherwise
become negative
C) To model the repayment of principal on term loans
D) To track the issuance of new equity shares
CORRECT ANSWER: B
EXPERT RATIONALE: The revolver is a short-term, flexible funding source that draws
when cash falls below a minimum threshold and repays when excess cash is available,
acting as the primary balancing mechanism.
QUESTION 3
A comparable company analysis (CCA) is being performed. Which of the following
valuation multiples is most appropriate for comparing companies with significantly
different capital structures?
A) Price-to-Earnings (P/E) ratio
B) Price-to-Book (P/B) ratio
C) Enterprise Value / EBITDA (EV/EBITDA)
D) Dividend Yield
CORRECT ANSWER: C
EXPERT RATIONALE: EV/EBITDA is capital structure-neutral because enterprise value
considers both debt and equity, while EBITDA is a pre-interest metric, allowing for a
cleaner comparison across firms.
,3|Page
QUESTION 4
In an Excel-based DCF model, what is the correct formula to calculate the present value
of a terminal value calculated using the Gordon Growth Method, assuming the discount
rate is in cell B10, the terminal growth rate in B11, and the final year's free cash flow
(FCF) in B12?
A) =B12*(1+B11)/(B10-B11)
B) =B12/(B10-B11)
C) =B12*(1+B11)/(B10-B11) * (1/(1+B10)^5)
D) =B12/(B10-B11) * (1/(1+B10)^5)
CORRECT ANSWER: C
EXPERT RATIONALE: The terminal value (TV) formula is FCF_n * (1+g) / (WACC - g),
which must then be discounted back to the present value using the appropriate
discount factor for the final year.
QUESTION 5
Which Excel function is most efficient for performing a sensitivity analysis on two
variables simultaneously, such as varying revenue growth and operating margin to see
their impact on net income?
A) =IF
B) =GOAL SEEK
C) =CHOOSE
D) Data Table
CORRECT ANSWER: D
EXPERT RATIONALE: Excel’s Data Table feature within What-If Analysis allows for a two-
dimensional sensitivity analysis by substituting a range of values for two input variables
into a single output formula.
, 4|Page
QUESTION 6
When building a financial model, which of the following best describes the concept of
"circularity" and the standard method for managing it?
A) A situation where the balance sheet doesn't balance, resolved by adjusting cash
B) A loop where interest income depends on cash, and cash depends on interest
income, typically resolved by enabling iterative calculations
C) A logical error in an =IF statement that references itself, resolved by using =SUM
D) A reference error caused by linking across workbooks, resolved by breaking the links
CORRECT ANSWER: B
EXPERT RATIONALE: Circularity often occurs when interest income/expense is calculated
based on average cash/debt balances, creating a loop. Iterative calculations allow Excel
to resolve this loop.
QUESTION 7
In capital investment analysis, what is the primary limitation of using the Internal Rate of
Return (IRR) for mutually exclusive projects?
A) It ignores the time value of money.
B) It cannot be calculated if cash flows are conventional.
C) It can lead to incorrect decisions due to scale and timing differences.
D) It requires an externally determined discount rate.
CORRECT ANSWER: C
EXPERT RATIONALE: IRR can favor smaller projects with high percentage returns over
larger projects with higher absolute NPV, and reinvestment rate assumptions can
conflict between projects.
QUESTION 8
Which Excel shortcut, when pressed after typing a formula, locks a cell reference to
make it absolute?
Corporate Finance Institute (CFI) Financial Modeling &
Valuation Analyst (FMVA) Final Exam 2026 | Latest
Verified Questions and Detailed Answers
OVERVIEW DESCRIPTION:
This comprehensive set of multiple-choice questions is designed for the Corporate Finance
Institute (CFI) Financial Modeling & Valuation Analyst (FMVA) Final Exam as of 2026. The
questions span the key competency areas of the certification, including financial modeling
(3-statement models, scenario analysis), corporate finance (capital structure, investment
analysis), advanced Excel proficiency (functions, shortcuts, and best practices), valuation
techniques (DCF, comparable analysis, precedent transactions), and budgeting,
presentation, and accounting fundamentals. Each question is structured to test practical
application and theoretical understanding, providing a robust review tool that emphasizes
the dynamic, Excel-based, and decision-oriented skills required to succeed in professional
financial analysis roles.
QUESTION 1
When projecting a company's free cash flow to the firm (FCFF) for a five-year period,
which of the following approaches most accurately reflects the relationship between net
income, non-cash charges, and working capital investments?
A) FCFF = Net Income + Depreciation & Amortization – Change in Net Working Capital
– Capital Expenditures + After-Tax Interest Expense
B) FCFF = Net Income + Depreciation & Amortization – Change in Net Working Capital
– Capital Expenditures
C) FCFF = EBITDA – Taxes – Change in Net Working Capital – Capital Expenditures
D) FCFF = Cash Flow from Operations – Capital Expenditures + After-Tax Interest
Expense
CORRECT ANSWER: A
EXPERT RATIONALE: FCFF starts with net income, adds back non-cash charges, subtracts
,2|Page
increases in working capital and CapEx, and adds back after-tax interest to arrive at cash
available to all investors.
QUESTION 2
In a three-statement financial model, what is the primary purpose of the "revolver" or
revolving credit facility in the debt schedule?
A) To calculate the interest expense on long-term debt
B) To serve as a plug to ensure the balance sheet balances when cash would otherwise
become negative
C) To model the repayment of principal on term loans
D) To track the issuance of new equity shares
CORRECT ANSWER: B
EXPERT RATIONALE: The revolver is a short-term, flexible funding source that draws
when cash falls below a minimum threshold and repays when excess cash is available,
acting as the primary balancing mechanism.
QUESTION 3
A comparable company analysis (CCA) is being performed. Which of the following
valuation multiples is most appropriate for comparing companies with significantly
different capital structures?
A) Price-to-Earnings (P/E) ratio
B) Price-to-Book (P/B) ratio
C) Enterprise Value / EBITDA (EV/EBITDA)
D) Dividend Yield
CORRECT ANSWER: C
EXPERT RATIONALE: EV/EBITDA is capital structure-neutral because enterprise value
considers both debt and equity, while EBITDA is a pre-interest metric, allowing for a
cleaner comparison across firms.
,3|Page
QUESTION 4
In an Excel-based DCF model, what is the correct formula to calculate the present value
of a terminal value calculated using the Gordon Growth Method, assuming the discount
rate is in cell B10, the terminal growth rate in B11, and the final year's free cash flow
(FCF) in B12?
A) =B12*(1+B11)/(B10-B11)
B) =B12/(B10-B11)
C) =B12*(1+B11)/(B10-B11) * (1/(1+B10)^5)
D) =B12/(B10-B11) * (1/(1+B10)^5)
CORRECT ANSWER: C
EXPERT RATIONALE: The terminal value (TV) formula is FCF_n * (1+g) / (WACC - g),
which must then be discounted back to the present value using the appropriate
discount factor for the final year.
QUESTION 5
Which Excel function is most efficient for performing a sensitivity analysis on two
variables simultaneously, such as varying revenue growth and operating margin to see
their impact on net income?
A) =IF
B) =GOAL SEEK
C) =CHOOSE
D) Data Table
CORRECT ANSWER: D
EXPERT RATIONALE: Excel’s Data Table feature within What-If Analysis allows for a two-
dimensional sensitivity analysis by substituting a range of values for two input variables
into a single output formula.
, 4|Page
QUESTION 6
When building a financial model, which of the following best describes the concept of
"circularity" and the standard method for managing it?
A) A situation where the balance sheet doesn't balance, resolved by adjusting cash
B) A loop where interest income depends on cash, and cash depends on interest
income, typically resolved by enabling iterative calculations
C) A logical error in an =IF statement that references itself, resolved by using =SUM
D) A reference error caused by linking across workbooks, resolved by breaking the links
CORRECT ANSWER: B
EXPERT RATIONALE: Circularity often occurs when interest income/expense is calculated
based on average cash/debt balances, creating a loop. Iterative calculations allow Excel
to resolve this loop.
QUESTION 7
In capital investment analysis, what is the primary limitation of using the Internal Rate of
Return (IRR) for mutually exclusive projects?
A) It ignores the time value of money.
B) It cannot be calculated if cash flows are conventional.
C) It can lead to incorrect decisions due to scale and timing differences.
D) It requires an externally determined discount rate.
CORRECT ANSWER: C
EXPERT RATIONALE: IRR can favor smaller projects with high percentage returns over
larger projects with higher absolute NPV, and reinvestment rate assumptions can
conflict between projects.
QUESTION 8
Which Excel shortcut, when pressed after typing a formula, locks a cell reference to
make it absolute?
