1|Page
FINANCIAL STATEMENT MODELING EXAM
LATEST 2024/2025 QUESTIONS AND CORRECT
ANSWERS(100% CORRECT VERIFIED
ANSWERS)ALREADY GRADED A+
Which formula is used to check that a Balance Sheet has
been built correctly? - .....ANSWER ...✔✔ Total Assets
= Total Liabilities + Stockholders' Equity
How do you calculate Inventory Turns? - .....ANSWER
...✔✔ COGS / Inventory
How do you calculate Days Sales Outstanding? -
.....ANSWER ...✔✔ Accounts Receivable / Revenue *
365
We can project prepaid expenses by assuming its
percentage of... - .....ANSWER ...✔✔ Revenue
How do you calculate Net Working Capital? -
.....ANSWER ...✔✔ Total non-cash current assets -
Total non-debt current liabilities
, 2|Page
Depreciation is to PP&E as Amortization is to... -
.....ANSWER ...✔✔ Intangible Assets.
We use this driver to project Capex: - .....ANSWER
...✔✔ % of revenue
When calculating the ending balance of a line item in a
projected year, we reference last year's ending balance
as the beginning balance (T or F) - .....ANSWER ...✔✔
TRUE
Beginning Intangible Balance is $10 million;
Amortization = $1.5 million; Additions = $0.75 million.
What is the ending balance? - .....ANSWER ...✔✔
$9.25 million
Assuming Intangible Balance is 10.0 in C11,
amortization is -1.5 in C12, and additions is 0.75 in
C13, how would you quickly calculate ending Tangible
Balance in C14? - .....ANSWER ...✔✔ Alt + =
FINANCIAL STATEMENT MODELING EXAM
LATEST 2024/2025 QUESTIONS AND CORRECT
ANSWERS(100% CORRECT VERIFIED
ANSWERS)ALREADY GRADED A+
Which formula is used to check that a Balance Sheet has
been built correctly? - .....ANSWER ...✔✔ Total Assets
= Total Liabilities + Stockholders' Equity
How do you calculate Inventory Turns? - .....ANSWER
...✔✔ COGS / Inventory
How do you calculate Days Sales Outstanding? -
.....ANSWER ...✔✔ Accounts Receivable / Revenue *
365
We can project prepaid expenses by assuming its
percentage of... - .....ANSWER ...✔✔ Revenue
How do you calculate Net Working Capital? -
.....ANSWER ...✔✔ Total non-cash current assets -
Total non-debt current liabilities
, 2|Page
Depreciation is to PP&E as Amortization is to... -
.....ANSWER ...✔✔ Intangible Assets.
We use this driver to project Capex: - .....ANSWER
...✔✔ % of revenue
When calculating the ending balance of a line item in a
projected year, we reference last year's ending balance
as the beginning balance (T or F) - .....ANSWER ...✔✔
TRUE
Beginning Intangible Balance is $10 million;
Amortization = $1.5 million; Additions = $0.75 million.
What is the ending balance? - .....ANSWER ...✔✔
$9.25 million
Assuming Intangible Balance is 10.0 in C11,
amortization is -1.5 in C12, and additions is 0.75 in
C13, how would you quickly calculate ending Tangible
Balance in C14? - .....ANSWER ...✔✔ Alt + =
