ࡱ> -, u'ɀ\pcmchiric Ba==X/#8X@"1Arial1Arial1Arial1Arial1Arial1@Arial1Arial1QTahoma1Arial1Arial1Arial1Arial"$"#,##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\);_(* "-"??_);_(@_)                + ) , *      ( ( #     #   # 1  (X  D   D  @ (x   $   d  #| 1 t  d  `  $  (8 *  * $@ * da@ * $a@ )   #  #4a@  #4@  #t `"U Three-Yr Profit ProjectionTZR3  @@+ S Enter your Company Name hereSales Gross ProfitOperating ExpensesPayroll (taxes etc.)Outside ServicesSupplies (off and operation)Repairs/ Maintenance AdvertisingCar, Delivery and TravelAccounting and LegalRent Telephone Utilities InsuranceTaxes (real estate etc.)InterestOther expense (specify)Total ExpensesNet Profit Before Tax Income TaxesNet Profit After TaxOwner Draw/ DividendsAdj. to Retained Earnings%Salary (Office & Overhead) DepreciationCost/ Goods Sold (COGS)$Profit and Loss Projection (3 Years)"  >  u'ɀ %[$+-  dMbP?_*+%&?'?(?)?M\\2khqprint2\B986364C odXXLetter DINU"4qWI "dXX??U} } $ } I} $} I'} $ } I} $} I'} $ } I} $} I'} $ %,                  "  "   % % % % %  % % %  % % %  % ~ X@ &\@  D & `@ D    &2% %  % ~ -~ 2?%~ -~ 2?%~  -~  2? % ~ 1>2}(D -DDB-%~ 1>2} (D -DDB-%~  1> 2 }(D  -D D B- % !. DD*>4} (D -DDB-%!. DD+>4}(D -DDB-%! . D D  +> 4} (D  -D D B- % 2% 2% 2% , ((5%))5%))5%" ~ - > 2} (D -D DB- %~ -> 2 } (D -D DB- %~ -> 2$} (D  -D D B- % ~ 1 > 2(} (D -D DB- %~ 1 2,}  2 (D -LDB- %~ 1 20}  2  (D  -LD B- % ~ 1  24} 2 (D -LDB- %~ 1 28} - %~ 1 2<}  - % ~ 12@} -%~ 12D} -%~  1 2H}  - % ~ 12L} -%~ 12P} -%~  1 2T}  - % ~ 12X} -%~ 12\} -%~  1 2`}  - %  ~ 12d} -%~ 12h} -%~  1 2l}  - %  ~ 12p} -%~ 12t} -%~  1 2x}  - %  ~ 12|} -%~ 12} -%~  1 2}  - %  ~ 12} -%~ 12} -%~  1 2}  - %  ~ 12} -%~ 12} -%~  1 2}  - % ~ 12} -%~ 12} -%~  1 2}  - % ~ 12} -%~ 12} -%~  1 2}  - % ~ 12} -%~ 12} -%~  1 2}  - % ~ 12} -%~ 12} -%~  1 2}  - % ~ 12} -%~ 12} -%~  1 2}  - % ~ 12} -%~ 12}  -%~  1 2}  - % ##/ % (3} -%#/ % )3}  -%# / %   ) 3} - % !% !%  !% !1  DD $%!1  DD %! 1 D D   % ~ 1 $%~ 1 $%~  1  % Dl<<..0>02>d 40 ! "  # $  ! 1" DD $%! 1" DD $%! 1" D D  % !~ !1 !$%~ !1 !$%~ ! 1 ! % "!"0 D D! "*$%!"0,&S D D! "*$%!" 0 D D!  " *$% #% #$% # % $% $$% $ % Pd0B*(  ~  <5 XPP? i ]4@5D .ACI_ 4<5Totals and percentages are calculated automatically.<, 4ll  s *XO +@ px]`XO D 3H<4Notes on Preparation Note: You may want to print this information to use as reference later. To delete these instructions, click the border of this text box and then press the DELETE key. A long term forecast is not a necessary part of a basic business plan. However, it is an excellent tool to help you open up your thinking about the company's future. Furthermore, venture capitalists will almost always want a long term forecast to get a feel for growth prospects. The further out you forecast, the less accuracy you can maintain, so use round numbers, except where you know exact amounts; e.g.: rent expense if you have a long term lease. The most important part of the long term forecast is not the numbers themselves, but the assumptions underlying the numbers. So make sure your assumptions are stated clearly and in detail in a narrative attachment. This will communicate your vision of the company's future and how you anticipate realizing that vision. You will note that there are some lines on the bottom of this spreadsheet which may not be on a twelve-month P & L. This is to help you do some planning about funding growth: - NET PROFIT BEFORE TAX is the same as Net Profit on a 12-month Profit and Loss spreadsheet. - INCOME TAX allows you to estimate how much of your profit will have to go to the IRS. - NET PROFIT AFTER TAX is what is left for you to use. - OWNER DRAW/ DIVIDENDS is how much the owners plan to take out for themselves. - ADJUSTMENT TO RETAINED EARNINGS is the amount of profit actually left in the business to increase Owners' Equity and fund growth. <H t     ' } T3Mitali Pattnaik >@A @7 Oh+'0 hp| sssss cmchiric Microsoft Excel@Oͱ@"}@/pD; ՜.+,D՜.+,H `ht  11SCORE5O Three-Yr Profit Projection  WorksheetsX 8@ _TemplateIDTC010175111033j  !"#%&'()*+Root Entry FP(N; Workbook$7SummaryInformation(DocumentSummaryInformation8$