Modeling & Valuation Analyst Practice
Questions & Ans, Exams of Nursing
Where would 'accounts payable' most likely appear on a set of
financial statements? - ANSWER-On the balance sheet under
'current liabilities'
Which is not a type of note found in a set of financial
statements? - ANSWER-Significant internal controls
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
, 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.