Docstoc

Business Plan Financials

Document Sample
Business Plan Financials Powered By Docstoc
					Authored by: Deborah Anderson, 206.334.0283, morosi93@hotmail.com
Financial Modeling Workbook
for use by
UW Bothell Entreprenuership Center Students




General:
         BEFORE beginning, save workbook with a different name (save as)
         Yellow areas are meant to be completed by students
         White areas are formulas (do not change)
         Do NOT insert rows or colmuns
         Hide rows that are not needed
         Before publishing IS, BS, CFS save file then,
               perform a "save as" so you have another clean version
               Change the "yellow" cells to "no fill"
Human Capital:
         FTE's:
               The position titles are examples and can be replaced to meet individual business plans.
               Forecast the number of full time equivalent (fte's) each anticipated position will bear.
               Forecast the increase in fte's in future years.
               Estimate the number of new hires per existing position or added position
         Salaries Projections:
               In year 2012, estimate the compensation level for each ee anticipated in your business model.
                    Enter that dollar amount into each month beginning with the ee's anticipated hire.
               In years successive years, formulas are required:
                    Estimate salary for each new ee anticipated PLUS
                    Estimate salary increases for ee's hired in prior years (generally 3%)
         Benefits:
               Research cost of providing medical/dental insurance.
               Decide when it is appropriate to add those costs to your business plan.
               Formula required: multiply the monthly premium costs by the number of employees.
               In years successive years, formulas are required:
                    Multiply monthly premiums with existing and new employee hires and add 20% premium increase

Sales Forecast:
           Sales:
                Estimate volume of product and/or service sales in present and future years
                In Column B, enter estimated product and/or service price based on market research
                Estimate product price increase in future years
                     In future years, formula is required:
                          Multiply # of units sold BY (price x percentage price increase)
                Estimate volume of sales returns and level of sales discounts
                     Enter estimated sales discounts (if any) in Column B (enter as a positive number)
                    Enter estimated sales returns in appropriate month (enter as a positive number)
          Sales and B&O Tax:
               Research your area's Sales and Business & Occupation (B&O) Tax.
                    Sales tax is based on destination of product or service.
                    B&O Tax is based on your cities tax code (not all jurisdictions have a B&O tax).
          Cost of Goods Sold:
               Everything that is sold has a cost of generating that sale
               Estimate cost of product or service in present and future years
               In Column B, estimate product or service cost based on market research
               Estimate increase in cost to product or service in future years
                    In future years, formula is required:
                         Multiply # of units sold BY (cost x percentage price increase)
               Estimate volume of purchase returns level of purchase discounts
                    Enter estimated purchase discounts (if any) in Column B (enter as a positive number)
                    Enter estimated puchase returns in appropriate month (enter as a positive number)

               *sales returns are received back from customer; product returns are sent back to supplier

Marketing Forecast
          Enter anticipated expenses from marketing plan
          Marketing designs are generally one time costs, unles going through a rebranding (which you most likely would no
          Print costs are generally one time, except replinishment of supplies
          Website, networking events and advertising will have ongoing costs
          Research those, determine when best to utilize these avenues and enter them appropriately.

Income Statement:
          Sales & Cost of Goods Sold flow from the sales forecase sheet
          Salaries, taxes, benefits flow for the human capital sheet
          Marketing expenses flow from the marketing forecast sheet
          Research:
               Rent, utilities, general liability insurance, mileage, postage, supplies, and other expenses and
               add monthly costs as they relate to your business plan.
          Federal Income Tax is based at 28%, if in a different tax bracket, then adjust rate within the formula
          Interest income is calculated based on current market rates
          Calculated interest expense at current market rates, based on loan terms (P&I)
               Payments on principle are reflected on the balance sheet as loan amortization - "Repayment of Loans"
               Interest payments are reflected in the income statement as interest expense
Balance Sheet:
          Estimate acquisition of land,buildings, equipment
          Estimate costs to patent technologies
          Estimate cash infusions by either securing long term bank notes, notes from FFF or sale of securities
               Estimate repayment plan - 36 mo, 60 mo, longer and amortize loan based on terms
          Estimate if portion of cash can be kept in reserve (monkey market account)
ur business model.
cipated hire.




add 20% premium increase
sitive number)
tive number)

ck to supplier




g (which you most likely would not do)


ppropriately.




her expenses and

within the formula


on - "Repayment of Loans"




or sale of securities
UW Bothell (Company Name)
Projected Human Capital
2012 - 2014

                                                                                                             2012
                                                 Jan       Feb       Mar       Apr       May       Jun
Sales & Marketing:
    Full Time Equivalents (FTE's):
          VP Sales & Marketing
          Sales Manager
          Marketing Manager
          Sales Representatives
          Customer Service
    Total Full Time Equivalents (FTE's):               0         0         0         0         0         0

    Salaries:
         VP Sales & Marketing
         Sales Manager
         Marketing Manager
         Sales Representatives
         Customer Service
         Sales Commissions
    Total Sales Salaries:                         0.00      0.00      0.00      0.00      0.00      0.00

    Sales & Marketing Benefits:
         Payroll Taxes (fica, futa, suta, L&I)    0.00      0.00      0.00      0.00      0.00      0.00
         Medical/Dental Insurances
         Life, STD, LTD Insurances
    Total Sales & Marketing Benefits:             0.00      0.00      0.00      0.00      0.00      0.00

Total Sales & Marketing Expenses:                 0.00      0.00      0.00      0.00      0.00      0.00

Product Development:
   Full Time Equivalents (FTE's):
         Dir Product Development
         Programmers/Design Team
         Product Testers/Quality Control
   Total Full Time Equivalents (FTE's):                0         0         0         0         0         0

    Salaries:
         Dir Product Development
         Programmers/Design Team
         Product Testers/Quality Control
    Total Product Salaries:                       0.00      0.00      0.00      0.00      0.00      0.00

    Product Benefits:
        Payroll Taxes (fica, futa, suta, L&I)     0.00      0.00      0.00      0.00      0.00      0.00
        Medical/Dental Insurances
        Life, STD, LTD Insurances
    Total Product Benefits:                       0.00      0.00      0.00      0.00      0.00      0.00

Total Product Development Expenses:               0.00      0.00      0.00      0.00      0.00      0.00

Administration:
   Full Time Equivalents (FTE's):
        CEO/ED
        Office Manager
        Receptionist
    Total Full Time Equivalents (FTE's):        0   0     0      0      0      0

    Salaries:
         CEO/ED
         Office Manager
         Receptionist
    Total Administrative Salaries:              0   0   0.00   0.00   0.00   0.00

    Administrative Benefits:
        Payroll Taxes (fica, futa, suta, L&I)   0   0   0.00   0.00   0.00   0.00
        Medical/Dental Insurances
        Life, STD, LTD Insurances
    Total Administrative Benefits:              0   0   0.00   0.00   0.00   0.00

Total Administratiion Expenses:                 0   0   0.00   0.00   0.00   0.00

Total FTE's:                                    0   0     0      0      0      0
2012                                                                                           2013
 Jul       Aug       Sep       Oct       Nov       Dec       Total       Q1           Q2


                                                                     0
                                                                     0
                                                                     0
                                                                     0
                                                                     0
       0         0         0         0         0         0           0        0   0        0


                                                                0.00
                                                                0.00
                                                                0.00
                                                                0.00
                                                                0.00
                                                                0.00
  0.00      0.00      0.00      0.00      0.00      0.00        0.00      0.00         0.00


  0.00      0.00      0.00      0.00      0.00      0.00        0.00      0.00         0.00
                                                                0.00
                                                                0.00
  0.00      0.00      0.00      0.00      0.00      0.00        0.00      0.00         0.00

  0.00      0.00      0.00      0.00      0.00      0.00        0.00      0.00         0.00



                                                                     0
                                                                     0
                                                                     0
       0         0         0         0         0         0           0        0            0


                                                                0.00
                                                                0.00
                                                                0.00
  0.00      0.00      0.00      0.00      0.00      0.00        0.00      0.00         0.00


  0.00      0.00      0.00      0.00      0.00      0.00        0.00      0.00         0.00
                                                                0.00
                                                                0.00
  0.00      0.00      0.00      0.00      0.00      0.00        0.00      0.00         0.00

  0.00      0.00      0.00      0.00      0.00      0.00        0.00      0.00         0.00
                                            0
                                            0
                                            0
  0      0      0      0      0      0      0      0      0


                                          0.00
                                          0.00
                                          0.00
0.00   0.00   0.00   0.00   0.00   0.00   0.00   0.00   0.00


0.00   0.00   0.00   0.00   0.00   0.00   0.00   0.00   0.00
                                          0.00
                                          0.00
0.00   0.00   0.00   0.00   0.00   0.00   0.00   0.00   0.00

0.00   0.00   0.00   0.00   0.00   0.00   0.00   0.00   0.00

  0      0      0      0      0      0      0      0      0
    2013                                                          2014
     Q3            Q4       Total       Q1           Q2            Q3            Q4


                                    0
                                    0
                                    0
                                    0
                                    0
0          0   0        0           0        0   0        0   0          0   0        0


                               0.00
                               0.00
                               0.00
                               0.00
                               0.00
                               0.00
      0.00          0.00       0.00      0.00         0.00          0.00          0.00


      0.00          0.00       0.00      0.00         0.00          0.00          0.00
                               0.00
                               0.00
      0.00          0.00       0.00      0.00         0.00          0.00          0.00

      0.00          0.00       0.00      0.00         0.00          0.00          0.00



                                    0
                                    0
                                    0
           0            0           0        0            0              0            0


                               0.00
                               0.00
                               0.00
      0.00          0.00       0.00      0.00         0.00          0.00          0.00


      0.00          0.00       0.00      0.00         0.00          0.00          0.00
                               0.00
                               0.00
      0.00          0.00       0.00      0.00         0.00          0.00          0.00

      0.00          0.00       0.00      0.00         0.00          0.00          0.00
                0
                0
                0
  0      0      0      0      0      0      0


              0.00
              0.00
              0.00
0.00   0.00   0.00   0.00   0.00   0.00   0.00


0.00   0.00   0.00   0.00   0.00   0.00   0.00
              0.00
              0.00
0.00   0.00   0.00   0.00   0.00   0.00   0.00

0.00   0.00   0.00   0.00   0.00   0.00   0.00

  0      0      0      0      0      0      0
            2015        2016
Total       Total       Total


        0
        0
        0
        0
        0
        0           0           0


   0.00
   0.00
   0.00
   0.00
   0.00
   0.00
   0.00        0.00        0.00


   0.00        0.00        0.00
   0.00
   0.00
   0.00        0.00        0.00

   0.00        0.00        0.00



        0
        0
        0
        0           0           0


   0.00
   0.00
   0.00
   0.00        0.00        0.00


   0.00        0.00        0.00
   0.00
   0.00
   0.00        0.00        0.00

   0.00        0.00        0.00
  0
  0
  0
  0      0      0


0.00
0.00
0.00
0.00   0.00   0.00


0.00   0.00   0.00
0.00
0.00
0.00   0.00   0.00

0.00   0.00   0.00

  0      0      0
UW Bothell (Company Name)
Projected Sales Forecast
2012 - 2014

                                                                                                         2012
                                               Jan      Feb       Mar       Apr       May       Jun
Units

Sales:
     Product Sales:
            Materials                           0.00      0.00      0.00      0.00      0.00      0.00
            Add-On Materials                    0.00      0.00      0.00      0.00      0.00      0.00
            Shipping                            0.00      0.00      0.00      0.00      0.00      0.00
            Production Labor                    0.00      0.00      0.00      0.00      0.00      0.00
     Total Product Sales:                       0.00      0.00      0.00      0.00      0.00      0.00

     Service Sales:
            Personal Services                   0.00      0.00      0.00      0.00      0.00      0.00
            Memberships                         0.00      0.00      0.00      0.00      0.00      0.00
            Minutes/Time                        0.00      0.00      0.00      0.00      0.00      0.00
            Subcontractors                      0.00      0.00      0.00      0.00      0.00      0.00
     Total Services Sales:                      0.00      0.00      0.00      0.00      0.00      0.00

     Less:
              Sales Discounts                   0.00      0.00      0.00      0.00      0.00      0.00
             Returns and Allowances

Sales and B&O Tax:
            Sales Tax                           0.00      0.00      0.00      0.00      0.00      0.00
            B&O Tax                             0.00      0.00      0.00      0.00      0.00      0.00

Cost of Goods Sold:
     Product Costs:
            Materials                           0.00      0.00      0.00      0.00      0.00      0.00
            Add-On Materials                    0.00      0.00      0.00      0.00      0.00      0.00
            Shipping                            0.00      0.00      0.00      0.00      0.00      0.00
            Production Labor                    0.00      0.00      0.00      0.00      0.00      0.00
            Burden Rate                         0.00      0.00      0.00      0.00      0.00      0.00
     Total Product Costs:                       0.00      0.00      0.00      0.00      0.00      0.00

     Service Costs:
            Personal Services                   0.00      0.00      0.00      0.00      0.00      0.00
            Memberships                         0.00      0.00      0.00      0.00      0.00      0.00
            Minutes/Time                        0.00      0.00      0.00      0.00      0.00      0.00
            Subcontractors                      0.00      0.00      0.00      0.00      0.00      0.00
     Total Services Costs:                      0.00      0.00      0.00      0.00      0.00      0.00

     Less:
              Purchase Discounts
             Purchase Returns and Allowances

Gross Margin %:
           Product Sales:                  #DIV/0!     #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!

             Service Sales:                #DIV/0!     #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!
Total Sales:   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!
 2012                                                                                          2013
  Jul      Aug       Sep       Oct       Nov       Dec       Total         Q1         Q2
                                                                     0



   0.00      0.00      0.00      0.00      0.00      0.00       0.00
   0.00      0.00      0.00      0.00      0.00      0.00       0.00
   0.00      0.00      0.00      0.00      0.00      0.00       0.00
   0.00      0.00      0.00      0.00      0.00      0.00       0.00
   0.00      0.00      0.00      0.00      0.00      0.00       0.00            0          0


   0.00      0.00      0.00      0.00      0.00      0.00       0.00
   0.00      0.00      0.00      0.00      0.00      0.00       0.00
   0.00      0.00      0.00      0.00      0.00      0.00       0.00
   0.00      0.00      0.00      0.00      0.00      0.00       0.00
   0.00      0.00      0.00      0.00      0.00      0.00       0.00        0.00       0.00


   0.00      0.00      0.00      0.00      0.00      0.00       0.00
                                                                0.00


   0.00      0.00      0.00      0.00      0.00      0.00       0.00        0.00       0.00
   0.00      0.00      0.00      0.00      0.00      0.00       0.00        0.00       0.00



   0.00      0.00      0.00      0.00      0.00      0.00       0.00
   0.00      0.00      0.00      0.00      0.00      0.00       0.00
   0.00      0.00      0.00      0.00      0.00      0.00       0.00
   0.00      0.00      0.00      0.00      0.00      0.00       0.00
   0.00      0.00      0.00      0.00      0.00      0.00       0.00        0.00       0.00
   0.00      0.00      0.00      0.00      0.00      0.00       0.00        0.00       0.00


   0.00      0.00      0.00      0.00      0.00      0.00       0.00
   0.00      0.00      0.00      0.00      0.00      0.00       0.00
   0.00      0.00      0.00      0.00      0.00      0.00       0.00
   0.00      0.00      0.00      0.00      0.00      0.00       0.00
   0.00      0.00      0.00      0.00      0.00      0.00       0.00        0.00       0.00


                                                                0.00
                                                                0.00


#DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!      #DIV/0!    #DIV/0!

#DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!      #DIV/0!    #DIV/0!
#DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!
 2013                                                        2014
  Q3          Q4        Total         Q1            Q2                Q3
                                0



                           0.00
                           0.00
                           0.00
                           0.00
        0          0          0               0          0                 0


                           0.00
                           0.00
                           0.00
                           0.00
   0.00        0.00        0.00         0.00         0.00              0.00


                           0.00
                           0.00


   0.00        0.00        0.00         0.00         0.00              0.00
   0.00        0.00        0.00         0.00         0.00              0.00



                           0.00
                           0.00
                           0.00
                           0.00
   0.00        0.00        0.00         0.00         0.00              0.00
   0.00        0.00        0.00         0.00         0.00              0.00


                           0.00
                           0.00
                           0.00
                           0.00
   0.00        0.00        0.00         0.00         0.00              0.00


                           0.00
                           0.00


#DIV/0!     #DIV/0!    #DIV/0!      #DIV/0!       #DIV/0!           #DIV/0!

#DIV/0!     #DIV/0!    #DIV/0!      #DIV/0!       #DIV/0!           #DIV/0!
#DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!
                         2015          2016
  Q4        Total        Total         Total
                    0



               0.00
               0.00
               0.00
               0.00
       0          0               0             0


               0.00
               0.00
               0.00
               0.00
   0.00        0.00         0.00          0.00


               0.00
               0.00


   0.00        0.00         0.00          0.00
   0.00        0.00         0.00          0.00



               0.00
               0.00
               0.00
               0.00
   0.00        0.00         0.00          0.00
   0.00        0.00         0.00          0.00


               0.00
               0.00
               0.00
               0.00
   0.00        0.00         0.00          0.00


               0.00
               0.00


#DIV/0!    #DIV/0!      #DIV/0!       #DIV/0!

#DIV/0!    #DIV/0!      #DIV/0!       #DIV/0!
#DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!
UW Bothell (Company Name)
Projected Marketing Expenses
2012 - 2014


                                                       Jan       Feb       Mar       Apr
Marketing Design:
           Brand Creation
           Packaging Creation
           Marketing Collateral Materials
           Sales Collateral Materials
           Letterhead Creation
Printing:
           Print Packaging
           Print Marketing Collateral Materials
           Print Sales Collaterial Materials
           Print Letterhead & Envelopes
           Print Business Cards
On-Line:
           Website Development
           Facebook Page Created
           On-line Payment Portal
In-Person:
           Networking at appropriate events

Marketing Channels (Advertising):
          Trade Magazines
          Business Journals
          On-Line Advertising
          Television
          Newspapers
          Chamber/Membership Organizations

Media Relations:
     Press Releases:
          Announcing Company Launch
          Announcing Product Launch
          Announcing Significant New Hire
          Announcing Sales Channel Developed
          Announcing Significant Milestone

      Newspapers:
         Article Featuring Company & Product Launch

      Business Journals:
          Article Featuring Company & Product Launch

Total Projected Marketing Expenses:                          0         0         0         0
                    2012
May       Jun        Jul       Aug       Sep       Oct       Nov       Dec       Total

                                                                                    0.00
                                                                                    0.00
                                                                                    0.00
                                                                                    0.00
                                                                                    0.00

                                                                                    0.00
                                                                                    0.00
                                                                                    0.00
                                                                                    0.00
                                                                                    0.00

                                                                                    0.00
                                                                                    0.00
                                                                                    0.00

                                                                                    0.00


                                                                                    0.00
                                                                                    0.00
                                                                                    0.00
                                                                                    0.00
                                                                                    0.00
                                                                                    0.00



                                                                                         0
                                                                                         0
                                                                                         0
                                                                                         0
                                                                                         0


                                                                                         0


                                                                                         0

      0         0          0         0         0         0         0         0           0
                          2013                                                              2014
Q1           Q2            Q3            Q4           Total       Q1           Q2

                                                         0.00
                                                         0.00
                                                         0.00
                                                         0.00
                                                         0.00

                                                         0.00
                                                         0.00
                                                         0.00
                                                         0.00
                                                         0.00

                                                         0.00
                                                         0.00
                                                         0.00

                                                         0.00


                                                         0.00
                                                         0.00
                                                         0.00
                                                         0.00
                                                         0.00
                                                         0.00



                                                              0
                                                              0
                                                              0
                                                              0
                                                              0


                                                              0


                                                              0

     0   0        0   0          0   0        0   0           0        0   0        0   0
2014                                    2015    2016
 Q3            Q4           Total       Total   Total

                               0.00
                               0.00
                               0.00
                               0.00
                               0.00

                               0.00
                               0.00
                               0.00
                               0.00
                               0.00

                               0.00
                               0.00
                               0.00

                               0.00


                               0.00
                               0.00
                               0.00
                               0.00
                               0.00
                               0.00



                                    0
                                    0
                                    0
                                    0
                                    0


                                    0


                                    0

       0   0        0   0           0
UW Bothell (Company Name)
Projected Income Statement
2012 - 2014


                                                     Jan          Feb          Mar          Apr          May
Income:
    Gross Sales:                                      $0.00        $0.00        $0.00        $0.00        $0.00
        Less: Sales Discounts                          0.00         0.00         0.00         0.00         0.00
               Returns and Allowances                  0.00         0.00         0.00         0.00         0.00
    Net Sales:                                        $0.00        $0.00        $0.00        $0.00        $0.00

    Cost of Goods Sold:
        Product/Service Costs                          0.00         0.00         0.00         0.00         0.00
        Less: Purchase Discounts                       0.00         0.00         0.00         0.00         0.00
               Purchase Returns and Allowances         0.00         0.00         0.00         0.00         0.00
    Total Cost of Goods Sold:                         $0.00        $0.00        $0.00        $0.00        $0.00

Gross Margin:                                         $0.00        $0.00        $0.00        $0.00        $0.00

Operating Expenses:
        Salaries and Wages                             0.00         0.00         0.00         0.00         0.00
        Payroll Taxes                                  0.00         0.00         0.00         0.00         0.00
        Fringe Benefits                                0.00         0.00         0.00         0.00         0.00
        Rent
        Utilities
        Insurance
        Legal Fees
        Advertising                                    0.00         0.00         0.00         0.00         0.00
        Marketing                                      0.00         0.00         0.00         0.00         0.00
        Printing                                       0.00         0.00         0.00         0.00         0.00
        Website Design/Maintenance                     0.00         0.00         0.00         0.00         0.00
        Mileage/Travel
        Postage
        Supplies
        Bank Charges
        Business Taxes                                 0.00         0.00         0.00         0.00         0.00
        Other
    Total Operating Expenses:                         $0.00        $0.00        $0.00        $0.00        $0.00

Net Income from Operations:                           $0.00        $0.00        $0.00        $0.00        $0.00

Other Income/Expense
    Other Income:
         Other Income
         Interest Income                               0.00         0.00         0.00         0.00         0.00
    Total Other Income:                               $0.00        $0.00        $0.00        $0.00        $0.00

    Other Expense:
        Depreciation & Amortization                    0.00         0.00         0.00         0.00         0.00
        Other Expense
        Federal Income Taxes                     0            0            0            0            0
        Interest Expense
    Total Other Expense:                              $0.00        $0.00        $0.00        $0.00        $0.00
Total Other Income/Expense:   $0.00   $0.00   $0.00   $0.00   $0.00

Net Income:                   $0.00   $0.00   $0.00   $0.00   $0.00
                          2012
    Jun          Jul             Aug          Sep          Oct          Nov          Dec      Total     % of Sales

     $0.00       $0.00            $0.00        $0.00        $0.00        $0.00        $0.00     $0.00    #DIV/0!
      0.00        0.00             0.00         0.00         0.00         0.00         0.00      0.00    #DIV/0!
      0.00        0.00             0.00         0.00         0.00         0.00         0.00      0.00    #DIV/0!
     $0.00       $0.00            $0.00        $0.00        $0.00        $0.00        $0.00     $0.00    #DIV/0!


      0.00        0.00             0.00         0.00         0.00         0.00         0.00      0.00    #DIV/0!
      0.00        0.00             0.00         0.00         0.00         0.00         0.00      0.00    #DIV/0!
      0.00        0.00             0.00         0.00         0.00         0.00         0.00      0.00    #DIV/0!
     $0.00       $0.00            $0.00        $0.00        $0.00        $0.00        $0.00     $0.00    #DIV/0!

     $0.00       $0.00            $0.00        $0.00        $0.00        $0.00        $0.00     $0.00    #DIV/0!


      0.00         0.00            0.00         0.00         0.00         0.00         0.00      0.00    #DIV/0!
      0.00         0.00            0.00         0.00         0.00         0.00         0.00      0.00    #DIV/0!
      0.00         0.00            0.00         0.00         0.00         0.00         0.00      0.00    #DIV/0!
                                                                                                 0.00    #DIV/0!
                                                                                                 0.00    #DIV/0!
                                                                                                 0.00    #DIV/0!
                                                                                                 0.00    #DIV/0!
      0.00         0.00            0.00         0.00         0.00         0.00         0.00      0.00    #DIV/0!
      0.00         0.00            0.00         0.00         0.00         0.00         0.00      0.00    #DIV/0!
      0.00         0.00            0.00         0.00         0.00         0.00         0.00      0.00    #DIV/0!
      0.00         0.00            0.00         0.00         0.00         0.00         0.00      0.00    #DIV/0!
                                                                                                 0.00    #DIV/0!
                                                                                                 0.00    #DIV/0!
                                                                                                 0.00    #DIV/0!
                                                                                                 0.00    #DIV/0!
      0.00         0.00            0.00         0.00         0.00         0.00         0.00      0.00    #DIV/0!
                                                                                                 0.00    #DIV/0!
     $0.00       $0.00            $0.00        $0.00        $0.00        $0.00        $0.00     $0.00    #DIV/0!

     $0.00       $0.00            $0.00        $0.00        $0.00        $0.00        $0.00     $0.00    #DIV/0!



                                                                                                 0.00    #DIV/0!
      0.00        0.00             0.00         0.00         0.00         0.00         0.00      0.00    #DIV/0!
     $0.00       $0.00            $0.00        $0.00        $0.00        $0.00        $0.00     $0.00    #DIV/0!


      0.00         0.00            0.00         0.00         0.00         0.00         0.00      0.00    #DIV/0!
                                                                                                 0.00    #DIV/0!
0            0            0               0            0            0            0               0.00    #DIV/0!
                                                                                                 0.00    #DIV/0!
     $0.00       $0.00            $0.00        $0.00        $0.00        $0.00        $0.00     $0.00    #DIV/0!
$0.00   $0.00   $0.00   $0.00   $0.00   $0.00   $0.00   $0.00   #DIV/0!

$0.00   $0.00   $0.00   $0.00   $0.00   $0.00   $0.00   $0.00   #DIV/0!
                            2013
    Q1          Q2          Q3           Q4      Total     % of Sales       Q1

    $0.00       $0.00        $0.00       $0.00     $0.00    #DIV/0!         $0.00
     0.00        0.00         0.00        0.00      0.00    #DIV/0!          0.00
     0.00        0.00         0.00        0.00      0.00    #DIV/0!          0.00
    $0.00       $0.00        $0.00       $0.00     $0.00    #DIV/0!         $0.00


     0.00        0.00         0.00        0.00      0.00    #DIV/0!          0.00
     0.00        0.00         0.00        0.00      0.00    #DIV/0!          0.00
     0.00        0.00         0.00        0.00      0.00    #DIV/0!          0.00
    $0.00       $0.00        $0.00       $0.00     $0.00    #DIV/0!         $0.00

    $0.00       $0.00        $0.00       $0.00     $0.00    #DIV/0!         $0.00


     0.00        0.00         0.00        0.00      0.00    #DIV/0!          0.00
     0.00        0.00         0.00        0.00      0.00    #DIV/0!          0.00
     0.00        0.00         0.00        0.00      0.00    #DIV/0!          0.00
                                                    0.00    #DIV/0!
                                                    0.00    #DIV/0!
                                                    0.00    #DIV/0!
                                                    0.00    #DIV/0!
     0.00        0.00         0.00        0.00      0.00    #DIV/0!          0.00
     0.00        0.00         0.00        0.00      0.00    #DIV/0!          0.00
     0.00        0.00         0.00        0.00      0.00    #DIV/0!          0.00
     0.00        0.00         0.00        0.00      0.00    #DIV/0!          0.00
                                                    0.00    #DIV/0!
                                                    0.00    #DIV/0!
                                                    0.00    #DIV/0!
                                                    0.00    #DIV/0!
     0.00        0.00         0.00        0.00      0.00    #DIV/0!          0.00
                                                    0.00    #DIV/0!
    $0.00       $0.00        $0.00       $0.00     $0.00    #DIV/0!         $0.00

    $0.00       $0.00        $0.00       $0.00     $0.00    #DIV/0!         $0.00



                                                    0.00    #DIV/0!
     0.00        0.00         0.00        0.00      0.00    #DIV/0!          0.00
    $0.00       $0.00        $0.00       $0.00     $0.00    #DIV/0!         $0.00


     0.00        0.00         0.00        0.00      0.00    #DIV/0!          0.00
                                                    0.00    #DIV/0!
0           0           0            0              0.00    #DIV/0!     0
                                                    0.00    #DIV/0!
    $0.00       $0.00        $0.00       $0.00     $0.00    #DIV/0!         $0.00
$0.00   $0.00   $0.00   $0.00   $0.00   #DIV/0!   $0.00

$0.00   $0.00   $0.00   $0.00   $0.00   #DIV/0!   $0.00
                        2014                                                  2015
    Q2          Q3                 Q4      Total     % of Sales       Total          % of Sales

    $0.00       $0.00              $0.00     $0.00    #DIV/0!           $0.00         #DIV/0!
     0.00        0.00               0.00      0.00    #DIV/0!            0.00         #DIV/0!
     0.00        0.00               0.00      0.00    #DIV/0!            0.00         #DIV/0!
    $0.00       $0.00              $0.00     $0.00    #DIV/0!           $0.00         #DIV/0!


     0.00        0.00               0.00      0.00    #DIV/0!            0.00         #DIV/0!
     0.00        0.00               0.00      0.00    #DIV/0!            0.00         #DIV/0!
     0.00        0.00               0.00      0.00    #DIV/0!            0.00         #DIV/0!
    $0.00       $0.00              $0.00     $0.00    #DIV/0!           $0.00         #DIV/0!

    $0.00       $0.00              $0.00     $0.00    #DIV/0!           $0.00         #DIV/0!


     0.00        0.00               0.00      0.00    #DIV/0!            0.00         #DIV/0!
     0.00        0.00               0.00      0.00    #DIV/0!            0.00         #DIV/0!
     0.00        0.00               0.00      0.00    #DIV/0!            0.00         #DIV/0!
                                              0.00    #DIV/0!            0.00         #DIV/0!
                                              0.00    #DIV/0!            0.00         #DIV/0!
                                              0.00    #DIV/0!            0.00         #DIV/0!
                                              0.00    #DIV/0!            0.00         #DIV/0!
     0.00        0.00               0.00      0.00    #DIV/0!            0.00         #DIV/0!
     0.00        0.00               0.00      0.00    #DIV/0!            0.00         #DIV/0!
     0.00        0.00               0.00      0.00    #DIV/0!            0.00         #DIV/0!
     0.00        0.00               0.00      0.00    #DIV/0!            0.00         #DIV/0!
                                              0.00    #DIV/0!            0.00         #DIV/0!
                                              0.00    #DIV/0!            0.00         #DIV/0!
                                              0.00    #DIV/0!            0.00         #DIV/0!
                                              0.00    #DIV/0!            0.00         #DIV/0!
     0.00        0.00               0.00      0.00    #DIV/0!            0.00         #DIV/0!
                                              0.00    #DIV/0!            0.00         #DIV/0!
    $0.00       $0.00              $0.00     $0.00    #DIV/0!           $0.00         #DIV/0!

    $0.00       $0.00              $0.00     $0.00    #DIV/0!           $0.00         #DIV/0!



                                              0.00    #DIV/0!            0.00         #DIV/0!
     0.00        0.00               0.00      0.00    #DIV/0!            0.00         #DIV/0!
    $0.00       $0.00              $0.00     $0.00    #DIV/0!           $0.00         #DIV/0!


     0.00        0.00               0.00      0.00    #DIV/0!            0.00         #DIV/0!
                                              0.00    #DIV/0!            0.00         #DIV/0!
0           0                  0              0.00    #DIV/0!     0                   #DIV/0!
                                              0.00    #DIV/0!            0.00         #DIV/0!
    $0.00       $0.00              $0.00     $0.00    #DIV/0!           $0.00         #DIV/0!
$0.00   $0.00   $0.00   $0.00   #DIV/0!   $0.00   #DIV/0!

$0.00   $0.00   $0.00   $0.00   #DIV/0!   $0.00   #DIV/0!
            2016
    Total          % of Sales

      $0.00         #DIV/0!
       0.00         #DIV/0!
       0.00         #DIV/0!
      $0.00         #DIV/0!


       0.00         #DIV/0!
       0.00         #DIV/0!
       0.00         #DIV/0!
      $0.00         #DIV/0!

      $0.00         #DIV/0!


       0.00         #DIV/0!
       0.00         #DIV/0!
       0.00         #DIV/0!
       0.00         #DIV/0!
       0.00         #DIV/0!
       0.00         #DIV/0!
       0.00         #DIV/0!
       0.00         #DIV/0!
       0.00         #DIV/0!
       0.00         #DIV/0!
       0.00         #DIV/0!
       0.00         #DIV/0!
       0.00         #DIV/0!
       0.00         #DIV/0!
       0.00         #DIV/0!
       0.00         #DIV/0!
       0.00         #DIV/0!
      $0.00         #DIV/0!

      $0.00         #DIV/0!



       0.00         #DIV/0!
       0.00         #DIV/0!
      $0.00         #DIV/0!


       0.00         #DIV/0!
       0.00         #DIV/0!
0                   #DIV/0!
       0.00         #DIV/0!
      $0.00         #DIV/0!
$0.00   #DIV/0!

$0.00   #DIV/0!
UW Bothell (Company Name)
Projected Balance Sheet
2012 - 2014



                                            2012     2013      2014          2015
Assets
    Current Assets
        Cash, Checking                       $0.00     $0.00     $0.00         $0.00
        Money Market, Securities
        Accounts Receivable, net              0.00     $0.00     $0.00         $0.00
        Inventories                           0.00      0.00      0.00          0.00
        Prepaid Expenses                      0.00      0.00      0.00          0.00
    Total Current Assets                      0.00      0.00      0.00          0.00

    Long Term Assets
        Land
        Buildings
        Patents
        Equipment
        Accum Depreciation & Amortization     0.00      0.00      0.00          0.00
    Total Long Term Assets                    0.00      0.00      0.00          0.00

Total Assets                                  0.00      0.00      0.00          0.00


Liabilities and Equity
     Current Liabilities
           Accounts Payable                   0.00      0.00      0.00          0.00
           Accrued Expenses Payable           0.00      0.00      0.00   0
           Payroll Taxes Payable              0.00      0.00      0.00          0.00
     Total Current Liabilities                0.00      0.00      0.00          0.00

    Long Term Liabilities
        Long Term Bank Loans
        Long Term Loans (fff)
        Repayment of Loans
    Total Long Term Liabilities               0.00      0.00      0.00          0.00

Equity
        Capital Stock
        Current Year Retained Earnings       $0.00     $0.00     $0.00         $0.00
        Retained Earnings                              $0.00      0.00         $0.00
    Total Equity                              0.00      0.00      0.00          0.00

Total Liabilities and Equity                  0.00      0.00      0.00          0.00
Debt/Asset Ratio:           #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!

Working Capital:                 0.00        0.00        0.00        0.00

Working Capital Ratio:      #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!

Sales to Working Capital:   #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!
    2016


      $0.00

      $0.00
       0.00
       0.00
       0.00




       0.00
       0.00

       0.00




       0.00
0
       0.00
       0.00




       0.00




      $0.00
       0.00
       0.00

       0.00
#DIV/0!

     0.00

#DIV/0!

#DIV/0!
UW Bothell (Company Name)
Projected Statement of Cash Flows
2012 - 2014



                                                  2012      2013      2014
Cash Flows from Operating Activities:
     Net Income                                    $0.00     $0.00     $0.00
     Adjustments to reconcile net income to
     net cash provided by operating activities:
          Depreciation & Amortization               $0.00     0.00      0.00
          (Increase)/Decrease in:
          Accounts Receivable                       $0.00    $0.00     $0.00
          Prepaid Expenses                          $0.00     0.00      0.00
          Inventories                               $0.00     0.00      0.00
          Increase/(Decrease) in:
          Accounts Payable                          $0.00     0.00      0.00
          Accrued Expenses Payable                  $0.00     0.00      0.00
          Payroll Taxes Payable                     $0.00     0.00      0.00
     Net Cash Provided by Operating Activities:     $0.00     $0.00     $0.00

     Cash Flows from Investing Activities:
          Purchase of Land                          $0.00      0.00      0.00
          Purchase of Buildings                     $0.00      0.00      0.00
          Purchase of Patents                       $0.00      0.00      0.00
          Purchase of Equipment                     $0.00     $0.00     $0.00
     Net Cash Used by Investing Activities:         $0.00     $0.00     $0.00

     Cash Flows from Financing Activities:
          Proceeds from Bank Loans                  $0.00     0.00      0.00
          Proceeds from Loans (fff)                 $0.00     0.00      0.00
          Repayment of Bank Loans                   $0.00     0.00      0.00
          Proceeds from Stock Sales                 $0.00     0.00      0.00
          Payment of Dividends to Shareholders
     Net Cash Used by Financing Activities:         $0.00     $0.00     $0.00

     Net Increase/(Decrease) in Cash:               $0.00     $0.00     $0.00

     Cash at the Beginning of the Year              $0.00    $0.00     $0.00

     Cash at the End of the Year                    $0.00     $0.00     $0.00
2015      2016

 $0.00     $0.00


  0.00      0.00

 $0.00     $0.00
  0.00      0.00
  0.00      0.00

  0.00      0.00
  0.00      0.00
  0.00      0.00
  $0.00     $0.00



  $0.00     $0.00
  $0.00     $0.00
  $0.00     $0.00
  $0.00     $0.00
  $0.00     $0.00



  0.00      0.00
  0.00      0.00
  0.00      0.00
  0.00      0.00

  $0.00     $0.00

  $0.00     $0.00

 $0.00     $0.00

  $0.00     $0.00

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:5/16/2012
language:
pages:40
fanzhongqing fanzhongqing http://
About