ࡱ> Root EntryRoot Entry FbYFkCompObj fWorkbookGkMSDigSig(Author)$<X  !"#$%&'()*+,-./0123456789:;=>?@ABCDEFHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|SummaryInformation(gDocumentSummaryInformation8$ ՜.+,D՜.+, PXd lt| :  Question Solution  Worksheets  8@ _PID_HLINKSA Nmsbpz://-r:276DB13A/Nmsbpz://-r:276DB13A/ FMicrosoft Excel WorksheetBiff8Excel.Sheet.89qOh+'0f X` +Working with Cash Flow Forecasts: QuestionfMicrosoft Corporation FMicrosoft Corporation FMicrosoft Excel@.u@7)+@Ge*  2&" WMFC l&lFd_* EMFlF  @    !" !" !  " !  `'%    &% 6% Ld!??% 6% Ld!??% 969% Ld999!??% J6J% LdJJJ!??% [6[% Ld[[[!??% l6l% Ldlll!??% }6}% Ld}}}!??% 6% Ld!??% 6% Ld!??% 6% Ld!??% 6`% Ld__!??% #6#% Ld###!??% 6% Ld!??% 6% Ld!??% _6_% Ld___!??'%  Ld!??'%  ( &% 6% Ld!??% 6% Ld!??%  ( &% 6% Ld!??% 6% Ld!??% % RLArialArial# WXw $\lP@$0) $\l|pd+%w0%    TT AA LP1re   ( &% 6% Ld!??   TT (7AA (LP2{@   %  6 % Ld   !??   TT :IAA :LP3   % :6:% Ld:::!??   TT KZAA KLP4z   % K6K% LdKKK!??   TT \kAA \LP5   % \6\% Ld\\\!??   TT m|AA mLP6   % m6m% Ldmmm!??   TT ~AA ~LP7v   % ~6~% Ld~~~!??   TT AA LP8F0   % 6% Ld!??   TT AA LP9   % 6% Ld!??   TT"AAL#PA0    % 6% Ld!??   TTyAAyLPB    % $6$% Ld$$$!??   TTAALPC    % 6% Ld!??   TT9AAA9LPDer    % 6% Ld!??% % " !% %&" WMFC llF   `'%    Ld#9 )!??'% (  Ld#_9#)!??'% (  Ld9#9 !??'% (  Ld#9_#9!??RL Tahoma Tahoma`hۍ0WXw G\@$0 G\ 0%    T3 +8AA3 LMicrosoft Business Planner       RL Verdana Verdana`hۍ0WXw H\@$0 H\0%  T2MYAA2MLhGo to Article:   RL  Verdana Ref Verdana Refw}!w`WXw M\@$0 M\3 0% T2^ykAA2^ LdOver-TradingRL  Verdana Verdana`hۍ0WXw I\@$0 I\ 0%   RL  Verdana VerdanaDhۍ0WXw ?\@$0 ?\ D0% %  % % % % % % % " !% %   $`%   TH3_AA3*LWorking With Cash Flow Forecasts: Question             % %  % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % " !% %   $`% % % % % % % % % % %   T2_AA2dLThis exercise demonstrates how small alterations to the cash flow forecast can have a big effect on     T2AA2Llthe bottom line. T2_AA2FLRework the cash flow forecast below, making the following assumptions:      T2_AA2`L 1) Existing customers pay their bills faster, amounting to 1,000 per month more cash coming in.     T2_AA2=L2) The furniture and fittings cost 2,000 less, i.e. 10,500.T2_AA2`L Your answer should provide a pleasant surprise for High Note's owner and bankers. When you have    T2_AA29Lfinished, click on the "Solution" tab to check your work. % % % " !% %   `% % " !% %   `' % ( L&WMFCllF    ( &% % Ld!??% % Ld#!??% % Ld!??% % Ld!??% % Ld_!??'%   ( &% #}6a}% Ld#}_}#}>!??% ( % " !%   `% " !%   `'%    ( &% 6`% Ld_`!??% 6% Ld!??% "   `  '' ' ,`-  -- @ !-- @ !-99- @ !9-JJ- @ !J-[[- @ ![-ll- @ !l-}}- @ !}-- @ !-- @ !-- @ !-`- @ !_-##- @ !#-- @ !-- @ !-__- @ !_-  @ !- -- @ !-- @ !- -- @ !-- @ !--Arial-  2  1 -- @ !  2 ( 2 -  - @ !   2 : 3 -::- @ !:  2 K 4 -KK- @ !K  2 \ 5o -\\- @ !\  2 m 6 -mm- @ !m  2 ~ 7 -~~- @ !~  2 8 -- @ !  2 9 -- @ !  2 #A  -- @ !  2 yB  -$$- @ !$  2 C  -- @ !  2 9D  -- @ !-"System-'-- ,`-   @ !) -    @ !)#-    @ ! 9-    @ !9# Tahoma-  .2 3Microsoft Business Planner        Verdana-  2 M2Go to Article:    Verdana Ref- 2 ^2 Over-Trading Verdana-    Verdana--  - - - - - --'- -  ,`$-  F2 3*Working With Cash Flow Forecasts: Question             - - ----------------------------------------'--  ,`$----------- 2 2dThis exercise demonstrates how small alterations to the cash flow forecast can have a big effect on     2 2the bottom line. p2 2FRework the cash flow forecast below, making the following assumptions:      2 2`1) Existing customers pay their bills faster, amounting to 1,000 per month more cash coming in.     c2 2=2) The furniture and fittings cost 2,000 less, i.e. 10,500.,2 2`Your answer should provide a pleasant surprise for High Note's owner and bankers. When you have    ]2 29finished, click on the "Solution" tab to check your work.o ---'--  ,`--'--  ,`-   -- @ !-- @ !#-- @ !-- @ !-- @ !_-  -}#}a- @ !>}#- -'- ,`-'- ,`-   -`- @ !`-- @ !-'0P *H A0=10 *H 0g +7Y0W03 +70%7)O•0 0 *H =Oz˧ω?00)ъĽ5ǛSV0  *H 010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.0 970512070000Z 991231070000Z010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.00  *H 0. h|,-.  WSu3* [4 Z%}XsjxqX)X^-bXq"X/6MJ;"V~!lJGj6 -Ӵ90  *H :>{թy=q#+(ߌe,ZbVkbEƢ5"r-| CMlX 5ʉp*}a qfbB="2"d$006C!FXF%`0  *H 010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.0 970512070000Z 991231070000Z01'0%U VeriSign Time Stamping Service10U VeriSign Trust Network1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.10U VeriSign, Inc.10UInternet00  *H 0aGܴ^i b1FI:?xZcEO n06- o' Q`5OTOз,B Ѝ^㖴"IBlӘV.:X"e匫xGBh[-}0  *H m`_i{p+b#D Q#tI'\q5+ൖ苧KsH ڋ %VNGWF8V!&;-%2Λ@GmGv0;~*1+ݰUApF-,~0 0 yfnжneq0  *H 0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA0 980416000000Z 990416235959Z0]10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA1F0DU =www.verisign.com/repository/CPS Incorp. by Ref.,LIAB.LTD(c)961>0<U 5Digital ID Class 3 - Microsoft Software Validation v21 0 UUS10U Washington10URedmond10UMicrosoft Corporation10U Microsoft Corporation0 0  *H  0&dm{AO o*q.S26h5IؖeS zpm̳*02X|k%gw #1z0v0u0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CAyfnжneq0 *H 0 *H  1  +70 +7 10  +70 *H  1jNL>8"]|DK0 +7 10TRExercise Working with Cash Flow Forecasts<:http://bookshelf.msn.com/z/msbp/teleport/fromCD/office.asp0  *H j_)\S ]08\zSCf6+c\$2d);rCaw!Ma{zB)F6 ~/GZ\J5ݿJBvlH܄gg9wmb kK3OG@@=i#iхkut|l]|Ǎ'[ *C-HF!Ue^\ѳ0`^neVۆSAVft iq>\6l}* 0 *H  100010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.C!FXF%`0 *H Y0 *H  1  *H 0 *H  1 981201005509Z0 *H  1fӯC886:6DMA@w0  *H RDg Bsl{EcK*>5B-q]_)7[u5-Cjm ؇?ʜ/:5݀%{ Ɓ$m<&~A} @`\pMicrosoft Corporation Ba==-j,8X@"1Arial1Arial1Arial1Arial1 Verdana1Verdana1Verdana1 Tahoma1Tahoma1Tahoma1Tahoma1 Arial1@ Tahoma1Tahoma1@ Tahoma1Verdana1Verdana1Verdana1& Verdana Ref1& Verdana Ref1& Verdana Ref1& Verdana Ref1&? Verdana Ref"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)"IR"#,##0;\-"IR"#,##0!"IR"#,##0;[Red]\-"IR"#,##0""IR"#,##0.00;\-"IR"#,##0.00'""IR"#,##0.00;[Red]\-"IR"#,##0.00;6_-"IR"* #,##0_-;\-"IR"* #,##0_-;_-"IR"* "-"_-;_-@_-,'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-C>_-"IR"* #,##0.00_-;\-"IR"* #,##0.00_-;_-"IR"* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.0050_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-=8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_- "$"#,##0.00 "$"#,##0#,##0;\ \(#,##0\)#,##0_);\ \(#,##0\)                 %@@   7 % @  %@"@        D $ 7 # ! ! ) )  % @  !7  7     @  `  `  %   ` p !p@  %   `7   % 7   `7   % 7   % 7   `  @ %!x  A  %   %1p  %  %!`    %0  a` h@@  `@  ` @ %! @  %!   %!`  %!`   a87   A(   a    a(   a8   a8 7   !x@  A0 A( %1 7   %(  %A "@  %1 "@  %1 "7 @   p  `  `7  %A("@  Q  Ah@@ %1h@  %1h @   %   %0 Ah@ %1h  %1h      a 87  %!`  a`  A`  %`  %1p %!x !7   H7 !  @ !  `  `7 ) ) X P h ` ! !7 # ) ) ) )  amount Body text header Header Total Header1 Header2 Header3 Header4NonPrint_copyrightNonPrint_HeadingNonPrint_HyperlinkNonPrint_TemTitle NonPrint_Text Normal 2 Product Title Text !Title`QuestionUSolution  ; %  ;. gJ#MayJuneJulyAugSept(High Note's Six-Month Cash Flow ForecastSales PurchasesRent, Rates etc.Wages AdvertisingFixtures and Fittings-Totals for SalesMonth:Apriland Purchases OnlyReceiptsCapital IntroducedLoans ReceivedTotal ReceiptsPaymentsTotal PaymentsCashflow Surplus/Deficit (-)Opening Bank BalanceClosing Bank BalanceGo to Article: Over-TradingScroll down to see the solution*Working With Cash Flow Forecasts: Question*Working With Cash Flow Forecasts: SolutionThis exercise demonstrates how small alterations to the cash flow forecast can have a big effect on the bottom line. Rework the cash flow forecast below, making the following assumptions: 1) Existing customers pay their bills faster, amounting to 1,000 per month more cash coming in. 2) The furniture and fittings cost 2,000 less, i.e. 10,500. Your answer should provide a pleasant surprise for High Note's owner and bankers. When you have finished, click on the "Solution" tab to check your work.Microsoft Business PlannerNote: If you save this template as a workbook, note the workbook's file name and location. To edit the workbook next time, you must open it using Excel. Every time you open this template from Business Planner, a new workbook is created.f Colin Barrow 1998, Accounting: Financial Management for the Small Business, published by Kogan Page.M* QlLg ( @ 4#+3=8=MCH]NS)U  dMbP?_*+% &LDate: &D&x?????@6 /^#($$$$$$A6 /^#($$$$$$ _  # /^# B C C C C D E F 9 /^#GHHHHHH*# /^# I'&&&&&,# /^# )*%@@%@%@%X@%p@%L@#Jp@% %+ # /^# K~ %@%%%%%-2 /^# K~ %@%%%%%+5 /^# LMp@ -&M@M@MX@Mp@ML@ N5 /^#OPQQQQQR4 /^# I'&&&&&,# /^# )*%|@% @%|@%@%:@%@#J@ % # /^# 3*%@%@%@%@%@%@ +# /^# 3 *%@@%@@%@@%@@%@@%@@ +# /^# 3 *%@o@%@o@%@o@%@o@%@o@%@o@ +# /^# 3 ~ %j@ 8 8 8 8 8 +5 /^# SM @! -.Md@!MZ@!Mk@!M)@!M@! N5 /^D l(<(<<((<<(<2,@,@,@LL ,@bbb !"#$%&'()*+,-./0123456789:;<=>? #T$$$$$$*4 /^!# !U!V$@%!!! LL!Vp%!!V%!!V%!!V%!!V@%! !W# !/^"#OXXXXXX*5 "/^## #U~ #V#V$@D%#V@D%#VpD%#VD%#V D% #W1 #/^$#OYXXXXX.1 $/^%# %Z%[$@#%%%,,B%[@#%%[p#%%[#%%[ #%%[,% %\# %/^&""""""""## &/^'"""""""""# '/^ (/^ )/^ */^ +/^ ,/^ -/^ ./^ //^ 0/^ 1/^ 2/^ 3/^ 4/^ 5/^ 6/^ 7/^ 8/^ 9/^ :/^ ;/^ </^ =/^ >/^ ?/^Dl,,, ,,@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _  @/^ A/^ B/^ C/^ D/^ E/^ F/^ G/^ H/^ I/^J ]777/^K ]777/^L ]777/^M ]777/^N ^^^^/^O ^^^^/^P ^^^^/^Q ^^^^/^R ^^^^/^S ^^^^/^T ^^^^/^U ^^^^/^V ^^^^/^W ^^^^/^X ^^^^/^Y ^^^^/^Z ^^^^/^[ ^^^^/^\ ^^^^/^] ^^^^/^^ ^^^^/^_ ^^^^/^Dl` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~  ` ^^^^/^a ^^^^/^b ^^^^/^c ^^^^/^d ^^^^/^e ^^^^/^f ^^^^/^g ^^^^/^h ^^^^/^i ^^^^/^j ^^^^/^k ^^^^/^l ^^^^/^m ^^^^/^n ^^^^/^o ^^^^/^p ^^^^/^q ^^^^/^r ^^^^/^s ^^^^/^t ^^^^/^u ^^^^/^v ^^^^/^w ^^^^/^x ^^^^/^y ^^^^/^z ^^^^/^{ ^^^^/^| ^^^^/^} ^^^^/^~ ^^^^/^ ^^^^/^D@l                                 ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^D@l                                 ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^D@l                                 ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^D@l                                 ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^D@l       ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^ ^^^^/^d>@<d   7^yK yK *msbpz://-r:276DB13A/ @ 1 Yak  dMbP?_*+% &LDate: &D&~?'~?(~?)~?MHP LaserJet 5Si/5Si MX7@ pdXX7@XXEXCELCourier New (X\\proliant\pro_frontHP5SI" dXX `? `?U} I} }  } } I} $ 01  @ @      ,   @ ^ ^             @        "fggggggg" " t ggggggg" "hiiiiiii" " jiiiiiii" " siiiiiii" "kkkkkkkk" "llllllll" " xwwwwwwm" " ywwwwwwn"  "oppppppp"  " v! wwwwwwn"  #qrrrrrrr#  #qrrrrrr u" # """""""""" """""""""" """""""""" """""""""" """""""""" """""""""" """""""""" """""""""" """""""""" ":;;;;;;<" " =>?????@6` "($$$$$$A6` "($$$$$$ _  #/ " B C C C C D E F  9a "GHHHHHH*#/ " I'&&&&&,#/ " )*%@%p@%p@%@@%d@%@@#J^@% %+  #/ " K~ %@%%%%%-2b " K~ %@%%%%%+5c D5l 4 44 44 424 6 4{@  ! " # $ % & '  (  ) * + , - . / 0  " L Mj@(   -& Mp@(  Mp@(  M@@(  Md@(  M@@(  N5c !"OPQQQQQR4d "" "I"'&&&&&,#/ #" #)*#%|@% @%|@%@%:@%@##J@ %## # #/ $" $3*$%@%@%@%@%@%@ $+#/ %" %3 *%%@@%@@%@@%@@%@@%@@ %+#/ &" &3 *&%@o@%@o@%@o@%@o@%@o@%@o@ &+#/ '" '3 ~ '%@ '8 '8 '8 '8 '8 '+5c (" (S(M@*((( -.(Md@*((MZ@*((Mk@*((M)@*((M@*( (N5c )"T$$$$$$*4d *" *U*VJ@.*** LL*V@.**V.**V,.**V]@.**V@.* *W#/ +"OXXXXXX*5c ," ,U~ ,V,VJ@ D.,VV@ D.,Vب@ D.,Vj@ D.,Vt@ D. ,W1e -"OYXXXXX.1e ." .Z.[J@,...,,B.[V@,..[ب@,..[j@,..[t@,..[(@#. .\#/ /""""""""#" 0"""""""""" & @ 4{VVV| >@ccc 7^yK yK *msbpz://-r:276DB13A/