Microsoft Word peachtree case study
Download 0.84 Mb. View original pdf
|
| Schedule of Tables Table 1 National Economy Highlighted Historical Data (By Quarter) ........................................................ 34 Table 2 ACCRA Cost of Living Index (Q 2006)............................................................................................ 41 Table 3 Earnings by Key Non‐Farm Sector 2002‐2005 ................................................................................ 43 Table 4 US. Economy Long‐Term Outlook through 2011 .......................................................................... 45 Table 5 National Key Indicators for Plumbing Products (Blns US. Dollars) ................................................ 48 Table 6 May 2004 Hourly Earnings for Plumbers, Pipefitters, & Steamfitters ........................................... 48 Table 7 Historical Balance Sheets (2002‐2006) ........................................................................................... 62 Table 8 Historical Income Statements (2002‐2006) ................................................................................... 63 Table 9 Financial Statement Normalization Adjustments .......................................................................... 65 Table 10 Balance Sheet Normalization Adjustments .................................................................................. 66 Table 11 Normalized Balance Sheets (2002‐2006) ..................................................................................... 68 Table 12 Income Statement Normalization Adjustments ........................................................................... 71 Table 13 Salary Normalization Details ........................................................................................................ 72 Table 14 Rent Normalization Details .......................................................................................................... 72 Table 15 Normalization of Income (2002‐2006) ......................................................................................... 73 Table 16 Common Size Normalized Balance Sheets ................................................................................... 74 Table 17 Common Size Normalized Income Statements ............................................................................ 77 Table 18 Selected Financial Ratios ‐ Normalized Basis ............................................................................... 78 Table 19 Base Year Income Forecast for Valuation Purposes ..................................................................... 84 Table 20 Owner's Discretionary Earnings Calculations ............................................................................... 86 Table 21 IBA Comparable Transaction Statistics ‐ Total Data Base ............................................................ 89 Table 22 IBA Comparable Transaction Statistics ‐ Sales Volume ................................................................ 90 Table 23 IBA Comparable Transaction Statistics ‐ Geographic Region ....................................................... 91 Table 24 IBA Comparable Transaction Statistics ‐ Sale Price to Gross Sales .............................................. 92 Table 25 IBA Valuation Multiples ‐ Direct Market Data Method ................................................................ 93 Table 26 Direct Market Data Method Value Calculations .......................................................................... 94 Table 27 Net Cash Flow to Equity Calculation ............................................................................................ 98 Table 28 Capitalization Rate ‐ Build‐Up Method ...................................................................................... 100 Table 29 Single Period Capitalization of Income ....................................................................................... 105 Page 13 of 141 Table 30 Adjusted Book Value .................................................................................................................. 109 Table 31 Reasonable Rate of Return Calculation of Excess Earnings ....................................................... 111 Table 32 Valuation of Intangible Assets .................................................................................................... 111 Table 33 Adjusted Book Value Incl. Excess Earnings Indicated Operating Value ..................................... 112 Table 34 Summary of Estimated Operating Values .................................................................................. 113 Table 35 Implied Minority Interest Discount ............................................................................................ 116 Table 36 Summary of Restricted Stock Studies ........................................................................................ 118 Table 37 Summary of Selected Court Cases ............................................................................................. 119 Table 38 Summary Non‐Operating Assets ................................................................................................ 121 Table 39 Indicated Equity Values ‐ 5.45% Interest ................................................................................... 122 Table 40 Reconciliation of Indicated Equity Values ‐ (5.45% Interest) ..................................................... 124 |