FINANCE 2 Cash flows financial planning Solvay Business
FINANCE 2. Cash flows + financial planning Solvay Business School Université Libre de Bruxelles Fall 2006 MBA 2006 Cash flows + financial planning
Sources of Cash Inflow and Cash Outflow Operating Activities Investing Activities Financing Activities Sales of goods and services Sale of fixed assets Sales of LT financial assets Issuance of stocks and bonds LT and ST borrowing CASH Operating Activities Investing Activities Purchase of supplies Selling, general and administrative expenses Tax expenses Capital expenditures and acquisitions LT financial investments CF from operating activities Financing Activities Repurchage of stocks and bonds Repayment of debt Dividend payment CF from investing activities MBA 2006 Cash flows + financial planning CF from financing activities 2
Farber. com: a fable • Starting a local version of Amazon. com • Initial balance sheet t = 0 Cash 100 Book Equity • Operations year 1: a. Sell 2 books @ € 100 each a. Buy 2 books @ € 50 each • Income statement year 1: Revenue 200 Expenses 100 Net Income 100 • But…. cash account = 0 100 What happened? MBA 2006 Cash flows + financial planning 3
Farber. com: what happened…. • Final balance sheet t = 1 Cash Account Receivable No payment from clients 0 200 Book Equity 200 Initial Capital + Retained Earnings • Statement of cash flows: reconciles the two views – Direct method: + Cash collected from customers - Cash payment to suppliers = Cash flow from operations – Indirect method: Net Income - Working Capital Requirement = Cash flow from operations MBA 2006 Cash flows + financial planning 0 + 100 - 100 + 200 -100 4
Farber. com: additional complications • Initial balance sheet t = 0 Cash 100 Book Equity 100 • Operations year 1: a. Borrow and buy 2 d hand computer @ € 200 a. Sell 1 books @ € 100 each a. Buy 2 books @ € 50 each • Income statement year 1: Revenue 100 Cost of goods sold 50 Depreciation 100 Interest 10 Net Income -60 • Final cash account -10 MBA 2006 Cash flows + financial planning Straight-line depreciation 2 years 5
Farber. com: details • Final balance sheet t = 1 • Cash -10 • Account Receiv. 100 • Inventories 50 • Fixed Assets 100 • Total 240 • Statement of cash flows: direct method Cash collection from customers -Cash payment to suppliers -Cash paid for interest Cash flow from operating activities Cash flow from investing activities Cash flow from financing activities Change in cash Book Equity Debt 40 200 Total 240 0 10 -110 -200 +200 -110 (=REV - AR) (=CGS+ INV) (= FA+Dep) MBA 2006 Cash flows + financial planning 6
Farber. com: statement of cash flows - indirect method • Statement of cash flows Net Income +Depreciation - Working Capital Requirement = Cash flow from operations -60 +100 + 150 -110 Cash flow from investing activities -200 Debt Cash flow from financing activities +200 Change in cash -110 MBA 2006 Cash flows + financial planning 7
Notations • • • Income statement REV Revenue CGS Cost of goods sold SGA Selling, general and administrative expenses Depreciation EBIT Earnings before interest and taxes Interest expenses TAX Taxes Tc Tax rate NI Net income • • • Balance sheet FA Fixed assets, net AR Accounts receivable INV Inventories CASH Cash & cash equivalents SE Equity capital LTD Long term debt AP Accounts payable STD Short-term borrowing • • Statement of retained income DIV Dividendes • MBA 2006 Cash flows + financial planning 8
Income statement and balance sheet • Income statement • EBIT = REV - CGS - SGA - Dep • TAX = Tc (EBIT - Int) • NI = EBIT - Int - TAX • Balance sheet equation • FA + AR + INV + CASH = SE + LTD + AP + STD Working capital requirement: WCR AR + INV - AP =(Current assets - CASH) - (Current liabilities - STD) Summarised balance sheet: FA + WCR + CASH = SE + D (D = LTD + STD) MBA 2006 Cash flows + financial planning 9
Cash flow statement : indirect method FA + WCR + CASH = SE + D FA = CAPEX - Dep CAPEX = Acquisitions - Disposals (investing & divesting) SE = NI - DIV + K K = New issuance of capital (NI + Dep - WCR) Cash flow from operating activities + - (CAPEX) Cash flow from investing activities + ( K + D -DIV) = CASH + Cash flow from financing activities MBA 2006 Cash flows + financial planning = 10
Statement of cash flows: direct method + Cash collection from customers - Cash payment to suppliers and employees - Cash paid for interest - Cash paid for taxes = Cash flow from operating activities REV - AR CGS + INV + SGA - AP Int TAX (REV-CGS-SGA-Int-TAX)- WCR =NI+Dep- WCR + Cash flow from investing activities -CAPEX + Cash flow from financing activity K + D - DIV = CASH (NI + Dep - WCR) + (-CAPEX) + ( K + D - DIV) = CASH MBA 2006 Cash flows + financial planning 11
Free Cash Flow • Free Cash Flow = Cash flow from operating activities + Cash flow from investing activities Free Cash Flow = DIV - K - D + Cash • Calculating free cash flows of all equity firm: Free Cash Flow = EBIT(1 -TC) + Dep - WCR - CAPEX • Statement of cash flows for all-equity firm: Free Cash Flow = DIV - K + Cash MBA 2006 Cash flows + financial planning 12
Financial Forecasting Income Statement of Cash Flows EBITDA -Depreciation =EBIT -Taxes +Net Income CF from operating activities CF from investing activities CF from financing activities Update Balance Sheet MBA 2006 Cash flows + financial planning 13
Financial Planning • Based on ∆Revenues • Assumptions on key ratios relating Revenues to: • Gross margin: m = EBITDA /Revenues • Working capital requirement: w = WCR / Revenues • Net fixed assets: a = NFA / Revenues • Financial policy: • Payout ratio p = DIV/Net Income • Depreciation d = Depreciation / Fixed Assets-1 • Environment: • Tax rate TC • Cost of debt i MBA 2006 Cash flows + financial planning 14
Data • Revenues year 0: 2, 000 • Growth rate year 1: 25% • Balance sheet end year 0 Net Fixed Assets 600 Working Capital Requirement 400 Cash 0 Total Assets 1, 000 Book Equity 600 Debt (financial) 400 Total Liabilities + Stockholders’ equity Gross margin: m = 30% WCR: w = 20% Net fixed assets: a = 30% Payout ratio p = 50% Depreciation d = 10% Tax rate TC = 40% Cost of debt i = 10% 1, 000 MBA 2006 Cash flows + financial planning 15
Step 1: Income statement Sales Year 0 Year 1 2, 000 2, 500 Rev-1 (1+g) EBITDA 750 m × Rev Depreciation 60 d × NFA-1 EBIT 690 Interests 40 Taxes 260 Net Income 390 TC × D-1 MBA 2006 Cash flows + financial planning 16
Step 2: Statement of Cash Flows Year 0 Year 1 Net Income 390 From Income Stat. Depreciation 60 From Income Stat. ∆WCR 100 w × Revenues CF from operations 350 ∆NFA 150 Depreciation 60 CF from investing -210 Div 195 a × Revenues p × Net Income Stock Issues/buy back 0 Assumption ∆Debt 55 Plug CF from financing ∆Cash -140 0 MBA 2006 Cash flows + financial planning 17
Step 3: Update balance sheet Year 0 Year 1 Net Fixed Assets 600 750 NFA-1 + Inv – Dep Working Capital 400 500 WCR-1 + WCR 0 0 Cash-1 + Cash 1, 000 1, 250 Book Equity 600 795 BEq-1+SI + NI – DIV Debt 400 455 D-1 + D 1, 000 1, 250 Cash MBA 2006 Cash flows + financial planning 18
The Full Model MBA 2006 Cash flows + financial planning 19
- Slides: 19