ࡱ> Root EntryRoot Entry F wyFk@CompObj fWorkbookI7GMSDigSig(Author)$>`  !"#$%&'()*+,-./0123456789:;<=?@ABCDEFGHJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklSummaryInformation(kDocumentSummaryInformation8 ՜.+,D՜.+, PXd lt| /  Question Solution  Worksheets 8@ _PID_HLINKSATmsbpz://-r:276DB136/  http:///msbpz://-r:276DB136/  http:/// FMicrosoft Excel WorksheetBiff8Excel.Sheet.89qOh+'0dk X` /Creating a Profit and Loss Statement: QuestionoMicrosoft CorporationLoMicrosoft CorporationLoMicrosoft Excel@1Fx@7)+@(!G@jz%" 5&" WMFC $)$Id2z%" EMF$I @    !" !" !  " !  3'%    &% 6% Ld!??% 6% Ld!??% 969% Ld999!??% J6J% LdJJJ!??% [6[% Ld[[[!??% l6l% Ldlll!??% }6}% Ld}}}!??% 6% Ld!??% 6% Ld!??% 6% Ld!??% 63% Ld22!??% #6#% Ld###!??% 262% Ld222!??'%  Ld!??'%  ( &% 6% Ld!??% 6% Ld!??%  ( &% 6% Ld!??% 6% Ld!??% % RLArialArial# WXw \lP@$0 \l|pd+%w0%    TT AA LP1 b   ( &% 6% Ld!??   TT (7AA (LP2H   %  6 % Ld   !??   TT :IAA :LP3So   % :6:% Ld:::!??   TT KZAA KLP40   % K6K% LdKKK!??   TT \kAA \LP5ə   % \6\% Ld\\\!??   TT m|AA mLP6   % m6m% Ldmmm!??   TT ~AA ~LP7   % ~6~% Ld~~~!??   TT AA LP8v   % 6% Ld!??   TT AA LP9F0   % 6% Ld!??   TT"AAL#PA    % 6% Ld!??   TTAALPB0    % $6$% Ld$$$!??% % " !% %   3'%    Ld#9 )!??'% (  Ld#29#T)!??'% (  Ld9#9 !??'% (  Ld#92#9T!??RL Tahoma Tahomadhۍ0&" WMFC $ $IWXw ]\@$0+ ]\ 0%    T3 +8AA3 LMicrosoft Business Planner       RL Verdana Verdanadhۍ0WXw ^\@$0+ ^\0%  T2MYAA2MLhGo to Article:   RL  Verdana Ref Verdana Refw}!w`WXw d\@$0+ d\3 0% RL  Verdana Verdanadhۍ0WXw `\@$0+ `\ 0%   RL  Verdana VerdanaDhۍ0WXw T\@$0+ T\ D0% %  % % % % % % " !% %   $3%   T`32AA3.LCreating a Profit and Loss Statement: Question              % %  % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % " !% %   $3% % % % % % % % % % % % %   T22AA2lL$This exercise will help to consolidate your understanding of the structure of the profit and loss statement.  T22AA2kL$The table on the left is an unordered list of items you would normally expect to find in a profit and loss    T22AA2nL(statement. Using the table on the right, rearrange them in the correct order, and so arrive at the business's   T2AA2Lxnet profit after tax.T22AA2iL The cells displaying zeroes contain formulae to perform automatic calculations on your data. Do not type     T22AA2oL,into these cells as you will erase the formulae. Also, be sure to put figures in the rows beneath each section    T22AA2_L heading. Any values entered in the same row as a heading will not be included in the automatic     Td22AA2YLcalculations. Click on the "Solution" tab to see the completed profit and loss statement. &F WMFC$ $I  % % % % " !% %   $\3l  TH2^kAA2^*LThe Structure of a Profit and Loss Account% % " !% %   3% % " !% %   3' % (     ( &% % Ld!??% % Ld#!??% % Ld2!??'%   ( &% #}64}% Ld#}2}#}!??% ( % " !%   3% " !%   3'%    ( &% 63% Ld23!??% 6% Ld!??% "   3  '' ' ,3-  -- @ !-- @ !-99- @ !9-JJ- @ !J-[[- @ ![-ll- @ !l-}}- @ !}-- @ !-- @ !-- @ !-3- @ !2-##- @ !#-22- @ !2-  @ !- -- @ !-- @ !- -- @ !-- @ !--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 B  -$$- @ !$-"System-'-- ,3-   @ !) -    @ !)T#-    @ ! 9-    @ !T9# Tahoma-  .2 3Microsoft Business Planner        Verdana-  2 M2Go to Article:    Verdana Ref-  Verdana-    Verdana--  - - - - --'- -  ,3$-  L2 3.Creating a Profit and Loss Statement: Question              - - ----------------------------------'--  ,3$------------- 2 2lThis exercise will help to consolidate your understanding of the structure of the profit and loss statement.  2 2kThe table on the left is an unordered list of items you would normally expect to find in a profit and loss .   2 2nstatement. Using the table on the right, rearrange them in the correct order, and so arrive at the business's   '2 2net profit after tax.2 2iThe cells displaying zeroes contain formulae to perform automatic calculations on your data. Do not type s    2 2ointo these cells as you will erase the formulae. Also, be sure to put figures in the rows beneath each section    2 2_heading. Any values entered in the same row as a heading will not be included in the automatic t    2 2Ycalculations. Click on the "Solution" tab to see the completed profit and loss statement.m   -- --'- -  ,l3\$ F2 ^2*The Structure of a Profit and Loss Account--'- -  ,3--'- -  ,3-   -- @ !-- @ !#-- @ !2-  -}#}4- @ !}#- -'-  ,3-'-  ,3-   -3- @ !3-- @ !-'0X *H I0E10 *H 0g +7Y0W03 +70%7)O•0 0 *H 3T Ɋ'Sa^?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 #10~0u0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CAyfnжneq0 *H  0 *H  1  +70 +7 10  +70 *H  1Y XϩyL0 +7 10\ZExercise Creating a Profit and Loss Statement<:http://bookshelf.msn.com/z/msbp/teleport/fromCD/office.asp0  *H @ WC_7_kza<[}\R <ּW$el.`yFMDVY,X.X="6! )B|/7rvƚXY-OVBjr ^-aY/C`Dc >k!FS7KTr8]|&'fCӤ)4&, ;AiP6SN@&v ^(ǘv`[90 *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 981201004618Z0 *H  1*q?3 0  *H ԒgtW_%_?X m`&6[©nlGLI#D۝є r="Iy'j>kC2-]aFe'D r%@ @`\pMicrosoft Corporation Ba==-j,8X@"1Arial1Arial1Arial1Arial1 Verdana1Verdana1 Tahoma1Tahoma1Tahoma1 Arial1@ Tahoma1Tahoma1Tahoma1Tahoma1@ Tahoma1Verdana1Verdana1Verdana1Verdana1& 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\)#,##0;\(#,##0\)                 %@@   7 % @ %@"@     D  $ 7 # ! ! ) )  %@  !7  7     @  `  `  @ !d   D  d    % 7  d@@  d @ A$7al7 7A$  a$ 7 A$@a|7 @A,a|7  %   % 7   % 7  %07 7 A,"@ %A0"7 @ Q(  %(7  Q(  %(7   % 7 7 %A 7 Q("@   %   % 7  A,%1 "7 @  A$%1 7  %!(@  h  ` %!( %! @ !p  `7 A   a  7 %A %A %A 7 % 77 %A( %( Ah@ %( A$%1 7  %1(  %1 7 7 %!(@  %1(  %A 7 %! @ %1h   %(7 %(7 %A(!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`Question1Solution  ; 0  ;: giD-Miscellaneous ExpensesInterest ExpensesSalesProvision for Income Tax Opening StockAdministration ExpensesSelling ExpensesAdvertising Expenses&Closing Stock at the End of the PeriodCost of Goods Sold Gross ProfitSellingAdministration Advertising Miscellaneous Rent ReceivedIncomeTotal Cost of Goods Sold ExpenditureTotal ExpenditureProfit Before TaxProfit After TaxProfit and Loss Statement List of Items&Rent from Sub-Letting Part of Workshop Total Income Scroll down to see the solution.Operating Profit Loan InterestNon-Operating RevenueNon-Operating ExpensesLess Closing Stock Plus Purchases !Stock Purchases During the PeriodGo to Article:*The Structure of a Profit and Loss Account.Creating a Profit and Loss Statement: Question.Creating a Profit and Loss Statement: SolutionThis exercise will help to consolidate your understanding of the structure of the profit and loss statement. The table on the left is an unordered list of items you would normally expect to find in a profit and loss statement. Using the table on the right, rearrange them in the correct order, and so arrive at the business's net profit after tax. The cells displaying zeroes contain formulae to perform automatic calculations on your 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. Click on the "Solution" tab to see the completed profit and loss statement.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.MM Colin Barrow 1998, Accounting: Financial Management for the Small Business,published by Kogan Page.2A o:w @ 4!+0  dMbP?_*+% &LDate: &D&x#%%%$% # R~ *@#V6#%%%$% # R~ *@#b?#%%%$% # R~ *X@#7?#%%%$% # R~ *h@# A':DDD#%%%$% # S~ T@@#1_#%%%$% """" ` ![# DD"""""BC""""" D @"""""56"DC l,,,,,,,"L"NBVB{BVBBBBO. !" # $%&'( ) *+,-. / 0123 """"56"!""""56""""""7?"#"""" #9##E% %"#"$""""YZ"%"""" %W!%a) DD#%"&""""XC"'"""" 'D 'C"(""""78")""""9%)E-D%D()"*""""3Z"+"""" +D +C",""""B?"-"""" -H!-[1 D)D,-".""""FG"/"""" /9 /E"0""""-\"1"""" 1]!1^] D-D/1"2"""""""3""""""",|QO.G.O.O>@<d  " 7FyK yK http:///^yK yK *msbpz://-r:276DB136/ @ =5<E  dMbP?_*+% &LDate: &D&~?'~?(~?)~?MHP LaserJet 5Si/5Si MX7@ `@dXX7@XXEXCELCourier New (X\\proliant\pro_frontHP5SI" dXX `? `?U} $)}  )}  )} $)}  I)} )=    r r r   "efffff#" s(fffff#"ghhhhh#" i#hhhhh#" y$yhhhh#"jjjjjj#"kkkkkk#" u&zzzzz#" wzzzzz# "nooooo# " x) zzzzz# #pqqqqq# #pqqqq t+ # #pqqqq t, #'"""""(('"""""(('"""""(('"""""(('"""""(('"""""(('"""""(('""""(('+,"""((' H&"""(('-."""(( '/ 0 """(('12"""((' 34"""((' 56=AZ"""((' 9#:=A% %&"""((';<"""((' = >"""((D$l........ .0.MS !" # $%&'()*+ , -./01 2 34567 8 9:;< ' V 6@!Z """((!' !c!!?@"Z!"""(("' "c "?@@#Z""""((#' #A'#:@5D D!D"#"""(($'1_"""((%' %` !%[J@( DD#%"""((&'BC"""(('' 'D'@"""''(' (5 (6X@)Z("""'')' )5 )6@*Z)"""''*' *5*6h@+Z*"""''+' +7+?@,Z+"""'',' ,9#,E@@. %(+,"'"''-'YZ"""''.' .W!.a@1 D%D,."""''/'XC"""''0' 0D0C"""''1' 1718y@2Z1"""(( 2'9%2Er@6D.D12"""((3'3Z"""((4' 4D4C"""((5' 5B5?p@Z5"""''6' 6H!6[@8 D2D56"""''7'FG"'"''8' 898E@:Z8"""''9'-\"""'':' :]!:^0@'' D6D8:"'"'';'''''"''<""""""''>0MMMWQ.MMMMSQ.MK.MQMQ>@ccc" 7FyK yK http:///^yK yK *msbpz://-r:276DB136/