10/25/24, 7:45 AM FINANCIAL STATEMENT MODELING |2024-2025 UPDATE | COMPREHENSIVE MOST FREQUENTLY TESTED QUESTIO…
FINANCIAL STATEMENT MODELING |2024-2025
UPDATE | COMPREHENSIVE MOST
FREQUENTLY TESTED QUESTIONS WITH
VERIFIED SOLUTIONS| GRADED A+| GET IT 100%
ACCURATE!!
Terms in this set (80)
Which formula is used to Total Assets = Total Liabilities + Stockholders' Equity
check that a Balance
Sheet has been built
correctly?
How do you calculate COGS / Inventory
Inventory Turns?
How do you calculate Accounts Receivable / Revenue * 365
Days Sales Outstanding?
We can project prepaid Revenue
expenses by assuming its
percentage of...
How do you calculate Total non-cash current assets - Total non-debt
Net Working Capital? current liabilities
Depreciation is to PP&E Intangible Assets.
as Amortization is to...
We use this driver to % of revenue
project Capex:
https://quizlet.com/962334525/financial-statement-modeling-2024-2025-update-comprehensive-most-frequently-tested-questions-with-verified-sol… 1/9
, 10/25/24, 7:45 AM FINANCIAL STATEMENT MODELING |2024-2025 UPDATE | COMPREHENSIVE MOST FREQUENTLY TESTED QUESTIO…
When calculating the TRUE
ending balance of a line
item in a projected year,
we reference last year's
ending balance as the
beginning balance (T or
F)
Beginning Intangible $9.25 million
Balance is $10 million;
Amortization = $1.5
million; Additions = $0.75
million. What is the
ending balance?
Assuming Intangible Alt + =
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?
In the Cash Flow They are non-cash expenses
Statement, we add back
Depreciation and
Amortization to Net
Income because...
In what section of the Investing
cash flow statement does
Capex belong?
Share repurchases True
decrease Stockholder's
Equity (T or F)
How do we project Assumed Dividend Payout Ratio * Projected Net
Dividends? Income
How do we link the Cash (CFS) Ending Cash = (BS) Same Year's Cash Balance
Flow Statement (CFS) to
the Balance Sheet (BS)?
https://quizlet.com/962334525/financial-statement-modeling-2024-2025-update-comprehensive-most-frequently-tested-questions-with-verified-sol… 2/9
FINANCIAL STATEMENT MODELING |2024-2025
UPDATE | COMPREHENSIVE MOST
FREQUENTLY TESTED QUESTIONS WITH
VERIFIED SOLUTIONS| GRADED A+| GET IT 100%
ACCURATE!!
Terms in this set (80)
Which formula is used to Total Assets = Total Liabilities + Stockholders' Equity
check that a Balance
Sheet has been built
correctly?
How do you calculate COGS / Inventory
Inventory Turns?
How do you calculate Accounts Receivable / Revenue * 365
Days Sales Outstanding?
We can project prepaid Revenue
expenses by assuming its
percentage of...
How do you calculate Total non-cash current assets - Total non-debt
Net Working Capital? current liabilities
Depreciation is to PP&E Intangible Assets.
as Amortization is to...
We use this driver to % of revenue
project Capex:
https://quizlet.com/962334525/financial-statement-modeling-2024-2025-update-comprehensive-most-frequently-tested-questions-with-verified-sol… 1/9
, 10/25/24, 7:45 AM FINANCIAL STATEMENT MODELING |2024-2025 UPDATE | COMPREHENSIVE MOST FREQUENTLY TESTED QUESTIO…
When calculating the TRUE
ending balance of a line
item in a projected year,
we reference last year's
ending balance as the
beginning balance (T or
F)
Beginning Intangible $9.25 million
Balance is $10 million;
Amortization = $1.5
million; Additions = $0.75
million. What is the
ending balance?
Assuming Intangible Alt + =
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?
In the Cash Flow They are non-cash expenses
Statement, we add back
Depreciation and
Amortization to Net
Income because...
In what section of the Investing
cash flow statement does
Capex belong?
Share repurchases True
decrease Stockholder's
Equity (T or F)
How do we project Assumed Dividend Payout Ratio * Projected Net
Dividends? Income
How do we link the Cash (CFS) Ending Cash = (BS) Same Year's Cash Balance
Flow Statement (CFS) to
the Balance Sheet (BS)?
https://quizlet.com/962334525/financial-statement-modeling-2024-2025-update-comprehensive-most-frequently-tested-questions-with-verified-sol… 2/9
