Focus Formulas Flashcards
Basel III Requirements and Their Goals
- Minimum Capital Requirement
- specifies ratio of assets to risk-weighted assets
- to ensure BS strong enough to cope with loan losses
- Stable Funding Requirements
- specify amount of stable funding relative to liquidity needs over one year
- Minimum Liquidity Requirement
- specifies minimum level liquidity to cover a partial loss of funding sources, or outflow due to off-BS commitments
Receivables Turnover
Sales
___________________
AR
DSO
365
____________________
Receivables Turnover
Asset Turnover
Revenue
__________________
Assets
Cash Conversion Cycle
DSO + Days Inventory on Hand - Days of Payables
Days of Payables
365
_______________________
Payables Turnover
Payables Turnover
Purchases
_________________
Avg. Payables
Days Inventory on Hand
365
____________________
Inventory Turnover
Inventory Turnover
COGS
___________________
Avg Inventory
Quick Ratio (2 ways)
Current Assets - Inventory
____________________________
Current Liabilities
OR
Cash + AR
__________________________
Current Liabilities
Cash Ratio
Cash + Marketable Securities
________________________
Current Liabilities
Inflation and BEI
Inflation:
1 + Nominal Rate
___________________
1+ Real Rate
BEI:
Expected Inflation + premium for inflation uncertainty
(the difference between the nominal and risk free rates)
Interest Coverage Ratio
EBIT
_____________________
Interest Expense
Fixed Charge Coverage Ratio
EBIT + Lease Payments
____________________________
Interest + Lease Payments
Debt to Capital Ratio
Total Debt
_________________________
Debt + Shareholders Equity
Debt to Equity Ratio
Total Debt
_________________
Shareholders Equity
Financial Leverage
Avg Total Assets
_________________________
Avg total Equity
Net Operating Assets
Operating Assets - Operating Liabilities
Operating Assets
Total Assets - Cash & Equiv - Marketable Securities
Operating Liabilities
Total Liabilities - Total Debt
Accruals
Ending NOA - Beginning NOA
NI - CFO - CFI
Accruals Ratio
Change in NOA
______________________
Avg NOA
Gross Margin
Rev - Cogs
___________________
Revenue
Operating Margin
Operating Income
_____________________
Revenue
Adjusted Operating Profit
Reported Operating Profit
+ Reported Pension Expense
- Service Cost
_______________________________
= Adjusted Operating Profit
Partial Goodwill
IFRS ONLY
Proceeds - pro rata identifiable FMV of Net Assets
Full Goodwill
IFRS AND GAAP
FMV (acquisition cost / % purchased) - identifiable FMV of Net Assets
Goodwill Impairment: IFRS
If carrying value > recoverable amount
recoverable amount = higher of net selling price or PV of future CF
Goodwill Impairment: GAAP
2-step:
1) identify: if carrying value of reporting unit + goodwill > FV of reporting unit
2) Measure: carrying value of goodwill > Implied FV of goodwill
VIE Criteria
1) Equity interest <10% of total assets
2) Equity Investor lacks decision-making, obligation to absorb losses (guarantee), right to receive residual returns
VIE mustb e conslidated under parent if the company is the primary beneficiary
PBO
BGN POBO
+ Service Cost
+Interest Cost
+/- Actuarial G/L
+/- Prior Service Cost
-Benefits Paid
_______________________
= Ending PBO
FVPA
BGN FVPA
+ /- ARPA
+ Contributions
- Benefits Paid
___________________
END FVPA
IFRS vs. GAAP Treatment of Prior Service Costs
IFRS: Expensed immediately: pension expense up 100
GAAP: Reported in comprehensive Income, amortized over employee service life
GAAP Pension Expense
CSC
+ Interest Expense
- ERPA
+/- Amort PSC
+/- Actuarial
_______________
= Pension Expense
IFRS Pension Expense
CSC
+/- Net Interest
+/- PSC
___________________
= Pension Expense
Net Interest = discount rate x BGN Funded status -> if negative, interest is positive
TPPC
calculated the same IFRS and GAAP
1) Contributions - Change in Funded Status
2) Service Cost + Interest + Plan amendments +/- current period actuarial G/L
- ARPA
3) Reported Pension Cost + change in OCI items
Analyst Adjustments for PBO / Pension
Replace I/S Expense with TPPC
Split Pension Expense up within I/S:
Service Cost = Operating
Interest Cost = interest expense
ARPA = non-operating income
Analyst Adjustments to Cash Flow Statement for Pension Stuff
If contributions > TPPC, it’s like pre-paying a loan –> the delta is the prepayment of principal
eg contributions = 50
TPPC = 25
—> 50-25 = 25
principal amount goes to CFF - CFF down by 25
CFO up by TPPC
COGS on I/S for Temporal Method
COGS = BGN Inventory + Purchases - Ending Inventory
Separate and translate each separately, then add back together for COGS
BGN Inventory = Historical
Purchases = Average
END Inventory = Historical
NOTE: BGN & END historical rates can be different
GAAP Vs. IFRS Hyperinflation
GAAP: NO adjusting for hyperinflation -> requires temporal method NO MATTER WHAT
IFRS: DOES allow adjustment –> re-state for inflation using price index under the CURRENT rate
Liquidity Coverage Ratio
High Quality Liquid Assets (Easy convert to cash)
____________________________________________
Expected Cash Outflows (in stress scenario)
NSFR
Available Stable Funding
_________________________________
Required Stable Funding
Days of Stress Level Cash
= LCR x # of days (given)
Total Capital Ratio
Tier 1 + Tier 2
_________________________________
Total RISK WEIGHTED Capital
Net Premium Written
Premiums Earned over Coverage Period (less reinsurance)
Net Premium Earned
Premiums earned over Accounting Period
Expense Ratio
Underwriting Expenses (incl. Commissions)
________________________________________
Net Premium WRITTEN
UW Loss Ratio
Incurred Losses + Loss adjustment expenses
_______________________________________
Net Premium EARNED
Combined Ratio
Expense Ratio + UW Loss Ratio
>100% = loss
High = Soft Market (can raise premiums )
Low = Hard market (can’t raise premiums much)
Dividends to Policyholders
Dividends to Policyholders
_____________________________
Net Premium Earned
CRAD
Combined Ratio after Dividends
Combined Ratio + Divs to policyholders ratio
For CVA:
Recovery Rate
LGD
Hazard Rate
Probability of Survival
Probability of Default
Discount Factor
Recovery Rate= percent recovered = 1 - Loss Severity
LGD = exposure x loss severity
Hazard Rate = Initial Prob of Default
Probability of Survival = (1 - Hazard Rate)T
Probability of Default = (Hazard Rate x PSt-1)
Discount Factor = PV of $1. so for y3 = 1 / (1+r)3
Required Return
Rf + ERP
build-up:
RfR + ERP + size premium + company-specific premium
Blume Method of adjusting beta
Beta tends to revert to 1.0 over time -> adjusts for beta drift
adjusted beta = (2/3 x regression beta) + (1/3 x 1.0)
ERP
(1y fwd forecased dividend yield) + (consensus growth rate) - (current LT gov bond yield)
Bond Yield Plus
Expected Return = ( YTM on Long Term Debt ) + ( risk premium)
Find Weights for WACC
We = Mkt Value Equity / (mkt value debt + mkt value equity)
same for Wd
Pastor-Stambaugh Model
Finds required return, adds a liquidity factor to the Fama french, making it more useful for pvt / thinly traded firms
PVGO
V0 = (E1 / r) + PVGO
Forecast FCFE
FCFE = NI - [(1-DR) x (FCInv - Depr)] - [(1-DR) x WCInv]
WCInv
∆(Current Assets - Cash & Investments) - (Current L’s - ST debt & Div’s payable)
Note: CHANGE
BGN WC - END WC
Change in WC
FCInv
END Net PPE
- BGN Net PPE
+ Depreciation
- Gain (loss) on sale of PPE
Leading P/E
1-b
__________________
r-g
Payout Ratio
_____________
r-g
Trailing P/E
(1-b)(1+g)
____________________
r-g
Leading P/E times 1+g
Justified P/B Ratio
ROE - g
_________________
r - g
AKA trailing P/E X ROE