ࡱ> Root EntryRoot Entry FFk@CompObj fWorkbookFLMSDigSig(Author)$;X  !"#$%&'()*+,-./0123456789:<=>?@ABCDEGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklSummaryInformation(eDocumentSummaryInformation8 ՜.+,D՜.+, PXd lt| /  Question Solution  Worksheets 8@ _PID_HLINKSATmsbpz://-r:276DB133/  http:///msbpz://-r:276DB133/  http:/// FMicrosoft Excel WorksheetBiff8Excel.Sheet.89qOh+'0de X` ,Transactions on the Balance Sheet: QuestionMicrosoft CorporationlaMicrosoft CorporationlaMicrosoft Excel@Tt@7)+@΁GBd* 2&" WMFC %Ed_* EMFE3 @    !" !" !  " !  `'%    &% 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 KLP4Lv   % K6K% LdKKK!??   TT \kAA \LP5   % \6\% Ld\\\!??   TT m|AA mLP6   % m6m% Ldmmm!??   TT ~AA ~LP7   % ~6~% Ld~~~!??   TT AA LP8   % 6% Ld!??   TT AA LP9   % 6% Ld!??   TT"AAL#PA    % 6% Ld!??   TTyAAyLPB    % $6$% Ld$$$!??   TTAALPC    % 6% Ld!??   TT9AAA9LPD    % 6% Ld!??% % " !% %&" WMFC E   `'%    Ld#9 )!??'% (  Ld#_9#)!??'% (  Ld9#9 4!??'% (  Ld#9_#94!??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 D\@$0 D\3 0% RL  Verdana Verdana`hۍ0WXw @\@$0 @\ 0%   RL  Verdana VerdanaDhۍ0WXw 4\@$0 4\ D0% % % % " !% %   $\`l  T`2^BkAA2^.LTransactions: Measuring Income and Expenditure  %  % % % % % % % " !% %   $`%   TP3_AA3+LTransactions on the Balance Sheet: Question           % %  % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % " !% %   $`% % % % % % %   Td2_AA2YLThis exercise will help to consolidate your understanding of how transactions affect the   T,2_AA2PLbalance sheet. Remember every transaction must have at least two effects on the     T2AA2Llbalance sheet. TX2_AA2WLRecord the effects of the following events in the appropriately numbered column on the    T2_AA2MLbalance sheet below. Click on the "Solution" tab to see the completed sheet.    % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % " !% %   `% % " !% %   `' % (     ( &% % Ld!??% % Ld#!??&>WMFCE% % 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 \ 5 -\\- @ !\  2 m 6 -mm- @ !m  2 ~ 7 -~~- @ !~  2 8| -- @ !  2 9 -- @ !  2 #A  -- @ !  2 yB  -$$- @ !$  2 C  -- @ !  2 9D  -- @ !-"System-'-- ,`-   @ !) -    @ !)#-    @ !4 9-    @ !49# Tahoma-  .2 3Microsoft Business Planner        Verdana-  2 M2Go to Article:    Verdana Ref-  Verdana-    Verdana-- --'- -  ,l`\$ L2 ^2.Transactions: Measuring Income and Expenditure  -  - - - - - --'- -  ,`$-  H2 3+Transactions on the Balance Sheet: Question           - - ------------------------------'--  ,`$------- 2 2YThis exercise will help to consolidate your understanding of how transactions affect the   2 2Pbalance sheet. Remember every transaction must have at least two effects on the     2 2balance sheet. 2 2WRecord the effects of the following events in the appropriately numbered column on the    {2 2Mbalance sheet below. Click on the "Solution" tab to see the completed sheet. m   ---------------------------------------------'--  ,`--'--  ,`-   -- @ !-- @ !#-- @ !-- @ !-- @ !_-  -}#}a- @ !>}#- -'- ,`-'- ,`-   -`- @ !`-- @ !-'0R *H C0?10 *H 0g +7Y0W03 +70%7)O•0 0 *H ,/ΔFb?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 #1|0x0u0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CAyfnжneq0 *H 0 *H  1  +70 +7 10  +70 *H  1w<K1t;ڽ0 +7 10VTExercise Transactions on the Balance Sheet<:http://bookshelf.msn.com/z/msbp/teleport/fromCD/office.asp0  *H )f7]Q!kT!0'3 (o>w8 \wĖ~0}}GsM+[@[B˖X?+R+M2Da WrzNjz!11aJ7~0 XGz%G8L~3$Fuk%<|awlolʡY`' 9$ _wZn-)7g|P$5dS0 *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 981201010439Z0 *H  1]pfԳr:0  *H 7D/x2h '`(4֠ʁ"zuKYdAQ]Ό@ /ec(ڊ:eQY/HZVGr+7ʍSa0TV5B5ꚙǬ3_CL @`\pMicrosoft Corporation Ba==y=j,8X@"1Arial1Arial1Arial1Arial1 Verdana1Verdana1Verdana1 Tahoma1Tahoma1Tahoma1Tahoma1 Arial1@ Tahoma1Tahoma1Arial1Tahoma1@ 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\);_(* "-"??_);_(@_)""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.0050_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_- "$"#,##0.00 "$"#,##0#,##0;\ \(#,##0\)#,##0_);\ \(#,##0\)                 %@@   7 % @  %@"@        D $ 7 # ! ! ) )  % @  !7  7     @ %!`@  `  `  %   `  % 7  %  !p@  !x@ %!`@   `7   % 7   % 7 7  `7   % 7  %! @  a`    a` 7   h  %0  %1`"@   %07  %("@   %1 "@  %!` %!x %!x7  %A 7%!(@   A  a` a   !x    A  %0  !x@@  h@  `@  `7 @  Q @  %(  %(7  Ah"@ Ah@%1h %1h   !x  Q  Ah@ %1h  %1h   h@@  `@  ` @  %1`"7 @   %1 "7 @   ah A( %(@  % @  % 7 @ %A( %   %   % 7   %0  a(7  h@  A  %1`  %1`7  !7   H7 !  @ !  `  `7 ) X P ) h ` x p !7 # ) ) ) ! ) )  amount Body text header Header Total Header1 Header2 Header3 Header4NonPrint_copyrightNonPrint_HeadingNonPrint_HyperlinkNonPrint_TemTitle NonPrint_Text Normal 2 Product Title Text !Title`Question4Solution  ;1  ;6 gO" Fixed Assets - Net Current AssetsMortgageNET ASSETS EMPLOYEDCurrent AssetsStockDebtorsCashTotal Current AssetsTotal Current LiabilitiesLess Current Liabilities FINANCED BY Share CapitalReserves Overdraft CreditorsStartHigh Finance Ltd Balance Sheet+Transactions on the Balance Sheet: SolutionU(All these transactions can be assumed to have happened over a period of a few days.)Net Total AssetsGo to Article:.Transactions: Measuring Income and ExpenditureThe 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."Scroll down to view the solution. +Transactions on the Balance Sheet: Question1. Stock costing 250 was sold for 400, received in cash. 2. Freehold land costing 15,000 was purchased by paying 1,500 cash and taking a 20-year mortgage for the balance. 3. A company car costing 3,000 was purchased, High Finance agreeing to pay the garage cash in 60 days. 4. Stock costing 3,000 was purchased, the supplier agreeing to payment within 30 days. 5. Stock costing 1,800 was sold for 2,700, the customer agreeing to pay within 120 days.]This exercise will help to consolidate your understanding of how transactions affect the balance sheet. Remember every transaction must have at least two effects on the balance sheet. Record the effects of the following events in the appropriately numbered column on the balance sheet below. Click on the "Solution" tab to see the completed sheet. 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.M Colin Barrow 1998, Accounting: Financial Management for the Small Business,published by Kogan Page.* ;t#\ @ 4 V*_3  dMbP?_*+%  &LDate: &D&x(((((/"$ ])))))1"$ L~ & @&&&&."$ L F&&&&."$ M ~ (@((((/"$ N 7~@$ - 7$7$7$7$Z$"Dl000000000000Nl0<0<<< ! " #  $  % & ' ( ) * + , -  .  / 0 1 2 3  $^_____`"!$ !a !)))))1""$ "L~ "&@"&&&&."#$ #M #F#((((/"$$ $N $:@($$$ -&$:($$:($$:($$:($$[($$"%$;<<<<<="&$ &O&P@.&&& LL&P&&P&&&P&&&P&&&Q&&&"'$hiiiiij"($ (O(P@&(((,LLB(P&((P((P((P((Q((")$R%%%%%-"*$ *S *%%%%%-"+$E'''''0",$ ,L~ ,&@,&&&&."-$ -M~ -(Y@-((((/" .$9.:@1... -.:1..:1..:1..:1..[1.."/$^_____`"0$ 0b 0e0ccccd" 1@T1U@111,,B1U11U.11U.11U.11V.11"2"""""""""3""""""""",|0<<0<<<>@<d:    7FyK yK http:///^yK yK *msbpz://-r:276DB133/ @ :7?K  dMbP?_*+% &LDate: &D&x((((/""Dpl000000000Db0V ! " #  $  % & ' (  )  * + , - . / 0 1 2  3  4 5 6 7 8 9  $ ] ))))1""!$ !L$!&8@&8@&8@&Ʊ@.|@ !"""$ "L "6 "6 "6 "6~ ".@ """#$ #M $#(@(@(@(@/@ #""$$ $N #$7@) %!# #$7@) %!# #$7@) %!# #$7[@) %!# #$Z<@) %!# $""%$^____`""&$ &a &))))1""'$ 'L$'&@&@&@&@.@ '""($ (M (8 (8((p@(p@/p@ ("")$ )N #):@- %'(&#):@- %'(&#):@@- %'(&#):|@- %'(&#)[|@- %'(& )""*$;<<<<=""+$ +O!+P@=" D$D)!+P@+ D$D)!+Pv@+ D$D)!+Pv@+ D$D)!+Q@+ D$D) +"",$hiiiij""-$ -O*-P@+$D$D)B*-P1@$$D$D)B*-P1@$$D$D)B*-P1@$$D$D)B*-Q@$$D$D)B -"".$R%%%%-""/$ /S /%%%%-""0$E''''0""1$ 1L$1&@&@&@&@.@ 1""2$ 2M$2(@o@(@o@(@o@(@o@/@ 2"" 3$9#3:@6 %12#3:@6 %12#3:@6 %12#3:@6 %12#3[@6 %12 3""4$^____`""5$ 5b 5e5c^@c^@c^@d^@ 5"" 6$T$6U@$$3$5B$6U1@3$3$5B$6U1@3$3$5B$6U1@3$3$5B$6V@3$3$5B 6""7$$$$$$$$"8$$$$$$$$"9@@@@@@8 0NlN0N^ 0NNV>@<dccc" 7FyK yK http:///^yK yK *msbpz://-r:276DB133/