Written by the Founder and CEO of the prestigious New York School of Finance, this book schools you in the fundamental tools for accurately assessing the soundness of a stock investment. Built around a full-length case study of Wal-Mart, it shows you how to perform an in-depth analysis of that company's financial standing, walking you through all the steps of developing a sophisticated financial model as done by professional Wall Street analysts. You will construct a full scale financial model and valuation step-by-step as you page through the book. The New York School of Finance, founded by Mr. Pignataro, has trained thousands of business students and practitioners, and hundreds of bulge bracket banks and investment funds worldwide. Mr. Pignataro has also over 13 years of investment banking experience at some of the top firms on Wall Street. When we ran this analysis in January of 2012, we estimated the stock was undervalued. Since the first run of the analysis, the stock has increased 35 percent. Re-evaluating Wal-Mart 9 months later, we will step through the techniques utilized by Wall Street analysts to build models on and properly value business entities. Step-by-step financial modeling - taught using downloadable Wall Street models, you will construct the model step by step as you page through the book. Hot keys and explicit Excel instructions aid even the novice excel modeler. Model built complete with Income Statement, Cash Flow Statement, Balance Sheet, Balance Sheet Balancing Techniques, Depreciation Schedule (complete with accelerating depreciation and deferring taxes), working capital schedule, debt schedule, handling circular references, and automatic debt pay downs. Illustrative concepts including detailing model flows help aid in conceptual understanding. Concepts are reiterated and honed, perfect for a novice yet detailed enough for a professional. Model built direct from Wal-Mart public filings, searching through notes, performing research, and illustrating techniques to formulate projections. Includes in-depth coverage of valuation techniques commonly used by Wall Street professionals. Illustrative comparable company analyses - built the right way, direct from historical financials, calculating LTM (Last Twelve Month) data, calendarization, and properly smoothing EBITDA and Net Income. Precedent transactions analysis - detailing how to extract proper metrics from relevant proxy statements Discounted cash flow analysis - simplifying and illustrating how a DCF is utilized, how unlevered free cash flow is derived, and the meaning of weighted average cost of capital (WACC) Step-by-step we will come up with a valuation on Wal-Mart Chapter end questions, practice models, additional case studies and common interview questions (found in the companion website) help solidify the techniques honed in the book; ideal for universities or business students looking to break into the investment banking field
Preface xv The Walmart Case Study xvi How This Book Is Structured xvii Part ONE Financial Statements and Projections 1 Chapter 1 The Income Statement 3 Revenue 4 Cost of Goods Sold 4 Gross Profit 4 Operating Expenses 5 Other Income 6 EBITDA 6 Depreciation and Amortization 8 EBIT 8 Interest 9 EBT 9 Taxes 9 Net Income 10 Non-Recurring and Extraordinary Items 10 Distributions 11 Net Income (as Reported) 11 Shares 11 Earnings per Share (EPS) 12 Walmart's Income Statement 12 Revenue 15 Getting to EBITDA 19 Digging up Depreciation 19 Cost of Goods Sold 21 Gross Profit 22 Selling, General, and Administrative Expenses 23 Other Income 23 EBITDA 24 Beyond EBITDA 24 Depreciation and Amortization 24 EBIT 24 Interest 25 EBT 25 Taxes 26 Net Income 26 Non-Recurring Events 26 Net Income (after Non-Recurring Events) 28 Distributions 28 Net Income (as Reported) 29 Shares and EPS 29 Income Statement--Making Projections 31 Revenue 32 Cost of Goods Sold 36 Operating Expenses 38 Depreciation and Amortization 40 Interest Income 40 Taxes 40 Non-Recurring Events 42 Non-Controlling Interest 43 Shares 44 Basic Shares Outstanding 44 Diluted Shares Outstanding and the Treasury Method 45 Earnings per Share 47 Chapter 2 The Cash Flow Statement 51 Cash from Operating Activities 51 Revenue 53 Cost of Goods Sold 53 Operating Expenses 53 Depreciation 53 Interest 53 Taxes 54 Cash from Investing Activities 55 Cash from Financing Activities 55 Financial Statement Flows Example 56 Walmart's Cash Flow Statement 62 Cash from Operating Activities 62 Cash from Investing Activities 65 Cash from Financing Activities 66 Cash Flow Statement--Making Projections 68 Cash from Operating Activities 68 The Seven Methods of Projections 69 Cash from Investing Activities 73 Proceeds from Disposal of Property and Equipment 78 Items Based on Cash Available 78 Cash Flow from Financing Activities 81 Dividends 81 Purchase of Common Stock 82 Purchase of Redeemable Non-Controlling Interest 85 Payment of Capital Lease Obligations 85 Other Financing Activities 85 Effect of Exchange Rate on Cash 86 Chapter 3 Depreciation Schedule 91 Straight Line Depreciation 92 Accelerated Depreciation 93 Declining Balance 93 Sum of the Year's Digits 94 Modified Accelerated Cost Recovery System (MACRS) 94 Deferred Taxes 97 Deferred Tax Asset 97 NOL Carryback Example 98 Deferred Tax Liability 99 Projecting Depreciation 101 Straight Line Depreciation 101 Anchoring Formula References 105 Accelerated Depreciation 116 Chapter 4 Working Capital 139 Operating Working Capital 140 Walmart's Operating Working Capital 142 Receivables 145 Inventory 147 Prepaid Expenses 148 Accounts Payable 149 Accrued Liabilities 151 Accrued Income Taxes 152 Projecting Operating Working Capital 153 Receivables 154 Inventories 156 Prepaid Expenses 157 Accounts Payable 159 Accrued Liabilities 159 Accrued Income Taxes 160 Operating Working Capital and the Cash Flow Statement 160 Changes in Accounts Receivable 164 Inventories 164 Prepaid Expenses 165 Changes in Accounts Payable 168 Changes in Accrued Liabilities 168 Changes in Accrued Income Taxes 169 Chapter 5 The Balance Sheet 175 Assets 175 Current Assets 175 Cash and Cash Equivalents 175 Accounts Receivable 175 Inventory 176 Prepaid Expense 177 Non-Current Assets 178 Property, Plant, and Equipment (PP&E) 178 Intangible Assets 178 Liabilities 178 Current Liabilities 178 Accounts Payable 178 Accrued Liabilities 179 Short-Term Debts 179 Non-Current Liabilities 179 Long-Term Debts 179 Deferred Taxes 179 Walmart's Balance Sheet 180 Current Assets 180 Non-Current Assets 180 Goodwill 182 Other Assets and Deferred Charges 182 Current Liabilities 182 Non-Current Liabilities 183 Deferred Taxes 183 Redeemable Non-Controlling Interest 185 Shareholders' Equity 187 Balance Sheet Projections 191 Cash Flow Statement Drives Balance Sheet vs. Balance Sheet Drives Cas