CFI FMVA FINAL EXAM Newest 2026
Questions and Answers (Latest
Update) (Verified Answers) 100% Correct |
Grade A+
The annual accounts receivable is 3,000; the annual sales 40,000, and the gross
profit margin is 40%.
The receivable days estimated from the data above is _____. - ANSWER -27.4
The PP&E gross book value at the start of the month is 60,000, and the CAPEX of
the month is 12,000. The accumulated depreciation at the start of the month is
25,000; the depreciation expense of the month is 750. The net book value of PP&E
calculated from the data above is _____. - ANSWER -46,250
Simple interest is important framework to start learning about Time value of
MoneyIf you are going to receive $2,000 in six years from now, how much is that
worth today, assuming 5% annual simple interest? - ANSWER -$1,538.46
The formula contained in the yellow highlighted cell (I39) is = ( , I9,I24). This
formula can be copied over to the entire live scenario section without any manual
modification. (Hint: do not forget to use absolute references.) - ANSWER -
You should perform sensitivity analysis when: - 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. - 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? - 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? - 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? - ANSWER -Slide Master
Suppose you have selected to Format Shape of a chosen textbox. Resize shape to
fit text is under which tab? - ANSWER -Text Box
What are financial modeling guidelines and why are they relevant? - 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?
- ANSWER -The company is 'stretching its payables' and deferring a cash outflow.
Why would an increase in a businesses' days in inventory consume cash? -
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? -
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? - 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
Questions and Answers (Latest
Update) (Verified Answers) 100% Correct |
Grade A+
The annual accounts receivable is 3,000; the annual sales 40,000, and the gross
profit margin is 40%.
The receivable days estimated from the data above is _____. - ANSWER -27.4
The PP&E gross book value at the start of the month is 60,000, and the CAPEX of
the month is 12,000. The accumulated depreciation at the start of the month is
25,000; the depreciation expense of the month is 750. The net book value of PP&E
calculated from the data above is _____. - ANSWER -46,250
Simple interest is important framework to start learning about Time value of
MoneyIf you are going to receive $2,000 in six years from now, how much is that
worth today, assuming 5% annual simple interest? - ANSWER -$1,538.46
The formula contained in the yellow highlighted cell (I39) is = ( , I9,I24). This
formula can be copied over to the entire live scenario section without any manual
modification. (Hint: do not forget to use absolute references.) - ANSWER -
You should perform sensitivity analysis when: - 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. - 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? - 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? - 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? - ANSWER -Slide Master
Suppose you have selected to Format Shape of a chosen textbox. Resize shape to
fit text is under which tab? - ANSWER -Text Box
What are financial modeling guidelines and why are they relevant? - 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?
- ANSWER -The company is 'stretching its payables' and deferring a cash outflow.
Why would an increase in a businesses' days in inventory consume cash? -
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? -
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? - 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
