ࡱ> dc  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry F3?c"efWorkbookv_VBA_PROJECT_CUR""0I)"VBA @|"s" Fɀ Worksheet"&Tools&WindowChart"&Tools&Window(Visual Basic Module"&Tools&Window\phcovitz Ba=   ThisWorkbook=J.8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1hArial1 Arial1Arial1Arial1Arial1.Times New Roman1Tahoma1QTahoma1Arial1.Times New Roman1Arial1. Times New Roman1 Arial1 Arial1. Times New Roman1.hTimes New Roman1.Times New Roman1.Times New Roman1.Times New Roman1Arial1.Times New Roman1.Times New Roman1.Times New Roman1Arial1Arial1Arial1Arial1Arial1Arial1QTahoma1Arial1Arial"$"#,##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\);_(* "-"??_);_(@_)50_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-0+_(* #,##0_);_(* \(#,##0\);_(* "-"??_);_(@_)0_);;; 0.0%#,##0.0_);\(#,##0.0\) :               :+ ) , *    :      :    : @  @   H   h   h     h    h    h    h   h   h   &X &P   h   h  h P : : `P   `  `  `P   `P   p &X  pP  &pP   a : &\ &p &p &x &x &xP  x &P &X &x &x x &x &xP  x xP                       x x@ &x@ &X &X &xP  &x &x &x xU  #x  !x  `3   h3  `P 3  3:"  |   |   "|  !|   @  !|  !!|  !x  !   | !| "| q!x !| !!| !x  ! !| !# !X  |  H  h #x  x ! | !#| "|"  |  !|  "| #      #! qX q `  p  q @ p ww@ @  !  q H  qX   ww@ @  # q H q ww@ @  p! q! &p ww@ @   p ww@ @  q  q ww@ @  y H !q H q"X q ` qX q x qX q H q!X q H p! q! q!X q h q h q" q ww@ @  q$ p ww@ @  &q ww@ @  &p ww@ @  q ww@ @  q! q  q! &q  q@ @  q@@  q @  q@ @  q&w@@  q&pw @   & d q  q p @ q" q  q# q! q! q#X % ww@ @   q! q p  "|   |   D  L  H % L  "x q! q pw @  %q ww@ @  %q pw @  q H  h  H      L  @   H   L  & L  % L q q h  q h  q h    |    |  q h    |  q!  q h  q!  q H q$ q"x  `  h  |  h  ` x  | )$Dezimal [0]_Compiling Utility Macros% Dezimal_Compiling Utility MacrosNormal_ChgLoanNormal_forecastNormal_proformamodel'"Standard_Anpassen der Amortisation)$Whrung [0]_Compiling Utility Macros% Whrung_Compiling Utility Macros8 ``i̜̙3f3333f3ffff333ff333f33f33BBB\`z Introduction Base YearU Assumptions/PIncome StatementQ Balance Sheeta Cash FlowOIncome Statement Chart-Balance Sheet Chart]Cash Flow Chart'zCumulative Free Cash Flow Chart<MyDialog VDlgModule1  - __123Graph_ACHART 2=''''- __123Graph_ACHART 2= ''''- __123Graph_ACHART 2= ''''- __123Graph_ACHART 2=''''- __123Graph_ACHART 2=''''- __123Graph_ACHART 2= ''''- __123Graph_ACHART 2= ''''- __123Graph_ACHART 2;}}- __123Graph_ACHART 2= ''''- __123Graph_BCHART 2=''''- __123Graph_BCHART 2= ''''- __123Graph_BCHART 2= ''''- __123Graph_BCHART 2=''''- __123Graph_BCHART 2=''''- __123Graph_BCHART 2= ''''- __123Graph_BCHART 2= ''''- __123Graph_BCHART 2;}}- __123Graph_BCHART 2= ''''- __123Graph_CCHART 2=''''- __123Graph_CCHART 2= ''''- __123Graph_CCHART 2= ''''- __123Graph_CCHART 2=''''- __123Graph_CCHART 2=''''- __123Graph_CCHART 2= ''''- __123Graph_CCHART 2= ''''- __123Graph_CCHART 2= - __123Graph_CCHART 2= ''''- __123Graph_DCHART 2=''''- __123Graph_DCHART 2= ''''- __123Graph_DCHART 2= ''''- __123Graph_DCHART 2=''''- __123Graph_DCHART 2=''''- __123Graph_DCHART 2= ''''- __123Graph_DCHART 2= ''''- __123Graph_DCHART 2;}} - __123Graph_DCHART 2= '''' __IntlFixup* __IntlFixupTable;Analysis:BaseAD:I BaseAP:U BaseAR:A BaseCash:? BaseCD:6 BaseCE:n BaseCM:W BaseCOGS: BaseCS:d BaseDep:& # BaseGAExpense: BaseGPE:H BaseI:B BaseIE:, BaseIER:p BaseIERL:q BaseII:+ BaseIIR:o ! BaseLTDTerm:^ BaseLTL:_ *BaseMarketingExpense: BaseMS:@ BaseOCA:C BaseOE1: BaseOE2: BaseOE3: BaseOE4:! BaseOI:* BaseOLTD:] BaseOTA:L BaseOTC:Y BasePD:5 BasePS:c BaseRE:e ! BaseRevenue: 'BaseRevenueGrowth: &BaseSalesExpense: BaseSTD:V ! BasetaxRate:0 BaseTP:X BENEFITS:'BreakevenAnalysis:BSDate:; DepYear:% Instruct"Macros.Village_But1"Macros.Village_But2"Macros.Village_But3NameArea9XNameArea9YNameArea9Z NameArea9[ NameArea9\NameArea9]NameArea9^NameArea9_ NameArea9`NameArea9a  PCHART;   ; T  ;E  ; 3  ;|   ; 5  ;3  ;2  ; ;  ; ,  ;   PRTCHT;} QHelpASQHelpBSQHelpBSCQHelpCFC QHelpCFCFCQHelpCFSQHelpISQHelpISCSS: StartYear: Table:"  Village_But19y"  Village_But29z"  Village_But39{ ZoomFactordTdJ 48       "[%ySS d"@=[%ySS d"pKyFx\]puFbKM yDI$ΏlQ R"o@+1wY5I4T@7Йe Eu]d4mDpr:6{@8e̙ W\`99;zuzQߞ>]oz}6y8sn%]=\{'h/M16E&wuw<g>Qkz߳c8v)RupMQƍx&\8YrUS8BO9FE 'P^ab141NYddrP̸Λ 8XN9K^QlY ʶ TWa(*h'~ٌ$2:ʰ{^&3:,te@@'X\Bq+EǐX\Jsz4YP ˳2>X6/EJANn.V?!_HԔrFcat0?ęC}:h'i>!S$b.b.a¨߈%c\7[y&bkuXh i!&eѩVnMTx<%1)%6nhfMXƳ2mOSuk•lb"WE8XilZY8+㏱l,"OuxG"2 ʧ锚,De[Flª:E΄u9uubpxUDQO[ i5˥"V,1LjǛC:Q,t.bL8]YE*ؤFlwf$+C c}1#+.G*$fTqbML\6 CM%L Oq; 8  G9zXsl&,A5?h(h4" 0 cqMdEf1NGdIqal)t#PӨ%%$rEʻF^.rpQA78ElVdoֹO.AT &4(ɳ>-KJL\6 BX;)vj3,lSDsx > ::>EeY+~"b ?X>Ym(0kXň < EQ@lw.R`ߕJAfcŌǨaF}Uk#g'$ 4aeS0!ȀH15!1G̊`KJ7B=4PӘV1zɀIs% bX3b`Ae4}>dh>/d܀lA"C##18b4aE$ v7nD Oȇ9LxYI:^ja!]V& MgL^/!}F3ԺF -#a`%L\I )@ZQh#~3?d6!K b ee| =H`<˖znWit DAiU!G$|h+#r<&Ѹnp(gB(8eCJ[~Puz6_rMؒ O\*ttɕf9_ bV=H,_"'K17fNrMvg]2䡙7vq }HhY,&ҙ\&{ ]a KFwm/cUӟ0Q,kb PTI1WggG8@W+" 1!Me317Je:_蟯ߟp.k PH?Dx!Vs0aSMLeg=@!"Ml&߼*]!3/tm`"\JEJk:Q],bO^Uy:Ig_J!5Y܌XR6NkT PPg4M~Tu@pDuxΰf"۔D Lf"#MP@4Q 80aS=Du_gE yb;Ξ)IS2 7dטɚgElOZ֩u5F|5iRs3!1TC.YP.|ȴx8]kAl竹19[r.Ϙ"q̛)Wym䫠. <̪ab_P\6)ZE<>a&!d>#PZŒˆS4"Y5JiM(Tx/JfX(féhӞB,H5ĭBlo^h-y %ɇCba10i; 3 0E^t| CaLL ǡ"!Q9$4fqRT#Ǖ;.BGG0D34d,{ ˞C12GUDdBGjjuu860TXqB:<sGhu Jb*St}5 M~bJ88rg"SanjH$o5pHrFkpʆxSR(U)_Vz8ͯb!L552ӣӠnz40tṕq^JꌩӪfȪmLoHmċٳfaLU'pVlzo;wYXMft j^vsG.w:uֵx2 [Trw*>[d&5nZ X@T_1bgE)ǂԏ~+uU8ӳ]H@ɰM+Gq0tLdvv bܽ#xZUW# Q?p/oY0,("epC\.fiܱC9^`u{jxד9tva3cG>[G(V+QʺfU" wkĭ¨w=[V3xGxiݕ-*Ξ#㶤rGQ+oecή.׷X]aċ_ , >`h>ZBVxQoɫFAɣ_kv+}iasÉ*P)_=?/+TTEtk-bb[Y]gFjN,X[JƋ 860j&{M}zz箞ɧ?r)뽮&+1|VΏ\8<3z;+;T˼xFzg뮮Q/kdzSz@}W&=ad93.'^׫X=^lgU Ʊj\OA]w5j]1k{Y&}/sf[#=zz[sy&_Rz_jN<' E`ޮAF\3ףxUiP==۶mMBM; 1޿RG ߓi9pU@Psjxs|Jo2 $oc_&'n:a__-a>kUaFΆ+}άNN..&Y7?kdCD{yO~"p=#G<];- MKKuD)إ> @^*Q.?$1IPtE-g!^FWju5,3QtralƖJzn)9W YL eU,11aa\*:9Jj+bv0wT2Jʵzr+Ȝx{,3`q1jd5v2udK=u&v}|P,[/(t@'xw evt_6hXrBڥI:{͒Ym=UGz2 uԴ4+R9t٫'UEzgo;K3X5Ӣ e^r`NxZ QP,|.5UШ՚K:{ jzf:\ν]hسfNw=@H)2*TȃG;1=C<~x3HO{!J#=2%Wa ۷^wCԄ2_/\~I#UA.*G!;<0,C*llrJ F}C(m&W7!Ijq1ӤC77?Sc{ ?|_:a>n<GG0y/̟\ >K➙)%By}9xa&s^">vL|Tߜ [?Turޟrz]w.M?})?y-0ET1tQ~8zb?C_ԻQUXzboy7_g:~kjV.z9|A(+wu.^LXp5E*J:eRn cr3** j ^uϨՆZkӅ[Kr+ﶒسj`+d*%|At;(3HnmJ1_v`*,`.pPqWP׈.ޒ0 *T2>k'52#}WzfE(B/ P>(ltE`YBGHU" H2;ȻM5&)txK첫K+$V*i %%RGpnB.Os?qG{o~uvL Eެk?XqApu7=ZYYYYYYYYYYYYYYYYYYYYYYYYnάάάά,ޙޙޙޙޙZwfޙpgn/G3  @@   RContents Introduction This sheet Base Year5Data entry sheet for first year estimates/actual data Assumptions=Data entry sheet for assumptions relating to major line itemsIncome StatementPro forma Income Statement Balance SheetPro forma Balance Sheet Cash FlowPro forma Cash Flow StatementIncome Statement Chart Projected Income Statement ChartBalance Sheet CharProjected Balance Sheet ChartCash Flow ChartProjected Cash Flow ChartCumulative FreeFree Cash Flow ChartOverview^Planning for the future is something managers spend much of their time doing. Marketing plansYnew products, manufacturing plans material requirements, and finance plans how much money]the company needs to operate from day-to-day. This is where financial forecasting comes in. _When a company runs out of money there is nothing they can do, short of winning the lottery, to]sustain themselves over the long-run. By developing pro forma financial forecasts, managersXcan estimate their financing requirements and make plans accordingly. Through financial[modeling, managers construct "what-if" scenarios by changing model inputs and observing the\results, for better or worse. The Pro forma model tool helps you build and analyze companiesusing this approach.]One major use of pro forma forecasting is estimating the future external financing needs of aXcompany. This allows managers to seek out the necessary cash in-flows before they impactZnormal company operations. There are several methods of forecasting financial statements,`one of which, is the percent-of-sales method. This simple but effective approach involves tyingYmany of the income statement and balance sheet figures to future sales. This system worksTwell because many of the variable costs and most current assets and liabilities vary_more-or-less directly with sales. There are exceptions to this rule, but for our purposes (and\this model) many of the line items take their cues from the annual growth in sales revenues.PThe goal of this tool is to guide you through the creation of a simple pro formaYincome statement, balance sheet, and cash flow analysis for a business. Your results willJbe simple and, for more advanced forecasting, you may need to adopt a more_sophisticated financial planning tool. However, this tool will help you develop a solid initialHunderstanding of the economics of a business and forecasting in general.TIn order to make your task as easy as possible, the workbook will ask you to provideVseveral initial financial numbers. It will then generate your financial statements andYprojections using very basic assumptions that it draws from your inputs. If you then needOto change these assumptions in order to refine your projections, you may do so.UBefore you begin, take a few minutes to look at the various tabs within the workbook.WWe've provided some sample data to give you a feel for how your results might look when you're done. DirectionsXThese directions provide a general introduction to the contents of each worksheet in theRtool. For more detailed directions place your mouse above the red celltips located)throughout the tool. See this example -->JYou may want to print these directions as a reference guide for this tool.GThis is your starting point for entering data about the company you areManalyzing. The workbook requires certain inputs to generate your projections.GThe model assumes that you are starting a new company; however the baseLyear can represent the company's first year in existence or the last year ofPactual data. Make good estimates as to what the first year financials will lookQlike, and fill in all white cells that apply to the company (if an option doesn'tOapply, leave it blank). Note that the shaded cells throughout the template are<calculated cells and should not be typed over at this stage.MThis tab includes an extensive list of assumptions for the model which can beKmodified by typing over the existing values. Any assumption you change will%carry through the years that follow. ,Income Statement - Balance Sheet - Cash FlowEThese are the primary output reports of your base year and assumption<inputs. Review these tabs to see how your projections look.,Income Statement Chart - Balance Sheet Chart1Cash Flow Chart - Cumulative Free Cash Flow ChartJThese charts reflect the output on each of the associated reports. ReviewDthese tabs to view the output of your projections in graphical form.IIf you would like to refine your projections, you can do so in two ways. Q You can change any of the data you have entered on the Base Year tabS You can change any of the data you have entered on the Assumptions tabTKeep in mind that, when you change assumptions or any other shaded cells, you may beYoverwriting the formulas that currently calculate assumptions automatically for you. This]will not affect the accuracy of the workbook. If you decide afterwards that you prefer to useZthe automated calculations, you will need to start over again by closing your working fileand re-opening the template.WIf you decide that you wish to make changes to formulas in the template, you will firstUneed to Unprotect the sheet. To do so, go to Tools|Protection& and choose "UnprotectSSheet& " When you are through making your changes, protect the sheet again by goingSto Tools|Protection& and choosing "Protect Sheet& " After doing so, you can apply aEpassword or just click Enter to reprotect the sheet with no password.VThe "circular reference" error message that may appear on startup is a consequence of Zthe iterative calculations needed to perform the analyses. To disable the error message, Zclick on the Tools|Options menu, go to the Calculation tab, and click the "Iteration" box.$Click on "Base Year" to get started.SProfessor William Sahlman developed this software as the basis for class discussion[rather than to illustrate either the effective or ineffective handling of an administrativeXsituation. Jon DeFriese, MBA `00 and Chad Ellis, MBA `98 modified it as part of the HBSToolkit._ 1999 by the President and Fellows of Harvard College and its licensors. All rights reserved.#Developed by Village Software, Inc."Enter Data in Thousands of Dollars Base Year RevenueAnnual Revenue Growth RateTotal Cost of Goods Sold Gross MarginSales ExpensesMarketing ExpensesGeneral and Admin. ExpensesOther Expenses 1Other Expenses 2Other Expenses 3Other Expenses 4Total Operating ExpensesDepreciation AssumptionYear - Straight LineDepreciation ExpenseOperating ProfitOther Income (Expense)Interest IncomeInterest ExpensePre-Tax IncomeIncome Tax Rate Income Tax Net IncomePreferred DividendsCommon DividendsAs ofAssetsOperating CashMarketable SecuritiesAccounts Receivable InventoryOther Current AssetsTotal Current AssetsGross Plant & EquipmentAccumulated DepreciationNet Plant & EquipmentOther Long-Term AssetsTotal Long-Term Assets Total Assets LiabilitiesAccounts PayableShort-Term DebtCurrent Maturities Taxes PayableOther Current LiabilitiesTotal Current LiabilitiesLong-Term DebtTerm of Long-Term DebtYearsOther Long-Term LiabilitiesTotal Long-Term LiabilitiesPreferred StockCommon SurplusRetained EarningsShareholders EquityTotal Liabilities and Cash Flow AnalysisCapital ExpendituresInterest Income Rate"Interest Expense Rate (Short-Term)!Interest Expense Rate (Long-Term)Year 1Year 2Year 3Year 4Year 5$Cost of Goods Sold as a % of Revenue(Other Income (Expense) as a % of RevenuePreferred Dividend RateCommon Dividend Payout Ratio Operating Cash as a % of Revenue%Accounts Receivable as <Qa % of RevenueDays Receivable&Inventory as a % of Cost of Goods SoldInventory Days&Other Current Assets as a % of Revenue(Other Long-Term Assets as a % of RevenueAccounts Payable as a % of COGS Days Payable$Current Maturities of Long-Term DebtTaxes Payable as a % of Taxes+Other Current Liabilities as a % of Revenue-Other Long-Term Liabilities as a % of RevenueDepreciation Tables: Assumes: Year Depreciation for the Year"Data Shown in Thousands of Dollars Revenue Cost of Goods SoldCOGSSales & MarketingTotal Other Expenses Depreciation, Interest and TaxesSurplus Liabilities'Total Liabilities & Shareholders EquityIn-Balance TestRevenues Earnings Before Interest & TaxesLess Tax Exposure&Earnings Before Interest & After TaxesPlus DepreciationOperating Cash FlowOperating Working Capital5Less Increase (Decrease) in Operating Working Capital7Plus Increase (Decrease) in Other Long-Term Liabilities2Less Increase (Decrease) in Other Long-Term AssetsLess Capital ExpendituresFree Cash Flow(Less After-Tax Interest Expense (Income)Less Amortization of DebtLess Total Dividends$External Financing Surplus (Deficit)0Harvard ManageMentor - PREPARING A BUSINESS PLAN=Note About Using Internet Explorer or AOL to access this tool_If you are accessing this tool through AOL or Internet Explorer, it is important that you first]download the tool to your local machine before running it. Otherwise, the tool may run inside7the browser, resulting in unpredictable Excel behavior.Pro Forma Financial PackageVS "TT%VX[nl^" c` bdcJgjvmmnB.ooaappq`yr/s!tuuIv)wCky Fɀ $|s5ݢ  dMbP?_*+%= &?'?(?)?MHP LaserJet 5P@g ,,@MSUDHP LaserJet 5P<d ">,,??U} @} `} `}  } } } }  } } } } } @@ @@w@O@@x@     ; ;;;;;;;;;;;;;;;;;00.......00 13 13 EFFFFFFFFFG @<;;;;;;;<8 VA*BB****A8 <56*::))))67 1&!!!!!!!"3  1'+++++++#3  1'+++++++#3 1' w hhhhhh#3 1' p qq p jhh#3 1' p qq p jhh#3 1' p qq p hhh#3 1' p qq p hhh#3 1' p qq p  hhh#3 1' p qq p  hhh#3 1' p qq p hhh#3 1' p qq p hhh#3 1' p qq p hhh#3 1' p qq p hhh#3 1' pqqqhhh#3 1'ihhhhhh#3 1'hhhhhhh#3 1' whhhhhh#3 1' pqqqqqh#3 1' pqqqqqh#3 1' pqqqqqh#3 1' pqqqqqh#3 1' pqqqqqh#3 BX , ,@ 6LLLLLLLLLL6 66666 ;!;";#;$;%;&;';(;);*;+;,;-;.;/;0;1;2;3;4;5;6;7;8;9;:;;;<, =>;?; 1' p qqqqqh#3 !1' !p!qqqqqh#3 "1' "p"qqqqqh#3 #1' #p#qqqqqh#3 $1'pqqqqqh#3 %1' %p%qqqqqh#3 &1' &p &qqqqqh#3 '1' 'p!'qqqqqh#3 (1' (p"(qqqqqh#3 )1' )p#)qqqqqh#3 *1' *p$*qqqqqh#3 +1' +p%+qqqqqh#3 ,1' ,p&,qqqqqh#3 -1'pqqqqqh#3 .1' .r'.ppppsk#3 /1' /r(/ppppsk#3 01' 0r)0pppppi#3 11' 1r*1pppptl#3 21' 2r+2uppptl#3 31'rupppvn#3 41' 4r,4uptppi#3 51' 5r-5uptppi#3 61' 6r.6uptppi#3 71' 7r/7uptptl#3 81'ruptptl#3 91' 9r09uppvtl#3 :1' :r1:upppum#3 ;1' ;r2;uppppi#3 <1'ihhhhhh#3 =1&"3 >1' >w3>hhhhhh#3 ?1' ?u4?qqqqhh#3 Dl6666 66666666 66666 6666 666 6@;A;B;C;D;E;F;G;H;I;J;K;L;M;N;O;P;Q;R;S;T;U;V;W;X;Y;Z;[;\;];^;_; @1' @u5@qqqqhh#3 A1' Au6Aqqqxhh#3 B1'wqqqqhh#3 C1' Cu7Cqqqqhh#3 D1'wqqqqhh#3 E1' EpEzzqqff#3 F1' Fr8Fz{{{jj#3 G1' Gr9G{{{{jj#3 H1' Hr:H{|z}ff#3 I1' Ir;I{|z}ff#3 J1' Jr<J{|z}ff#3 K1' Kr=K{|z}ff#3 L1' Lp>L{|z}ff#3 M1' Mp?M{|z}ff#3 N1'{{qqzff#3 O1' OpO{qqzff#3 P1' Pr@Pzqqzff#3 Q1' QrAQ{|z}ff#3 R1' RrBR{|z}ff#3 S1'p{|z}ff#3 T1' TpCTzzqqff#3 U1' UyDU{pqpff#3 V1' VyEV{{qqff#3 W1'{{{qqff#3 X1' XpFXzzqqff#3 Y1' YyGY{{{{jj#3 Z1' ZyHZ{{{{jj#3 [1' [yI[{{{{jj#3 \1'{{{{{jj#3 ]1' ]rJ]{{{{jj#3 ^1'r|z}zff#3 _1' _~K_|z}zff#3 Dl66 6 666666666 6666 666 6666 6 `;a;b;c;d;e;f;g;h;i;j;k;l;m;n;o;p;q;r;s;t;u;v;w;xy;z;{;|;};~,  `1' `~L`z}zfff#3 a1'{z}zfff#3 b1' brMb{{{{jj#3 c1' crNc|z}zff#3 d1' drOd|z}zff#3 e1' erPe|z}zff#3 f1' frQf|z}zff#3 g1'r|zzzff#3 h1' hrRh|z}zff#3 i1' irSi|zzzff#3 j1' jrTj|zzzff#3 k1' krUk|zzzff#3 l1' lrVl|zzzff#3 m1'r|zzzff#3 n1' nrWn|zzzff#3 o1' orXo|zzzff#3 p1' prYp|zzzff#3 q1'r|zzzff#3 r1' rrZr|zzzff#3 s1'r|zzzff#3 t1' tt#3 u1 uu#3 v1 vv#3 w1 ww#3 x1'#3 y1' y[yzzzoo#3 z1' z\zzzzoo#3 {1' {]{zzzoo#3 |1' |^|zzzoo#3 }1'ee#3 ~1($$$$$$$%3 1+++++++++3 Dzl6 66666 66666 666 6 6666 6666 , <@@@ ,1+++++++++3 abbbbbbbbbc 1 [_]]]]]]` _` 31+++++++++3 13 /////////// `d H `( 333 `~ ` <X XPP?  ]@ 'B]4@X$'  iMZf <Example of comment box <%  lAVillage Software><P????m8@X`I 0D 0 0L 40 0x 0000? 0:000qq     }CHART 28@X`I 0D 0 0L 40 0x 0000? 0:000@  7 Sheet1 Fɀ (5  dMbP?_*+%9 &?'?(?)?MHP LaserJet 5P@g ,,@MSUDOHP LaserJet 5P<d "L,,??U} @} `} }  } @ }  }  } } } ` } } `} Isample1Microsoft CorporationVillage Softwareffhhmm nn oo pqqq rrr qqq rr srsp JanuaryWidget350575071501200502001000 ^sample2Microsoft CorporationVillage Softwarewwuv/# current1 Jim Davidson#Created by Jim Davidson on 12/29/98ffhhm n o mnopqrqqrqrsq r q r p sri# current2 Jim Davidson#Created by Jim Davidson on 12/29/98wwuv%#@ #@#*@#@#w@#O@#X@#i@ #x@ #@  #x@ #@ #@#@#@@@@@@@@@@@@@@@@@ @00........00 13 13 13 UUUUUUUUUUU^ 13 VFC;DDDDDDD<7"WXYYYYYYYYXZ  WXYYYYYYYYXZ  13  1&JJJJKKKKL3  1'MN3  1'MN3 1' afffN3 1'fffN3 1'f b ~  <@ N3 1'fN3 1' N3 1'fN3 1'f c ~  @@ N3 1'f d ~  4@ N3 1'fN3 1'f e ~  @ N3 1'fN3 1'f f ! 0@# D D  N3 1'fN3 1'f g ~  r@ N3 1'f h ~  Y@ N3 1'f i ~  Y@ N3 1'f j ~   N3 1'f k ~   N3 1'f l ~  N3 D) l""""."X""""""8"N"8"NN"N"e"NNNNN!@"@#@$@%@&@'@(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@ 9@:@;@<@=@>@?@@@ !1'f !m !~ ! ! N3 "1'fN3 #1'f #n ### @@& %! # N3 $1'fN3 %1'f %o %~ % @ % p % N3 &1'f &q &%& i@( DH D% & N3 '1'fN3 (1'f (r ('( y@+ D D# D& ( N3 )1'fN3 *1'f *s *~ * * N3 +1'f +t +!+ @, D@ Do + N3 ,1'f ,u ,<, 43333/@. &DV Dp D] Dq DW Dq , N3 -1'fN3 .1'f .v .-. fffff2x@1 D( D* D+ D, . N3 /1'fN3 01'f 0w 0~ 0 4@0 N3 11'f 1x 1!1 Q[S@3 D. D0 1 N3 21'fN3 31'f 3y 3!3 Q[s@E D. D1 3 N3 41'ffN3 51'f 5z 5~ 5 5 fN3 61'f 6{ 6~ 6 6 fN3 71'ffN3 81'fffffN3 91& 9 9L3 :1'ffN3 ;1'f ;| ;~ ; @; fN3 <1'ffN3 =1'f =}=fN3 >1'ffN3 ?1'f ?~ ?~ ? I@? fN3 @1'f @ @~ @ N@@ fN3 D lN"g"Zi"k"Ne"q"Ne"e"NN""8"N"8"NA@B@C@D@E@F@G@H@I@J@K@L@M@N@O@P@Q@R@S@T@U@V@W@X@Y@Z@[@\@]@^@_@`@ A1'f A A~ A T@A fN3 B1'f B B~ B D@B fN3 C1'f C C~ C Y@C fN3 D1'ffN3 E1'f E E#E t@N %=C E fN3 F1'ffN3 G1'ffN3 H1'f H H~ H @@H fN3 I1'f I I~ I Y@I fN3 J1'ffN3 K1'f K K!K @W DH DI K fN3 L1'f L L~ L Y@L fN3 M1'ffN3 N1'f N N!N @@P DK DL N fN3 O1'ffN3 P1'f P P'P Ȕ@[ DE DK DL P fN3 Q1'ffN3 R1'ffN3 S1'f SSfN3 T1'ffN3 U1'f U U~ U I@U fN3 V1'f V V~ V T@V fN3 W1'f W WBW .@ ,D] D^ A~D] D^ BW fN3 X1'f X X~ X @X fN3 Y1'f Y Y~ Y D@Y fN3 Z1'ffN3 [1'f [ [#[ g@a %UY 6[ fN3 \1'ffN3 ]1'f ] ]~ ] ^@] fN3 ^1'f ^ ^~ ^ @ ^ ^ fN3 _1'f _ _~ _ @P@_ fN3 `1'ffN3 D lNNN"g""NN"eN"e"k""8"NNNN"g"NZNa@b@c@d@e@f@g@h@i@j@k@ l@m@n@o@p@q@r@s@t@u@v@w@ x@y@ z<@{|@ }@~@@%%@ a1'f a a!a g@g D] D_ a fN3 b1'ffN3 c1'f c c~ c c fN3 d1'f d d~ d p|@d fN3 e1'f e e~ e e fN3 f1'ffN3 g1'f g g#g p|@i %ce Ҵg fN3 h1'ffN3 i1'f i i'i @H'D[ Da Dg i fN3 j1'f jjfN3 k1'ffN3 l1& llL3 m1'ffN3 n1'f n n~ n @@n fN3 o1'f o o~ o @o fN3 p1'f p p~ p  @p fN3 q1'f q q~ q @q fN3 r1'ffffffffN3 s1'PPPN3 t1'PPPPPN3 u1'TTPPPPPN3 v1'OOOOOOOON3 w1(QQQQQQQQR3 x1+PPPPPPPPS3 y1+PPPPPPPPS3 z2,--------,4 {1 {[_{\\\\\\\\ { _`{ 3|13 }//////////// Dle"NNN"g"k8"8"NNNN"""""""""J""%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@Dl%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@%%@:051 /GK  /3W /"i  3 ( Qb l  s *|?  ],|,*x'9T $ < Quick Help<'- xx   6XPP?  * OS]4 @* /JQZfX =<>Enter the calendar year which corresponds to your base year. < =xx ! 6DXPP?  * OS]4!@D+ 0JQZfX ,<-Enter total revenue for the base year here. < ,xx " 6XPP?  * OS]4"@, 1JQZfX L<MYour revenues, and most other line items, will grow at this rate each year. <( Lxx # 6 XPP?  * OS]4#@ - 2JQZfX 7<8Enter total cost of goods sold for the base year here. < 7xx $ 6pXPP? *r S]4$@p$/ 3JQZfX U<VEnter/change expense headings. These will appear in your income statement as well. <Uxx % 6ԣXPP?  * O S]4%@ԣT0 4JQZfX 5<6Enter base year value for the various expense types. <5xx & 68XPP?  &* O*S]4&@81 5JQZfX T<UEnter the number of years over which you wish to depreciate your plant & equipment. <Txx ' 6XPP?  '* O+S]4'@2 6JQZfX <<=Assumes plant & equipment have been in place for full year. <<xx ( 6XPP?  ,* O0S]4(@3 7JQZfX S<TMarketable securities x interest income rate. Assumes investment for entire year. <Sxx ) 6dXPP?  -* O1S]4)@d5 8JQZfX 4<5Debt assumed to have been in place for entire year. <4xx * 6ȥXPP?  6* O:S]4*@ȥD6 9JQZfX I<JEnter preferred dividend amount here. If not relevant to you leave at 0. <Ixx + 6,XPP?  7* O;S]4+@,t7 :JQZfX F<GEnter common dividend amount here. If not relevant to you leave at 0. <Fxx , 6XPP? :*>S]4,@8 ;JQZfX =<>Assumes no assets or liabilities existed prior to base year. < =xx - 6XPP?  <* O@S]4-@9 JQZfX M<NEquals the portion of long term debt due for repayment during the base year. <Mxx 0 6 XPP?  o* OsS]40@ d= ?JQZfX B<CCapital expenditure growth rates default to revenue growth rates. <Bxx 1 6XPP?  p* OtS]41@> @JQZfX J<KEnter the rate of interest you are earning on your marketable securities. <Jxx 2 6XPP?  q* OuS]42@? AJQZfX )<*Enter interest rate for short term debt. <)xx 3 6LXPP?  r* OvS]43@L@ BJQZfX (<)Enter interest rate for long term debt. <(- !A satisfied Microsoft Office userX- !!A satisfied Microsoft Office userX- "!A satisfied Microsoft Office userX- #!A satisfied Microsoft Office userX-$!A satisfied Microsoft Office userX- %!A satisfied Microsoft Office userX-% &!A satisfied Microsoft Office userX-& '!A satisfied Microsoft Office userX-+ (!A satisfied Microsoft Office userX-, )!A satisfied Microsoft Office userX-5 *!A satisfied Microsoft Office userX-6 +!A satisfied Microsoft Office userX-9,!A satisfied Microsoft Office userX-; -!A satisfied Microsoft Office userX-V .!A satisfied Microsoft Office userX-W /!A satisfied Microsoft Office userX-n 0!A satisfied Microsoft Office userX-o 1!A satisfied Microsoft Office userX-p 2!A satisfied Microsoft Office userX-q 3!A satisfied Microsoft Office userX><P????mpp%xx%%%%pI 0Dpp 0 0L p4 00x 000? 0:0-00qq     @  7 Sheet2 Fɀ Vc4B  dMbP?_*+%&?'?(?)?MHP LaserJet 5P@g ,,@MSUDOHP LaserJet 5P<d "<,,??U} @} `} } @ }  }  }  } } } } @ } } @} } } `V@@ @*@@h@*@O@ @ i@    ;;;;;;;;;;;;;;;;&00............00&13&13&13 U$HHHHHHHHHHHHHHI&13&13 V$ >============>?& 13& 1&!!!!!!!!!!!!"3& 1'++++++++++++#3& 1'++++++++++++#31'       +#31'7 <@ !Cw  #w B; @@ %Cw  Cw B; D@ %Cw  Cw B; H@ %Cw  Cw B; L@%Cw  Cw B;P@ %Cw  Cw B+#3&1'+#3 1' d  ? Z  ? D  ? D  ?D ? D +#3 1' c  @@ Z ( @ D Z  ( @ D Z  ( @ D Z  ( 333333@D Z  (p= ףp@ D Z +#3&1'+#3 1'  J ? 4Z Z A~Z Z B ? D  ? D  ? D  ?D ?D +#3&1'+#3&1'+#3 1' &ZSales Expenses J 333333? 4Z Z A~Z Z B 333333?   #L 333333?   333333?   333333? 333333?@' +#3 1',&ZMarketing Expenses J ? 4Z Z A~Z Z B ?   ?   ?   ? ?  +#3 1'T&ZGeneral and Admin. Expenses J ? 4Z Z A~Z Z B ?   ?   ?   ? ?  +#3 1'&ZOther Expenses 1 J  4Z Z A~Z Z B             +#3 1'&ZOther Expenses 2 J  4Z Z A~Z Z B             +#3 1'&Z Other Expenses 3 J  4Z Z A~Z Z B             +#3 1'& Z!Other Expenses 4 J  4Z! Z A~Z! Z B             +#3&1'+#3 1'  J  4Z* Z A~Z* Z B   % #L          +#3B6X****6**6****|*;*'**bS\QQQQ* ;!;";#;$;%;&;';(;);*;+;,;-;.;/;0;1;2;3;4;5;6;7;8;9;:;<;=>@? 1'   ? Zo  ?   ?   ?   ?   ?!   +#3 !1' ! !! {Gz?! Zp ! {Gz?!  ! {Gz?!  ! {Gz?!  ! {Gz?! !{Gz?"  !+#3 "1' " "" Q?" Zq " Q?"  " Q?"  " Q?"  " Q?" "Q?#  "+#3 #1' #w ## ?# Z0 # ?#  # ?#  # ?#  # ?# #?$  #+#3 $1' $ $J$ $ 4Z5 Zc A~Z5 Zc B$ $  $ $  $ $  $ $ $%  $+#3 %1' % %J% % 4Z6 Zd A~Z6 Zd B% %  % %  % %  % % %*  %+#3&&1'+#3 '1' ' 'J' ?' 4Z? Z A~Z? Z B' ?' ' '(  L' ?' ' ' ?' ' ' ?'' '? ' '+#3 (1' ( (J( {Gz?( 4ZA Z A~ZA Z B( {Gz?( ' ( {Gz?( ' ( {Gz?( ' ( {Gz?(' ({Gz?)' (+#3 )1' ) )) 333333-@' ) ))  mL) 333333-@) ) ) 333333-@) ) ) 333333-@) ) ) 333333-@) ) )333333-@) ) )+#3 *1' * *J* ll?* 4ZB Z A~ZB Z B* ll?* D* * ll?* D* * ll?* D* * ll?*D* *ll?+ D* *+#3 +1' + ++ 880@+ + ++  mL+ 880@+ + + 880@+ + + 880@+ + + 880@++ +880@- + ++#3 ,1' , ,J, ?, 4ZC Z A~ZC Z B, ?, D, , ?, D, , ?, D, , ?,D, ,?( D, ,+#3 -1' - -- @@0 Zn '- w@?DG DG DE '- @|@@DG DG DE '- @ADG DG DE '- GzԄ@BDG DG DE '-o= ף@CDGDG DE-+#3 .1' . .J. ?. 4ZL Z A~ZL Z B. ?. D. . ?. D. . ?. D. . ?.D. .?, D. .+#3&/1'+#3 01' 0 0J0 qq?0 4ZU Z A~ZU Z B0 qq?0 D0 0 qq?0 D0 0 qq?0 D0 0 qq?0D0 0qq?1 D0 0+#3 11' 1 11 qqG4@1 1 11  mL1 qqG4@1 1 1 qqG4@1 1 1 qqG4@1 1 1 qqG4@11 1qqG4@2 1 1+#3 21' 2 22 T@2 ZV 2 T@2 D2 2 T@2 D2 2 T@2 D2 2 T@2D2 2T@3 D2 2+#3 31' 3 33 .@5 ZW C3 .@3 -Z^  Z] Z^  BC3 .@3 -Z^  Z] Z^  BC3 .@3 -Z^  Z] Z^  BC3 .@3-Z^  Z] Z^  BC3.@4 -Z^  Z] Z^  B3+#3 41' 4 44 ^@4 Z] !4 @Z@4 D4 D3 !4 V@4 D4 D3 !4 R@4 D4 D3 !4 N@4 D4 D3 !4F@8 D4 D34+#3 51' 5 5J5 {?5 4ZX Z1 A~ZX Z1 B5 {?5 5 59 L5 {?5 5 5 {?5 5 5 {?55 5{?G 5 5+#3 61' 6 6J6 {Gz?6 4ZY Z A~ZY Z B6 {Gz?6 5 6 {Gz?6 5 6 {Gz?6 5 6 {Gz?65 6{Gz?. 5 6+#3 71' 7 7J7 p= ף?7 4Z_ Z A~Z_ Z B7 p= ף?7 5 7 p= ף?7 5 7 p= ף?7 5 7 p= ף?75 7p= ף?6 5 7+#3 81' 8 88 8 Zc 8 8 5 8 8 5 8 8 5 8 85 89 5 8+#3 91' 9 99 p|@9 Zd 9 p|@9 5 9 p|@9 5 9 p|@9 5 9 p|@95 9p|@@5 9+#3&:1'+#3&;1'+#3 <1' < < << @ CS < p< +#3&=1'+#3 >1' > >> > *> ?@@@@@ >+#3 ?1'~ ???w@? D- ? =? S@E 'CS D?CS B=? S@E 'CS D?CS B=? S@E 'CS D?CS B=?S@E'CS D?CS B=?S@E'CS D?CS B ?+#3D l''*:'''6'*':''***@ABCDE;F;G;HIJKLMN, OP, Q<@RS@T@ U, @1';@@A%Cw  D? B@@|@@D- @ =@ V@? 'CS D@CS B=@ V@A 'CS D@CS B=@V@@ 'CS D@CS B=@V@A'CS D@CS B @+#3 A1';A@B%Cw  D@ BA @AD- A =A HzG[@? 'CS DACS B=AHzG[@@ 'CS DACS B=AHzG[@B'CS DACS B A+#3 B1';B@C%Cw  DA BBGzԄ@BD- B =BCl`@?'CS DBCS B=BCl`@G'CS DBCS B B+#3 C1';C@E %Cw  DB BCo= ף@CD-C=CYd;Od@?'CS DCCS B C+#3&D1'+#3 E1' EE 7E i@G!C3D< D> D< LE m@G 6C3D< D> D< B%?C LE fffffq@G 6C3D< D> D< B%?C oLE Q8v@G 6C3D< D> D< B%?C LEZd;O |@@6C3D< D>D< B%?CoLECl@7 6C3D< D>D< B%?C E+#3&F1'+#3 G1g G G+G @G ZK CJZ +G @- ZK CJZ  +G @@- ZK CJZ  +G L@- ZK CJZ  +G )\(@- ZK CJZ  +G"~@-ZK CJZ  +G3 ZK CJZ  G+#3&H1'++++++++++++#3&I1'++++++++++++#3&J1'++++++++++++#3&K1'++++++++++++#3&L1'++++++++++++#3&M1' #3&N1($$$$$$$$$$$$%3&O1++++++++++++++3&P1++++++++++++++3(QabbbbbbbbbbbbbbcdR1 R[_R]]]]]]]]]]]` R_`R3&S1++++++++++++++3&T13&U////////////////0 U* **********,R**x /3 /5 /B KE E CE E G WG 0( 333ff3 l  s *? ],D<'d9n $ < Quick Help<'- Rxx  6dXPP? y`]4@dE &JQZfX [<\Taken from base year growth rate by default. You can change the growth rates for any year. < [ xx  6XPP? `]4@F 'JQZfX E<FActual revenue for each year, calculated from revenue growth rates. <E xx  6,XPP? `]4@,@G (JQZfX d<eBased on what's entered in the 'Base Year' tab. To change, simply type into the appropriate cells. <dxx  6XPP? ,+0]4@pH )JQZfX B<CKeith MacKay: Calculate from diff in Net PPE & year's depreciation<TB ,,xx  6XPP? -+1]4@I *JQZfX k<lKeith MacKay: Add an override line for CapEx - if blank, use other. Make sure Net PP&E takes into account.< k xx  6XXPP? F+JC]4@XJ +JQZfX ?<@Keith MacKay: = Revenues * base yr Net PP&E / Base Year Revenue< ?( -!A satisfied Microsoft Office user -!A satisfied Microsoft Office user -!A satisfied Microsoft Office user --!A satisfied Microsoft Office user -.!A satisfied Microsoft Office user -G!A satisfied Microsoft Office user ><P  ????m#X$`$$$h%p%%%x&&EI 0DE E 0 0L E4D 0x 0D00? 0:0-00qq     }CHART 2#X$`$$$h%p%%%x&&EI 0DE E 0 0L E4D 0x 0D00? 0:0-00@  7 Sheet3 Fɀ Q=Rg~  dMbP?_*+%&?'?(?)?MHP LaserJet 5P@g ,,@MSUDOHP LaserJet 5P<d "P,,??U} @} `} } @ }  }  } } } } } @ } } `} @} } `Q@@ @*@@h@*@O@ @ i@    ;;;;;;;;;;;;;;;;$00...........00$13$13$13 U"HHHHHHHHHHHHHI$13$13 V" >===========>?$ 13$ 1&!!!!!!!!!!!"3$ 1'+++++++++++#3$ 1'+++++++++++#3 1' ++#31'       ++#31'7<@ !Cw  #w B; @@ %Cw  D B; D@ %Cw  D  B; H@ %Cw  D  B; L@ %Cw  D  B; P@%Cw  D  B++#3$1'++#3 1'  @@ Z   @ Z   @ Z   @ Z   333333@ Z   p= ףp@ Z ++#3$1'++#3 1'   @Z # @ D Z  # @@ D Z  # L@ D Z  # )\(@ D Z  # "~@ D Z ++#3$1'++#3 1' f 0@  LL @  @  33333@  Rѡ@  Mb@ ++#3$1'++#3 1'&ZSales Expenses r@Z # v@ D Z  # {@ D Z  # 333333@ D Z  # p= ףp@ D Z  # S@ D Z ++#3 1'<&ZMarketing Expenses Y@Z # ^@ D Z  # b@ D Z  # e@ D Z  # Qi@ D Z  # vo@ D Z ++#3 1'd&ZGeneral and Admin. Expenses Y@Z # ^@ D Z  # b@ D Z  # e@ D Z  # Qi@ D Z  # vo@ D Z ++#3 1'&ZOther Expenses 1 Z #  D Z  #  D Z  #  D Z  #  D Z  #  D Z ++#3 1'&ZOther Expenses 2 Z #  D Z  #  D Z  #  D Z  #  D Z  #  D Z ++#3 1'&Z Other Expenses 3 Z #  D Z  #  D Z  #  D Z  #  D Z  #  D Z ++#3 1'&*Z!Other Expenses 4  Z! # D Z  # D Z  # D Z  # D Z  # D Z ++#3$1'++#3BX((((4((4((((>z(( ((HLUJJJJ ;!;";#;$;%;&;';(;);*;+;,;-;.;/;0;1;2345, 67, 8<@9:@;@ <, 1' n  @@$    -̴ @"   @"   @"   333333@"   p= ףp@"   ++#3$!1'++#3 "1' "q ""i@Z& " m@$ ZE " fffffq@$ ZE " Q8v@$ ZE " Zd;O |@$ ZE" Cl@$ ZE"++#3$#1'++#3 $1' $r $$y@&$$$ LLL$ @~@& $$ @& $$ ףp=J@& $$ vڈ@& $$ ɡE@& $$++#3$%1'++#3 &1' &s &&(Z* %&  Z  @Z  %&  Z  @Z  %&  Z  @Z  %&  Z  @Z  %& 0Z @Z  &++#3 '1' 't ''@0 Z+ f' ?!' PZ @Z Z A~$Z @Z Z Bf' !' PZ @Z Z A~$Z @Z Z Bf' g=e&?!' PZ @Z Z A~$Z @Z Z Bf' 狜1@!' PZ @Z Z A~$Z @Z Z Bf' >V4@!( PZ @Z ZA~$Z @Z ZB'++#3 (1' (u ((43333/@'Z, ( \-;@!( Z! Z% Z% Z! Z1 Z1 Z" Z, Z, Z" Z& Z& A~zZ! Z% Z% Z! Z1 Z1 Z" Z, Z, Z" Z& Z& B( 3S.}@@!( Z! Z% Z% Z! Z1 Z1 Z" Z, Z, Z" Z& Z& A~zZ! Z% Z% Z! Z1 Z1 Z" Z, Z, Z" Z& Z& B( 97}3@!( Z! Z% Z% Z! Z1 Z1 Z" Z, Z, Z" Z& Z& A~zZ! Z% Z% Z! Z1 Z1 Z" Z, Z, Z" Z& Z& B( Y(@!( Z! Z% Z% Z! Z1 Z1 Z" Z, Z, Z" Z& Z& A~zZ! Z% Z% Z! Z1 Z1 Z" Z, Z, Z" Z& Z& B( @&@!* Z!Z%Z% Z!Z1Z1 Z"Z,Z, Z"Z&Z& A~zZ!Z%Z% Z!Z1Z1 Z"Z,Z, Z"Z&Z& B(++#3$)1'++#3 *1' *v **fffff2x@,*!** LLLL* 3/mӛ|@)* ** J@)* ** -w:@)* ** zI@)* ** H<Щ@), **++#3$+1'++#3 ,1' ,x ,#,Q[S@. D*Z0 #, \{V@!, Z # @D* #, |r);[@!, Z # @D* #, $,!/`@!, Z # @D* #, .Bc@!, Z # @D* #, T9g@!. Z #@D* ,++#3$-1'++#3 .1' .y ..Q[s@G...  LL. \{v@). .. |r);{@). .. $,!/@). .. ~.Bƃ@). .. T9@)1 ..++#3$/1'++#3 01' 0z 001Z5 %0 0 Z$ @Z3 %0 0 Z$ @Z3 %0 0 Z$ @Z3 %0 0 Z$ @Z3 %0 Z$@Z30++#3 11' 1{ 11"Z6 %1 !1 Z % @Z . %1 !1 Z % @Z . %1 !1 Z % @Z . %1 !1 Z % @Z . %1 !J Z %@Z . 1++#3$21'ffff++#3$31'++#3$41' #3$51($$$$$$$$$$$%3$61+++++++++++++3$71+++++++++++++3&8abbbbbbbbbbbbbcd91 9[_9]]]]]]]]]]` 9_`93$:1+++++++++++++3$;13$<///////////////>n0(((*o((&((**((((((*P((ABCDEFGHIJKLMNOPA+B+C+D+E+F+G GG G GGG LG G GG @G GG LG GG )\(G GG "~HGG+H HHyIHHH  LLH ~H HH H HH H HH QH HH vI HH+I IIY@JIII  -I ^@I II b@I II e@I II Qi@I II vo@' II+J JJGz$rH J*JJ  LLLLLJ suv)J JJ Vz)J JJ tnt)J JJ dLsk0)J JJ n) D'JJ+K+L+M+N+O P $w, G  G G G G !G  1 Z ,  Z  & " A~& zZ3& %&' (1 ZI @7 ( @  r ( 0H?   ],(HN8%'9t $ < Quick Help<&-  (><K  ????mXRRRRR@SHSSSSShLI 0DhL hL 0 0L hL4K 0Dx 0K00? ]}0q 00qq     }CHART 2XRRRRR@SHSSSSShLI 0DhL hL 0 0L hL4K 0Dx 0K00? ]}0q 00@  7 Sheet4 Fɀ Z_D  dMbP?_*+%&?'?(?)?MHP LaserJet 5P@g ,,@MSUDOHP LaserJet 5P<d "H,,??U} @} `} } @ }  }  } } } } } @ } }  } `} } `Z@@ @*@@h@*@O@ @ i@    ;;;;;;;;;;;;;;;;;;;$00...........00$13$13$13 U"HHHHHHHHHHHHHI$13$13 V" >===========>?$ 13$ 1&!!!!!!!!!!!"3$ 1'+++++++++++#3 1'  +#31'        +#31'; <@ %Cw@  #w B? @@ )Cw@  D  B? D@ )Cw@  D  B? H@ )Cw@  D  B? L@)Cw@  D  B?P@ )Cw@  D  B +#3 1' }+#3$1'+#3 1' ~  I@ Z? % N@ Z' Z % R@ Z' Z % U@ Z' Z % QY@Z' Z %v_@ Z' Z  +#3 1'   N@ Z@ < ! &ZD  ZD B< ! &ZD  ZD B< `FwC@! &ZD  ZD B< T *q@!&ZD  ZD B<P^@! &ZD  ZD B +#3 1'   T@ ZA % X@ Z( Z % \@ Z( Z % HzGa@ Z( Z % #~jd@ Z( Z %+eh@ Z( Z  +#3 1'   D@ ZB % H@Z* Z % L@ Z* Z % HzGQ@ Z* Z % #~jT@ Z* Z %+eX@ Z* Z  +#3 1'   Y@ ZC % ^@Z, Z % b@ Z, Z % e@ Z, Z % Qi@ Z, Z %vo@ Z,Z  +#3$1'+#3 1'  3 t@/ D D D D D 3 @t@! D D D D D = Lx@! 'Z Z Z Z Z 3 x[@! D D D D D 3 Y{'@!D D D D D 3Υ@! DDDDD +#3$1'+#3 1'   @ ZG  @ ZG  @@ ZG  L@ ZG  )\(@ ZG "~@ZG +#3 1'   Y@5 ZL % ^@- Z. Z % b@ Z. Z % e@ Z. Z % Qi@ Z. Z %vo@ Z.Z  +#3$1'+#3 1'   @@    LL @   @   @   333333@ p= ףp@$  +#3$1'+#3 1'   Ȕ@;    LL З@)   33333@)   okr@)   R@) Wl@)'  +#3BX((((4((4(((>z>(****((*(( ;!;";#;$;%;&;';(;);*;+;,;-;.;/;0;1;2;3;4;5;6;7;8;9;:;;;<;=>?, $ 1'+#3$!1'+#3 "1' ""+#3$#1'+#3 $1' $ $$ I@%ZU %$ N@$ Z0 Z %$ R@$ Z0 Z %$ U@$ Z0 Z %$ QY@$Z0 Z %$v_@ Z0Z  $+#3 %1' % %% T@$ ZV % T@ Z2 % T@% Z2 % T@% Z2 % T@% Z2 %T@% Z2 %+#3 &1' & && .@* ZW & .@( Z3 & .@& Z3 & .@& Z3 & .@& Z3 &.@& Z3 &+#3 '1' ' '' @% ZX %' SdƇ@!' Z5 @Z, %' y*"@!' Z5 @Z, %' u!@!' Z5 @Z, %' VLn$@!'Z5 @Z, %'%'@!* Z5@Z,  '+#3 (1' ( (( D@' ZY %( H@Z6 @Z %( L@( Z6 @Z %( HzGQ@( Z6 @Z %( #~jT@( Z6 @Z %(+eX@( Z6@Z  (+#3$)1'+#3 *1' * ** g@9 * '** LLLLL* C'3>,j@)* * * "Gl@)* * * 1ͽE1p@)* * * l=r@)** *FX?#t@)1 * *+#3$+1'+#3 ,1' , ,, ^@&Z4 , @Z@, Z4 , V@, Z4 , R@, Z4 , N@, Z4 ,F@, Z4 ,+#3 -1' - -- @P@,Z_ %- S@/ Z7 Z %- gfffffW@/ Z7 Z %- Gz\@/ Z7 Z %- +`@/ Z7 Z %-37d@/Z7Z  -+#3$.1'+#3 /1' / // g@7 / //  LL/ f@- / / 43333f@- / / ףp=jg@- / / +Yh@-/ /3i@T / /+#3$01'+#3 11' 1 1~ 1 <1 YVZns@!1 &ZD@ ZD@B<1 8߬c@!1 &ZD@ ZD@B<1 !1 &ZD@ ZD@B<1 !1&ZD@ ZD@B<1!5 &ZD@ ZD@B 1+#3$21'+#3 31' 3 33 3Zc 3 - Z8 3 3 Z8 3 3 Z8 3 3 Z8 33 Z8 3+#3 41' 4 44 p|@3 Zd 4 p|@4 Z9 4 p|@4 Z9 4 p|@4 Z9 4 p|@4 Z9 4p|@4 Z9 4+#3 51' 5 55 4Ze 35 \{v@!5 D5 Z. Z0 Z1 35 ~@!5 D5 Z. Z0 Z1 35 VdД@!5 D5 Z. Z0 Z1 35 #o@!5D5 Z. Z0 Z1 35k% (@!7 D5 Z. Z0 Z1  5+#3$61'+#3 71' 7 77 p|@S 7 77 LLL7 =FŇ@)7 7 7 YB?@)7 7 7 Vd@)7 7 7 @)77 7k% @)9 7 7+#3$81'+#3 91' 9 99 @R 9 !99 LLLL9 З@)9 9 9 43333@)9 9 9 okr@)9 9 9 R@)99 9Vl@); 9 9+#3$:1'+#3 ;1' ; ;; @@ ; ;;  LL; ); ; ; ); ; ; ); ; ; );; ;)R ; ;+#3$<1'zzzffff+#3$=1'+#3$>1' #3$?1($$$$$$$$$$$%3D1l((>(***(!(*(((p((((((@A, B<@CD@E@ F,LMNOPQRSTUVWXY$@1+++++++++++++3$A1+++++++++++++3&BabbbbbbbbbbbbbcdC1 C[_C]]]]]]]]]]` C_`C3$D1+++++++++++++3$E13$F///////////////Ljjjjjjjj+Mjjjjjjjj+Njjjjjjjj+Ojjjjjjjj+Pjjjjjjjj+Q+R RR g(R RR LR C'3>,j)R R R "Gl)R R R 1ͽE1p)R R R l=r)RR RFX?#t)U R R+S SS ^S S ST  LS @ZS S S VS S S RS S S NSS SFT S S+T TT @PU S T ST S T gfffffWT S T Gz\T S T +`TS T37dS T+U UU p|V U UU LU =FŇ)U U U YB?)U U U Vd)U U U )UU Uk% )V U U+V VV & V VV LV YVZns)V V V 8߬c)V V V )V V V )VV V)dx'V V+W+X+Y+++++++++.~((*P(((` + + / Z  5 V <P$( yyyy l  s *?  ],Qx\'9o $ < Quick Help< - xx  6XPP? 0 r4]4@R yJQZfX r<sThis calculates the difference between total assets and total liabilities. If balanced, all cells should read 0. <rxx   6PXPP?  r#U]4 @PR zJQZfX M<NBalancing item. Base year amount of short-term debt plus any surplus assets. <> Mxx   6XPP?  r ]4 @T {JQZfX \<]Balancing item. Assumes that any surplus assets will be invested in marketable securities. <q \- !A satisfied Microsoft Office users-% !A satisfied Microsoft Office users-9!A satisfied Microsoft Office users><P  ????mtHuPuuuHvPvv\OI 0D\O \O 0 0L \O4N 0Kx 0N00? 0:0-00qq     }CHART 2tHuPuuuHvPvv\OI 0D\O \O 0 0L \O4N 0Kx 0N00? 0:0-00@  7 Sheet5 Fɀ Qon  dMbP?_*+%&?'?(?)?MHP LaserJet 5P@g ,,@MSUDOHP LaserJet 5P<d "P,,??U} @} `} } @ }  }  } } } }  } @ } }  } ` } } `Q@@ @*@@h@*@O@ @ i@    ;;;;;;;;;;;;;;;;;;(00.............00(13(13(13 U&HHHHHHHHHHHHHHHI(13(13 V& >=============>?( 13( 1&!!!!!!!!!!!!!"3( 1'+++++++++++++#3( 1'+++++++++++++#3 1' "f#31'        f#31' 7 <@ !Cw  #w B; @@ %Cw  D  B; D@%Cw  D  B;H@%Cw  D  B;L@%Cw  D B;P@ %Cw  D B f#3(1'f#3 1'   @@ Z @ Z  @ Z @ Z 333333@Z p= ףp@Z f#3(1'f#3 1'  % y@ Z$Z&% @~@ Z$ Z& % @ Z$ Z& % ףp=J@Z$ Z& %vڈ@Z$ Z& %ɡE@Z$ Z&  f#3(1'f#3 1'  # T@ Z# D # 433333X@ Z# D # zG\@ Z# D #x&1a@ Z# D#+ec@ Z# D#;Nё\f@ Z#D f#3(1'f#3 1'   t@    LL 333333x@   zG|@  x&1@ +e@ :Nё\@ #3(1'f#3 1'   i@Z" m@Z"  fffffq@ Z" Q8v@ Z" Zd;O |@Z" Cl@Z" f#3(1'f#3 1'   @@$    LL y@   p= c@ 1Z$@ d`@ <,t@  f#3(1'f#3 1'  M e@' 7Z Z Z Z Z$ Z' Z( M Bj@! 7Z Z Z Z Z$ Z' Z( M w Ro@!7Z Z Z Z Z$ Z' Z( M*r@!7Z Z Z Z Z$ Z' Z( Mͮ~v@!7Z Z Z Z Z$ Z' Z      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abpufghijklmnoqzrstvwxy{|}~( MzBg>{@! 7ZZZZZ$Z'Z( f#3 1'  ~  ! b3OA@! D D ! - E@! D D !B"9(I@! DD !h5FN@! DD!C7R@!$ DD f#3BX,,,,8,,8,,,,B~,,6,*,,,,& ;!;";#;$;%;&;';(;);*;+;,-./, 01, 2<@34@5@ 6,;<=>? 1'   ~ % *@ Z- Z- % 833333/@ Z- Z- % Q2@ Z- Z- %  X9v6@ Z- Z- % D:@? Z-Z-  f#3 !1' !! ~ ! %! 4@BZ Z %! 8@BZ Z %!<@BZ Z %!HzGA@BZ Z %! ~jD@BZZ  !f#3 "1' "" " @@ Zn " w@CZ- " @|@CZ- " @CZ- "GzԄ@CZ- "o= ף@CZ- "f#3(#1'f#3 $1' $$ $ 4@H $ -$$ #LLLLLL$ #i@)$ $ $ 8n@)$$ $*ahr@)$$ $< ,u@)$$ $n[Jx@)& $ $f#3(%1'f#3 &1' && 3& (\$@! Z(Z'Z# 3& s}k:5@!& Z( Z' Z# 3& xa:@!&Z( Z' Z# 3&=,=-@!&Z( Z' Z# 3&E" @!&Z( Z' Z# 3&b |!( Z( Z' Z# &f#3 '1' '' ' .@' Z& 9' .@( #Z& Z, Z& Z, 9' .@'#Z& Z, Z& Z, 9'.@'#Z& Z, Z& Z, 9'.@'#Z& Z, Z& Z, 9'.@A #Z&Z,Z& Z,  'f#3 (1' (( %(  Z0Z1%( & Z0Z1%( !(Z0 Z1 %(!(Z0 Z1 %(!(Z0 Z1 %(!* Z0 Z1  (f#3()1'f#3 *1' ** -* LSKd@!* D$ D& D' D( -* ԓi@!*D$ D& D' D( -*p@!*D$D&D'D(-*~(vt@!*D$D&D'D(-*:x@!?D$D&D'D( *f#3(+1'zzzfffff#3(,1'#3(-1'fffffffffffff#3(.1' #3(/1($$$$$$$$$$$$$%3(01+++++++++++++++3(11+++++++++++++++3*2abbbbbbbbbbbbbbbcd31 3[_ 3]]]]]]]]]]]]` 3_`33(41+++++++++++++++3(513(6/////////////////; < = >  ? ? 4@D$ !?k@!? D? D$ !?b1}@!? D?D$ !? N͇@!? D?D$!?J2N@!? D?D$!?ώP@!A D?D$<6,+,6,7,,,,,,,.T,,,@ A B C D E F G H I J K L M N O P @  A A B A AA LAb3OA)AA A- E)AA AB"9(I)AA Ah5FN)AA AC7R)DA B B C B BC  LB4! B B8!B B<!B BHzGA!B B ~jD" B C C @J B CwK B C@|LB C LB CGzԄLB Co= ףLB D DYVZns@!DoZ Z Z Z Z Z Z$ Z% Z& Z' Z( Z, Z- Z7 D8߬c@!DoZ Z Z Z Z Z Z$ Z% Z& Z' Z( Z, Z- Z7 D`FwC!DoZ Z Z Z Z Z Z$ Z% Z& Z' Z( Z, Z- Z7 DT *q!DoZ Z Z Z Z Z Z$ Z% Z& Z' Z( Z, Z- Z7 DP^!H oZZZZZZZ$Z%Z&Z'Z(Z,Z-Z7E F G  H H 4@( D$ !H k@!H D$ DH !Hb1}@!H D$ DH !H N͇@!H D$DH!HJ2N@!H D$DH!HώP@!J D$DHHI  J J K J JJ LJ b3OA)JJ J- E)JJ JB"9(I)JJ Jh5FN)JJ JC7R)M J J K K L K KL  LK 4KK K8KK K<KK KHzGAKK K ~jDL K K L L @' K L w" K L@|"K L "K LGzԄ"K Lo= ף K L M M YVZns@!MoZ Z Z Z Z Z Z$ Z% Z& Z' Z( Z, Z- Z7 M8߬c@!MoZ Z Z Z Z Z Z$ Z% Z& Z' Z( Z, Z- Z7 M`FwC!MoZ Z Z Z Z Z Z$ Z% Z& Z' Z( Z, Z- Z7 MT *q!MoZ Z Z Z Z Z Z$ Z% Z& Z' Z( Z, Z- Z7 MP^!`'oZZZZZZZ$Z%Z&Z'Z(Z,Z-Z7MN +++++++++O +++++++++P +++++++++& @T  +0 +" Z0'  "(  Z((  'M Z`X( 3f333 Xr X 0(?+ y0],(WP'(9s $ < Quick Help< & $0 >  ????m` h  P X  I 0D    0 0L  4\ 0Nx 0\00? ]}0q 00qq     }CHART 2` h  P X  I 0D    0 0L  4\ 0Nx 0\00? ]}0q 00@  7 Sheet6 Fɀ .Y]  dMbP?_*+%&?'?(?)?MHP LaserJet 5P@g ,,@MSUDOHP LaserJet 5P<d "\,,??U} @} `} } @ }  }  } } } } } @ } }  } ` } } `.@@ @*@@h@*@O@ @ i@    $00...........00$13$13$13 U"HHHHHHHHHHHHHI$13$13 V" >===========>?$ 13$ 1&!!!!!!!!!!!"3$ 1'+++++++++++#3$ 1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3B4X((((4((4((((((((((((((((((((( !"#$%&, '(, )<@*+@,@ -,$ 1'+++++++++++#3$!1'+++++++++++#3$"1'+++++++++++#3$#1'+++++++++++#3$$1'+++++++++++#3$%1'+++++++++++#3$&1($$$$$$$$$$$%3$'1+++++++++++++3$(1+++++++++++++3&)abbbbbbbbbbbbbcd*1 *[_*]]]]]]]]]]` *_`*3$+1+++++++++++++3$,13$-/////////////// r(((((((((*P((Fp,.(  ,v , <NMM? yb$l]`Z  Fɀ"Z??3,A3d23 M NM4 3Q  Total RevenueQ% ; Q ; Q3_43_4E4 3Q (Cost of Goods SoldQ% ;GG Q ; Q3_ O  `  fo  i@za9C_iyuU( ww"B  ` d43_4E4 3Q 8Sales & Marketing ExpensesQ% ;HH Q ; Q3_ O 3ff 9 fo  9i@za%oOyy@( ww"B  ` d43_4E4 3Q 0G&A and Other ExpensesQ% ;II Q ; Q3_43_4E4 3Q:J D Depreciation, Interest and TaxesQ% ;JJ Q ; Q3_ O `  fo  i@za3x!tV$d( "B  ` d43_4E4 3Q  Net IncomeQ% ;.. Q ; Q3_ % NM  %%d43_4E4D$% M 3O&"Q4$% M 3O&"Q4FAt% 3Ol%/ 3 boN" &#43*i@! 4523  /43" " ~3O% M3OQ423 M NM4444At% 3O3 bo43*! M43" 444e<@<@<@<@<@<@@@@@@@@@@@@@D@D@D@D@D@D@H@H@H@H@H@H@L@L@L@L@L@L@P@P@P@P@P@P@e@@ yY@Gz$rQ[s@@~^@suv\{v@@@b@Vz|r);{@@Le@tnt$,!/@333333@)\(QQi@dLsk0~.Bƃ@p= ףp@"~vvo@nT9@e xx , 6<(?? 6 ],<(_<'x0(9u $ < Quick Help<'- ,>  ????m (08I 0D  0 0L 4 0\x 000? ]}0q 00qq     }CHART 2 (08I 0D  0 0L 4 0\x 000? ]}0q 00@  7 Sheet7 Fɀ 5 /l7<  dMbP?_*+%&?'?(?)?MHP LaserJet 5P@g ,,@MSUDOHP LaserJet 5P<d "T,,??U} @} `} } @ }  }  } } } } } @ } }  } ` } } `5@@ @*@@h@*@O@ @ i@    $00...........00$13$13$13 U"HHHHHHHHHHHHHI$13$13 V" >===========>?$ 13$ 1&!!!!!!!!!!!"3$ 1'+++++++++++#3$ 1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3B4X((((4((4((((((((((((((((((((( !"#$%&'()*+,-, ./, 0<@12@3@ 4,$ 1'+++++++++++#3$!1'+++++++++++#3$"1'+++++++++++#3$#1'+++++++++++#3$$1'+++++++++++#3$%1'+++++++++++#3$&1'+++++++++++#3$'1'+++++++++++#3$(1'+++++++++++#3$)1'+++++++++++#3$*1' #3$+1' #3$,1' #3$-1($$$$$$$$$$$%3$.1+++++++++++++3$/1+++++++++++++3&0abbbbbbbbbbbbbcd11 1[_1]]]]]]]]]]` 1_`13$21+++++++++++++3$313$4///////////////.((((((((((((((((*P((F8.( ؟2؟ 8v 8 <NMM?  6|%C]`b  FɀMHP LaserJet 5P@g XX@MSUDOHP LaserJet 5P<d "dXX??3@( Ԫر G @ @ DK( @A@Text 1]K(Pf $<Year<_S3d23 M NM4 3Q: ,Total Current AssetsQ% ; Q ; Q3_ O   d43_4E4 3Q: .Net Plant & EquipmentQ% ; Q ; Q3_ O  `  fo  i@za3x!tV$d( "B  ` d43_4E4 3Q 0Other Long-Term AssetsQ% ; Q ; Q3_ O   d43_4E4 3Q:R 6Total Current LiabilitiesQ% ;RR Q ; Q3_ O  fo i@za.Hy]_{`@U( f3f3"B  ` d43_4E4 3Q  Long-Term DebtQ% ;SS Q ; Q3_ O `  d43_4E4 3Q :Other Long-Term LiabilitiesQ% ;TT Q ; Q3_ O   d43_4E4 3Q%:V *Surplus LiabilitiesQ% ;VV Q ; Q3_43_4E4 3Q:U *Shareholders EquityQ% ;UU Q ; Q3_ O   fo  i@za 1=<*I؜U( wwwwwwww"B  ` d43_4E4D$% M 3O&"Q4$% M 3O&"Q4FAS / 3OZ 3 bo" & 43*4523  /43"  N 3O <+% M3OQ423 M NM4444AS / 3O3 bo43*Y@Y@#M! M43" 444e<@<@<@<@<@<@<@<@@@@@@@@@@@@@@@@@D@D@D@D@D@D@D@D@H@H@H@H@H@H@H@H@L@L@L@L@L@L@L@L@P@P@P@P@P@P@P@P@et@ @Y@g^@Pp|@t@@^@C'3>,j@ZSYVZns=FŇLx@@@b@"GlVgfffffW8߬cYB?x[@L@e@1ͽE1pRGz\VdY{'@)\(@Qi@l=rN +`Υ@"~@vo@FX?#tF37dk% e xx 8 6L1(?? vQ],L1(`l'L(9p $ < Quick Help<'- ar>  ????mXPXPXI 0D  0 0L 4 0Px 000? ]}0q 00qq     }CHART 2XPXPXI 0D  0 0L 4 0Px 000? ]}0q 00@  7 Sheet8 Fɀ 5"_ngl  dMbP?_*+%&?'?(?)?MHP LaserJet 5P@g ,,@MSUDOHP LaserJet 5P<d "T,,??U} @} `} } @ }  }  } } } } } @ } }  } ` } } `5@@ @*@@h@*@O@ @ i@    $00...........00$13$13$13 U"HHHHHHHHHHHHHI$13$13 V" >===========>?$ 13$ 1&!!!!!!!!!!!"3$ 1'+++++++++++#3$ 1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3B4X((((4((4((((((((((((((((((((( !"#$%&'()*+,-, ./, 0<@12@3@ 4,$ 1'+++++++++++#3$!1'+++++++++++#3$"1'+++++++++++#3$#1'+++++++++++#3$$1'+++++++++++#3$%1'+++++++++++#3$&1'+++++++++++#3$'1'+++++++++++#3$(1'+++++++++++#3$)1'+++++++++++#3$*1' #3$+1' #3$,1' #3$-1($$$$$$$$$$$%3$.1+++++++++++++3$/1+++++++++++++3&0abbbbbbbbbbbbbcd11 1[_1]]]]]]]]]]` 1_`13$21+++++++++++++3$313$4///////////////.((((((((((((((((*P((FH.(  Hv H <NMM? N&]`lo  Fɀ"lo??3j3d23 M NM4 3Q *Operating Cash FlowQ& ; Q ; Q3_ O   fo  i@za3x!tV$d( "B  ` d4E4 3Q J#Change in Operating Working CapitalQ& ;JJ Q ; Q3_ O   d4E4 3Q ,Capital ExpendituresQ& ;LL Q ; Q3_ O `  fo  i@za.Hy]_{`@U( f3f3"B  ` d4E4 3Q  Free Cash FlowQ& ;$$ Q ; Q3_ ! NM  !!d4E4 3Q L$External Financing Surplus (Deficit)Q& ;** Q ; Q3_ " NM   d4E4 3Q D Change in Other Long-Term AssetsQ& ;KK Q ; Q3_ O   d4EC3% M@83O& Q444 3Q N%Change in Other Long-Term LiabilitiesQ& ; Q ; Q3_ O   fo  i@za9C_iyuU( ww"B  ` d4E4D$% M 3O&"Q4$% M 3O&"Q4FA  3O_Au 3 bo#M& 43*N& 4% 2BMZ3OT& Q  $ in Thousands'4523  NM43" < d3O 6% M3O& Q423 M NM4444A  3O3 bo43*! M43" 444e<@<@<@<@<@<@<@@@@@@@@@@@@@@@D@D@D@D@D@D@D@H@H@H@H@H@H@H@L@L@L@L@L@L@L@P@P@P@P@P@P@P@e@@@4@y@b3OAw#i@LSKd@4*@p= c@- E@| 8n@ԓi@8833333/@1Z$@B"9(I *ahr@p@<Q2@d`@h5FNGzԄ< ,u@~(vt@HzGA X9v6@<,t@C7Ro= ףn[Jx@:x@ ~jDD:@e xx H 6\M(?? yA ],\M(r'@f(9q $ < Quick Help<'- R>  ????mXPXPXI 0D  0 0L 4$ 0x 0$00? ]}0q 00qq     }CHART 2XPXPXI 0D  0 0L 4$ 0x 0$00? ]}0q 00@  7 Sheet9 Fɀ 4Г  dMbP?_*+%&?'?(?)?MHP LaserJet 5P@g ,,@MSUDOHP LaserJet 5P<d "U,,??U} @} `} } @ }  }  } } } } } @ } }  } ` } } `4@@ @*@@h@*@O@ @ i@    $00...........00$13$13$13 U"HHHHHHHHHHHHHI$13$13 V" >===========>?$ 13$ 1&!!!!!!!!!!!"3$ 1'+++++++++++#3$ 1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3$1'+++++++++++#3B4X((((4((4((((((((((((((((((((( !"#$%&'()*+,, -., /<@01@2@ 3,$ 1'+++++++++++#3$!1'+++++++++++#3$"1'+++++++++++#3$#1'+++++++++++#3$$1'+++++++++++#3$%1'+++++++++++#3$&1'+++++++++++#3$'1'+++++++++++#3$(1' #3$)1' #3$*1' #3$+1' #3$,1($$$$$$$$$$$%3$-1+++++++++++++3$.1+++++++++++++3&/abbbbbbbbbbbbbcd01 0[_0]]]]]]]]]]` 0_`03$11+++++++++++++3$213$3///////////////,|(((((((((((((((*P((FP.(  Pv P <NMM?LB$]`u  Fɀ"u??3$3d23 M NM4 3QQ& ;HH Q ; Q3_43_4E4D$% M 3O&"Q4$% M 3O&"Q4FAxv 3Ot ,$3 bo&$43*43" 3_ M NM  d 444% gM13OX&"Q'4%  %M13O&"Q'4% M13O&"Q'44e<@@@D@H@L@P@e4@k@b1}@ N͇@J2N@ώP@e xx P 6g(??(],g(lu'D(9r $ < Quick Help<'- ( >  ????m1`2h222p3x33444I 0D  0 0L 4 0x 000? ]}0q 00qq     }CHART 21`2h222p3x33444I 0D  0 0L 4 0x 000? ]}0q 00@  7 Sheet10 Fɀ    dMbP?_*+%i&A Page &P"dXX??U}  \(  \r \ 0(@A@PI.]@(y <Help<(ll \ s *(?CM ](y $ <OK<rr \ 0X(@A@@ ] @X(z <To use the template: 1. If no actual data for the current year is available, enter assumptions for values called for in the white cells.<rr \ 0(@A@@] @({ <2. If any row does not apply to you (e.g. Other Expenses 1) you may leave it blank or rename it. Your new name will carry forward to the remaining sheets.<rr \ 0(@A@@]@(| k<l3. You should only enter data into the white cells for now. The shaded cells are automatically calculated.<krr \ 0x(@A@%A+]@x(} <5. This financial model contains circular references. To disable the error message, click the Tools|Options menu, go to the Calculation tab, and set Calculation mode to "Iteration".<rr \ 0ؔ(A @!A#]ؔ(l~ H<I4. Move from one entry (white) cell to the next by pressing the TAB key.<Hrr \ 08(@A@ @]@8(T <Later, you can refine your projections by over-writing the shaded cells, but this will eliminate the formulas. The only way to restore the automatic calculations will be to close your working file and re-open the template.<>"@ 7 Fɀ в  dMbP?_*+%i&A Page &PMZHP LaserJet 5P/5MP (HP)&,&6ә@X"dhh??U} 9& ( CC   @P(@A@ CRED%JI]@P( <Village Software<  FAA@Picture 28  n I]&   @(?CRED_OK> H ]( $ <OK<  H(?CRED_SUP>nHn],(8'L(9U $<Support<((  JL(@A@PNL1_TXT1! I;I%]L( $<Village Software provides a variety of business and financial desktop solutions for Excel and Office. For a free catalog, call 800-724-9332 or come to our Web site. (http://www.villagesoft.com)< agesof  Hԥ(?CRED_LIC>H],ԥ(,T't(9V $<License<  FD(A @ PNL1  n<]$@D(d h`B  S & LN1 ]\  H(?CRED_WEB>H],(p'(9W $<Website<> @ 7 Fɀ"??>  Module1__SRP_2<__SRP_3?ThisWorkbookF  !"#$%&'()*+,-./0123456789:;=>@ABCDEGHIJKLMNOPQRSTUWXYZ[\]^_`abcdeghijklmnopqrstuwxyz{|}~<j }xME(6 << < H`@ 14 ` 14 $` 14 & ` 14 (h`` 14 *` 14 ,` 14 .@`8 14 0` 14p@H h%  @|"8$*\Rffff*013f0e8661' " "(z0 "t8 "@r` "fP ",XZ "\X " `\ "X` pMyDialog$B@oXHcThis sheet shows your income statement. To change data go to the 'Base Year' or 'Assumptions' tab. "HelpA@ oH^This tab shows your balance sheet. To change data go to the 'Base Year' or 'Assumptions' tab. "HelpA@ o Cash Flow Sheet\This is your cash flow analysis. To change data go to the 'Base Year' or 'Assumptions' tab. "HelpA@ o  OThe cash flow chart shows various cash flow components over the period of time. "HelpA@ oh Cumulative Free Cash Flow ChartDThis chart shows cumulative free cash flow for each successive year. "HelpA@ oFThe income statement chart shows the breakdown of income and expenses. "HelpA@ oBalance Sheet ChartFAssets show with positive values and liabilities with negative values. "HelpA@ o@Assumptions SheetAYou can override any of these assumptions by typing in the cell. "HelpA@ o˲Attribute VB_Name = "Module1" Public Sub Instruct() *.ProcDataInvoke_Func \n14DialogShee@ts("My").Show 8EndkyrQHelpIS q$pMsgBox "This swows your inco{statement. To cha nge de go the 'Base Year' or 'Assumptions' tab.", vbOKOnly, "]xhBhBSh;gbalance cfCF@3 ' Cash Flow SAYɈBl 18+@mBjcfanalysis7j8CFC@.3e 0@rtnvariousIompons oveHr t@pe@ d of time@*A0humulative FreelChart_6zlcf G f`heach success=yk_`"JISQ3_3bea&4/breakdXownA0ĆaexpensesB cuSs0`@BK with posi>values liabilneg#CAHAą2You b-`Pridey_h eag by typing8Be@cell. rU~| CrU $`a$`a$`a$`a$!`a$I`a$q`a$`a$`an+ i#xME (SLSS<N0{00020819-0000-0000-C000-000000000046}8(%H xAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2 + i#Sheet1VSheet2 fSheet3vSheet4 xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%H xAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 +i#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%H xAttribute VB_Name = "She@et2" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 +i#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%H xAttribute VB_Name = "She@et3" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 +i#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%H xAttribute VB_Name = "She@et4" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 +i#Sheet5Sheet6 Sheet7Sheet8 xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%H xAttribute VB_Name = "She@et5" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 +i#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%H xAttribute VB_Name = "She@et6" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 +~i#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%H xAttribute VB_Name = "She@et7" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 +|i#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%H xAttribute VB_Name = "She@et8" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 +zi#Sheet9Sheet10_VBA_PROJECTQdirxME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%H xAttribute VB_Name = "She@et9" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 +xi#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%H xAttribute VB_Name = "Sheet10" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2 ೀ0* pHd VBAProject4@j = r |"8 J< rstdole>stdole f%\*\G      !"#$&()*+-./0123456789:<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvxyz{|}~3579; =!?"$p\Office10\EXCEL.EXE#Microsoft Excel 10.0 Object Library*\G{00020430-0000-0000-C{00020430-C 0046}#2.0#0#C:\WINDOWS\SYSTEM\c2.tlb#OLE Automation^DOfficDO>fic5DD2DF8D04C-5BFA-101B -BDE5DAAB42DPROGRAM FILES\MICROSOFT OFFICE\MSO97.DLL#Microsoft G 8.0 Ob LibraryDMSForms>SFrms3D452EE1-E08FYA-8-02608C4D0BB4 ONT\System32\FMl20& @[L&/;!1flAl00}#0l# 50 A729E1AE7-30B5-4B16-9029-E429544963256DOCUME~1\hcovitz\LOCALSTemp\VBE\S.exdb;!.E .`M  CkoduPle1GDkouQ1 2HB1CE@,B}!B+BBThisWorkbookGD@ThsDWkboks2o1m i"e~Sheet+! Selt{ 2 i 2G, 2  2Y 2  3 3 3 3 b< 4 4 4 V4  5 5 5 5  6 6 6 6 U 7 7 7 7 ~ 8 j8 8 8 |U 9 999>zqj>0O)=0 OG _8_xZGosoft Forms 2.K*srU~~~~~~~~k__SRP_0__SRP_1%zPROJECTwm'PROJECT, dGJȉO6    i a 1 Q     ) A Y q     Module1 ThisWorkbookSheet1Sheet2Sheet3Sheet4Sheet5Sheet6Sheet7Sheet8Sheet9Sheet10 VBAProjectF /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA  10F7C:\program files\microsoft office xpas  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.4#0#C:\program files\microsoft office xp\Office10\EXCEL.EXE#Microsoft Excel 10.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\SYSTEM\stdole2.tlb#OLE Automation *\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.2#0#C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\MSO97.DLL#Microsoft Office 8.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\WINNT\System32\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{729E1AE7-30B5-4B16-9029-E42954496325}#2.0#0#C:\DOCUME~1\hcovitz\LOCALS~1\Temp\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M   |"8   Module1013f0e8661Module1} ThisWorkbook023f0e860c3ThisWorkbook i1 Sheet1033f0e860c5 Sheet1 i01 Sheet2043f0e860c7 Sheet2iH1 Sheet3053f0e860c9 Sheet3i`1 Sheet4063f0e860c; Sheet4ix1 Sheet5073f0e860c= Sheet5i1 Sheet6083f0e860c? Sheet6i1 Sheet7093f0e860cA Sheet7~i1 Sheet80:3f0e860cC Sheet8|i1 Sheet90;3f0e860cE Sheet9zi1Sheet100<3f0e860cGSheet10xi1(0`Hxid( KD90Harvard ManageMentor - PREPARING A BUSINESS PLAN        Times New Roman-02 aBPro Forma Financial Package      Times New Roman-2 Contents Times New Roman-2 Introduction2 k This sheet 2 Base Yeart  W2 k5Data entry sheet for first year estimates/actual data  -"SystemHl-'-- -   @ !2% @ !-W @ !-  @ !{9-  @ !%- -99- @ !9-RR- @ !R-   @ !;- -'-  , --'՜.+,D՜.+, PX  c#Harvard Business School PublishingrA D Introduction Base Year AssumptionsIncome StatementBalance Sheet Cash FlowIncome Statement ChartBalance Sheet ChartCash Flow Chart Cumulative Free Cash Flow Chart AnalysisBaseADBaseAPBaseAR BaseCashBaseCDBaseCEBaseCM BaseCOGSBaseCSBaseDepBaseGAExpenseBaseGPEBaseIBaseIEBaseIER BaseIERLBaseIIBaseIIR BaseLTDTermBaseLTLBaseMarketingExpenseBaseMSBaseOCABaseOE1BaseOE2BaseOE3BaseOE4BaseOI BaseOLTDBaseOTABaseOTCBasePDBasePSBaseRE BaseRevenueBaseRevenueGrowthBaseSalesExpenseBaseSTD BasetaxRateBaseTPIntroduction!BENEFITSBreakevenAnalysisBSDateDepYearIntroduction!PCHARTAssumptions!Print_Area'Balance Sheet'!Print_Area!'Balance Sheet Chart'!Print_Area'Base Year'!Print_Area'Cash Flow'!Print_Area'Cash Flow Chart'!Print_Area-'Cumulative Free Cash Flow Chart'!Print_Area'Income Statement'!Print_Area$'Income Statement Chart'!Print_AreaIntroduction!Print_AreaIntroduction!PRTCHTTable  Worksheets  Named Ranges:aiy )9 I Y i y  Company NameCompany Address Company CityCompany State Company ZIPCompany Phone Company Fax Period Product#REF!tvital1#REF!vital2#REF!vital4#REF!vital5#REF!vital6#REF!vital8#REF!vital9#REF!Data1#REF!Data2 FMicrosoft Excel WorksheetBiff8Excel.Sheet.89q