FINANCIAL STATEMENT MODELING EXAM X X X
X 2025/2026 | REAL QUESTION AND ANSWERS| A+ X X X X X X
Study Material X
Beginning Intangible Balance is $10 million; Amortization = $1.5 million;
X X X X X X X X X
Additions = $0.75 million. What is the ending balance?
X X X X X X X X X
$9.25 million X
Assuming Intangible Balance is 10.0 in C11, amortization is -1.5 in C12, and
X X X X X X X X X X X X
additions is 0.75 in C13, how would you quickly calculate ending Tangible
X X X X X X X X X X X X
Balance in C14?
X X X
Alt + = X X
In the Cash Flow Statement, we add back Depreciation and Amortization to Net
X X X X X X X X X X X X
Income because...
X X
They are non-cash expenses
X X X
In what section of the cash flow statement does Capex belong?
X X X X X X X X X X
,Investing
Share repurchases decrease Stockholder's Equity (T or F)
X X X X X X X
True
X
How do we project Dividends?
X X X X
Assumed Dividend Payout Ratio * Projected Net Income
X X X X X X X
How do we link the Cash Flow Statement (CFS) to the Balance Sheet (BS)?
X X X X X X X X X X X X X
(CFS) Ending Cash = (BS) Same Year's Cash Balance
X X X X X X X X X
Debt issuance decreases long-term debt (T or F)
X X X X X X X
False
X
Which formula is used to check that a Balance Sheet has been built correctly?
X X X X X X X X X X X X X
Total Assets = Total Liabilities + Stockholders' Equity
X X X X X X X X
, How do you calculate Inventory Turns?
X X X X X
COGS / Inventory
X X X
How do you calculate Days Sales Outstanding?
X X X X X X
Accounts Receivable / Revenue * 365
X X X X X X
We can project prepaid expenses by assuming its percentage of...
X X X X X X X X X
Revenue
X
How do you calculate Net Working Capital?
X X X X X X
Total non-cash current assets - Total non-debt current liabilities
X X X X X X X X
Depreciation is to PP&E as Amortization is to...X X X X X X X
Intangible Assets.
X X
We use this driver to project Capex:
X X X X X X
% of revenue
X X
X 2025/2026 | REAL QUESTION AND ANSWERS| A+ X X X X X X
Study Material X
Beginning Intangible Balance is $10 million; Amortization = $1.5 million;
X X X X X X X X X
Additions = $0.75 million. What is the ending balance?
X X X X X X X X X
$9.25 million X
Assuming Intangible Balance is 10.0 in C11, amortization is -1.5 in C12, and
X X X X X X X X X X X X
additions is 0.75 in C13, how would you quickly calculate ending Tangible
X X X X X X X X X X X X
Balance in C14?
X X X
Alt + = X X
In the Cash Flow Statement, we add back Depreciation and Amortization to Net
X X X X X X X X X X X X
Income because...
X X
They are non-cash expenses
X X X
In what section of the cash flow statement does Capex belong?
X X X X X X X X X X
,Investing
Share repurchases decrease Stockholder's Equity (T or F)
X X X X X X X
True
X
How do we project Dividends?
X X X X
Assumed Dividend Payout Ratio * Projected Net Income
X X X X X X X
How do we link the Cash Flow Statement (CFS) to the Balance Sheet (BS)?
X X X X X X X X X X X X X
(CFS) Ending Cash = (BS) Same Year's Cash Balance
X X X X X X X X X
Debt issuance decreases long-term debt (T or F)
X X X X X X X
False
X
Which formula is used to check that a Balance Sheet has been built correctly?
X X X X X X X X X X X X X
Total Assets = Total Liabilities + Stockholders' Equity
X X X X X X X X
, How do you calculate Inventory Turns?
X X X X X
COGS / Inventory
X X X
How do you calculate Days Sales Outstanding?
X X X X X X
Accounts Receivable / Revenue * 365
X X X X X X
We can project prepaid expenses by assuming its percentage of...
X X X X X X X X X
Revenue
X
How do you calculate Net Working Capital?
X X X X X X
Total non-cash current assets - Total non-debt current liabilities
X X X X X X X X
Depreciation is to PP&E as Amortization is to...X X X X X X X
Intangible Assets.
X X
We use this driver to project Capex:
X X X X X X
% of revenue
X X
