ࡱ> Root EntryRoot Entry Fp;uFkCompObj fWorkbookD9MSDigSig(Author)$90  !"#$%&'()*+,-./012345678:;<=>?@ABCEFGHIJKLMNOPQRSTUVWXYZ[\]^_`SummaryInformation((`DocumentSummaryInformation8 ՜.+,D՜.+, PXd lt| / Summary of Key Ratios  Worksheets 8@ _PID_HLINKSA ?`msbp://-r:276DB119/  http:/// FMicrosoft Excel WorksheetBiff8Excel.Sheet.89qOh+'0_ X`  %Summary of Key Ratios - Years 1 to 5elMicrosoft Corporation- Microsoft Corporation- Microsoft Excel@v)t@7)+@)ԱG^% e/&" WMFCsr !Ad3% EMFA @    !" !" !  " !  4'%    &% 6% Ld!??% 6% Ld!??% 969% Ld999!??% J6J% LdJJJ!??% [6[% Ld[[[!??% l6l% Ldlll!??% }6}% Ld}}}!??% 6% Ld!??% 6% Ld!??% 6% Ld!??% 64% Ld33!??% #6#% Ld###!??% 6% Ld!??% 363% Ld333!??'%  Ld!??'%  ( &% 6% Ld!??% 6% Ld!??%  ( &% 6% Ld!??% 6% Ld!??% % RLArialArial# WXw \lP@$0S \l|pd+%w0%    TT AA LP14   ( &% 6% Ld!??   TT (7AA (LP2a   %  6 % Ld   !??   TT :IAA :LP3A   % :6:% Ld:::!??   TT KZAA KLP498   % K6K% LdKKK!??   TT \kAA \LP5U   % \6\% Ld\\\!??   TT m|AA mLP6   % m6m% Ldmmm!??   TT ~AA ~LP7t1   % ~6~% Ld~~~!??   TT AA LP83    % 6% Ld!??   TT AA LP9R   % 6% Ld!??   TT"AAL#PA    % 6% Ld!??   TT{AA{LPB/w    % $6$% Ld$$$!??   TT AALPCIG    % 6% Ld!??% % " !% %   4'%    Ld#9 )!??'% (  Ld#39#j)!??'% (  Ld9#&" WMFC A9 !??'% (  Ld#93#9j!??RL Tahoma TahomaDhۍ0WXw \@$0 \ $ 0%    T4 38AA4 LMicrosoft Business Planner      RL Verdana Verdana`hۍ0WXw \@$0 \0%  T2MYAA2MLhGo to Article:   RL  Verdana VerdanaDhۍ0WXw }\@$0 }\ D0% RL  Verdana Verdana`hۍ0WXw \@$0 \ 0%   RL  Verdana VerdanaDhۍ0WXw ~\@$0 ~\ D0% % % % " !% %   $\3l  T2^jAA2^LSummary of Performance Ratios  %  % % % % % % % % " !% %   $4%   T$33AA3$LSummary of Key Ratios - Years 1 to 5            % %  % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % " !% %   $4% % % % % % % % %   Tt23AA2\LThis template will automatically calculate your key operating ratios, based on the data you    T23AA2MLenter from your income statement and balance sheet summaries of years 1 to 5.    Tp23AA2[LFill in the appropriate cells in the "Data Collection" section. The cells displaying zeros   T\23AA2XLcontain formulas to perform the calculations on your data. Do not type into these cells    Tt23AA21Lbecause doing so will erase the formulas in them.   % % % " !% %   4% % " !% %   4' % (     ( &% % Ld!??% % Ld#!??% % Ld!??% % Ld3!??'%   ( &% #}65}% Ld#}3}#}!??% ( % " !%   4% " !%   4'%    &WMFCA( &% 64% Ld34!??% 6% Ld!??% "   4  '' ' ,4-  -- @ !-- @ !-99- @ !9-JJ- @ !J-[[- @ ![-ll- @ !l-}}- @ !}-- @ !-- @ !-- @ !-4- @ !3-##- @ !#-- @ !-33- @ !3-  @ !- -- @ !-- @ !- -- @ !-- @ !--Arial-  2  1< -- @ !  2 ( 2 -  - @ !   2 : 3] -::- @ !:  2 K 4 -KK- @ !K  2 \ 5Y -\\- @ !\  2 m 6 -mm- @ !m  2 ~ 7N -~~- @ !~  2 8< -- @ !  2 9 -- @ !  2 #A]  -- @ !  2 {B  -$$- @ !$  2 CY  -- @ !-"System-'-- ,4-   @ !) -    @ !)j#-    @ ! 9-    @ !j9# Tahoma-  .2 4Microsoft Business Planner       Verdana-  2 M2Go to Article:    Verdana-  Verdana-    Verdana-- --'- -  ,l3\$ 32 ^2Summary of Performance Ratios  -  - - - - - - --'- -  ,4$-  =2 3$Summary of Key Ratios - Years 1 to 5            - - ------------------------------'--  ,4$--------- 2 2\This template will automatically calculate your key operating ratios, based on the data you    {2 2Menter from your income statement and balance sheet summaries of years 1 to 5.n    2 2[Fill in the appropriate cells in the "Data Collection" section. The cells displaying zeros   2 2Xcontain formulas to perform the calculations on your data. Do not type into these cells    Q2 21because doing so will erase the formulas in them.o   ---'--  ,4--'--  ,4-   -- @ !-- @ !#-- @ !-- @ !3-  -}#}5- @ !}#- -'- ,4-'- ,4-   -4- @ !4-- @ !-'0& *H 010 *H 0g +7Y0W03 +70%7)O•0 0 *H 9'}b6v|T_Ġ?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 #1P0L0u0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CAyfnжneq0 *H 0 *H  1  +70 +7 10  +70 *H  1V%Z5-Q0~ +7 1p0n,*Summary of Key Ratios>](80#g" d7s>Rc܂,;};+&}jRM ۑҢV{=" @`\pMicrosoft Corporation Ba==-%8X@"1Arial1Arial1Arial1Arial1 Verdana1Verdana1Verdana1 Tahoma1Tahoma1Tahoma1 Arial1@ Tahoma1?Verdana1Tahoma1@ Tahoma1Verdana1Verdana1Tahoma"$"#,##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   %   % 7   A    A @!p   H  @  `   h@@  `@  ` @  % 7  %!(@ %!8@ %!0 %!0   A(@ Q @  % @  % 7  % 7 7  %   % 7   %1`7  % @7  A(@ A( $  ah  a(   %(@ !7   H7 !  @ !  `  `7 H @ ) ) X P  %   $ )P )P P @ %!p  a8 7  %(  %8  %(  , %( %(7  %( %(7   %(7   !7  x  0 ! ) ) ) )  amount Body text header Header Total Header1 Header2 Header3 Header4NonPrint_HeadingNonPrint_HyperlinkNonPrint_TemTitle NonPrint_Text Normal 2 Product Title Text Title`_Summary of Key Ratios  ; 3 g*) Balance SheetDATA COLLECTION KEY RATIOSYear 1Year 2Year 3Year 4Year 5Go to Article:Summary of Performance Ratios$Summary of Key Ratios - Years 1 to 5CashMicrosoft Business PlannerIncome StatementProfitability Ratios Microsoft, 1998.This template will automatically calculate your key operating ratios, based on the data you enter from your income statement and balance sheet summaries of years 1 to 5. Fill in the appropriate cells in the "Data Collection" section. The cells displaying zeros contain formulas to perform the calculations on your data. Do not type into these cells because doing so will erase the formulas in them.Marketable securitiesAccounts receivable, netTotal current assetsTotal long-term assetsTotal current liabilitiesTotal long-term liabilitiesTotal shareholders' equity Total sales Gross profitTotal operating expensesIncome (loss) before taxesNet income (loss)Return on equityReturn on assetsReturn on salesGross profit marginAsset turnover ratioLeverage ratio Current ratioQuick or acid test ratioLong-term debt ratioDebt to equity ratioLeverage and Liquidity RatiosNote: When 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 Microsoft Business Planner, a new workbook is created.2j h#nm$ @ Hz"T78  dMbP?_*+% &LDate: &D&x ?  " E ____`S!" !E!____`S"" "E"____`S#" #E#____`S$"?::::;S%" %8%&&&&'S&")&&&&'S'" '@'<<<<=S(" ([M(BS7D@@@D#D@BM(B(7D@@@D#D@BM(B(7D@@@D#D@BM(B(7D@@@D#D@BM(B(7D@@@D#D@B(T)" )[J)B(4DDD#DD BJ)B)4DDD#DD BJ)B)4DDD#DD BJ)B)4DDD#DD BJ)B)4DDD#DD B)T*" *[=*B)'DD#D B=*B*'DD#D B=*B*'DD#D B=*B*'DD#D B=*B*'DD#D B*T+" +\ =+B*'DD D B=+B+'DD D B=+B+'DD D B=+B+'DD D B=+B+'DD D B+T," ,[!J,B+4DDDDD BJ,B,4DDDDD BJ,B,4DDDDD BJ,B,4DDDDD BJ,B,4DDDDD B,T-">:::::S." .A'.<<<<<S/" /[#=/],'DDD B=/]/'DDD B=/]/'DDD B=/]/'DDD B=/]/'DDD B/S0" 0[$J0^/4DDDDD BJ0^04DDDDD BJ0^04DDDDD BJ0^04DDDDD BJ0^04DDDDD B0T1" 1["D1B1.DDDD BD1B1.DDDD BD1B1.DDDD BD1B1.DDDD BD1B3.DDDD B1T2" 2[%J2$04DDDDD BJ2$24DDDDD BJ2$24DDDDD BJ2$24DDDDD BJ2$24DDDDD B2S3" 3c&D322.DDDD BD323.DDDD BD323.DDDD BD323.DDDD BD323.DDDD B3S4""""""""--- 5""""""""--- 6-.......--- 7-8-9-:-;-<-=->-?-Djl......gg.g @ABCDEFG@-A-B-C-D-E-F-G- >@<d*  7FyK yK http:///\yK yK (msbp://-r:276DB119/