Cash Flow Statement Analysis, Exams of Business Economics

An in-depth analysis of the cash flow statement, a crucial financial statement that helps understand a company's liquidity and financial health. It covers key concepts such as cash from operations (cfo), cash from financing activities (cff), working capital, and the calculation of interest expense and enterprise value. The document also discusses various valuation methods, including discounted cash flow (dcf) analysis and comparable company analysis. Additionally, it covers topics related to leveraged buyouts (lbos) and accounting adjustments. This comprehensive resource would be valuable for students and professionals studying corporate finance, financial analysis, and valuation.

Typology: Exams

2024/2025

Available from 09/27/2024

kiana-githinji
kiana-githinji 🇺🇸

3.6

(20)

2.2K documents

1 / 44

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
1 / 12
Wall Street Prep Accounting Exam
Transaction Comps Modeling Wall Street Prep Exam Q&A
1. Liquidity Ratios: measures of a firm's short-term ability to meet its current
obligations
2. Profitability Ratios: measures of a firm's profitability relative to its assets (oper-
ating efficiency) and to its revenue (operating profitability)
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18
pf19
pf1a
pf1b
pf1c
pf1d
pf1e
pf1f
pf20
pf21
pf22
pf23
pf24
pf25
pf26
pf27
pf28
pf29
pf2a
pf2b
pf2c

Partial preview of the text

Download Cash Flow Statement Analysis and more Exams Business Economics in PDF only on Docsity!

Wall Street Prep Accounting Exam

Transaction Comps Modeling Wall Street Prep Exam – Q&A

  1. Liquidity Ratios: measures of a firm's short-term ability to meet its current

obligations

  1. Profitability Ratios: measures of a firm's profitability relative to its assets (oper-

ating efficiency) and to its revenue (operating profitability)

  1. Activity Ratios: Measure of efficiency of a firm's assets
  2. Solvency Ratios: Measure of a firm's ability to pay its obligations
  3. Inventory Turnover: COGS / avg inventory
  4. Receivables Turnover: revenue / average accounts receivable 7. DSO (Days

Sales Outstanding): AR/Credit Sales * days in period days in

period/receivables turnover

  1. A/P turnover: COGS / Average A/P
  2. PPP (payables purchasing period): days in period/ Accounts payable turnover
  3. Current Ratio: current assets/current liabilities
  4. Quick ratio (acid test): Cash and AR divided by current liabilities
  5. Gross profit margin: gross profit/revenue
  6. operating margin: operating profit/revenue
  7. net profit margin: net income/revenue
  8. asset turnover: revenue/ average assets
  9. return on assets (ROA): Net Income / Average Assets
  10. return on equity (ROE): net income/ total equity
  11. Basic EPS: (Net Income - Preferred Dividends)/(Weighted Average of Shares

Outstanding)

What is generally not considered to be a pre-tax non-recurring (unusual or infrequent) item? - Correct answer-Extraordinary gains/losses

what is false about depreciation and amortization - Correct answer-D&A may be classified within interest expense

Company X's current assets increased by $40 million from 2007-2008 while the companies current liabilities increased by $25 million over the same period. the cash impact of the change in working capital was - Correct answer-a decrease of 15 million

the final component of an earnings projection model is calculating interest expense. the calculation may create a circular reference because - Correct answer-interest expense affects net income, which affects FCF, which affects the amount of debt a company pays down, which, in turn affects the interest expense, hence the circular reference

a 10-q financial filing has all of the following characteristics except - Correct answer-issued four times a year.

Depreciation Expense found in the SG&A line of the income statement for a manufacturing firm would most likely be attributable to which of the following - Correct answer-computers used by the accounting department

If a company has projected revenues of $10 billion, a gross profit margin of 65%, and projected SG&A expenses of $2billion, what is the company's operating (EBIT) margin? - Correct answer-45%

A company has the following information, 1. 2014 revenues of $5 billion, Accounts receivable of $400 million, 2014 accounts receivable of $600 million, what are the days sales outstanding - Correct answer-36.

A company has the following information:

  • 2014 Revenues of $8 billion
  • 2014 COGS of $5 billion
  • 2013 Accounts receivable of $400 million
  • 2014 Accounts receivable of $600 million
  • 2013 Inventories of $1 billion
  • 2014 Inventories of $800 million
  • 2013 Accounts payable of $250 million
  • 2014 Accounts payable of $300 million What are the inventory days for the company? - Correct answer-65.7 days

Which of the following is true - Correct answer-Coca Cola's brand name is not reflected as an intangible asset on its balance sheet

A company has the following information:

  • 2014 share repurchase plan of $4 billion
  • Average share price of $60 for the year 2013
  • Expected EPS growth for 2014 of 10% What should the number of shares repurchased by the company be in your financial model? - Correct answer-60.6 million

non-controlling interest - Correct answer-is an expense on the income statement and equity o the balance sheet

A company has the following information:

  • 2013 retained earnings balance of $12 billion
  • Net income of $3.5 billion in 2 014
  • Capex of $200 million in 2014
  • Preferred dividends of $100 million in 2014
  • Common dividends of $400 million in 2014 What is the retained earnings balance at the end of 2014? - Correct answer- billion

in order to find out how much cash is available to pay down short term debt, such as revolving credit line, you must take - Correct answer-beginning cash balance + pre-debt cash flows - min. cash balance - required principal payments of LT and other debt

You estimate that the weighted average cost of capital (WACC) for Company X is 10% and assume that free cash flows grow in perpetuity at 3.0% annually beyond 2020, the final projected year. Calculate Company X's implied Enterprise Value by using the discounted cash flow method: - Correct answer-2951.2 million

On January 1, 2014, shares of Company X trade at $6.50 per share, with 400 million shares outstanding. The company has net debt of $300 million. After building an earnings model for Company X, you have projected free cash flow for each year through 2014 as follows:

Year 2014 2015 2016 2017 2018 2019 2020 Free Cash Flow 110 120 150 170 200 250 280

You estimate that the weighted average cost of capital (WACC) for Company X is 10% and assume that free cash flows grow in perpetuity at 3.0% annually beyond 2020, the final projected year. According to the discounted cash flow valuation method, Company X shares are: - Correct answer-.13 per share overvalued

the formula for discounting any specific period cash flow in period "t"is: - Correct answer-cash flow from period "t" divided by (1+discount rate raised exponentially to "t"

the terminal value of a business that grows indefinitely is calculated as follows - Correct answer-cash flow from period "t+1" divided by (discount rate-growth rate)

the two-stage DCF model is: - Correct answer-where stage 1 is an explicit projection of free cash flows (generally for 5-10 years), and stage 2 is a lump-sum estimate of the cash flows beyond the explicit forecast period

disadvantages of a DCF do not include - Correct answer-free cash flows over the first 5-10 year period represent a significant portion of value and are highly sensitive to valuation assumptions

the typical sell-side process - Correct answer-shorter than the buy side, buyer secures financing, and doesn't involve id'ing potential issues to address such as ownership and unusual equity structures, liabilities, etc.

the following happened in a recent M&A transaction: 1. PP&E of the target company was increased from its original book basis of $600 million to $800 million to reflect fair market value for book purposes in accordance with the purchase method of accounting. 2. no "step-up" for tax purposes. 3. original tax basis of $650 million. assuming a corporate tax rate of 35% for book purposes, the company should record the following - Correct answer-A deferred tax liability equal to $52.5 million

An acquisition creates shareholder value: - Correct answer-when a company acquires a business whose fundamental value is higher than the purchase price

  • Acquirer purchases 100% of target by issuing additional stock to purchase target shares
  • No premium is offered to the current target share price
  • Acquirer share price at announcement is $
  • Target share price at announcement is $
  • Acquirer EPS next year is $3.
  • Target EPS next year is $2.
  • Acquirer has 4 thousand shares outstanding
  • Target has 2 thousand shares outstanding What is the exchange ratio for the deal? - Correct answer-1.7x
  • Acquirer purchases 100% of target by issuing additional stock to purchase target shares
  • No premium is offered to the current target share price
  • Acquirer share price at announcement is $
  • Target share price at announcement is $
  • Acquirer EPS next year is $3.
  • Target EPS next year is $2.
  • Acquirer has 4 thousand shares outstanding
  • Target has 2 thousand shares outstanding

A good LBO candidate has which of the following characteristics? - Correct answer-Little to no existing leverage, steady cash flows and little investment in business through capex and working capital

Which of the following is NOT a disadvantage of performing an LBO analysis? - Correct answer-Stand-alone LBO may overestimate strategic sale value by ignoring synergies with acquirer

While equity contribution went as low as the single digits in the 1980's, the current split between equity and debt in an LBO deal is best characterized as: - Correct answer-Equity - 35%; Debt 65%

When an LBO sponsor wishes to exit its investment in 5 years, one way to find the equity value of a company at the LBO sponsor's exit year is to: - Correct answer- Use an Enterprise Value/Sales multiple to find Enterprise Value and then subtract net debt Use an Enterprise Value/EBITDA multiple to find Enterprise Value and then subtract net debt Use a Price/Earnings multiple to find Equity Value

Under recapitalization accounting - Correct answer-The purchase price is reflected as a reduction to equity

which of the following is true about senior debt - Correct answer-None of the Below. Has the least restrictive covenants because it is secured by the company's assets Since it is secured by the company's assets, lenders prefer to have the debt outstanding over time in order to generate more interest Usually uses PIK securities or come with warrants like mezzanine debt

On December 30, 2013:

  • Company Y trades at $10 per share
  • Enterprise Value / EBITDA multiple of 5.0x
  • Leverage ratio of 0.6x (Net debt/EBITDA)
  • 2013 EBITDA = $2.0 billion
  • Assume no cash on company Y's balance sheet

On December 31, 2013:

  • Company Y undergoes an LBO and is recapitalized
  • The company's new leverage ratio becomes 5.0x
  • Financial sponsor exit is planned for Year 5. Assume that the EV/ EBITDA multiple at exit year is the same as the current multiple.
  • Required rate of return is 25%
  • Exit year EBITDA projected to be $3.0 billion
  • The company's year-end leverage ratio is 1.6x What is the initial Equity Value? - Correct answer-8.8 billion

On December 30, 2013:

  • Company Y trades at $10 per share
  • Enterprise Value / EBITDA multiple of 5.0x
  • Leverage ratio of 0.6x (Net debt/EBITDA)
  • 2013 EBITDA = $2.0 billion
  • Assume no cash on company Y's balance sheet On December 31, 2013:
  • Company Y undergoes an LBO and is recapitalized
  • The company's new leverage ratio becomes 5.0x
  • Financial sponsor exit is planned for Year 5. Assume that the EV/ EBITDA multiple at exit year is the same as the current multiple.
  • Required rate of return is 25%
  • Exit year EBITDA projected to be $3.0 billion
  • The company's year-end leverage ratio is 1.6x How much debt is paid down by the exit year (since the LBO announcement)? - Correct answer-5.2 billion

On December 30, 2013:

  • Company Y trades at $10 per share
  • Enterprise Value / EBITDA multiple of 5.0x
  • Leverage ratio of 0.6x (Net debt/EBITDA)
  • 2013 EBITDA = $2.0 billion
  • Assume no cash on company Y's balance sheet On December 31, 2013:

Company A's major competitors are trading at an average share price / 2014 Expected EPS of 15.0x. Using the comparable company analysis valuation method, Company A shares are: - Correct answer-2.5 per share undervalued

When looking to do a transaction comp analysis, some of the merger-related filings that should be looked at include each of the following except: - Correct answer-Form s-

when determining value for a company based on transaction rather than trading comps, one of the key differences that will affect the value is - Correct answer- premium paid for control of the business

Garth's Micro Brewery, whose shares are currently trading at $40 per share, is considering acquiring Wayne's Beer Bottling Co. You have compiled a group of comparable transactions within the beer bottling space and have calculated that since 2014, acquisitions similar (or comparable!) to the one Garth's is currently considering have had transaction values (offer value of target plus any target debt, net of cash) that are, on average, 8.0x target's EBITDA.

  • Wayne's shares currently trade at $34 per share
  • Wayne's has 50 million diluted shares outstanding
  • Wayne's LTM EBITDA was $250 million
  • Wayne's Net Debt was $200 million What is the offer value per share and the offer premium? - Correct answer-$36. per share; 5.9%
  1. asset write downs / impairments: -added back to CFS via CFO
  2. Increases in A/R, inventory, prepaid expenses, other current assets should

be net income to get to CFO: subtracted

  1. increases in A/P, accrued expenses, other current liabilities should be

net income to get to CFO: added

  1. gains on sale of assets: subtracted from CFO
  2. stock based compensation: added to CFO
  3. Common CFI inflows/outflows: - capital expenditures
  • purchases of intangible assets
  • asset sales

  • sales of debt/ equity security

  • purchases of debt/equity security
  1. Common CFS inflows/outflows: -Issuance / repayment of debt (cash inflow /

outflow)

-Common stock issued / repurchased (cash inflow / outflow)

-Payment of common & preferred dividends (cash outflow)

  1. Form 8-Q: Required filing any time a company undergoes or announces a

materially significant event such as an earnings press release, an acquisition,

disposal of assets, bankruptcy, etc.

  1. Form 14A: Required filing prior to company's annual shareholder meetings
  2. S-1 Registration: IPO
  3. The only parts of a financial statement that a financial analyst will need to pay attention to:: oPart 1, item 1. Business

oPart 2, item 6. Selected financial data oPart 2, item 7. Management's Discussion

and Analysis of Financial Condition and Results of Operation oPart 2, item 8.

Financial statements and supplementary data

  1. Revenue: Represents proceeds from the sale of goods and services

produced or offered by a company

  1. Revenue Recognition: Multiple Deliverables: For sales of bundled

products, companies should assign individual values to each of the bundled

components

  1. Revenue Recognition: Long-term projects: 1. Percentage Completion

Method

  1. Completed Contract Method
  2. Percentage Completion Method: revenues are recognized on the basis of

the percentage of total work completed during the accounting period

-Equipment used for selling (cash register)

-Executive salaries

-Legal expenses

  1. R&D: R&D expenses stem from a company's activities that are directed at

developing new products or procedures

  1. Depreciation Expense: Quantifies wear and tear of a physical asset through

systematic decrease of historical value

  1. Useful Life of Fixed Assets (examples): Plants and buildings 15-40 yrs

Machinery & Equipment 3-20 yrs

Furniture & Fixtures 5-10 yrs

Computer Software & Hardware 3-5 yrs

  1. Is land depreciated?: no
  2. Depreciation is included within depending on whether the

asset being depreciated is directly tied with manufacture or procurement or

selling or marketing: COGS or SG&A

  1. Depreciation and amortization are a expense: non-cash
  2. Straight Line Depreciation: Annual depreciation expense = (original cost-

sal- vage value)/useful life

  1. Accelerated Depreciation Methods: -calculates a greater amount of depreci-

ation in early years

-declining balance, sum of years digits, units of production

  1. Amortization Expense: Allocation of the cost of intangible assets over the

number of years that these assets are expected to help generate revenue for

the company

  1. Types of Intangible assets: Customer lists

Franchise, membership, licenses