Securities Valuation & Financial Modelling Flashcards
A firm’s potential to generate profits is determined by:
- Industry choice
- Competitive positioning
- Cost efficiency & control: Ability to carry out operations at low cost and the ability to control the costs
- Corporate strategy: Way in which firm creates synergies across its range of businesses
Boston Chicken - what were its 3 business areas?
- operates restaurants
- sells franchises
- financier for its area developers
Boston Chicken - accounting issues summary:
Boston Chicken - adjustments for accounting distortions:
Consolidate areal developers (ADs) financial statements with Boston Chicken (BC):
– fictitious consolidated entity
– Deals with Notes receivables from ADs as well as AD performance in current financial statements
– remove royalties interest
– add together revenues and expenses
Harvey Norman: Major Australian Retailer and Franchisor of Home Appliances, furnishings and Electronic items –> what where the problems?
- Transparency Issues
- Accounting Issues
- –> what
Key questions to ask to understand potential accounting/transparency problems:
Some RED flags for financial reporting
- using different accounting methods or estimates than the industry
- unexplained changes in methods/estimates (e.g. Delta changing depreciation from 10y to 20-30 like competitors do)
- big gap between NI and CFO
- unusual income-boosting transactions (on-off gains)
- related-party transactions (e.g. important for subsidiaries, leases, rentals, etc.)
- change in auditor (often untruthful “explanatory reasons” given)
- poor overall disclosure
Reformulated Balance Sheet - split into operating and financial part
Basic Dupont Model
Capital Employed has to equal… (and that in turn consists of…)
…Net Operating Assets
Reformulating Income Statement
Tax adjustments for reformulating the Income Statement - for Net Operating Income and Net Finance Expense
Page 11
Net Borrowing Cost
Return on Net Operating Assets
Return on Equity
Advanced Dupont Model
Identifying Sustainable Earnings - Items to Consider:
- Restructuring Charges: E.g. depreciate at 10 years instead of 5 years, then take RX charge after 5 years when selling
- Asset Impairments: Impair assets when new CEO takes over, to boost profits later
- Realized gains and losses
- Other” income/expenses
- Changes in estimates (e.g. Delta airlines useful life of airplanes)
- R&D (capitalizing)
- Advertising and promotion
- Income taxes (DTAs, valuation allowance)
How to calculate Core NOI?
Start with NOI, identify the non-recurring income/expenses within NOI, estimate tax on them: Core NOI = NOI – non-recurring income (expense) post-tax
How to calculate Core NFE?
Calculate NFE (after tax), identify the non-recurring items, estimate tax on them, then: tCore NFE = NFE – non-recurring income (expense) post-tax
Where do start with IS Reformulation?
EBIT
Marginal Tax Rate Method - how does it work?
*Assign to EBIT entire tax expense from IS
* But: Tax also related to NFE - because there is a tax benefit from the NFE
* so you you also have to add (reverse) the NFE tax benefit
* so you can calculate the Tax on NOI (Ebit/Operating Profit)
How to adjust NOI and NFE (and thus Net Income afterwards) considering taxes?
- Find reported NOI and NFE, sum one-off items for both categories, thus giving adjusted numbers
- Find Tax benefit (expense) on One-off income (expense) in NFE by taking NFE adjustments * marginal tax rate
- Find total non-underlying tax benefit (expense), and calculate the number for NOI given you calculated the NFE number
- To one-off items for NOI and NFE, add/substract the taxes –> then sum with reported to get adjusted numbers
What items are operating assets?
- Inventory, right-of-use assets, PPE, Trade and other receivables
- Financial Services customers and other banks
- Amounts due from Financial Services customers and other banks
- –> Investments in JVs and associates: Tricky, you have to decide
- –> Derivatives: If used for hedging - do they affect operations? Interest rate risk relates to debt, so their value should be included in debt; commodities or FX hedging or sales hedging probably operational
- Cash: Practice in banking - assign entire amount as financial asset (but could be split into operational and financial, but normally really does not matter)