companynameforecastmodel_v4

8/20/2019 CompanyNameForecastModel_V4

1/14

Financial Forecast ModelInstructions

* General guidelines This model is intended to be a high-level plug-and-play forecasting toolMost assumptions are common P&L inputs; this model will allow those input#s an e$ample% each major line item has been bro en down into supporting

1 Input historical actual data!opy and paste or lin data from ) % B % and !" into cells highlighted in yell!olumn ) should contain data from the most recent +uarter close!hec that balance sheet ties for all actual columns in row ,

2 Update income statement forecast assumptio#ll forecast assumptions should be input into cells highlighted in yellow in c/evenues are input as a 010 growth rate 2 'you can manually input a 3 am!45 are input as a 2 of revenue 'you can manually input a 3 amount in th4perating e$penses are input as a 2 of revenue 'you can manually input a4ther income1'e$pense( is input as a 3 value

Ta$ e$pense is input as 2 of pre-ta$ incomeMinority interest is input as a 3 value

3 Update balance sheet forecast assumptions

#ll forecast assumptions should be input into cells highlighted in yellow in cMost line items are automatically forecasted based on the assumptions desLong-term debt is input as a 3 value!hec that the balance sheet ties for all forecast columns in row ,

4 Update cash ow forecast assumptions#ll forecast assumptions should be input into cells highlighted in yellow in c

ome line items are automatically forecasted based on changes in the bala7epreciation is input as a 2 of revenue#morti8ation of intangibles is input as a 3 value

#morti8ed software development is input as a 2 of revenueB! 'stoc based compensation( is input as a 3 value

!apital e$penditures are input as a 2 of revenue!apitali8ation of software development is input as a 2 of revenueBusiness ac+uisition and investment e+uity are input as a 3 valuePurchase of shares is input as a 3 value4ther items are input as a 3 value


2/14

!euse for future periods The 6le is a rolling forecast and is always projecting 9 +uarters out from the

hift all historical data within the yellow highlighted cells so that column ) h!ontinue to use columns T*. to project the ne$t 9 +uarters


3/14

s to project a B and !" statement data% but you do not have to use all of them 'or you can rename them(

w in columns !*)

s lumns T*.

unt in the manual adjustment lines as an alternative(e 6$ed line as an alternative(

amount in the manual adjustment lines as an alternative(

lumns T*. ribed in column P

lumns T*.ce sheet as described in column P


4/14

prior +uarter close s the data from the most recent +uarter close


5/14

"#ompan$% Financial Forecast&er' 1'( P: - P: - P: #)3 Thousands #ctual #ctual #ctual Forecast

Income tatement!e&enue +,3(( 11,-(( 12,-(( 13,.((

/ecurring ervice 9%%== >,)mplementation ?== ,"i$ed == A== A== A==

Gross pro t ,2(( 0,0(( +,2(( .,33(

/perating e pense rr 11 rr 11 rr 11 rr 11ales & Mar eting 9%9== ?% == ,%===

5 % == %?== %


6/14

"#ompan$% Financial Forecast&er' 1'( P: - P: - P: #)3 Thousands #ctual #ctual #ctual Forecast#ccounts receivable %===

5oodwill - - - -)ntangible assets % == %=== %=== %===4ther assets % == % == % == % A)nvestment in e+uity interests - - - -7otal assets rr 11 rr 11 rr 11 22, +.

#ccounts payable % == % == %=== % ,#ccrued e$penses A%== ,%=== ,%===4ther liabilities %A== %>== %,== %< A7otal liabilities 40,3(( 4.,2(( (,+(( ,.12

!ommon stoc & addDtl P)! %A== %==( ' ?%?==( ' ?%9 (#ccumE other compE 'loss( income - - - -7otal shareholders8 e9uit$ :0,1((; :14,1((; :23,4((; :33,323;7otal liabilities and shareholders8 e9uit 4(,2(( 3 ,1(( 20,4(( 22, +.

Crr*9 Crr*9 Crr*9 -

#ash Flow tatementFet income Crr*9 Crr*9 Crr*9 Crr*9

7epreciation == == == ,<#morti8ation of intangibles >== A== A== -#morti8ed software development == == == -

7 % == == ,<#ccounts receivable ' == % == ', ()nventory - - - -4ther current assets =% == %?== ?== ' ? (#ccounts payable 9== '


7/14


B! - - - -C$cess ta$ bene6ts from B! - - - -

4ther items - - - -#ash from operating acti&ities rr 11 rr 11 rr 11 : ,-4(;

Purchases of PP&C '>==( '?==( '(

Business ac+E & e+uity invE - - - -4ther items ' % ==( - - -#ash from in&esting acti&ities :2,3((; :0((; :+((; :+34;

Borrowings 'repayments( of LT7% net - - - -Purchase of ordinary shares - - - -4ther items - - - -#ash from nancing acti&ities < < < <CGect of e$chE rate changes on cash - - - -5et :decrease; increase in cash rr 11 rr 11 rr 11 :-,404;

!ash and e+uivE at beginning of period Crr*9 Crr*9 Crr*9 %,==!ash and e+uivE at end of period Crr*9 Crr*9 Crr*9 9% ?


8/14


Income tatement < #ommon i=e

!e&enue 1((> 1((> 1((> 1((>

#/G > 30'3> 33'-> 34'.> 32'.>

Gross margin -2'0> --'4> - '1> -0'1>

/perating e pense >

/perating income >

CGective ta$ rate

5et income > rr 11 rr 11 rr 11 rr 11


9/14


Income tatement < ?o? Growth

!e&enue +2'.>

#/G -3'2>

Gross pro t .4'4>

/perating e pense

/perating income

4ther income1'e$pense(% net =E=2

Pre-ta$ income Ta$ e$pense

Minority interest

5et income


10/14

#) @ 1 #) @ 2 #) @ 3 #) @ 4Forecast Forecast Forecast Forecast

14,1( 1 ,-3 10,((( 1+,+3(>%


11/14


,%< ?


12/14


- - - -- - - -

- - - -:.,+(1; :0,0+1; :0,+20; :0,32+;

',=9( ',< ( '


13/14


1((> 1((> 1((> 1((>

32' > 31'0> 3('4> 3('0>

-0' > -+'3> -.'-> -.'3>

=E=2

rr 11 rr 11 rr 11 rr 11


14/14


-.'.> 34'+> 34'.> 3 ' >

4+'1> 20'1> 10'-> 2-'4>

+3'(> 3+'0> 44'2> 3.'.>

9=E=2 9 E

companynameforecastmodel_v4

Documents