5/15/25, 8:53 AM Financial modeling Exam #2 Flashcards | Quizlet
Terms in this set (71) Original
How did we calculate
free cash flows
generated during the
period under Revolver
needs analysis in our
FSM?
A. CFO + CFI + CFF except revolver
Cash available to pay
down revolver under
Revolver needs analysis
in our FSM is calculated
as?
A. BOP Cash - Minimum cash balance + Free cash
flows generated during period
Interest expense on
Commercial Paper (CP)
is calculated as:
Weighted average interest rate * Average End of
period CP balance (from B/S)
4. Total interest expense
is calculated as the sum
of Interest expense on
Revolver and Interest
expense on Long term
debt? T or F
True
Excel shortcut for Data
Table is:
Alt+D+T
How do you interpret the
values in the below
scenario table?
How do changes in Revenue
growth rate and Gross Profit
Margin affect the Net Income?
https://quizlet.com/1034664023/financial-modeling-exam-2-flash-cards/ 1/11
, 5/15/25, 8:53 AM Financial modeling Exam #2 Flashcards | Quizlet
In the above scenario
table, what will you input
as the Column input cell
when creating the Data
Table?
Gross profit margin
What is the keyboard
shortcut for repeating the
last action?
F4
What is the keyboard
shortcut for undo?
Ctrl+Z
What is the impact of
stock buy-back on
number of shares?
Number of shares decrease
Basic shares in current
period is calculated as:
Prior period basic shares + Net change in basic
shares
How is Diluted EPS
calculated?
Net income/Diluted Shares
In our FSM model,
diluted shares are
calculated as straight
lining historical
difference between basic
and diluted weighted
average shares. True or
False
True
https://quizlet.com/1034664023/financial-modeling-exam-2-flash-cards/ 2/11
Terms in this set (71) Original
How did we calculate
free cash flows
generated during the
period under Revolver
needs analysis in our
FSM?
A. CFO + CFI + CFF except revolver
Cash available to pay
down revolver under
Revolver needs analysis
in our FSM is calculated
as?
A. BOP Cash - Minimum cash balance + Free cash
flows generated during period
Interest expense on
Commercial Paper (CP)
is calculated as:
Weighted average interest rate * Average End of
period CP balance (from B/S)
4. Total interest expense
is calculated as the sum
of Interest expense on
Revolver and Interest
expense on Long term
debt? T or F
True
Excel shortcut for Data
Table is:
Alt+D+T
How do you interpret the
values in the below
scenario table?
How do changes in Revenue
growth rate and Gross Profit
Margin affect the Net Income?
https://quizlet.com/1034664023/financial-modeling-exam-2-flash-cards/ 1/11
, 5/15/25, 8:53 AM Financial modeling Exam #2 Flashcards | Quizlet
In the above scenario
table, what will you input
as the Column input cell
when creating the Data
Table?
Gross profit margin
What is the keyboard
shortcut for repeating the
last action?
F4
What is the keyboard
shortcut for undo?
Ctrl+Z
What is the impact of
stock buy-back on
number of shares?
Number of shares decrease
Basic shares in current
period is calculated as:
Prior period basic shares + Net change in basic
shares
How is Diluted EPS
calculated?
Net income/Diluted Shares
In our FSM model,
diluted shares are
calculated as straight
lining historical
difference between basic
and diluted weighted
average shares. True or
False
True
https://quizlet.com/1034664023/financial-modeling-exam-2-flash-cards/ 2/11
