ࡱ> Root EntryRoot Entry FFkCompObj fWorkbookJbMSDigSig(Author)$?P |  !"#$%&'()*+,-./0123456789:;<=>@ABCDEFGHIKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{SummaryInformation( 8hDocumentSummaryInformation8 !՜.+,D՜.+,$ PXd lt| :  Question Worksheet Solution  Worksheets 8@ _PID_HLINKSA|rmsbpz://-r:276DB142/msbpz://-r:276DB141/msbpz://-r:276DB140/msbpz://-r:276DB143/  http:///  http:///  http:///msbpz://-r:276DB140/msbpz://-r:276DB142/msbpz://-r:276DB141/msbpz://-r:276DB143/  http:///  http:///msbpz://-r:276DB142/msbpz://-r:276DB141/msbpz://-r:276DB143/  http:///  http:///msbpz://-r:276DB140/Oh+'0h X` )Calculating Performance Ratios: QuestionsofMicrosoft Corporatione Microsoft Corporatione Microsoft Excel@[@7)+@)LGf+$ l3&" WMFC` H'HGdf.+$ EMFHG& @    !" !" !  " !  g/'%    &% 6/% Ld..!??% 6% Ld!??% 969% Ld999!??% J6J% LdJJJ!??% [6[% Ld[[[!??% l6l% Ldlll!??% }6}% Ld}}}!??% 6% Ld!??% 6% Ld!??% .6.% Ld...!??% 6g% Ldff!??% #6#% Ld###!??% 6% Ld!??% "6"% Ld"""!??% f6f% Ldfff!??'%  Ld!??'%  ( &% 6% Ld!??% 6% Ld!??%  ( &% 6% Ld!??% 6% Ld!??% % RLArialArial# WXw v\lP@$0B v\l|pd+%w0%    TT AA LP1re   ( &% 6% Ld!??   TT (7AA (LP2'   %  6 % Ld   !??   TT :IAA :LP3iS   % :6:% Ld:::!??   TT KZAA KLP4X   % 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!??   TT}AA}LPB    % $6$% Ld$$$!??   TTAALPC    % 6% Ld!??   TT@HAA@LPDer    % #6#% Ld###!??% % " !% %&" WMFC HHG   g/'%    Ld#9 )!??'% (  Ld#f9#)!??'% (  Ld9#.9 !??'% (  Ld#9f.#9!??RL Tahoma Tahomadhۍ0WXw 6\@$0 6\ 0%    T3 +8AA3 LMicrosoft Business Planner       RL Verdana Verdanadhۍ0WXw 7\@$0 7\ 0%  T2MYAA2MLhGo to Article:   RL  Verdana Ref Verdana Refw}!w`WXw >\@$0 >\3 0% RL  Verdana Verdanadhۍ0WXw 9\@$0 9\ 0%   RL  Verdana VerdanaDhۍ0WXw ,\@$0 ,\ D0% % % % " !% %   $\"l  T2^kAA2^"LThe Main Measures of Profitability  %  % % % % % % % % " !% %   $g%   T<3fAA3(LCalculating Performance Ratios: Question            % %  % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % " !% %   $g.% % % % % % % % % % % % % % % % % % %   T2fAA2`L This exercise asks you to calculate various performance ratios from a set of fictional accounts.  TX2fAA2WLFrom the Parkwood accounts set out below, calculate the following ratios for each year:    T,2AA2%L(1) Return on total capital employed; Tl2<AA20L(2) Return on shareholders' capital (after tax);T2xAA2 Ld(3) Gearing; T2AA2L(4) Times interest earned; T2AA2Lp(5) Gross profit; T2AA2Lx(6) Operating profit; T2AA2L(7) Net profit after tax.T2 f,AA2 ;LUse the table on the "Worksheet" tab to enter your answers.  % % % " !% &jWMFCHHG%   g/% % " !% %   g/' % (     ( &% % Ld!??% % Ld#!??% % Ld!??% % Ld"!??% % Ldf!??'%   ( &% #}6h}% Ld#}f}#}E!??% ( % " !%   g/% " !%   g/'%    ( &% 6g% Ldfg!??% 6/% Ld./!??% "   /g  '' ' ,/g-  -/- @ !.-- @ !-99- @ !9-JJ- @ !J-[[- @ ![-ll- @ !l-}}- @ !}-- @ !-- @ !-..- @ !.-g- @ !f-##- @ !#-- @ !-""- @ !"-ff- @ !f-  @ !- -- @ !-- @ !- -- @ !-- @ !--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  -- @ !  2 @D  -##- @ !#-"System-'-- ,/g-   @ !) -    @ !)#-    @ ! 9-    @ !9# Tahoma-  .2 3Microsoft Business Planner        Verdana-  2 M2Go to Article:    Verdana Ref-  Verdana-    Verdana-- --'- -  ,l"\$ :2 ^2"The Main Measures of Profitability  -  - - - - - - --'- -  ,g$-  C2 3(Calculating Performance Ratios: Question            - - -----------------------------------------'--  ,.g$------------------- 2 2`This exercise asks you to calculate various performance ratios from a set of fictional accounts.  2 2WFrom the Parkwood accounts set out below, calculate the following ratios for each year:a    ?2 2%(1) Return on total capital employed;l O2 20(2) Return on shareholders' capital (after tax);2 2 (3) Gearing; .2 2(4) Times interest earned; !2 2(5) Gross profit;t '2 2(6) Operating profit;r -2 2(7) Net profit after tax.;`2 2;Use the table on the "Worksheet" tab to enter your answers.  ---'--  ,/g--'--  ,/g-   -- @ !-- @ !#-- @ !-- @ !"-- @ !f-  -}#}h- @ !E}#- -'- ,/g-'- ,/g-   -g- @ !g-/- @ !/-'0K *H <0810 *H 0g +7Y0W03 +70%7)O•0 0 *H L_V PQ?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 #1u0q0u0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CAyfnжneq0 *H 0 *H  1  +70 +7 10  +70 *H  1}R+ʴ 0 +7 10PNExercise Calculating Performance Ratios<:http://bookshelf.msn.com/z/msbp/teleport/fromCD/office.asp0  *H Ka{_?QֶyȖ豢|~ ̼ ٲٴ"[Gƹ3KV7`וBέZ9^jkO$ /a]D'V`'6U꿑K"h[uKX9ϔdꣅr똞=>JH,.U01Ρ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 981201005112Z0 *H  19|lnl0  *H |)Cİt9$D^*/ ŵV㽐:j_S&Iep* ԍ9 \a ޕdDRS(!A0>{ʉfo @`\pMicrosoft Corporation Ba==-j,8X@"1Arial1Arial1Arial1Arial1 Verdana1Verdana1 Tahoma1Tahoma1Tahoma1Tahoma1 Arial1@ Tahoma1Tahoma1 Tahoma1Tahoma1@ Tahoma1Verdana1Verdana1Verdana1$Arial1Verdana1& 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     @  `  `  `  %   `  % 7  %   `   `7   % 7   % 7 7  % 7  %1x  `7  %` Q %A "@ %A "7 @  %( %A "@  %A "7 @   %(7  ` !p Q0Q07  @   `@  `7 @ %Q  %1x  !x  %(  %(  %  %1` @  %1`@  h@@  `@  ` @  `@@ %10@ %10 %10   `@ %18@ %1` %1p !p@ !p   QpQ0Q07 Q0@Q07 @a   % @ Q("@ %A`a 7 Q(%A %A 7 Qh@@ %Ah@  %Ah @  %Ah Q "@ %A`"@ %A`"7 @ %Q(Q`@p@ %Q(%Q("@ %A`  %1h  %1x  %1x7  `  `7   % 7 %h@@  %Q(@%A @%A 7 @ %   % 7  Qh@%Ah %Ah  Q(@%Qh@ %Ah  %Ah  %18@@  p  0   %1` @  4  47  %Q0 %0  %07  %Q07  47   47 7   4  47  !p@  `@  `7 @ Q0  %Q8Q8Q8Q8  Q8 7 q   q  7 !7   H7 !  @ !  `  `7 H @ 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`&QuestionlA WorksheetPSolution  ;5  ;  ; g _>Parkwood and Co Fixed AssetsSalesCost of Goods SoldCurrent Assets Gross Profit Loan InterestNet Current AssetsTax Due on Profits Share CapitalRetained EarningsLong-Term Loan (at 12 per cent) '(2) Return on the Shareholders' Capital (3) Gearing(5) Gross Profit(6) Operating Profit(7) Net Profit After TaxProfit and Loss StatementNET ASSETS EMPLOYEDIncome Total IncomeStockDebtorsCashTotal Current Assets ExpenditureSales and MarketingLess Current LiabilitiesAdministrationBank OverdraftGeneral CreditorsTaxTotal ExpenditureTotal Current LiabilitiesProfit Before TaxProfit After Tax FINANCED BYOperating ProfitAnswers$(1) Return on Total Capital Employed(4) Times Interest Earned (X).Balance Sheet at 20 January This Year and Last Last Year This YearNet Total AssetsGo to Article: See Also:"The Main Measures of ProfitabilityUse the table below to fill in your answers to the questions on the "Question" tab. When you have finished, click on the "Solution" tab to check your answers.(Calculating Performance Ratios: Question)Calculating Performance Ratios: Worksheet(Calculating Performance Ratios: Solution!Return on Capital Employed (ROCE)/Gearing and the Return on Shareholder's CapitalProfit MarginsThis exercise asks you to calculate various performance ratios from a set of fictional accounts. From the Parkwood accounts set out below, calculate the following ratios for each year: (1) Return on total capital employed; (2) Return on shareholders' capital (after tax); (3) Gearing; (4) Times interest earned; (5) Gross profit; (6) Operating profit; (7) Net profit after tax. Use the table on the "Worksheet" tab to enter your answers.aScroll down to see the answers. Click on a cell and then look at the formula in the formula bar to see where the information in that cell is drawn from. The formula will show the name of the tab followed by the cell reference in that tab. For example, "Question!G40" is the reference for the figure for operating profit this year on the "Question" tab).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.MBp 9+VD !H @ ?)2S>  dMbP?_*+% &LDate: &D&x  % 6 '&@-@ % }! ~@z@& DD! @@& DD g!% !9!)@.p@!%G{|2"% "h#"i @( %!&#"jw@( %!&"% "k "*/2#%lmA% #E#'@-L@#2$% $n $*/% $6$'@-@$2%% %6%'@-p@%% %6%' @-@%2&% &6 &'p@-u@&% &o"#&4 @( %#%+#&5p@( %#%+&2'% '9!') @.@'%xyzp(% (h##(76@, %%'&#(8[@, %%'&(% (}'!(~@+ D D&!(F@+ D D&(p)%qrs%F{|g*% *d!*ev@{| D"D(!*fp@* D"D(*% *G*{@|@*%+%qrs% +}$!+~{@2 D(D*!+U@  D(D*+p,% ,d.',e@*DD"D(',f@@"DD"D(,%t(u2-%D&,% -o-7ɲ@8@-g.% .\&.&,%v).2/%3(u% /%!/-@" D+D-!/@/ D+D-/20% 06 0'@-@0%22221% 16 1'D@-V@1%2222 2%h#27@5 %01&#28@5 %01&2%222%3%9).%222%4% 49 4)@.@4%%%%% 5%w$5e@/$4$2B$5f@@2$4$2B5%%%%%6%%%%%%%%%7%%%%%%%%%8:9:::;><>=>>>B^ XBBVfBvB0vBBpBr >@<d2 7FyK yK http:///FyK yK http:///FyK yK http:///^yK yK *msbpz://-r:276DB143/^yK yK *msbpz://-r:276DB140/^yK yK *msbpz://-r:276DB141/^yK yK *msbpz://-r:276DB142/ @ &DLcN  dMbP?_*+% &LDate: &D&x0000000 4!4"4#4$4%4n #%%%%%%%???????????????????????????????????????????3l!?:????????????????????????????????????????????????3">#>$>%>drp >@<d* 7FyK yK http:///FyK yK http:///^yK yK *msbpz://-r:276DB143/^yK yK *msbpz://-r:276DB141/^yK yK *msbpz://-r:276DB142/^yK yK *msbpz://-r:276DB140/ @ &TG^`  dMbP?_*+% &LDate: &D&x~~~~~~~ 4!4"4#4$4%4n #%%%%%%%???????????????????????????????????????????3l!?:????????????????????????????????????????????????3">#>$>%>drp >@<dccc* 7^yK yK *msbpz://-r:276DB140/FyK yK http:///FyK yK http:///^yK yK *msbpz://-r:276DB143/^yK yK *msbpz://-r:276DB141/^yK yK *msbpz://-r:276DB142/  FMicrosoft Excel WorksheetBiff8Excel.Sheet.89q