ࡱ> ba T8\p Seainin Bates Ba==K8X@"1Arial1Arial1Arial1Arial1 Arial1 Arial1 Arial1 Arial1Arial1Arial1Arial1Arial1 Arial1Arial1Arial1,Arial1Arial1Arial1.Arial1+Arial1+Arial1Arial1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1>141<Calibri1?Calibri1h8Cambria1Calibri1 Calibri""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.005*0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_- 0.0%                                                                      ff + ) , *     P  P    !   " ` #      $   % & a> '  H  H   H1   H+   H+   H+  @+   H  H  H   H   H  @  H  H  #x1  `   h+    h   L   L  H   H  @   H  @   H  H1  H   H*   H*  H1  @        H (     "     H  H+ (X+  @8  "X  H   L     D  H  H  "X  L  L  l    ||xč}A} _-;_-* "ef-@_- }A} _-;_-* "ef-@_- }A} _-;_-* "ef-@_- }A} _-;_-* "ef-@_- }A} _-;_-* "ef-@_- }A} _-;_-* "ef -@_- }A} _-;_-* "L-@_- }A} _-;_-* "L-@_- }A} _-;_-* "L-@_- }A} _-;_-* "L-@_- }A} _-;_-* "L-@_- }A} _-;_-* "L -@_- }A} _-;_-* "23-@_- }A} _-;_-* "23-@_- }A} _-;_-* "23-@_- }A} _-;_-* "23-@_- }A}  _-;_-* "23-@_- }A}! _-;_-* "23 -@_- }A}" _-;_-* "-@_- }A}# _-;_-* "-@_- }A}$ _-;_-* "-@_- }A}% _-;_-* "-@_- }A}& _-;_-* "-@_- }A}' _-;_-* " -@_- }A}( _-;_-* "-@_- }}) }_-;_-* "-@_-    }}* _-;_-* "-@_- ??? ??? ??? ???}-}/ _-;_-* "}A}0 a_-;_-* "-@_- }A}1 _-;_-* "-@_- }A}2 _-;_-* "?-@_- }A}3 _-;_-* "23-@_- }-}4 _-;_-* "}}5 ??v_-;_-* "̙-@_-    }A}6 }_-;_-* "-@_- }A}7 e_-;_-* "-@_- }x}8_-;_-* "-@_  }}9 ???_-;_-* "-@_??? ???  ??? ???}-}; _-;_-* "}U}< _-;_-* "-@_ }-}= _-;_-* " 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text % 0Good;Good  a%1 Heading 1G Heading 1 I}%O2 Heading 2G Heading 2 I}%?3 Heading 3G Heading 3 I}%234 Heading 49 Heading 4 I}% 5InputuInput ̙ ??v% 6 Linked CellK Linked Cell }% 7NeutralANeutral  e%"Normal 8Noteb Note   9OutputwOutput  ???%????????? ???:$Percent ;Title1Title I}% <TotalMTotal %OO= Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight16`8Sales forecasthCashflow P&LSheet1,SM[MonthTotalRevenue Cost of sales Gross profitGross profit margin (%)Premises (rent, rates) Telephone Insurance Depreciation!Interest and bank charges payable%Power (light, heat, electricity, gas)Other specific expenses Net profitNet profit marginExpenses/overheadsTotal expenses/overheads VAT invoicedDirectors loansShare capital investmentOther external finance/loansTOTAL CASH RECEIPTS CASH PAID OUTOPERATING EXPENSES SUBTOTALBad-debt provision#Plant and other capital expenditureLoan and financing repaymentsRepayment of directors loans!Other specific financing paymentsTOTAL CASH PAID OUT CASH BALANCE#CASH IN HAND AT BEGINNING OF PERIODCash sales excluding VATOther specific cash inflowCASH INSummaryby end month 1by end month 2by end month 3by end month 4by end month 5by end month 6TOTALCustomerStatusForecast% Close dateABC Ltd In progressDEF LtdGHI plcWeighted estimate JLK Partners Early stagesMonthly analysisCommentsby end month 7by end month 8by end month 9by end month 10by end month 11by end month 12Weighted forecastForecast total for periodEstimated close dateDrawings, wages or salaries AdvertisingPostage and carriageAccountancy fees&SALES FORECAST TEMPLATE - COMPANY NAME)CASHFLOW FORECAST TEMPLATE - COMPANY NAME0PROFIT AND LOSS FORECAST TEMPLATE - COMPANY NAMEMotor expensesLegal/professional feesEquipment hire Stationery30.04.1031.05.1030.06.1031.07.1031.08.1031.09.1031.10.1030.11.1031.12.1031.01.1128.02.1131.03.11'VAT payment due to HM Revenue & CustomsNET CASHFLOW FOR PERIODb(1 1W2;334n4U5956X7<7ccB T8  s3;FtS`h  dMbP?_*+%&?'?(?)?MNSamsung 7050 Series PCL5eps XXA4ter &''''" dX??&U} } } }  }  }  } } $} } s  h_  h q b              X J h d       j    ?Fc `#h iA k? rgm a$pDJJJ a%pD"JJJ a&p.D*JJJ a'p1D2JJJ a( p9D: J J J a) p?DB J J J a9 pHDJ J J J a: pQDR J J J a; pYDZ J J J a<p_DbJJJ a=phDjJJJ a>pqDrJJJXlJJ Y*#p %I `7 e+ e, e- e. e8 e/ d4 a$ 0 1f wM)fDDd 2 1f wM)f DDd 3 1f wM)f DDd 5 6f wM)f DDd n@#f  %U#o  %nff dd e+ e, e- e. e8 e/ d4 a% 0 1f wN)f "DDd 2 1f wN)f DDdD l 0KKKKKKKKKKKK(5 b{mmm\p{ ! " $ _% & ' ( ) * , _- J. / 0 1 2 4 _5 6 7 8 9 : < _= > ?  3 1 f wN) f !D D d !5 !6!f !wN)!f "D!D!d "n@#"f & %!U#"o  %! %dd %e+ %e, %e- %e. %e8 %e/ %d4 &a& &0 &1&f &wO)&f'D&D&d '2 '1'f 'wO)'f(D'D'd (3 (1(f (wO)(f)D(D(d )5 )6)f )wO))f*D)D)d *n@#*f* %&)U#*o %&) -bb -s+ -s, -s- -s. -s8 -s/ -b4 .a' .0 .1.f .wP).f/D.D.d /2 /1/f /wP)/f0D/D/d 03 010f 0wP)0f2D0D0d 15 161f 1wP)1f2D1D1d 2n@#2f6 %.1U#2o %.1 5dd 5e+ 5e, 5e- 5e. 5e8 5e/ 5d4 6a( 60 616f 6wQ)6f7D6D6d 72 717f 7wQ)7f8D7D7d 83 818f 8wQ)8f:D8D8d 95 969f 9wQ)9f:D9D9d :n@#:f> %69U#:o  %69 =dd =e+ =e, =e- =e. =e8 =e/ =d4 >a) >0 >1>f >wR)>fBD>D>d ?2 ?1?f ?wR)?f@D?D?d<h mm\p{mmm\p{mmm\p{mmm\p{@ A B D _E F G H I J L _M N O P Q R T _U V W X Y Z \ _] ^ _  @3 @1@f @wR)@fAD@D@d A5 A6Af AwR)AfBDADAd Bn@#BfF %>AU#Bo  %>A Edd Ee+ Ee, Ee- Ee. Ee8 Ee/ Ed4 Fa9 F0 F1Ff FwS)FfGDFDFd G2 G1Gf GwS)GfJDGDGd H3 H1Hf HwS)HfIDHDHd I5 I6If IwS)IfJDIDId Jn@#JfN %FIU#Jo  %FI Mdd Me+ Me, Me- Me. Me8 Me/ Md4 Na: N0 N1Nf NwT)NfODNDNd O2 O1Of OwT)OfPDODOd P3 P1Pf PwT)PfRDPDPd Q5 Q6Qf QwT)QfRDQDQd Rn@#RfV %NQU#Ro  %NQ Udd Ue+ Ue, Ue- Ue. Ue8 Ue/ Ud4 Va; V0 V1Vf VwU)VfWDVDVd W2 W1Wf WwU)WfXDWDWd X3 X1Xf XwU)XfZDXDXd Y5 Y6Yf YwU)YfZDYDYd Zn@#Zf^ %VYU#Zo  %VY ]dd ]e+ ]e, ]e- ]e. ]e8 ]e/ ]d4 ^a< ^0 ^1^f ^wV)^fbD^D^d _2 _1_f _wV)_f`D_D_d<h mm\p{mmm\p{mmm\p{mmm\p{` a b d _e f g h i j l _m n o p q r  `3 `1`f `wV)`faD`D`d a5 a6af awV)afbDaDad bn@#bff %^aU#bo %^a edd ee+ ee, ee- ee. ee8 ee/ ed4 fa= f0 f1ff fwW)ffgDfDfd g2 g1gf gwW)gfjDgDgd h3 h1hf hwW)hfiDhDhd i5 i6if iwW)ifjDiDid jn@#jfn %fiU#jo %fi mdd me+ me, me- me. me8 me/ md4 na> n0 n1nf nwX)nfoDnDnd o2 o1of owX)ofpDoDod p3 p1pf pwX)pfrDpDpd q5 q6qf qwX)qfrDqDqd rn@#rf %nqU#ro %nq&@mm\p{mmm\p{mmm .r >@rr{{{7ggD T8 /k yf  dMbP?_*+%&?'?(?)?MNSamsung 7050 Series PCL5eps XXA4ter &''''" dX??&U} (/  hT W V X J       ^ [                ?G WNW?W@W@W@W@W@W@W @W"@W$@W&@W(@ ~ VV. L+V.V.V.V.V.V. V.  V.  V.  V.  Y"I  N N N N  N  !N  Z# Z  %  # Z  %   Z    -  Z   Z   Z   Z   Z   Z   Z   Z   Z!  [ UN U N UN UN UDN U N ULN UBN UKN UIN UEN UJN U N L N L N < `v ````````````````````! ]# $ % & ' ( * @, . K !\#!]! %c#!]! %c!]!!!! -c!]!!!]!!!]!!!]!!!]! !! ]! !! ]! !! ]! !! ]*! #UN# $N$ %N% &N& 'wYN' (N( *@;*@*&8$!%#(!(;*@,&$!%#(!(;*@*&8$!%#(!(;*@*&8$!%#(!(;*@*&$!%#(!(;*@,&$!%#(!(;*@*&$!%#(!(;*@* &X$!%#(!(;* @* &x$! %#( !( ;* @, &$! %#( !( ;* @* &x$! %#( !( ;* @,&$! %#( !( ,wZ%,,D D*%,*D D*,,,,, LL,,,,,,,*,,,,,, ,, , ,, * ,, , ,, ., .K%.KDD,%.KDD,.K... LL.K..K..K..K..K .. K .. K .. K .. K. `````` .  > @.*"""7ggD T8 $X#i  dMbP?_*+%&?'?(?)?M6hp deskjet 990cXC 4d,,A4DINU"4$ŪF $$$$" d,X??&U} $h>@JJJJJ A  S  FJJJJJJJJJHJJJJJJJJ ?H @N@?@@@@@@@@@@@@@ @@"@@$@@&@@(@  M N INJJJJJJJJJJJJ # N %  N INJJJJJJJJJJJJ # N  %  N B A    LL A   A   A   A   A   A   A   A   A   A   A   O   P R% u D D u(    LL u L(   u L(   u L(   u L(   u L(   u L(   u L(   u L(   u L(   u L(  % v L D D  P G Q JNJJJJJJJJJJJJ  N    - J NJJJJJJJJJJJJ  N  JNJJJJJJJJJJJJ  N  JNJJJJJJJJJJJJ  N  UDNJJJJJJJJJJJJ  N  UCNJJJJJJJJJJJJ  N  U NJJJJJJJJJJJJ  N  ULNJJJJJJJJJJJJ  N  UBNJJJJJJJJJJJJ  N  HKNHHHHHHHHHHHH  N  UINJJJJJJJJJJJJ  N  UENJJJJJJJJJJJJ  N  UJNJJJJJJJJJJJJ  N  U JJJ6JJJJJJJJ  N  U NJJJJJJJJJJJJ  N  U NJJJJJJJJJJJJ  N L N LJ -JJ!JJJJ!J  J # J %  J!  J! J! @Dn    !D"#K P !C ,!D!DDD!D#! !! LLL!D#!!D!!!D!!!D#!!D#!!D! !! D! !! D# !! D# !! D#!! D# !" P #E%#t #D!D#t(!### LL#t L(##t L(###t L(###t L(!##t L(##t L(# ## t L(# ## t L(! ## t L( ## t L(## t L( # <    #  >@#"'''7ggD T8   dMbP?_*+%&ffffff?'ffffff?(?)?"333333?333333?&<3U>@ggD Oh+'0@HXp chrismSeainin BatesMicrosoft Excel@ϫ@՜.+,0 PX   Business Hotline Publications Sales forecast CashflowP&LSheet1  Worksheets  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPRSTUVWXZ[\]^_`Root Entry FWorkbookSummaryInformation(QDocumentSummaryInformation8Y