Financial Statement Modeling
A organization announces that it expects to spend $1 million on buybacks in the imminent year.
If its shares are projected to have an average charge of $250, what number of shares could be
repurchased? - ANS-4000
A Depreciation Waterfall is a type of Depreciation Schedule that aggregates depreciation of
current PP&E and new Capex. (T or F) - ANS-True
A dilutive interest will increase the quantity of stocks first-rate (T or F) - ANS-True
A model has these projections and assumptions: $20 million of Net Income, shares exchange at
20.0x income, and 1 million shares tremendous. What is the projected proportion rate? -
ANS-400 (Projected Share Price = Earnings Multiple * EPS)
Are option proceeds a source or use of coins? - ANS-Source
Are proportion repurchases a supply or a use of cash? - ANS-Use
Assuming Intangible Balance is 10.0 in C11, amortization is -1.Five in C12, and additions is
0.Seventy five in C13, how would you quickly calculate ending Tangible Balance in C14? -
ANS-Alt + =
Beginning balance = $10M, Capex = $3M, Depreciation= $2M, COGS = $1M. What is the
ending PP&E balance? - ANS-$11M
Beginning Intangible Balance is $10 million; Amortization = $1.5 million; Additions = $zero.75
million. What is the ending stability? - ANS-$nine.25 million
Circularity is induced if you have more than one cells' formulas referencing each different. (T or
F) - ANS-True
Debt issuance decreases lengthy-term debt (T or F) - ANS-False
Depreciation is to PP&E as Amortization is to... - ANS-Intangible Assets.
How did we calculate EPS in our model? - ANS-Net earnings / diluted shares exceptional
How did we calculate historical dilutive securities fantastic? - ANS-Dilutive Shares Outstanding -
Basic Shares wonderful
, How did we task out accrued liabilities? - ANS-As a % of COGS
How did we task out depreciation rate? - ANS-As a % of capex
How did we assignment out prepaid prices? - ANS-As a % of sales
How did we mission sales in our model? - ANS-By geography and by way of division
How will we calculate historic revenue increase rate for 2019? - ANS-(2019 Revenue / 2018
Revenue) - 1
How can we hyperlink the Cash Flow Statement (CFS) to the Balance Sheet (BS)? - ANS-(CFS)
Ending Cash = (BS) Same Year's Cash Balance
How can we challenge Dividends? - ANS-Assumed Dividend Payout Ratio * Projected Net
Income
How do you calculate days payable extraordinary? - ANS-Accounts Payable * 365 / Cost of
Goods Sold
How do you calculate Days Sales Outstanding? - ANS-Accounts Receivable / Revenue * 365
How do you calculate Inventory Turns? - ANS-COGS / Inventory
How do you calculate Net Working Capital? - ANS-Total non-cash cutting-edge belongings -
Total non-debt modern-day liabilities
If no extra debt is raised and there are fixed, annual debt bills, what will take place to short-time
period debt from yr to yr? - ANS-Stay the same
In module 8, what was the brand new reason of circularity in our version - ANS-Shares
Outstanding / Share Price / EPS
In module nine, what did we use a waterfall for? - ANS-For depreciation
In the Cash Flow Statement, we add lower back Depreciation and Amortization to Net Income
because... - ANS-They are non-coins prices
In what segment of the coins flow declaration does Capex belong? - ANS-Investing
In which segment of the coins flow statement will capital increases be located? - ANS-Cash float
from financing
In which segment did our version mission the highest increase fee? - ANS-Greater China
A organization announces that it expects to spend $1 million on buybacks in the imminent year.
If its shares are projected to have an average charge of $250, what number of shares could be
repurchased? - ANS-4000
A Depreciation Waterfall is a type of Depreciation Schedule that aggregates depreciation of
current PP&E and new Capex. (T or F) - ANS-True
A dilutive interest will increase the quantity of stocks first-rate (T or F) - ANS-True
A model has these projections and assumptions: $20 million of Net Income, shares exchange at
20.0x income, and 1 million shares tremendous. What is the projected proportion rate? -
ANS-400 (Projected Share Price = Earnings Multiple * EPS)
Are option proceeds a source or use of coins? - ANS-Source
Are proportion repurchases a supply or a use of cash? - ANS-Use
Assuming Intangible Balance is 10.0 in C11, amortization is -1.Five in C12, and additions is
0.Seventy five in C13, how would you quickly calculate ending Tangible Balance in C14? -
ANS-Alt + =
Beginning balance = $10M, Capex = $3M, Depreciation= $2M, COGS = $1M. What is the
ending PP&E balance? - ANS-$11M
Beginning Intangible Balance is $10 million; Amortization = $1.5 million; Additions = $zero.75
million. What is the ending stability? - ANS-$nine.25 million
Circularity is induced if you have more than one cells' formulas referencing each different. (T or
F) - ANS-True
Debt issuance decreases lengthy-term debt (T or F) - ANS-False
Depreciation is to PP&E as Amortization is to... - ANS-Intangible Assets.
How did we calculate EPS in our model? - ANS-Net earnings / diluted shares exceptional
How did we calculate historical dilutive securities fantastic? - ANS-Dilutive Shares Outstanding -
Basic Shares wonderful
, How did we task out accrued liabilities? - ANS-As a % of COGS
How did we task out depreciation rate? - ANS-As a % of capex
How did we assignment out prepaid prices? - ANS-As a % of sales
How did we mission sales in our model? - ANS-By geography and by way of division
How will we calculate historic revenue increase rate for 2019? - ANS-(2019 Revenue / 2018
Revenue) - 1
How can we hyperlink the Cash Flow Statement (CFS) to the Balance Sheet (BS)? - ANS-(CFS)
Ending Cash = (BS) Same Year's Cash Balance
How can we challenge Dividends? - ANS-Assumed Dividend Payout Ratio * Projected Net
Income
How do you calculate days payable extraordinary? - ANS-Accounts Payable * 365 / Cost of
Goods Sold
How do you calculate Days Sales Outstanding? - ANS-Accounts Receivable / Revenue * 365
How do you calculate Inventory Turns? - ANS-COGS / Inventory
How do you calculate Net Working Capital? - ANS-Total non-cash cutting-edge belongings -
Total non-debt modern-day liabilities
If no extra debt is raised and there are fixed, annual debt bills, what will take place to short-time
period debt from yr to yr? - ANS-Stay the same
In module 8, what was the brand new reason of circularity in our version - ANS-Shares
Outstanding / Share Price / EPS
In module nine, what did we use a waterfall for? - ANS-For depreciation
In the Cash Flow Statement, we add lower back Depreciation and Amortization to Net Income
because... - ANS-They are non-coins prices
In what segment of the coins flow declaration does Capex belong? - ANS-Investing
In which segment of the coins flow statement will capital increases be located? - ANS-Cash float
from financing
In which segment did our version mission the highest increase fee? - ANS-Greater China
