ࡱ> Root EntryRoot Entry FXFk@CompObj fWorkbookG^MSDigSig(Author)$<h  !"#$%&'()*+,-./0123456789:;=>?@ABCDEFHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvSummaryInformation(fDocumentSummaryInformation8 ՜.+,D՜.+,$ PXd lt| :  Question Worksheet Solution  Worksheetsl 8@ _PID_HLINKSA$Nmsbpz://-r:276DB13A/Nmsbpz://-r:276DB13A/Nmsbpz://-r:276DB13A/ FMicrosoft Excel WorksheetBiff8Excel.Sheet.89qOh+'0f X`   2Relating Cash Flow to the Balance Sheet: QuestionorMicrosoft CorporationthMicrosoft CorporationthMicrosoft Excel@u@7)+@ldGle*' 2&" WMFC ,&,Fd_*' EMF,F @    !" !" !  " !  `'%    &% 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 :LP3tw   % :6:% Ld:::!??   TT KZAA KLP4   % 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 ,,F   `'%    Ld#9 )!??'% (  Ld#_9#)!??'% (  Ld9#9 !??'% (  Ld#9_#9!??RL Tahoma Tahoma`hۍ0WXw \@$0 \ 0%    T3 +8AA3 LMicrosoft Business Planner       RL Verdana Verdana`hۍ0WXw \@$0 \ 0%  T2MYAA2MLhGo to Article:   RL  Verdana Ref Verdana Refw}!w`WXw \@$0 \3 0% T2^ykAA2^ LdOver-TradingRL  Verdana Verdana`hۍ0WXw \@$0 \ 0%   RL  Verdana VerdanaDhۍ0WXw \@$0 \ D0% %  % % % % % % % " !% %   $`%   Tt3_AA31LRelating Cash Flow to the Balance Sheet: Question              % %  % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % " !% %   $`% % % % % % % % % %   T2_AA2dLThis exercise will help you consolidate your understanding of how entries on the cash flow forecast    TH2!AA2*Lare related to those on the balance sheet.T2_AA2dLUsing the information from the cash flow forecast below, work out High Note's closing balance sheet      T\2_AA2XLat the end of September. You also know that High Note will have to collect 12,000 from     T2_AA2dLcustomers, is carrying forward 9,108 of stock, and has retained profit for the period of 8,700. A   T2_AA27Lblank balance sheet is provided on the tab "Worksheet". % % % " !% %   `% % " !% %   `' % (     ( ,&NWMFC,,F&% % Ld!??% % Ld#!??% % Ld!??% % Ld!??% % Ld_!??'%   ( &% #}6a}% Ld#}_}#}>!??% ( % " !%   `% " !%   `'%    ( &% 6`% Ld_`!??% 6% Ld!??% "   `  '' ' ,`-  -- @ !-- @ !-99- @ !9-JJ- @ !J-[[- @ ![-ll- @ !l-}}- @ !}-- @ !-- @ !-- @ !-`- @ !_-##- @ !#-- @ !-- @ !-__- @ !_-  @ !- -- @ !-- @ !- -- @ !-- @ !--Arial-  2  1g -- @ !  2 ( 2 -  - @ !   2 : 3 -::- @ !:  2 K 4H -KK- @ !K  2 \ 5 -\\- @ !\  2 m 6 -mm- @ !m  2 ~ 7 -~~- @ !~  2 8 -- @ !  2 9g -- @ !  2 #A  -- @ !  2 yB  -$$- @ !$  2 CH  -- @ !  2 9D  -- @ !-"System-'-- ,`-   @ !) -    @ !)#-    @ ! 9-    @ !9# Tahoma-  .2 3Microsoft Business Planner        Verdana-  2 M2Go to Article:    Verdana Ref- 2 ^2 Over-Trading Verdana-    Verdana--  - - - - - --'- -  ,`$-  Q2 31Relating Cash Flow to the Balance Sheet: Question              - - --------------------------------------------'--  ,`$---------- 2 2dThis exercise will help you consolidate your understanding of how entries on the cash flow forecast    F2 2*are related to those on the balance sheet.2 2dUsing the information from the cash flow forecast below, work out High Note's closing balance sheet      2 2Xat the end of September. You also know that High Note will have to collect 12,000 from     2 2dcustomers, is carrying forward 9,108 of stock, and has retained profit for the period of 8,700. A   Z2 27blank balance sheet is provided on the tab "Worksheet".  ---'--  ,`--'--  ,`-   -- @ !-- @ !#-- @ !-- @ !-- @ !_-  -}#}a- @ !>}#- -'- ,`-'- ,`-   -`- @ !`-- @ !-'0^ *H O0K10 *H 0g +7Y0W03 +70%7)O•0 0 *H C9?}IT9?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 #100u0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CAyfnжneq0 *H 0 *H  1  +70 +7 10  +70 *H  1){f-?20 +7 10b`Exercise Relating Cash Flow to the Balance Sheet<:http://bookshelf.msn.com/z/msbp/teleport/fromCD/office.asp0  *H V8 (m(>1[02d@U? cڦNP cΛ U 6gݭ40˸lTmPxh ׹Cedž7I>N/hԊH_|Zn?8rEtg@ZS[XQ}u-Dd(` p+ۮ62LGD\P ׊ jzNv(_-"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     @  `  `  %   `  q   !p@  %   `7   % 7   `7   q(   q8   Q0 %0 %1 @  %   `@  q87     % 7  p  Q  %(    %A`"7 @   %A`" @    @  `  Q(   %Q "@  %A "@  %A "7 @  %A 7   %Q("@ p  `  `7  Q( !x@  h@@  `@  ` @ %1 @  %1   %1`  %1`   q8 7   a  Qh@@ %Ah@  %Ah @  Qh@%Ah   %   %0  % 7  Qh@ %Ah  %Ah     h %1`  Q` %` p  Qp %`  %h  !x  a` Qh  h !p@@  `7 @   @  @  %   %(  Qh"@  %Q @ %(@@  % 7 @  %Q  Qh@ %A` @  !x %1 @   q  7 p7 @  Q07 %h@  %Q( q 87  !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` #Question58 Worksheet`ISolution  ; %  ;7  ; . g| V:AprilMayJuneJuly(High Note's Six-Month Cash Flow ForecastAugSeptSalesOwner's Capital PurchasesRent, Rates etc.Wages AdvertisingFixtures and Fittings-High Note Balance Sheet Fixed AssetsCurrent AssetsStockDebtorsCashOverdraft needed CreditorsNet Current AssetsLong-Term LoanReceiptsMonth:Capital IntroducedLoans ReceivedTotal ReceiptsPaymentsTotal PaymentsCashflow Surplus/Deficit (-)Opening Bank BalanceClosing Bank BalanceTotals for Salesand Purchases OnlyNET ASSETS EMPLOYEDTotal Fixed AssetsTotal Current AssetsTotal Current Liabilities FINANCED BY/Scroll down to see the completed balance sheet.Less Current Liabilities Profit Retained (Reserves)Net Total AssetsGo to Article: Over-TradingUse the blank balance sheet below to create High Note's closing balance sheet from the information on the "Question" tab. The cells displaying zeroes in the total rows contain formulae to perform automatic calculations on the data. Do not type into these cells as you will erase the formulae. Also, be sure to put figures in the rows beneath each section heading. Any values entered in the same row as a heading will not be included in the automatic calculations. A completed version of this balance sheet is provided on the "Solution" tab.1Relating Cash Flow to the Balance Sheet: Question2Relating Cash Flow to the Balance Sheet: Worksheet1Relating Cash Flow to the Balance Sheet: SolutionThis exercise will help you consolidate your understanding of how entries on the cash flow forecast are related to those on the balance sheet. Using the information from the cash flow forecast below, work out High Note's closing balance sheet at the end of September. You also know that High Note will have to collect 12,000 from customers, is carrying forward 9,108 of stock, and has retained profit for the period of 8,700. A blank balance sheet is provided on the tab "Worksheet". 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.MBK dAnCW! @  d(&1$7N7t7  dMbP?_*+% &LDate: &D&x >                        #$ # 7$ #$ # /$ # 0$ #$ #$ # 2$ # 5$  #$  # 8 $  $$  $ 9 $ #LMMMMMMN$ $ OPQQQQQR$ $)%%%%%%5$ $)%%%%%% $ $$ A ( ( ( ( . / S% $$K000000+$ $ J8'''''-$ $ **&@@&@&@&X@&p@&L@#Ep@& %+ $$ :~ &@&&&&&7$ $ :~ &@&&&&&,$ $ BCp@ -&C@C@CX@Cp@CL@ D$ $6GHHHHHI$ $ J8'''''-$ $ * *&|@& @&|@&@&:@&@#E@ % $$ 3 *&@&@&@&@&@&@ ,$ $ 3 *&@@&@@&@@&@@&@@&@@ ,$ $ 3 *&@o@&@o@&@o@&@o@&@o@&@o@ ,$ $ 3~ &j@ 1 1 1 1 1 ,$ $ F C @! -.Cd@!CZ@!Ck@!C)@!C@! D$ D, l2222222222w>>2wTTTz ! " # $ % & ' ( ) * + , - . / 0 $T%%%%%%+$ !$ !U!!V$@%!!! LL!Vp%!!V%!!V%!!V%!!V@%! !W$ "$6ZZZZZZ+$ #$ #U"~ #V#V$@D%#V@D%#VpD%#VD%#V D% #W$ $$6[ZZZZZ\$ %$ %]#%^$@#%%%,,B%^@#%%^p#%%^#%%^ #%%^,% %_$ &$$$$$$$$$$ '$$$$$$$$$$ (@(>>>>>>>)@*@+@,@-@.@/@0@& @" cc>@<d   7^yK yK *msbpz://-r:276DB13A/ @ 3L;jC{H  dMbP?_*+% &LDate: &D&x@<d 7^yK yK *msbpz://-r:276DB13A/ @ ;wLT]  dMbP?_*+% &LDate: &D&x >      #$ # 7$ #$ # /$ # 0$ #$ #$ # 4$ # +$  #$  # 8 $  $$  $ 9 $ #a$$$$$$$$ $bb$$$$$$$ $de$$$$$$$ $cf$$$$$$$ $dg$$$$$$$ $hg$$$$$$$ $i$$$$$$$$ $j$$$$$$$$ $kl$$$$$$$ "$LN4$$$$$$>>>> $ 2{4$$$$$$>>>> "$mn4$$$$$$>>>> $o |4$$$$$$>>>> "$pv4$$$$$$>>>> $ T&\4$$$$$$>>>> "$q\4$$$$$$>>>> $ 974$$$$$$>>>> $ 3,j@4Z4$$$$$$>>>> $ s'<j@.D4$$$$$$>>>> Dl2222222&:&<&:&:Y !"#$ % &'() * +,-./0123 4 56789:" $t}4$$$$$$>>>> !$ !9!~4$$$$$$>>>> "$ "3~ ",@"4$$$$$$>>>> #$ #:~ #,p@#4$$$$$$>>>> $$ $3~ $,$4$$$$$$>>>> %$ %s(#%<@* %"$&%4$$$$$$>>>> "&$uv4$$$$$$>>>> '$ ','74$$$$$$>>>> ($ (3!(,,@6 Z%(4$$$$$$>>>> )$ )3~ ),)4$$$$$$>>>> *$ *s)#*=,@ %()R*4$$$$$$>>>> "+#z+4$$$$$$>>>> ,# ,X%,Y@$$D%D*,4$$$$$$>>>> "-#z+4$$$$$$>>>> .# .X.*.Y@,$D%D*B.4$$$$$$>>>> "/#r\4$$$$$$>>>> 0# 0T*0\4$$$$$$>>>> "1#w74$$$$$$>>>> 2# 23 2,@Z24$$$$$$>>>> 3# 3:-~ 3,@34$$$$$$>>>> 4#s#4=C@7 %23&44$$$$$$>>>> "5#xy4$$$$$$>>>> 6# 6q6\@2Z64$$$$$$>>>> 7#$7_@%$6$4B74$$$$$$>>>> "8$$$$$$$$$$>>>> "9$$$$$$$$$$>>>> :>>: `:&:FFF_&:]F_&a&f&:&YFU&YV&&>@<dccc 7^yK yK *msbpz://-r:276DB13A/