ࡱ> Root EntryRoot Entry FrFkCompObjfWorkbookJ>MSDigSig(Author)$?@j  !"#$%&'()*+,-./0123456789:;<=>@ABCDEFGHIKLMNOPQRSTUVWXYZ[\]^_`abcdefghiSummaryInformation(nDocumentSummaryInformation8 ՜.+,D՜.+, PXd lt| / Profit and Loss Statement  Worksheets 8@ _PID_HLINKSA`kkmsbp://-r:276DB1E2/Oh+'0xn X` +Income Statement - Summary of Years 1 to 5fMicrosoft CorporationmaMicrosoft CorporationmaMicrosoft Excel@B@7)+@vGXm* 6&" WMFC \+\Kd_* EMF\K$ @    !" !" !  " !  `'%    &% 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!??% _6_% Ld___!??'%  Ld!??'%  ( &% 6% Ld!??% 6% Ld!??%  ( &% 6% Ld!??% 6% Ld!??% % RLArialArial# WXw \lP@$0 \l|pd+%w0%    TT AA LP1re   ( &% 6% Ld!??   TT (7AA (LP2   %  6 % Ld   !??   TT :IAA :LP3    % :6:% Ld:::!??   TT KZAA KLP4    % K6K% LdKKK!??   TT \kAA \LP5   % \6\% Ld\\\!??   TT m|AA mLP6   % m6m% Ldmmm!??   TT AA }LP7nc   % ~6~% Ld~~~!??   TT AA LP80    % 6% Ld!??   TT AA LP9   % 6% Ld!??   TT"AAL#PAre    % 6% Ld!??   TTyAAyLPBSi    % $6$% Ld$$$!??   TTAALPCTN    % 6% Ld!??   TT9AAA9LPDco    % 6% Ld!??% % " !% %&" WMFC \ \K   `'%    Ld#9 )!??'% (  Ld#_9#)!??'% (  Ld9#9 !??'% (  Ld#9_#9!??RL Tahoma TahomaDhۍ0WXw \@$0 \ $ 0%    T4 M8AA4 LMicrosoft Business Planner      RL Verdana Verdana`hۍ0WXw \@$0 \0%  T2MYAA2MLhGo to Article:   RL  Verdana Verdana`hۍ0WXw \@$0 \ 0% RL  Verdana Verdana`hۍ0WXw \@$0 \ 0%   RL  Verdana VerdanaDhۍ0WXw \@$0 \ D0% % % % " !% %   $\_l  T$2] iAA2]$LIntroduction to Financial Statements % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % " !% %   $`% % % % % % % % % % % % %   T2_AA2aLThis template provides a pro forma income statement. Please note that this type of layout is for     T2_AA2aLmanagement purposes only, rather than for the year-end filing of accounts. You can customize the   Th2FAA2/Lform by changing the row labels or adding rows.   T2_AA2cLTo add a row, select one of the rows labeled "Other," click Insert on the Excel menu bar, and then     T2_AA2eLclick Rows. You will then need to use the fill handle (see Excel Help) to fill in the formula in the    T2_AA2bL"Totals" column. The cells displaying zeros contain formulas to perform automatic calculations on     T2_AA2_L your data. Do not enter data into these cells because doing so will erase the formulas in th&~ WMFC\ \Kem.    % %  % % % % % % % " !% %   $`%   TH3_AA3*LIncome Statement - Summary of Years 1 to 5                %  % % " !% %   `% % " !% %   `' % (     ( &% % Ld!??% % Ld#!??% % Ld!??% % Ld!??% % Ld_!??'%   ( &% #}6a}% Ld#}_}#}>!??% ( % " !%   `% " !%   `'%    ( &% 6`% Ld_`!??% 6% Ld!??% "   `  '' ' ,`-  -- @ !-- @ !-99- @ !9-JJ- @ !J-[[- @ ![-ll- @ !l-}}- @ !}-- @ !-- @ !-- @ !-`- @ !_-##- @ !#-- @ !-- @ !-__- @ !_-  @ !- -- @ !-- @ !- -- @ !-- @ !--Arial-  2  1L -- @ !  2 ( 2H -  - @ !   2 : 3 -::- @ !:  2 K 4 -KK- @ !K  2 \ 5 -\\- @ !\  2 m 6 -mm- @ !m  2 } 7L -~~- @ !~  2 8H -- @ !  2 9 -- @ !  2 #A  -- @ !  2 yB  -$$- @ !$  2 C  -- @ !  2 9DL  -- @ !-"System-'-- ,`-   @ !) -    @ !)#-    @ ! 9-    @ !9# Tahoma-  .2 4Microsoft Business Planner       Verdana-  2 M2Go to Article:    Verdana-  Verdana-    Verdana-- --'- -  ,l_\$ =2 ]2$Introduction to Financial Statements --------------------------------------------------'--  ,`$------------- 2 2aThis template provides a pro forma income statement. Please note that this type of layout is for     2 2amanagement purposes only, rather than for the year-end filing of accounts. You can customize the   N2 2/form by changing the row labels or adding rows.e   2 2cTo add a row, select one of the rows labeled "Other," click Insert on the Excel menu bar, and then     2 2eclick Rows. You will then need to use the fill handle (see Excel Help) to fill in the formula in the    2 2b"Totals" column. The cells displaying zeros contain formulas to perform automatic calculations on     2 2_your data. Do not enter data into these cells because doing so will erase the formulas in them.o    --  - - - - - --'- -  ,`$-  F2 3*Income Statement - Summary of Years 1 to 5                -  --'- -  ,`--'- -  ,`-   -- @ !-- @ !#-- @ !-- @ !-- @ !_-  -}#}a- @ !>}#- -'-  ,`-'-  ,`-   -`- @ !`-- @ !-'08 *H )0%10 *H 0g +7Y0W03 +70%7)O•0 0 *H a{0wAV}E<#Ԡ?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 #1b0^0u0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CAyfnжneq0 *H 0 *H  1  +70 +7 10  +70 *H  1tMo*n/ 0 +7 10~<:Income Statement-Years 1 to 5>.ٽ^γύ+=RR9BאY&Y֕DUr hń펩-/6h >XPwIYH㡂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 981125024118Z0 *H  1eJ(ӎ_`0  *H +bpj ")7=U4tZ r)ok((O$Z0|.Ͳ(j"Hʿ [`wkQ 2Bd}W~b7Qp VC~ @`\pMicrosoft Corporation Ba==8X@"1Arial1Arial1Arial1Arial1 Verdana1Verdana1 Tahoma1Tahoma1Tahoma1 Arial1@ Tahoma1?Verdana1Tahoma1Tahoma1@ Tahoma1Verdana1Verdana1Verdana1 Tahoma1 Arial1$Arial1Arial1Tahoma1Tahoma"$"#,##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     @  `  ` Q @ ` !p@  `7   %   % 7  Q    @ q` 7   h Q @@ `   h q` q`7   %h@ Qh@ %Ap  %` %Ax %Q @@%Ap7   %`7  %1 @ %A`@ %A`7 @ %Q  @ %A`   %A` 7  %Ah %Ah  Q`@ %A` %A`7  %Qh@ %Ah  %Ah   h@@  `@ %1  %1` Qh@ %( a(@ !7   H7 !  @ !  `  `7 H @ X P %h %( a(@ %Q("@@   %Ax  %1(@ q(  q8 7  H %Q("@ %( %Ah"7 @   H    h %( %Ah7 %8@ %(7 %Ah7  %Ah"@  %( %(7  %( %( %( %(@ %(@7  (  ( %Ax" %Ax"7  %Ah@ %(@ %(7  %(@ %(!7   !7  x  0 H ) ) ) )  amount Body text  header Header Total Header1 Header2 Header3 Header4NonPrint_HeadingNonPrint_TemTitle NonPrint_Text Normal 2 Product Title Text Title`!Profit and Loss Statement  ; B g62TotalsSales MaterialsTotal Cost of Goods Sold Gross Profit Advertising DepreciationOtherLess Cost of Goods SoldGo to Article:LaborOverheadRent UtilitiesTravel Miscellaneous TelephonePostage InsuranceOperating ExpensesTotal Operating ExpensesOperating Income Income TaxesNet Income (Loss)Cumulative Net Income (Loss)#Total Nonoperating Income (Expense) Total SalesIncome (Loss) Before TaxesMicrosoft Business PlannerYear 1:Year 2:Year 3:Year 4:Year 5:*Income Statement - Summary of Years 1 to 5 Microsoft, 1998.{This template provides a pro forma income statement. Please note that this type of layout is for management purposes only, rather than for the year-end filing of accounts. You can customize the form by changing the row labels or adding rows. To add a row, select one of the rows labeled "Other," click Insert on the Excel menu bar, and then click Rows. You will then need to use the fill handle (see Excel Help) to fill in the formula in the "Totals" column. The cells displaying zeros contain formulas to perform automatic calculations on your data. Do not enter data into these cells because doing so will erase the formulas in them.Salaries and wagesEmployee benefits Payroll taxesRepairs and maintenanceOffice suppliesMarketing/promotionProfessional feesTraining and development Bank chargesInterest income (expense)Other income (expense)Note: 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.$Introduction to Financial Statements: 9x1p( @ H/D*8=  dMbP?_*+% &LDate: &D&xFi ?F j ] qqqqqr!j !s%!ttutt!o4!!3 -"j "s&"ttutt"o#!#j #s'#ttutt#o$!$j $s $ttttt$o%!%j %s %ttttt%o&!&j &s(&ttttt&o'!'j 'v'qqqqq'o(!(j (v(ttttt(o)!)j )v)ttttt)o*!*j *v*ttttt*o+!+j +v)+ttttt+o,!,j ,w,nnnnn,o-!-j -s*-ttttt-o.!-x.j .s+.ttttt.o/!.x/j /s,/ttttt/o0!/x0j 0s-0ttttt0o1!0x1j 1s1ttttt1o2!2j 2m2ttttt2o3!3j 3m3nnnnn3o!!4j 4^4p6444 -4p644p644p644p644g945"8<<<<<=6" 6M6A:666 LL6A:66A:66A:66A:66B<67"N\(((()8j 8k.8fffff#8l: %889j 9m/9nnnnn#9o8 %99:j :^:p<::: -:p<::p<::p<::p<::g>:;"8<<<<<=<" <4<A@<<< LL<A@<<A@<<A@<<A@<<B@<=">?????@>d >e>fffff#>g %>>?>hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhE?"8<<<<<=D3l.fKKKKKKKKKKKUUUUKKKSS@G"AG"BG-CG!DG!GG @4@AB@@@ LL@A@@A@@A@@A@@BB@@//////////////////////////////////////////////////////////////EACDDDDDE//////////////////////////////////////////////////////////////E BFBGBD@!BGB D@DB!BGB D@DB!BGB D@DB!BG D@DBBHD@B00000000000000000000000000000000000000000000000000000000000000EC ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++FD ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++FG_dgf>@<d*  7\yK yK (msbp://-r:276DB1E2/  FMicrosoft Excel WorksheetBiff8Excel.Sheet.89q