ࡱ> Root EntryRoot Entry FmrFk@CompObj fWorkbookI3MSDigSig(Author)$>H  !"#$%&'()*+,-./0123456789:;<=?@ABCDEFGHJKLMNOPQRSTUVWXYZ[\]^_`abSummaryInformation(kDocumentSummaryInformation8 ՜.+,D՜.+, PXd lt| /  Question Solution  Worksheets 8@ _PID_HLINKSATImsbpz://-r:276DB13F/  http:///Imsbpz://-r:276DB13F/  http:/// FMicrosoft Excel WorksheetBiff8Excel.Sheet.89qOh+'0tk X` "Adjusting for Inflation: QuestionExMicrosoft Corporationn:Microsoft Corporationn:Microsoft Excel@qZ+x@7)+@*G\j&  &5&" WMFC (Hd7& EMFH3 @    !" !" !  " !  8'%    &% 6% Ld!??% 6% Ld!??% 969% Ld999!??% J6J% LdJJJ!??% [6[% Ld[[[!??% l6l% Ldlll!??% }6}% Ld}}}!??% 6% Ld!??% 6% Ld!??% 6% Ld!??% 68% Ld77!??% #6#% Ld###!??% 6% Ld!??% 767% Ld777!??'%  Ld!??'%  ( &% 6% Ld!??% 6% Ld!??%  ( &% 6% Ld!??% 6% Ld!??% % RLArialArial# WXw R\lP@$0y R\l|pd+%w0%    TT AA LP14   ( &% 6% Ld!??   TT (7AA (LP2i   %  6 % Ld   !??   TT :IAA :LP3(   % :6:% Ld:::!??   TT KZAA KLP4   % 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!??   TTksAAkLPB0    % $6$% Ld$$$!??   TTAALPC2.    % 6% Ld!??% % " !% %   8'%    Ld#9 )!??'% (  Ld#79#)!??'% (  Ld9#&" WMFC H9 !??'% (  Ld#97#9!??RL Tahoma Tahomadhۍ0WXw N\@$0 N\ 0%  % % " !% %   $ 79   T3 +8AA3 LMicrosoft Business Planner       % % " !% %   8RL Verdana Verdanadhۍ0WXw O\@$0 O\0%    T2MYAA2MLhGo to Article:   RL  Verdana Ref Verdana Refw}!w`WXw U\@$0 U\3 0% RL  Verdana Verdanadhۍ0WXw Q\@$0 Q\ 0%   RL  Verdana VerdanaDhۍ0WXw F\@$0 F\ D0% %  % % % % % % % % " !% %   $8%   T37AA3!LAdjusting for Inflation: Question         % %  % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % " !% %   $8% % % % % % % % % % % % %   T27AA2fLThis exercise will help to consolidate your understanding of adjusted sales ratios and also test your  T,2 AA2%Lknowledge of basic formulae in Excel.  T27AA2cLHigh Note's sales figures for the first three years have been confirmed as 100,000, 130,000, and  T|27AA2]L160,000 respectively. You also know that the consumer index for each year was 106, 124, and    T27AA2aL140. Using the table below, calculate the unadjusted sales growth ratios. Compare these with the      T27AA2bLratios you get once you have accounted for inflation. When you have completed the table, click on   T<2AA2(Lthe "Solution" tab to check your answer.& WMFCH % % % % " !% %   $\7l  T02^ kAA2^&LThe Problems with Using Ratio Analysis  % % " !% %   8% % " !% %   8' % (     ( &% % Ld!??% % Ld#!??% % Ld!??% % Ld7!??'%   ( &% #}69}% Ld#}7}#}!??% ( % " !%   8% " !%   8'%    ( &% 68% Ld78!??% 6% Ld!??% "   8  '' ' ,8-  -- @ !-- @ !-99- @ !9-JJ- @ !J-[[- @ ![-ll- @ !l-}}- @ !}-- @ !-- @ !-- @ !-8- @ !7-##- @ !#-- @ !-77- @ !7-  @ !- -- @ !-- @ !- -- @ !-- @ !--Arial-  2  1 -- @ !  2 ( 2 -  - @ !   2 : 3 -::- @ !:  2 K 4t -KK- @ !K  2 \ 5r -\\- @ !\  2 m 6@ -mm- @ !m  2 ~ 7~ -~~- @ !~  2 8 -- @ !  2 9 -- @ !  2 #Ab  -- @ !  2 kB  -$$- @ !$  2 C  -- @ !-"System-'-- ,8-   @ !) -    @ !)#-    @ ! 9-    @ !9# Tahoma-  --'- -  ,97 $ .2 3Microsoft Business Planner       --'- -  ,8 Verdana-   2 M2Go to Article:    Verdana Ref-  Verdana-    Verdana--  - - - - - - --'- -  ,8$-  92 3!Adjusting for Inflation: Question         - - --------------------------------------------------------------'--  ,8$------------- 2 2fThis exercise will help to consolidate your understanding of adjusted sales ratios and also test your  ?2 2%knowledge of basic formulae in Excel.e  2 2cHigh Note's sales figures for the first three years have been confirmed as 100,000, 130,000, and u 2 2]160,000 respectively. You also know that the consumer index for each year was 106, 124, and ,   2 2a140. Using the table below, calculate the unadjusted sales growth ratios. Compare these with the      2 2bratios you get once you have accounted for inflation. When you have completed the table, click on   C2 2(the "Solution" tab to check your answer. -- --'- -  ,l7\$ @2 ^2&The Problems with Using Ratio Analysis  --'- -  ,8--'- -  ,8-   -- @ !-- @ !#-- @ !-- @ !7-  -}#}9- @ !}#- -'-  ,8-'-  ,8-   -8- @ !8-- @ !-'0= *H .0*10 *H 0g +7Y0W03 +70%7)O•0 0 *H  +BwZwf?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 #1g0c0u0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CAyfnжneq0 *H 0 *H  1  +70 +7 10  +70 *H  1 xv.j0 +7 10B@Exercise Adjusting for Inflation<:http://bookshelf.msn.com/z/msbp/teleport/fromCD/office.asp0  *H HWO߬2=6C!o5ʀB' b'9cJ;zy& ņGPG ,e 99{%okzZ3Ph7y0RgF[Z1Ex!pil 3>WD5DH+-RI¾` zެ1"6agP>me7܆(u5o;HڎU673w||z mrGNQ0_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 981201004501Z0 *H  1>Ed1<0  *H 3)"ϞWSTT \f՛~E"0Znwdi$D.CPjmM05ܙ:|)cS%F1;(eOe%"c>5<RP @`\pMicrosoft Corporation Ba==-j,8X@"1Arial1Arial1Arial1Arial1 Verdana1Verdana1 Tahoma1Tahoma1Tahoma1Tahoma1 Arial1@ Tahoma1Tahoma1@ 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\);_(* "-"??_);_(@_)""#,##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\) 0.0%                 %@@   7 % @ %@"@     D  $ 7 # ! ! ) )  % @  !7  7     @ %!`@  `  ` A  %   %  ah a(   `7 A$a$a  h  `  ` %!( %! @ %!`@ !p A07A(  a( 7  !x  `7 Q  %A A 7 %   % 7  %   $7 %a a 7 ,7  % 7  % 7  $77 !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`Questionx#Solution  ;   ;$ gJUnadjusted Sales RatiosYearSales Sales GrowthSales Growth RatioUNADJUSTED RATIOSADJUSTED RATIOSHigh Note's Sales RatiosGo to Article:&The Problems with Using Ratio AnalysislScroll down to see the solution. Click on any of the cells to see the formulae used to calculate the values.!Adjusting for Inflation: Question!Adjusting for Inflation: Solution7This exercise will help to consolidate your understanding of adjusted sales ratios and also test your knowledge of basic formulae in Excel. High Note's sales figures for the first three years have been confirmed as 100,000, 130,000, and 160,000 respectively. You also know that the consumer index for each year was 106, 124, and 140. Using the table below, calculate the unadjusted sales growth ratios. Compare these with the ratios you get once you have accounted for inflation. When you have completed the table, click on the "Solution" tab to check your answer.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.M*  @ )"  dMbP?_*+% &LDate: &D&~?'~?(~?)~?MHP LaserJet 5Si/5Si MX7@ `@dXX7@XXEXCELCourier New (Xw \\proliant\pro_frontHP5SI" dXX `? `?U} I} } }  } I@@,@  @ U U  "HIIIII$" VIIIII$"JKKKKK$" L KKKKK$" \ \KKKK$"MMMMMM$"NNNNNN$" X YYYYO$" ZYYYYP$ "QRRRRR$ " [ YYYYP$ $STTTTT$ $STTTT W $ "/001$$$$ 23#4$$$$5%+ 6 $$$$ 7 ) * 8 $$$$9%%:$$$$ ;%%:$$$$<,&=$$$$~ >?((?$$$$~ @@''A$$$$~ @@''A$$$$9%%:$$$$ ;%%:$$$$B-.C$$$$~ >?((?$$$$~ @@''D$$$$~ E@FFG$$$""""""""""""""""B X........0R........>@" 7FyK yK http:///^yK yK *msbpz://-r:276DB13F/ @ -&.2  dMbP?_*+% &LDate: &D&x?(j@(?$$$$@@'@!'L@$ DD!A333333?$ DD $$$$@@'A!'L@ DD!A؉؉? DD $$$$9%%:$$$Dl........0R.4zz !"#$%&'()*+, $ ; %%:$$$!$B-.C$$$"$~ ">?$"( [A#jD"(?$$$#$~ #@@$#'cA$|D!#'e\@ D#D"!#D\Dž}? D#D" #$$$$$~ $E@$$FA#D!$Fs9@" D$D#!$G qq?# D$D# $$$$%$$$$$$$$&$$$$$$$$'$$$$$$$$($$$$$$$$)$$$$$$$$*$$$$$$$$+"""""""","""""""".T>@<dccc" 7FyK yK http:///^yK yK *msbpz://-r:276DB13F/