4. Financial Reporting Analysis Flashcards
Net Income (Formula)
Everything in
a. Revenues (-) COGS (-) SG&A (-) Dep/Amort (-) Taxes ----------------- = Net Income
Operating Profit (Formula)
Only COGS and SG&A
a. Revenues
b. (-) COGS
c. (-) SG&A
—————–
= Operating Profit
Gross Profit (Formula)
Only COGS
a. Revenues
b. (-) COGS
—————–
= Gross Profit
CFO (Cashflow formula)
a. NI (+) Dep/Amort (+) Working Capital (NCG) ----------------- = CFO ~ EBITDA (cuidado!)
CFO = NI + D + Deltas
Indirect v. Direct CFO Method
If using direct method, ignore depreciation
CFI (Formula)
CFI = Capex
\+ Sale of Assets - Purchase of Assets \+ Proceeds from Debt/Equity Investment - Loans Made / Equity bought ----------------- = CFI
CFF (Formula)
Equity/Debt related
+ Principal from Debt Issued
+ Proceeds from Issuing Stock
- Dividends paid
- Principal paid on debt
Dividends Paid v. Received (IFRS v. U.S. GAAP)
Gaap: dividends paid are always CFF; everything else is Operational
IFRS: If received, CFO/CFI. If paid, CFO / CFF
Inventory Accounting (Valuation Method)
Rule:
IFRS: Lower of (a) Cost or (b) Net Realizable Value (NRV)
U.S. GAAP: Lower of (a) Cost or (c) Market / Replacement, if LIFO or Retail Method
Others under U.S. GAAP: follow IFRS
- Assumptions:
(a) FIFO / LIFO / Weighted Avg Cost are assumptions for the outflow
Mkt Range (Gaap): If replacement (market) is out of the range, move to the range
Top: NRV (P * Q - SG&A)
Bottom: (NRV - Normal Profit)
PP and E Accounting (Valuation Method)
a. Cost Model (Purchase + Delivery & Installation), including depreciation, amortization
or
b. Revaluation Model
IFRS: Both accepted
U.S. GAAP: Cost model, only
Annual Test for Impairment: Impaired if Carrying Value > Recoverable Amount
Recoverable Amount = Higher (Value in use, NRV)
Accounts Receivable (Valuation Method)
Net Realizable Value (Gross + Bad Debt Allowances)
Inventory Costs
Sum of PRODUCT costs:
a. Purchase
b. Conversion
c. Transportation costs only to the plant
d. Labor and Overhead for manufacturing only
Obs.: Abnormal costs are expensed as incurred (storage, admin, selling costs, waste of materials)
Intangible Assets (IFRS v. US. GAAP)
IFRS: Purchased may be reported using cost or revaluation
U.S. GAAP: Cost method (only)
COGS (Formula)
Ending Inventory = Beggining Inv. + Purchases - COGS
Basic EPS
Basic EPS = (NI - Pref. Div) / Avg Shares
- Dividends via shares are adjusted backwards
Discontinued Operations Treatment
a. If sale is announced
b. Already sold, but the transference has not occurred yet
If (a) or (b), a separate result should be included in the Income Statement
Rationale for changes in:
a. Accounting Estimates
b. Accounting Rules / Principles
a. Assumptions = Restatement is not necessary
b, Principles = Restatement is necessary
Cost Recognizing Methods (IFRS)
a. Fair Value via P&L
b. Fair Value through OCI
c. Amortized Cost
Irrevocable choice for Equity Instrument to be treated as “b” is allowed
Cost Recognizing Methods (U.S. GAAP)
a. Trading Securities
b. Available for Sale
c. Held to Maturity
Goodwill Creation
Excess of Purchase Price in the Acquisition of Identifiable Net Assets
Condition: there is no internal goodwill
Classified Balance Sheet
Current / Non-Current Assets and Liabilities
Investment Property (IFRS v. U.S. GAAP)
IFRS: Amortized or Fair Value (in this case, any change is reported in the Income Statement)
U.S. GAAP: N/A. Treatment is the same as PP&E
Cashflow Representation (U.S. GAAP)
Indirect method is allowed (only). If the Direct method is included, it should be reconciled against Net Income
Interest / Taxes paid may be included in the Cashflow Statements or Audit Notes
Cashflow Representation (IFRS)
Direct / Indirect methods are both accepted
Interest / Taxes paid should be disclosed separately under each method
Cash Balance (Formula)
(a) CFI + CFO + CFF = Chg in Cash Balance
(b) Beggining Cash Balance + Chg = Ending Cash Balance
Double Declining Depreciation (DDB Formula)
DDB = (2 / Useful Life) * (Cost - Cumulative Dep)
Common-Size Cashflow (Basis)
% of Total Revenues
Free Cash Flow to Firm (Formula)
a. FCFF = NI + NCC + [(1-t) * Interest] - FCInv
b. NI + NCC = CFO
Free Cash Flow to Equity (Formula)
FCFE = CFO - Fixed Capital Inv + Net Borrowing
Debt Coverage Ratio (Formula)
Debt Coverage = CFO / Total Debt
Interest Coverage (Formula)
Interest Coverage = (CFO + Int Paid + Tax Paid) / Interest Paid
Unqualified Opinion
Audit opinion free of any issues
Qualified Opinion
Audit opinion with relevant issue
Vertical Analysis Basis for
a. Income Statement
b. Balance Sheet
a. Total Revenues
b. Total Assets
Receivables Turnover (Formula)
Rec Turnover = Annual Sales / Avg. Receivables
Inventory Turnover (Formula)
Inventory Turnover = COGS / Avg Inventory
Payables Turnover (Formula)
Payables Turnover = Purchases / Avg. Payables
Days of Inventory in Hand (Formula)
DIH = 365 / Inventory Turnover
Current Ratio (Formula)
Current Ratio = Current Assets / Current Liabilities
Quick Ratio (Formula)
Quick Ratio = (Cash + TVM + Receivables) / Current Liabilities
Cash Ratio (Formula)
Cash Ratio = Cash + TVM / Current Liabilities
Defensive Interval (concept and formula)
Defensive Interval = (Cash + Mkt Securities + Receivables) / Avg Daily Expenditures
Cash Conversion Cycle (Formula)
CCCycle = Dias a Receber + Dias de Inventário - Dias a Pagar