ࡱ> Root EntryRoot Entry FFkCompObjfWorkbookH_MSDigSig(Author)$=X  !"#$%&'()*+,-./0123456789:;<>?@ABCDEFGIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwSummaryInformation( LfDocumentSummaryInformation8 ՜.+,D՜.+,, PXd lt| / Stage 1Stage 2Stage 3Stage 4  Worksheets 8@ _PID_HLINKSA0msbpz://-r:276DB130/  http:///msbpz://-r:276DB130/  http:///msbpz://-r:276DB130/  http:///msbpz://-r:276DB130/  http:/// FMicrosoft Excel WorksheetBiff8Excel.Sheet.89qOh+'0f X` "Creating a Personal Balance SheetExMicrosoft CorporationlaMicrosoft CorporationlaMicrosoft Excel@^ ht@7)+@6Ge& y2&" WMFCŶ %Ed>& EMFE @    !" !" !  " !  ?'%    &% 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>>>!??'%  Ld!??'%  ( &% 6% Ld!??% 6% Ld!??%  ( &% 6% Ld!??% 6% Ld!??% % RLArialArial# WXw k\lP@$0R k\l|pd+%w0%    TT AA LP14   ( &% 6% Ld!??   TT (7AA (LP2i   %  6 % Ld   !??   TT :IAA :LP3   % :6:% Ld:::!??   TT KZAA KLP4Y0   % K6K% LdKKK!??   TT \kAA \LP5U   % \6\% Ld\\\!??   TT m|AA mLP6   % m6m% Ldmmm!??   TT ~AA ~LP7   % ~6~% Ld~~~!??   TT AA LP8O   % 6% Ld!??   TT AA LP9y    % 6% Ld!??   TT"AAL#PA    % 6% Ld!??   TTAALPB0    % $6$% Ld$$$!??   TT AALPC2.    % 6% Ld!??% % " !% %   ?'%    Ld#9 )!??'% (  Ld#>9#`)!??'% (  Ld9#&" WMFC E9 !??'% (  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% RL  Verdana Verdana`hۍ0WXw \@$0 \ 0%   RL  Verdana VerdanaDhۍ0WXw \@$0 \ D0% %  % % % % % % " !% %   $?%   T3>AA3!LCreating a Personal Balance Sheet          % %  % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % " !% %   $?% % % % % % % % % % % %   Tt2>AA2\LThis exercise will help you consolidate your understanding of the components of the balance   T2>AA27Lsheet, by focusing on your personal financial position.T2>AA2`L Start by summarizing your financial position. List all your assets and liabilities in the table  T82>AA2RLbelow using the Terry Brown example as your guide (the headings are based on that    Tt2>AA2\Lexample). If necessary, add extra rows by selecting the row labelled "Other", then clicking     Td2>AA2YLInsert on the Excel menu bar, and then clicking Rows. When you have completed your list,     T2AA2Lclick on the tab "Stage 2".% % % % " !% %   $\>l  T2^kAA2^!LCreating a Personal Balance Sheet% % " !% %   ?% % " !% %   ?' % (     &WMFCE( &% % Ld!??% % Ld#!??% % Ld!??% % Ld>!??'%   ( &% #}6@}% 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 B  -$$- @ !$  2 C  -- @ !-"System-'-- ,?-   @ !) -    @ !)`#-    @ ! 9-    @ !`9# Tahoma-  .2 3Microsoft Business Planner        Verdana-  2 M2Go to Article:    Verdana Ref-  Verdana-    Verdana--  - - - - --'- -  ,?$-  92 3!Creating a Personal Balance Sheet          - - -------------------------------------'--  ,?$------------ 2 2\This exercise will help you consolidate your understanding of the components of the balance   Z2 27sheet, by focusing on your personal financial position.2 2`Start by summarizing your financial position. List all your assets and liabilities in the table  2 2Rbelow using the Terry Brown example as your guide (the headings are based on that    2 2\example). If necessary, add extra rows by selecting the row labelled "Other", then clicking     2 2YInsert on the Excel menu bar, and then clicking Rows. When you have completed your list, n    02 2click on the tab "Stage 2".p-- --'- -  ,l>\$ 92 ^2!Creating a Personal Balance Sheet--'- -  ,?--'- -  ,?-   -- @ !-- @ !#-- @ !-- @ !>-  -}#}@- @ !}#- -'-  ,?-'-  ,?-   -?- @ !?-- @ !-'0R *H C0?10 *H 0g +7Y0W03 +70%7)O•0 0 *H !+M Bqx2 ?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  1rb+úWY0 +7 10VTExercise Creating a Personal Balance Sheet<:http://bookshelf.msn.com/z/msbp/teleport/fromCD/office.asp0  *H  v.#'+w;2Tu%J{#7l,‰2&ѵKta>VۢOu+׾ܓML.~֐Dbvm_[ٶ6DSiA48f0 *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 981201004914Z0 *H  1'U:KF2x0  *H %{o$)/sw.pUl7FoIL I |Ëub{tҨQ5z%y^ ʥ,mq1,]Frt-o5ʪbyyxj;F. @`\pMicrosoft Corporation Ba==-j,8@"1Arial1Arial1Arial1Arial1 Verdana1Verdana1 Tahoma1Tahoma1Tahoma1 Arial1@ Tahoma1Tahoma1Tahoma1@ 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\)                 %@@   7 % @ %@"@     D  $ 7 # ! ! ) )  % @  !7  7     % 7 7   @  `  `  Q  %!`  %! @  % %!`  %  Q( A %!(@ Q  h@  `@  %! @  %!    `   % 7   % 7  Q  Q 7  A   %!  @  h@@  ` @ A A  @  ` A(A 7 % 7 7 A  % 7  A "@ %1 " @  %! @@  %1( @  A(7  A A 7 %!`@ %!`7 @ a  7 A(7 Q(  %   % 7   %   % 7 %A "@ %1 "7 @  %A("@ %1(  %!(@   h@ @  `@ @  h %! @   h@  `7 @  7  Q( %!(@  %1(  %! @@ a  7 !7   H7 !  @ !  `  `7 ) ) X P ) A(7 h `   %(7  %( !7 # ) ) ) ) !  amount Body text header Header Total Header1 Header2 Header3 Header4NonPrint_copyrightNonPrint_HeadingNonPrint_HyperlinkNonPrint_TemTitle NonPrint_Text Normal 2 Product Title Text !Title`g%Stage 13Stage 2@Stage 3QNStage 4  ;  ;   ; #  ; 7 g"V7CashHouseMortgage Overdraft Credit CardsJewellery and Paintings Furniture(Where I Got the Money from)!(What I Have Done with the Money) Hire PurchaseCarTotal Claims by Other People My Capital My AssetsLiabilities (Long Term)Fixed Assets (Long Term) Current Liabilities (Short Term)Current Assets (Short Term)Total Liabilities Total Assets Fixed AssetsMoney Owed to You*Creating a Personal Balance Sheet: Stage 2*Creating a Personal Balance Sheet: Stage 4*Creating a Personal Balance Sheet: Stage 3(Where I Got the Money From)Liabilities and Claims Assets $Total of My and Other People's MoneyFinancial Position LiabilitiesAssetsPersonal Balance SheetLess Current LiabilitiesCurrent AssetsNet Current AssetsNET ASSETS EMPLOYEDNet Book ValueTotal Current AssetsTotal Current Liabilities FINANCED BYNet Total AssetsGo to Article:!Creating a Personal Balance SheetOtherThis exercise will help you consolidate your understanding of the components of the balance sheet, by focusing on your personal financial position. Start by summarizing your financial position. List all your assets and liabilities in the table below using the Terry Brown example as your guide (the headings are based on that example). If necessary, add extra rows by selecting the row labelled "Other", then clicking Insert on the Excel menu bar, and then clicking Rows. When you have completed your list, click on the tab "Stage 2".tMake sure you have completed Stage 1 before starting this stage. Now divide the entries you made in Stage 1 into assets and liabilities and put them into the tables below. The value of "My Capital" is the difference between "My Assets" and "Total Claims by Other People". If necessary, add extra rows by selecting either row labelled "Other", then clicking Insert on the Excel menu bar, and then clicking Rows. 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. When you have completed both tables click on the tab "Stage 3".Make sure you have completed Stage 3 before starting this stage. With the financial position redrafted to divide up the short- and long-term assets and liabilities, you are ready to create a full balance sheet using the table below. As in previous stages, be careful not to enter data into the cells displaying zeroes as these contain formulae, and use the rows labelled "Other" if you need to insert extra rows. ("Financed By" is the balance sheet heading for long-term liabilities.)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.Make sure you have completed Stage 2 before starting this stage. Next, further divide the assets and liabilities tables into long term and short term. (Current Liabilities are those which need to repaid within one year.) As in Stage 2, be careful not to enter data into the cells displaying zeroes as these contain formulae, and use the rows labelled "Other" if you need to insert extra rows. When you have completed both tables, click on the tab "Stage 4".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.:  jkrs|} @ 4~',/1  dMbP?_*+% &LDate: &D&?'?(?)?MHP LaserJet 4Si@w  XX@MSUDOHP LaserJet 4Si<d " dXX??U} I?} }  } I4@@@  X@    #hiiiii$# z1iiiii$#jkkkkk$# l+kkkkk$# ,kkkk$#mmmmmm$#nnnnnn$# ~,}}}}}$# .}}}}}$ #qrrrrr$ # |2 }}}}}$ #uvvvvv$ #uvvvv {5 $ #uvvvv {6 $#;<##$$$$ .'##$$$$78##$$$ $9 g##$$$$ =5##$$$$ >6##$$$$ >6##$$$$ >6##$$$$ >6##$$$$ > 6##$$$$ >6##$$$$ >6##$$$$ > 6##$$$$ >6##$$$$ t-"####$$$$$$##$$######$@DVl.........0........... !"#$%&'()*+,-./0123 @!@"@#@$@%@&@'@(@)@*@+@,@-@.@/@0@1@2@3@,X| >@<d  " 7FyK yK http:///^yK yK *msbpz://-r:276DB130/ @ 35&=?  dMbP?_*+% &LDate: &D&?'?(?)?MHP LaserJet 4Si@w XX@MSUDOHP LaserJet 4Si<d "dXX??U} I?}  }  }  }  } I3@@@@  @ w w    #hiiii$# z1iiii$#jkkkk$# l+kkkk$# ,kkk$#mmmmm$#nnnnn$# ~~~~o$# /p$ #qrrrr$ # |2 |||s$ $uvvvv$ $uvvv {4 $ #;<$f:## ( %$ ( 3## . 4$ . 3#$K8$LM# $9 g $9 g#$>6$>6#$>6$>6#$>6$>6#$A6$>6#$A6$>6#$JC$>6#$ J-C$A6#$ F #G %$A6#$DE$A6#$ > !6 DD$>6#$BC$ A- 6#$ H!IA DD$ H#I %#$###$$#$###$$#Dl,,,,,,,BBB,QO. !"#$%&'()*+,-./012 @!@"@#@$@%@&@'@(@)@*@+@,@-@.@/@0@1@2@*:h >@<d" 7FyK yK http:///^yK yK *msbpz://-r:276DB130/ @ 'BJ2M  dMbP?_*+% &LDate: &D&~?'~?(~?)~?MHP LaserJet 4Si@w  XX@MSUDOHP LaserJet 4Si<d " dXX `? `?U} I} }  } }  } I'@@@@  @ w w    #hiiii+# z1iiii+#jkkkk+# l+kkkk+# ,kkk+#mmmmm+#nnnnn+# ~~~~o+# 3p+ #qrrrr+ # |2 |||s+ $uvvvv+ $uvvv {4 + 0\]$\]+^ [ 1$ [ 1+* [ 2* [ 2+*NO*NO+ -9 P -9 P+-LQ-LQ+- R Q- R Q+-U6$U6+&U6+U6+&U6+U6+&U6+V6+&U6+U6+& x- C+ x- C+ &Y#X! %R +Y#X! %(+&ST+ST+& 7 T+ 7 T+&U6+U6+&U6+U6+&VC+VC+Ddl,,,,,,,BBBBBtB  ! "#$%& , x- C+ x- C+ !,W#!X# %  !+W#!X# % !+"$ST)ST+#$ #_!#e+ DD!#) #_!#e DD!#+$$++++++%$++++++&+xBt>@" 7FyK yK http:///^yK yK *msbpz://-r:276DB130/ @ :hPW^  dMbP?_*+% &LDate: &D&~?'~?(~?)~?MHP LaserJet 4Si@w  XX@MSUDOHP LaserJet 4Si<d " dXX `? `?U} I} I}  } I:  @ @      @ @  @ w w                      #hiiiiii## z1iiiiii##jkkkkkk## l+kkkkkk## ,kkkkk##mmmmmmm##nnnnnnn## ~~~~~~o## 0p# #qrrrrrr# # |2 |||||s# $uvvvvvv$ $uvvvvv {4 $ /;<##$$$#/ _!4##$$$#/`a##$$$# /9 P##$$$#/LM##$$$#/ 7%M##$$$#/LM##$$$#/ Lb##$$$#/U6##$$$#/U6##$$$#/U6##$$$#/U6##$$$#/U6##$$$#/ y-C##$$$#/ Y&#X" %##$$$#/ST##$$$#/ R#T##$$$#/U6##$$$#/U6##$$$#D?l000000002000U0 !  "  # $ % & ' (  )  * + , - . / 0 1 2 3 4 5 6 7 8 9  /U6##$$$#!/ !y-!C##$$$#"/ "Y'#"X) %!&"##$$$##/7T##$$$#$/ $c"$T##$$$#%/U6##$$$#&/U6##$$$#'/U6##$$$#(/ (y-(C##$$$#)/ )Y(#)X- %%(&)##$$$#*/7T##$$$#+/ +($!+Z7 D"D)+##$$$#,/7T##$$$#-/ -.*'-Z+DD"D)-##$$$#./7T##$$$#// /R)/T##$$$#0/Lb##$$$#1/U6##$$$#2/U6##$$$#3/U6##$$$#4/U6##$$$#5/U6##$$$#6/ 6y-66##$$$# 7/d#7e# %16.7##$$$#8/&+++$$$#9)))))$$$#8Y0U00USY00K>@" 7FyK yK http:///^yK yK *msbpz://-r:276DB130/