business valuation model excel

8/12/2019 Business Valuation Model Excel

1/20

Business Valuation Model EVersion: 60 - Build: 20100925

from

Then add your business inputs to determine a forecas

Software License:

Not Licensed, for Evaluation On

In Evaluation Mode Business Revenue alied is loc!ed

#o fully ena$le t%is software it must $e lice

&urc%ase a license usin' t%e lin! $elow" Re'istration details

Inut your re'istration details $elow to re'ister and fully ena$

To purchase a soft!are license please vi

"s soon as your transaction is complete you !ill receive #e$istrat

&nput your #e$istration %etails belo! and 'ave to re$ister and f

Inut Re'istered Name:

Inut Re'istered Email (ddress:Inut Re'istration )ode:

'oft!are !hich is not correctly licensed e(poses individuals and bus

*opyri$ht + !!!bi,peponlinecom a member of the Bi,p

http:..!!!bi,peponlinecom.

#o startuse the sheet tabs to select the &npu

Inut is in $lue cells only /or full help please r

&nstruction 'heet

http:..!!!bi,peponlinecom.BusinessValuation

" sin$le user on-*ommercial icense is only

'ecure online transaction rocessin is rovided and is covered b our
http://www.bizpeponline.com/http://var/www/apps/conversion/tmp/scratch_1/http://www.bizpeponline.com/BusinessValuationReg.htmlhttp://www.bizpeponline.com/BusinessValuationReg.htmlhttp://var/www/apps/conversion/tmp/scratch_1/http://www.bizpeponline.com/


2/20

cel

t and valuation

ly

and not calculated"

nsed"

ill t%en $e sent $y email"

le your software"

it:

ion %etails by return email

lly enable your soft!are

iness to serious ris)

ep roup

sheet

fer to the:

#e$html

S+-"..

/. da mone $ac! uarantee
http://www.bizpeponline.com/BusinessValuationReg.htmlhttp://www.bizpeponline.com/BusinessValuationReg.htmlhttp://www.bizpeponline.com/


3/20

Inut 0 Business Valuation Model ExcelBlue cells allo! input Vie! comments by positionin$ your mouse over the red mar)er cell or clic) the hyperlin) for the

This section revie!s current business performance for a full year

(ample Business This appears on the 3utput 'heets

5004000 "nnual business revenue for the current year

In evaluation mode Business Revenue alied in )alculation s%eets is loc!ed to t%e Examle value of 1....."

Monetary &ercent 'et the (pense &nput as onetary or ercent"nnual costs that vary !ith the level of revenue

104000 2 *ost of items used in the product.service or resold

2004000 70 *ost of labor includin$ all benefits and add-ons

504000 10 *ost of an employee !ho could replace the o!ner

204000 7 *ost to $et the product.service to the consumer

104000 2 *ost of mar)etin$ and promotion

204000 7 "ny other costs incurred in the product.service/2.,... 3 Total Variable *osts and their 8 of #evenue

"nnual costs that do not vary !ith revenue704000 *ost of rent4 utilities etc (clude o!nership costs

04000 6 *ost of administration supplies and re;uirements

504000 10 *ost of labor includin$ all benefits and add-ons

104000 2 *ost of an employee !ho could replace the o!ner

0 0 &nterest component of loans4 'et to 0 for valuation0 0 "ny other overhead costs not already included

2/.,... 3 Total /i(ed *osts and their 8 of #evenue.,... 23 3peratin$ surplus before ta(ation

23.,... 34 3peratin$ surplus to o!ner includin$ !a$es

&nput #elative &ndicators to build a 100?&nc4 @100?%ec *ompetition1058 1008 1008 >100?&nc4 @100?%ec ar)et 'tren$th

1058 1058 1008 >100?&nc4 @100?%ec base *osts

1008 108 1058 >100?&nc4 @100?%ec base *osts

1008 1058 958 >100?&nc4 @100?%ec base &nterest

1108 1058 108 >100?&nc4 @100?%ec Business osition108 1058 1008 >100?&nc4 @100?%ec Variable fficiency

1008 1028 1058 >100?&nc4 @100?%ec /i(ed fficiency

258 The 8 increase in /i(ed *osts for each 1008 increase in revenue

1008 &nput the percenta$e of !or) hours applied to the business

604000 Ao! much could the o!ner earn if !or)in$ outside the business1004000 Chat is the value of business assets e(cludin$ property

Chat is the avera$e life of the assets

0 Ao! much could you sell the business real estate for

174591 3peratin$ capital4 $ood!ill4 etc This is adDusted by Valuation

274591

0 E%&V.0F &nput amount financed4 interest rate is calculated

274591 This is the amount of e;uity in the business

Outut 0 Business Valuation Model)urrent Exected Valuation is 346,1-2

Outut S%eets

&nput sensitivity factors to determine your forecast and valuation ran$e

&nput your desired #eturn on &nvestment to calculate the Business Valuation

Vie! (pected Business


4/20

Sensitivity (nalysis 0 Business Valuation Model Excel

208208

)urrent 5ear 5ear 2 5ear 3 5ear /

Business #evenue5004000 5=946 6174769 66046 6141=

5004000 560460 54=17 6254129 591450=

5004000 572405 564=6 5914795 5654=

3peratin$ 'urplus3ptimistic 604000 9=401 1224621 1294=7 116476=

(pected 604000 4695 10641=0 1054=2 10040=9

essimistic 604000 04605 90472 246 747=

3!ner *ash /lo!

3ptimistic 1204000 15=401 174721 19746 1=469=

(pected 1204000 174695 16=49=0 1=04262 162409

essimistic 1204000 1704605 152422 17=42=6 1764=0

Business #eturn

3ptimistic 7=4500 740 1094=66 11=42 1046=9

(pected 7=4500 =5415 94115 924090 =400=

essimistic 7=4500 6=472 ==41=0 6417 =1410Summary

The


5/20

Valuation (nalysis 0 Business Valuation Model Excel


6/20

Exected Results 0 Business Valuation Model ExcelExected 16"-> 2"/> ."3>9ross &rofit 2-.,... 333,/- 342,-/ 343,.2= 3/1,1/2

ross rofit 8 /6".> /-"=> 42"2> /6"=> /-"6>ar)-up ;uivalent 2"/> 1"-> -"6> /"3> "3>

/="1> /=".> /1".>

)oyri'%t 7 www"$i8eonline"com a mem$er of t%e Bi8e 9rou"

/ 5ear(vera'e


7/20

Otimistic Results 0 Business Valuation Model Excel

Otimistic Examle Business

)urrent 5ear 5ear 2 5ear 3 5ear /

Business Revenue 1..,... 1=-,66 24,4- .,// 26,2=/ExensesVaria$le )osts

Materials ? Sulies 104000 114=50 124 14259 23,44-8 #evenue 208 208 208 208 208

La$or excludin' Owner 2004000 2041=0 25421 2654969 34/,63.8 #evenue 7008 9=8 8 708 978

La$or Owner 504000 794602 514166 57420 12,8 #evenue 1008 68 8 28 78

;istri$ution 204000 2242 2242 27405 33,-/-8 #evenue 708 98 68 68 =8Mar!etin'

104000 114191 114191 12402= 22,4-8 #evenue 208 198 18 18 198Ot%er 204000 2242 2242 27405 33,-/-

8 #evenue 708 98 68 68 =8#otal Varia$le )osts /2.,... /4=,4== /14,==- /-/,1-3 /1,36/

Total Variable *osts 8 3".> 1-"-> 1="=> 1-"> 1-"2>9ross &rofit 2-.,... 3/3,322 31-,-. 3,==2 313,6-.

ross rofit 8 /6".> 4."2> 43"/> 4."4> 4."->ar)-up ;uivalent 2"/> "6> =/"3> ="6> -"3>

44"3> 4="3> 42"=>


/ 5ear(vera'e


8/20

&essimistic Results 0 Business Valuation Model Excel

&essimistic 3/"-> 3/"2> 3/"6>

#otal Exenses 44.,... 42,46. 4=/,/4. 1.-,2.- 462,/2.

Oeratin' Surlus .,... 6.,.1 -.,436 63,/6 64,4=/3peratin$ 'urplus 8 23".> 24"-> 2".> 2/"-> 24"->

Owner )as% 3=".> 34"-> 31"->

LESS;ereciation (llowance 124500 124=6 12499 140=2 23,-22Owners External Earnin' &ower 604000 604000 624160 65490 3,6/

Business Return 4=,1.. =,643 ==,2=. 6,/24 =2,2.6Return on Sales 958 1258 1=8 1158 1268

#otal Investment 346,1-2Return on #otal Investment 2-"2> 3="/> /2".> 3="1> 36">


/ 5ear(vera'e


9/20

*urrent

business valuation model excel

Documents