CFI FMVA Final Exam 2026 | All Questions and
Correct Answers | Graded A+ | Verified
Answers | Brand New Version!
You should perform sensitivity analysis when: ---------CORRECT ANSWER--------------
---You need to determine which assumptions matter the most
Which charts would be better choices to visualize a company's actual
performance ratio in comparison to a target ratio? Select TWO best answers. ------
---CORRECT ANSWER-----------------Two-series line chart, column and marker chart
Building a heat map would be an appropriate way to visualize data in which of the
following? ---------CORRECT ANSWER-----------------Sensitivity Analysis
If the last data point in this chart is the accumulated total (1258), what will you do
to set up the chart properly? ---------CORRECT ANSWER-----------------Right click the
last data point and select "Set as Total"
If you wanted to insert the same company logo onto the right-hand corner of
every slide in the pitchbook (footer), which of the following slide views would you
open to complete the task the quickest? ---------CORRECT ANSWER-----------------
Slide Master
,Suppose you have selected to Format Shape of a chosen textbox. Resize shape to
fit text is under which tab? ---------CORRECT ANSWER-----------------Text Box
What are financial modeling guidelines and why are they relevant? ---------
CORRECT ANSWER-----------------A stringent set of rules about financial modeling,
which are required for Microsoft Excel to function properly.
Why would an increase in the company's days in A/P produce cash for a business?
---------CORRECT ANSWER-----------------The company is 'stretching its payables' and
deferring a cash outflow.
Why would an increase in a businesses' days in inventory consume cash? ---------
CORRECT ANSWER-----------------The business is expending cash to build up its
inventory levels.
A real-estate holdings company has the following fixed asset detail:Buildings:
$25.0 Million; Useful Life 20-years.Land: $5.0 Million.Assuming straight-line
depreciation, what would the company's total annual depreciation expense be? --
-------CORRECT ANSWER-----------------$1.25 million.
,The Role of Financial Modeling Professionals Financial modeling professionals are
expected to perform many tasks. Which of the following is not typically a task as
part of the financial modeling process? ---------CORRECT ANSWER-----------------
Smoothing data for management
Financial Modeling Practices Financial modeling professionals typically break their
work down into modular steps for ease and transparency, before linking
everything back to the three core financial statements. Corkscrew schedules are
primarily used to support calculations for which financial statement? ---------
CORRECT ANSWER-----------------Balance Sheet
Circularity in models Many sophisticated models use circular calculations. What is
a required Excel setting that allows for circular calculations? ---------CORRECT
ANSWER-----------------Enable iterative calculations
Where would 'accounts payable' most likely appear on a set of financial
statements? ---------CORRECT ANSWER-----------------On the balance sheet under
'current liabilities'
Which is not a type of note found in a set of financial statements? ---------
CORRECT ANSWER-----------------Significant internal controls
What is the correct syntax for the =YEARFRAC function? ---------CORRECT
ANSWER-----------------=YEARFRAC(start_date,end_date,[basis])
, Which of the following is NOT a form of subordinated debt? ---------CORRECT
ANSWER-----------------Revolver
Which of the following is not a function of public accounting firms? ---------
CORRECT ANSWER-----------------Due dilligence
Which ratio would you use to determine the profitability of the goods sold by a
company? ---------CORRECT ANSWER-----------------Gross Profit Margin
Horizontal analysis allows us to analyze performance over: ---------CORRECT
ANSWER-----------------Time
If a company wanted to finance the purchase of equipment without diluting
shareholders equity, which of the following operation could it consider? ---------
CORRECT ANSWER-----------------Issuing convertible bonds
When calculating the quick ratio or "acid test" which current asset or liability is
omitted? ---------CORRECT ANSWER-----------------Inventory
Correct Answers | Graded A+ | Verified
Answers | Brand New Version!
You should perform sensitivity analysis when: ---------CORRECT ANSWER--------------
---You need to determine which assumptions matter the most
Which charts would be better choices to visualize a company's actual
performance ratio in comparison to a target ratio? Select TWO best answers. ------
---CORRECT ANSWER-----------------Two-series line chart, column and marker chart
Building a heat map would be an appropriate way to visualize data in which of the
following? ---------CORRECT ANSWER-----------------Sensitivity Analysis
If the last data point in this chart is the accumulated total (1258), what will you do
to set up the chart properly? ---------CORRECT ANSWER-----------------Right click the
last data point and select "Set as Total"
If you wanted to insert the same company logo onto the right-hand corner of
every slide in the pitchbook (footer), which of the following slide views would you
open to complete the task the quickest? ---------CORRECT ANSWER-----------------
Slide Master
,Suppose you have selected to Format Shape of a chosen textbox. Resize shape to
fit text is under which tab? ---------CORRECT ANSWER-----------------Text Box
What are financial modeling guidelines and why are they relevant? ---------
CORRECT ANSWER-----------------A stringent set of rules about financial modeling,
which are required for Microsoft Excel to function properly.
Why would an increase in the company's days in A/P produce cash for a business?
---------CORRECT ANSWER-----------------The company is 'stretching its payables' and
deferring a cash outflow.
Why would an increase in a businesses' days in inventory consume cash? ---------
CORRECT ANSWER-----------------The business is expending cash to build up its
inventory levels.
A real-estate holdings company has the following fixed asset detail:Buildings:
$25.0 Million; Useful Life 20-years.Land: $5.0 Million.Assuming straight-line
depreciation, what would the company's total annual depreciation expense be? --
-------CORRECT ANSWER-----------------$1.25 million.
,The Role of Financial Modeling Professionals Financial modeling professionals are
expected to perform many tasks. Which of the following is not typically a task as
part of the financial modeling process? ---------CORRECT ANSWER-----------------
Smoothing data for management
Financial Modeling Practices Financial modeling professionals typically break their
work down into modular steps for ease and transparency, before linking
everything back to the three core financial statements. Corkscrew schedules are
primarily used to support calculations for which financial statement? ---------
CORRECT ANSWER-----------------Balance Sheet
Circularity in models Many sophisticated models use circular calculations. What is
a required Excel setting that allows for circular calculations? ---------CORRECT
ANSWER-----------------Enable iterative calculations
Where would 'accounts payable' most likely appear on a set of financial
statements? ---------CORRECT ANSWER-----------------On the balance sheet under
'current liabilities'
Which is not a type of note found in a set of financial statements? ---------
CORRECT ANSWER-----------------Significant internal controls
What is the correct syntax for the =YEARFRAC function? ---------CORRECT
ANSWER-----------------=YEARFRAC(start_date,end_date,[basis])
, Which of the following is NOT a form of subordinated debt? ---------CORRECT
ANSWER-----------------Revolver
Which of the following is not a function of public accounting firms? ---------
CORRECT ANSWER-----------------Due dilligence
Which ratio would you use to determine the profitability of the goods sold by a
company? ---------CORRECT ANSWER-----------------Gross Profit Margin
Horizontal analysis allows us to analyze performance over: ---------CORRECT
ANSWER-----------------Time
If a company wanted to finance the purchase of equipment without diluting
shareholders equity, which of the following operation could it consider? ---------
CORRECT ANSWER-----------------Issuing convertible bonds
When calculating the quick ratio or "acid test" which current asset or liability is
omitted? ---------CORRECT ANSWER-----------------Inventory
