diy-business-valuation-worksheets

Document Sample
diy-business-valuation-worksheets Powered By Docstoc
					Facts Sheet

Enter in Orange cells only

Company:
Purchase Price:                   $0 + SAV =           $0

Plant & Machinery                 $0   (At depreciated value)
Vehicles                          $0   (At depreciated value)
Equipment & Fittings              $0   (At depreciated value)
Stock (SAV)                       $0
Goodwill                          $0
Total                             $0   (adjusted for SAV)


Turnover
Gross Profit                      $0
                                            (Before depreciation, interest, owners
Net Profit                                           remuneration & tax)
Depreciation                      $0
EBIT & Remuneration               $0
Owners Remuneration               $0
EBIT                              $0




     www.onlinebookkeepers.co.nz +649 950 7578. +6427 429 5372 (027GayleSB)
(a) Capitalisation of profits method
Earnings before interest, taxation and remuneration             $0
Less management remuneration allowance                          $0
Earnings before interest and tax (EBIT)                         $0

Derive rate of return expected of similar industry share     11.0%
Plus risk and asset negotiability required by investor        7.0%
                                                             18.0%
Profit retention         33%                                  8.9%
Expected rate of return (after tax)                          26.9%
Allow for taxation       28%                                 37.3%
Expected rate of return before tax say                       37.3%
earnings before interest and tax / expected rate of return
= Value of the business                                         $0
less commercial allowance for stock               10%           $0
less tangible assets (plant, fittings, vehicles)                $0

Estimated Goodwill Value using this method is           $0
Estimated Sale Price of the business excluding stock is $0
Estimated Stock Value is                                $0

TOTAL BUSINESS VALUE                                            $0 adjusted for SAV




    www.onlinebookkeepers.co.nz +649 950 7578. +6427 429 5372 (027GayleSB)
(b) Price/Earnings Ratio Method
Sale price of the business      =             $0   =   #DIV/0! Years
          EBIT                                $0




( C ) Return on investment method
Earnings before interest and Tax (EBIT)   =   $0   =   #DIV/0!
Sale price of the business                    $0




     www.onlinebookkeepers.co.nz +649 950 7578. +6427 429 5372 (027GayleSB)
(d) Goodwill method
EBIT and Remuneration                                    $0.00
less MAR (Minimum Acceptable Return)
Fixed Tangile Assets(plant, fittings, vehicles, stock)   $0.00
At an Investment Rate of :            3%                 $0.00
Management Salary                                        $0.00
Total MAR                                                $0.00

SUPER PROFIT                                             $0.00

less Tax       28%                                       $0.00

Adjusted Super Profits (ASP)                             $0.00

Goodwill = ASP x           2.5 years of profit           $0.00

VALUE OF BUSINESS

Fixed Tangible Assets                                    $0.00
Intangible Assets                                        $0.00

TOTAL BUSINESS VALUE                                     $0.00




    www.onlinebookkeepers.co.nz +649 950 7578. +6427 429 5372 (027GayleSB)
       EBIT capitalisation method

Assumed Sustainable EBIT:      $0.00      A

     Industry Risk Factor:      0.25      B       (Between 0.25 and 0.30)

     Total price of assets:    $0.00   C = A/B    Business Value

                   Stock:      $0.00      D

  Value of Fixed Assets:       $0.00      E

                 Goodwill:          F
                               $0.00 = C-(A+D+E)




       www.onlinebookkeepers.co.nz +649 950 7578. +6427 429 5372 (027GayleSB)

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:7
posted:11/27/2011
language:English
pages:5