Docstoc

INput - ESOP Services_ Inc

Document Sample
INput - ESOP Services_ Inc Powered By Docstoc
					                                                                                                                                                                                                             ESOP Services, Inc.
                                                                                                                                                                                                          www.esopservices.com
                                                                                                                                                                                                        East Coast 434-286-3130
                                                                                                                                                                                                       West Coast: 858-292-4819
Preliminary Tax Savings and Cash Flow Estimate
PAQA Data Input Sheet
COMPANY NAME
Edit cells and add lines as needed. Estimates are appropriate for this preliminary analysis.
ASSUMPTIONS:

               Estimated Value (for discussion purposes)
                                          ESOP Effective
                          Sale of percentage of company                0.0%

This Preliminary Analysis has been prepared for initial discussion purposes only and is provided without any representation or warranty as to the accuracy or
completeness of any information or analysis regarding the value of the Company, tax savings, or feasibility of an ESOP transaction.


                                                  Growth                                            Pro Forma Income & Cash Flow Statement
For Fiscal Years Ending     12/31                  Rate               2009              2010               2011              2012              2013             2014          2015
Revenues                                              10%      $10,000,000       $11,000,000       $12,100,000       $13,310,000       $14,641,000       $16,105,100    $17,715,610
Less: Expenses *                                      85%        8,500,000         9,350,000        10,285,000        11,313,500        12,444,850        13,689,335     15,058,269
Less: Employer 401(k), Profit Sharing etc.**          50%          250,000           262,500           275,625           289,406           303,877           319,070        335,024
Net Ordinary Income                                             $1,250,000        $1,387,500        $1,539,375        $1,707,094        $1,892,273        $2,096,695     $2,322,318
Other (Expenses) Income                                                  0                 0                 0                 0                 0                 0              0
Interest (Expenses) Income                                               0                 0                 0                 0                 0                 0              0
Earnings Before Tax (EBT)                                       $1,250,000        $1,387,500        $1,539,375        $1,707,094        $1,892,273        $2,096,695     $2,322,318
Less: Taxes (Federal & State)                         40%         (500,000)         (555,000)         (615,750)         (682,838)         (756,909)         (838,678)      (928,927)
Earnings After Tax                                               $750,000          $832,500          $923,625         $1,024,256        $1,135,364        $1,258,017     $1,393,391
Less: Dividends or S Corp Distributions                0%                0                 0                 0                 0                 0                 0              0
Change in Retained Earnings                                      $750,000          $832,500          $923,625         $1,024,256        $1,135,364        $1,258,017     $1,393,391
Cash Flow Statement
Beginning Cash Balance                                                  $0         $800,000         $1,685,000        $2,663,750        $3,745,888        $4,942,027     $6,263,858
Change in Retained Earnings                                        750,000           832,500           923,625         1,024,256         1,135,364         1,258,017      1,393,391
Depreciation                                           5%          100,000           105,000           110,250           115,763           121,551           127,628        134,010
Changes in Working Capital                                               0                 0                 0                 0                 0                 0              0
Non ESOP Amortization                                                    0                 0                 0                 0                 0                 0              0
Capital Expenditures                                   5%          (50,000)          (52,500)          (55,125)          (57,881)          (60,775)          (63,814)       (67,005)
Ending Cash Balance                                               $800,000        $1,685,000        $2,663,750        $3,745,888        $4,942,027        $6,263,858     $7,724,253

Total Eligible Compensation                            5%       $5,000,000        $5,250,000        $5,512,500        $5,788,125        $6,077,531        $6,381,408     $6,700,478
401(k) Deferral (% of Elig. Comp.)                    10%          500,000           525,000           551,250           578,813           607,753           638,141        670,048

* Exclude employer contributions to employee benefit plans, 401(k) PSP, etc.
** As a percentage of Payroll or deferral




                                                                                                                                                                                       56521fa1-e190-47d5-8d89-1e29fa9cbd02.xls
                                                                                                                                                                                                                           INput
                                                                                                                                                                                                                      7/26/2011

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:7/26/2011
language:English
pages:1