Docstoc

Financial_projection_worksheet_template

Document Sample
Financial_projection_worksheet_template Powered By Docstoc
					Sample Wage Analysis worksheet
Monthly wage analysis

                                                                                                                        Goal
                                                      weekly       weely                                 weekly        weekly
     Teacher                      rate per hour       hours       OT hours              OT rate        gross wage    gross wage

                                  $          8.60       33.25                       $      12.90       $   285.95    $   285.95
                                  $          8.25          40         8             $      12.38       $   429.00    $   330.00
                                  $          8.00          40         6             $      12.00       $   392.00    $   320.00
                                  $         10.25        22.5                       $      15.38       $   230.63    $   230.63
                                  $         10.00          40         6             $      15.00       $   490.00    $   400.00
                                  $          8.50       33.25                       $      12.75       $   282.63    $   282.63
                                  $          8.75          35                       $      13.13       $   306.25    $   306.25
                                  $          8.75          40         6             $      13.13       $   428.75    $   350.00
                                  $          7.50          35                       $      11.25       $   262.50    $   262.50
                                  $          8.25          30                       $      12.38       $   247.50    $   247.50
     Floater staff                $          8.50         31                        $      12.75                     $   263.50

                                  $          7.50          40         5             $      11.25       $   356.25    $   300.00
                                  $          7.50        32.5                       $      11.25       $   243.75    $   243.75
                                                                     31
                 total normal work hours summer           389          Summer bi-weekly payroll:       $ 7,942.50    $ 7,658.95    $ 283.55
                     Total normal work hours school     381.5             School bi-weekly payroll:    $ 7,701.75    $ 7,538.58    $ 163.17
                                                          420
     total hours needed each week:                       420                 summer monthly total      $ 15,885.01   $ 15,317.91
     hours not covered right now:                         -31                   Scholl monlyt total:   $ 15,403.51   $ 15,077.16

                                                              average OT rate:      $      12.87
                                                           average hourly rate:     $       8.58

                                                                      March gross wages:               $ 16,432.00
                                                                    Amount for normal pay:                  14,725
                                                                     Amount paid for OT:               $ 1,706.97
                                                               Hours of OT for the month:                      133
                                                       Hours of OT each week on average;                        29

1)   Need to add a floater part-time staff that can fill in to ensure no one works OT in a week.
2)   Need to implement a policy of zero OT - this means that staff are not allowed to work OT with out
     approval. If they see that they are about to reach 40 hours, they must inform Irma.
3)   How is staff scheduling done? Need to implement a process where owner can quickly see if a staff
     will go over the 40 hours, so that she can bring in a floater later in the week to fill in.
Sample Weekly Cash Flow worksheet
Weekly Cash flow budget

Summer cash flow:
                                         Week 5 - 1   Week 2    Week 3      Week 4     Week 5 -1       total

Cash Inflows:
                  Parent paid tuition       14,723      1,945      6,225       2,245        2,105      27,243
             CCS from prior month:                                   500                      500       1,000
         city subsidy from prior mth:          200                                                        200
                      Food subsidy:                                  800                                  800
                                            14,923      1,945      7,525       2,245        2,605      29,243

Cash Outflows:
                  Salaries, gross:           7,659                 7,659                               15,318
                     payroll taxes:            613                   613                                1,225
          Mortgage loan payment:             1,272                                                      1,272
       2nd mortgage loan payment:                                    554                                  554
                    Debt payment             1,350                                                      1,350
                Van loan payment               480                                                        480

       Food and supplies for center            500       500         500         500          500       2,500
                                                                                                          -
                        Accounting                                               450                      450
     Additional accounting payment                                               400                      400
                             Utilities         450                                                        450
                 Cell phone & other            185                                                        185
           property taxes to escrow            400                                                        400
                        pest control                     103                                              103
                          insurance                                              360                      360
                                                                                                          -
                     Owners draws              500       -                       500          500       1,500
                             Other             500       500                                  500       1,500
  Cash transfer to savings account                                                          1,000       1,000

           Total outflows:                  13,908      1,103      9,326       2,210        2,500      29,047


Cash balance:                                1,015      1,857         56          91          196           196

Goal: to create an operating reserve (cash in savings account) of $10K over the next 12 months.
            Should be able to put $1K into savings on the last week of each month in order to do this.
            Creating this reserve is very important to ensure that Center is able to cover all unexpected
            costs, both personal and business.
Projection Worksheet (Template)
Profit & Loss                                                                                     Orange cells require input. All other cells are formulas and should not be adjusted.
Projections                                                                                       Purple cells are generated from assumptions in another worksheet

                                             Actual                                                                                               2005
                                         as of YE 2004             Jan        Feb        Mar           Apr            May             Jun           Jul            Aug           Sep       Oct         Nov        Dec          Total
Ordinary Income/Expense
       Tuition
           Total tuition                                                                                                                                                                                                   $       -
           Special events & activities                                                                                                                                                                                             -
           Annual supply fee                                                                                                                                                                                                       -
           Food program subsidy                                                                                                                                                                                                    -
           Refunds                                                                                                                                                                                                                 -
       Total Income                               -                   -          -          -                -              -               -             -            -             -           -        -          -             -

Cost of Goods Sold
       Teacher wages (gross)                             #####   #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!
       Payroll tax expense (employeer)                   #####      1,400      1,400      1,400        1,400          1,400           1,400          1,400         1,400         1,400      1,400       1,400      1,400     16,800
       Food                                              #####   #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!
       Outside services                                  #####                            2,000                                                                                                                               2,000
       Paper products & other supplies                   #####   #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!
Total Cost of goods sold                          -      #####   #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!
                     Gross Profit                 -      #####   #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!
Expense
      Facility costs
          Rent                                                                                                                                                                                                                     -
          Property taxes                                                                                                                                                                                                           -
          Repairs and maintenance
                     Building repairs                                                                                                                                                                                              -
                     Equipment repairs                                                                                                                                                                                             -
                     Maintenance                                                                                                                                                                                                   -
           Total R&M                              -                   -          -          -                -              -               -             -            -             -           -        -          -             -
           Telephone
                     Cell phone                                                                                                                                                                                                    -
                     other                                                                                                                                                                                                         -
           Total telephone                        -                   -          -          -                -              -               -             -            -             -           -        -          -             -
           Utilities
                     Gas & Electric                                                                                                                                                                                                -
                     Grease Disposal                                                                                                                                                                                               -
           Total Utilities                        -                   -          -          -                -              -               -             -            -             -           -        -          -             -
           Cleaning supplies                                                                                                                                                                                                       -
           Pest control                                                                                                                                                                                                            -




                                                                                                                 Full fs projection worksheet
Projection Worksheet (Template)
Profit & Loss                                                       Orange cells require input. All other cells are formulas and should not be adjusted.
Projections                                                         Purple cells are generated from assumptions in another worksheet

                                      Actual                                                                        2005
                                  as of YE 2004   Jan   Feb   Mar        Apr            May             Jun           Jul            Aug           Sep     Oct       Nov   Dec   Total
          Office costs                                                                                                                                                               -
      Total Facility Expense               -        -     -     -              -              -               -             -            -             -         -     -     -       -
      Insurance
          Insurance - liability                                                                                                                                                      -
      Total Insurance Expense              -        -     -     -              -              -               -             -            -             -         -     -     -       -

      Educational Supplies
          Educational supplies                                                                                                                                                       -
      Total Supply Expense                 -        -     -     -              -              -               -             -            -             -         -     -     -       -

      Bank charges
          ATM Fees                                                                                                                                                                   -
          Return deposit fees                                                                                                                                                        -
          Service charges                                                                                                                                                            -
      Total Bank charges                   -        -     -     -              -              -               -             -            -             -         -     -     -       -

      Marketing and promotions
          Advertising                      -                                                                                                                                         -
          Collateral costs                                                                                                                                                           -
      Total Advertising Expense            -        -     -     -              -              -               -             -            -             -         -     -     -       -




                                                                                   Full fs projection worksheet
Projection Worksheet (Template)
Profit & Loss                                                                             Orange cells require input. All other cells are formulas and should not be adjusted.
Projections                                                                               Purple cells are generated from assumptions in another worksheet

                                              Actual                                                                                      2005
                                          as of YE 2004     Jan         Feb       Mar          Apr            May             Jun           Jul            Aug           Sep       Oct        Nov       Dec       Total
       Other operating expenses
           Automobile fuel costs                                                                                                                                                                                      -
           Meals                                                                                                                                                                                                      -
           Dues and subscriptions                                                                                                                                                                                     -
           Gifts                                                                                                                                                                                                      -
           Licenses and permits                                                                                                                                                                                       -
           Misc                                                                                                                                                                                                       -
           Postage and delivery                                                                                                                                                                                       -
           Franchise tax                                                                                                                                                                                              -
           Professional fees                                                                                                                                                                                          -
       Total Other operating expenses              -           -          -         -                -              -               -             -            -             -           -       -         -          -

       Interest Expense
           Loan Interest                           -                                                                                                                                                                  -
                    CDC loan                                                                                                                                                                                          -
                    Other bank loans                                                                                                                                                                                  -
                    Owner financed loan                                                                                                                                                                               -
       Total Interest Expense                      -           -          -         -                -              -               -             -            -             -           -       -         -          -

Total Expense                                      -           -          -         -                -              -               -             -            -             -           -       -         -          -

Total Operating net income (loss)                  -      #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!

Other Income:                                                                                                                                                                                                         -

Net Income                                    $    -      #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!
Operating Activities
       Change in current assets                                                                                                                                                                                      -
       Change in current liabilities                                                                                                                                                                                 -
Net Cash-flow from operating activities            -      #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!

Investing Activities
       Purchase of fixed assets
           Building purchase & Improvements                 (1,000)                                                                                                                                                (1,000)
                                                                                                                                                                                                                      -
Net Cash used in Investing Activities                       (1,000)       -         -                -              -               -             -            -             -           -       -         -       (1,000)




                                                                                                         Full fs projection worksheet
Projection Worksheet (Template)
Profit & Loss                                                                                                    Orange cells require input. All other cells are formulas and should not be adjusted.
Projections                                                                                                      Purple cells are generated from assumptions in another worksheet

                                                       Actual                                                                                                    2005
                                                   as of YE 2004               Jan         Feb         Mar            Apr            May             Jun           Jul            Aug             Sep           Oct           Nov            Dec        Total
Financing Activities
      Principal paid on LT debt
           Outstanding loans                                                     -            -           -                                                                                                                                                 -
           Existing bank loans                                                                                                                                                                                                                              -
           Owner financed debt                                                                                                                                                                                                                              -
                                                                                 -            -           -                 -              -               -             -            -               -               -           -              -          -
       Cash from borrowing                                                                                                                                                                                                                                  -
       Payments on Past payroll tax                                                                                                                                                                                                                         -
       Owners Draws                                                                                                                                                                                                                                         -
       Owners contributions                                                                                                                                                                                                                                 -
Net Cash from Financing Activities                            -                  -            -           -                 -              -               -             -            -               -               -           -              -          -

Net Cash Increase for period                                  -              #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!

Beginning Cash Balance                                        -                          #DIV/0!     #DIV/0!       #DIV/0!        #DIV/0!         #DIV/0!        #DIV/0!       #DIV/0!          #DIV/0!      #DIV/0!        #DIV/0!         #DIV/0!         -

Ending Cash Balance                                 $         -              #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!



Break Even Analysis:
                     total contribution margin:         #DIV/0!                                                                                                                                                           total contribution margin:   #DIV/0!


                     total overhead cost                       -                                                                                                                                                          total overhead cost               -
                     Add in owners salary                  30,000                                                                                                                         Add in owners salary+ tax and debt payments                       -
                     total overhead:                       30,000                                                                                                                                                         total overhead:                   -


               Sales required to Break even:            #DIV/0!                                                                                                                                       Sales required to Break even:                    #DIV/0!




                                                        Total loan payment    #REF!       #REF!       #REF!         #REF!          #REF!           #REF!          #REF!          #REF!           #REF!        #REF!          #REF!           #REF!
                                                     Rent in old location:           -           -           -              -              -               -          -                 -               -             -             -              -
                                                  Additional cash outflow:                                                                                        #REF!




                                                                                                                                Full fs projection worksheet
Projection Worksheet (Template)
Profit & Loss
Projections

                                             Actual
                                         as of YE 2004
Ordinary Income/Expense
       Tuition
           Total tuition
           Special events & activities
           Annual supply fee
           Food program subsidy
           Refunds
       Total Income                               -

Cost of Goods Sold
       Teacher wages (gross)
       Payroll tax expense (employeer)
       Food
       Outside services
       Paper products & other supplies
Total Cost of goods sold                          -
                     Gross Profit                 -

Expense
      Facility costs
          Rent
          Property taxes
          Repairs and maintenance
                     Building repairs
                     Equipment repairs
                     Maintenance
           Total R&M                              -
           Telephone
                     Cell phone
                     other
           Total telephone                        -
           Utilities
                     Gas & Electric
                     Grease Disposal
           Total Utilities                        -
           Cleaning supplies
           Pest control




                                                         Full fs projection worksheet
Projection Worksheet (Template)
Profit & Loss
Projections

                                       Actual
                                   as of YE 2004
Ordinary Income/Expense
           Office costs
       Total Facility Expense               -
       Insurance
           Insurance - liability
       Total Insurance Expense              -

       Educational Supplies
           Educational supplies
       Total Supply Expense                 -

       Bank charges
           ATM Fees
           Return deposit fees
           Service charges
       Total Bank charges                   -

       Marketing and promotions
           Advertising                      -
           Collateral costs
       Total Advertising Expense            -




                                                   Full fs projection worksheet
Projection Worksheet (Template)
Profit & Loss
Projections

                                              Actual
                                          as of YE 2004
Ordinary Income/Expense
       Other operating expenses
           Automobile fuel costs
           Meals
           Dues and subscriptions
           Gifts
           Licenses and permits
           Misc
           Postage and delivery
           Franchise tax
           Professional fees
       Total Other operating expenses              -

       Interest Expense
           Loan Interest                           -
                    CDC loan
                    Other bank loans
                    Owner financed loan
       Total Interest Expense                      -

Total Expense                                      -

Total Operating net income (loss)                  -

Other Income:

Net Income                                    $    -
Operating Activities
       Change in current assets
       Change in current liabilities
Net Cash-flow from operating activities            -

Investing Activities
       Purchase of fixed assets
           Building purchase & Improvements

Net Cash used in Investing Activities




                                                          Full fs projection worksheet
Projection Worksheet (Template)
Profit & Loss
Projections

                                                       Actual
                                                   as of YE 2004
Ordinary Income/Expense
Financing Activities
       Principal paid on LT debt
           Outstanding loans
           Existing bank loans
           Owner financed debt


       Cash from borrowing
       Payments on Past payroll tax
       Owners Draws
       Owners contributions
Net Cash from Financing Activities                            -

Net Cash Increase for period                                  -

Beginning Cash Balance                                        -

Ending Cash Balance                                 $         -



Break Even Analysis:
                     total contribution margin:         #DIV/0!


                     total overhead cost                       -
                     Add in owners salary                  30,000
                     total overhead:                       30,000


               Sales required to Break even:            #DIV/0!




                                                        Total loan payment
                                                     Rent in old location:
                                                  Additional cash outflow:




                                                                             Full fs projection worksheet
Revenue Projection worksheet

          Current enrollment                                             Addition of Afterschool program
                                          Full time       Afterschool                              Full time      Afterschool
          Age range                      Monthly fee      Monthly fee    Age range                Monthly fee     Monthly fee

          Infants - 12 months                      540                   Infants - 12 months                540
          12 months - 17 months                    500                   12 months - 17 months              500
          18 months - 23 months                    480                   18 months - 23 months              480
          2 years                                  460             145   2 years                            460            145
          3 & up                                   420             145   3 & up                             420            145
          3 & sibling discount          n/a                              3 & sibling discount     n/a
          Summer school age                        400                   Summer school age                  400

          Enrollment breakdown:                                          Enrollment breakdown:
                                        # of students    # of students                         # of students # of students
          Infants - 12 months                        6                   Infants - 12 months                6
          12 months - 17 months                      5                   12 months - 17 months              5
          18 months - 23 months                     11                   18 months - 23 months            11
          2 years                                   12                   2 years                          12
          3 & up                                    33               9   3 & up                           33              9
          3 & sibling discount                       0                   3 & sibling discount               0
          Summer school age                          0                   Summer school age                  9
                                                    76                                                    76
          Monthly revenue stream                                         Monthly revenue stream

          Infants - 12 months                   3,240             -      Infants - 12 months             3,240            -
          12 months - 17 months                 2,500             -      12 months - 17 months           2,500            -
          18 months - 23 months                 2,500             -      18 months - 23 months           2,500            -
          2 years                               5,520             -      2 years                         5,520            -
          3 & up                               12,474           1,305    3 & up                         12,474          1,305
          3 & sibling discount                    -               -      3 & sibling discount                             -
                                               26,234           1,305                                   26,234          1,305
          Monthly total:                       27,539                    Monthly total:                 27,539
          Summer reveune adj                   (1,305)                   Summer reveune adj              2,295
          Summer monthly total                 26,234                    Summer monthly total           29,834


          Special programs                                               Special programs
                                          Dance fee total potential                                   Dance fee total potential
          2 yrs and up                  $      15.00             45      2 yrs and up                $    15.00             45
          # of students participating             14                     # of students participating          14
          total monthly revenue:        $     210.00                     total monthly revenue:      $   210.00
Outstanding Term Loan


              Loan Amount:                 60,625
                    Principle :     $      60,625
               Date borrowed:             5/1/2003
                        Term:                   60 months
                         Rate:                11%
                    daily rate:             0.03%
    Required monthly payment:       $    1,349.58                                                                  Required monthly p




                                                                    Original amort
                 Date               Prin balance     Payment        Interest      Principle

             1           1/1/2004           58,882                  $      539.75
             2           2/1/2004           58,882                  $      539.75
             3           3/1/2004           58,882                  $      539.75
             4           4/1/2004           58,882                  $      539.75
             5           5/1/2004           62,552   $   1,349.58   $      573.39   $     776.19
             6           6/1/2004           61,776   $   1,349.58   $      566.28   $     783.30
             7           7/1/2004           60,992   $   1,349.58   $      559.10   $     790.48
             8           8/1/2004           60,202   $   1,349.58   $      551.85   $     797.73
             9           9/1/2004           59,404   $   1,349.58   $      544.54   $     805.04
            10          10/1/2004           58,599   $   1,349.58   $      537.16   $     812.42
            11          11/1/2004           57,787   $   1,349.58   $      529.71   $     819.87
            12          12/1/2004           56,967   $   1,349.58   $      522.19   $     827.39
            13           1/1/2005           56,139   $   1,349.58   $      514.61   $     834.97
            14           2/1/2005           55,304   $   1,349.58   $      506.96   $     842.62
            15           3/1/2005           54,462   $   1,349.58   $      499.23   $     850.35
            16           4/1/2005           53,611   $   1,349.58   $      491.44   $     858.14
            17           5/1/2005           52,753   $   1,349.58   $      483.57   $     866.01
            18           6/1/2005           51,887   $   1,349.58   $      475.63   $     873.95
            19           7/1/2005           51,013   $   1,349.58   $      467.62   $     881.96
            20           8/1/2005           50,131   $   1,349.58   $      459.54   $     890.04   $   19,027.32
            21           9/1/2005           49,241   $   1,349.58   $      451.38   $     898.20
            22          10/1/2005           48,343   $   1,349.58   $      443.14   $     906.44
            23          11/1/2005           47,437   $   1,349.58   $      434.84   $     914.74
            24          12/1/2005           46,522   $   1,349.58   $      426.45   $     923.13
            25           1/1/2006           45,599   $   1,349.58   $      417.99   $     931.59
            26           2/1/2006           44,667   $   1,349.58   $      409.45   $     940.13
            27           3/1/2006           43,727   $   1,349.58   $      400.83   $     948.75
            28           4/1/2006           42,778   $   1,349.58   $      392.13   $     957.45
            29           5/1/2006           41,821   $   1,349.58   $      383.36   $     966.22
            30           6/1/2006           40,855   $   1,349.58   $      374.50   $     975.08
            31           7/1/2006           39,880   $   1,349.58   $      365.56   $     984.02
            32           8/1/2006           38,895   $   1,349.58   $      356.54   $     993.04   $   16,543.95
            33           9/1/2006           37,902   $   1,349.58   $      347.44   $   1,002.14
            34          10/1/2006           36,900   $   1,349.58   $      338.25   $   1,011.33
            35          11/1/2006           35,889   $   1,349.58   $      328.98   $   1,020.60
            36          12/1/2006           34,868   $   1,349.58   $      319.63   $   1,029.95
            37           1/1/2007           33,838   $   1,349.58   $      310.19   $   1,039.39
            38           2/1/2007           32,799   $   1,349.58   $      300.66   $   1,048.92
            39           3/1/2007           31,750   $   1,349.58   $      291.04   $   1,058.54
            40           4/1/2007           30,692   $   1,349.58   $      281.34   $   1,068.24
41    5/1/2007   29,623   $   1,349.58   $   271.55   $   1,078.03
42    6/1/2007   28,545   $   1,349.58   $   261.67   $   1,087.91
43    7/1/2007   27,457   $   1,349.58   $   251.69   $   1,097.89
44    8/1/2007   26,360   $   1,349.58   $   241.63   $   1,107.95
45    9/1/2007   25,252   $   1,349.58   $   231.47   $   1,118.11
46   10/1/2007   24,133   $   1,349.58   $   221.22   $   1,128.36
47   11/1/2007   23,005   $   1,349.58   $   210.88   $   1,138.70
48   12/1/2007   21,866   $   1,349.58   $   200.44   $   1,149.14
49    1/1/2008   20,717   $   1,349.58   $   189.91   $   1,159.67
50    2/1/2008   19,558   $   1,349.58   $   179.28   $   1,170.30
51    3/1/2008   18,387   $   1,349.58   $   168.55   $   1,181.03
52    4/1/2008   17,206   $   1,349.58   $   157.72   $   1,191.86
53    5/1/2008   16,014   $   1,349.58   $   146.80   $   1,202.78
54    6/1/2008   14,812   $   1,349.58   $   135.77   $   1,213.81
55    7/1/2008   13,598   $   1,349.58   $   124.65   $   1,224.93
56    8/1/2008   12,373   $   1,349.58   $   113.42   $   1,236.16
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
                   Bof A loan - Previous mortgage
                   & Bank one loan - vehicle loan
                                                                                                 Principle :       176,000
                                                                                           Date borrowed:          5/1/2003
                                                                                                     Term:              300
                     Rate:            9% est mix                                                      Rate:             7%
                daily rate:        0.03%                                                         daily rate:            0%
Required monthly payment:         1033.09                                        Required monthly payment:           1,272




                   Existing other bank loan: B of A & Bank One                                      Owner financing
                   Date       Prin balance Payment Interest    Principle                            Date      Prin balance

               1      1/1/2004      25,855    $   1,033.09   $   193.91    $     839.18         1      1/1/2004     176,000
               2      2/1/2004      25,016    $   1,033.09   $   187.62    $     845.47         2      2/1/2004     175,755
               3      3/1/2004      24,170    $   1,033.09   $   181.28    $     851.81         3      3/1/2004     175,508
               4      4/1/2004      23,319    $   1,033.09   $   174.89    $     858.20         4      4/1/2004     175,259
               5      5/1/2004      22,460    $   1,033.09   $   168.45    $     864.64         5      5/1/2004     175,009
               6      6/1/2004      21,596    $   1,033.09   $   161.97    $     871.12         6      6/1/2004     174,758
               7      7/1/2004      20,725    $   1,033.09   $   155.43    $     877.66         7      7/1/2004     174,506
               8      8/1/2004      19,847    $   1,033.09   $   148.85    $     884.24         8      8/1/2004     174,251
               9      9/1/2004      18,963    $   1,033.09   $   142.22    $     890.87         9      9/1/2004     173,996
              10     10/1/2004      18,072    $   1,033.09   $   135.54    $     897.55        10     10/1/2004     173,738
              11     11/1/2004      17,174    $   1,033.09   $   128.81    $     904.28        11     11/1/2004     173,480
              12     12/1/2004      16,270    $   1,033.09   $   122.02    $     911.07        12     12/1/2004     173,220
              13      1/1/2005      15,359    $   1,033.09   $   115.19    $     917.90        13      1/1/2005     172,958
              14      2/1/2005      14,441    $   1,033.09   $   108.31    $     924.78        14      2/1/2005     172,695
              15      3/1/2005      13,516    $   1,033.09   $   101.37    $     931.72        15      3/1/2005     172,430
              16      4/1/2005      12,585    $   1,033.09   $    94.38    $     938.71        16      4/1/2005     172,164
              17      5/1/2005      11,646    $   1,033.09   $    87.34    $     945.75        17      5/1/2005     171,896
              18      6/1/2005      10,700    $   1,033.09   $    80.25    $     952.84        18      6/1/2005     171,626
              19      7/1/2005       9,747    $   1,033.09   $    73.10    $     959.99        19      7/1/2005     171,355
              20      8/1/2005       8,787    $   1,033.09   $    65.90    $     967.19        20      8/1/2005     171,083
              21      9/1/2005       7,820    $   1,033.09   $    58.65    $     974.44        21      9/1/2005     170,809
              22     10/1/2005       6,846    $   1,033.09   $    51.34    $     981.75        22     10/1/2005     170,533
              23     11/1/2005       5,864    $   1,033.09   $    43.98    $     989.11        23     11/1/2005     170,256
              24     12/1/2005       4,875    $   1,033.09   $    36.56    $     996.53        24     12/1/2005     169,977
              25      1/1/2006       3,878    $   1,033.09   $    29.09    $   1,004.00        25      1/1/2006     169,696
              26      2/1/2006       2,874    $   1,033.09   $    21.56    $   1,011.53        26      2/1/2006     169,414
              27      3/1/2006       1,863    $   1,033.09   $    13.97    $   1,019.12        27      3/1/2006     169,130
              28      4/1/2006         844    $   1,033.09   $     6.33    $   1,026.76        28      4/1/2006     168,844
              29      5/1/2006        (183)   $   1,033.09   $    (1.37)   $   1,034.46        29      5/1/2006     168,557
              30      6/1/2006      (1,218)   $   1,033.09   $    (9.13)   $   1,042.22        30      6/1/2006     168,268
              31      7/1/2006      (2,260)   $   1,033.09   $   (16.95)   $   1,050.04        31      7/1/2006     167,978
              32      8/1/2006      (3,310)   $   1,033.09   $   (24.82)   $   1,057.91        32      8/1/2006     167,685
              33      9/1/2006      (4,368)   $   1,033.09   $   (32.76)   $   1,065.85        33      9/1/2006     167,391
              34     10/1/2006      (5,434)   $   1,033.09   $   (40.75)   $   1,073.84        34     10/1/2006     167,096
                     11/1/2006      (6,508)   $   1,033.09   $   (48.81)   $   1,081.90        35     11/1/2006     166,798
                     12/1/2006      (7,589)   $   1,033.09   $   (56.92)   $   1,090.01        36     12/1/2006     166,499
                      1/1/2007      (8,679)   $   1,033.09   $   (65.10)   $   1,098.19        37      1/1/2007     166,198
                      2/1/2007                                                                 38      2/1/2007     165,896
                      3/1/2007                                                                 39      3/1/2007     165,591
                      4/1/2007                                                                 40      4/1/2007     165,285
 5/1/2007   41    5/1/2007   164,977
 6/1/2007   42    6/1/2007   164,667
 7/1/2007   43    7/1/2007   164,356
 8/1/2007   44    8/1/2007   164,042
 9/1/2007   45    9/1/2007   163,727
10/1/2007   46   10/1/2007   163,410
11/1/2007   47   11/1/2007   163,091
12/1/2007   48   12/1/2007   162,770
 1/1/2008   49    1/1/2008   162,448
 2/1/2008   50    2/1/2008   162,123
 3/1/2008   51    3/1/2008   161,797
            52    4/1/2008   161,468
            53    5/1/2008   161,138
            54    6/1/2008   160,806
            55    7/1/2008   160,472
            56    8/1/2008   160,136
            57    9/1/2008   159,798
            58   10/1/2008   159,458
            59   11/1/2008   159,116
            60   12/1/2008   158,772
            61    1/1/2009   158,426
            62    2/1/2009   158,078
            63    3/1/2009   157,728
            64    4/1/2009   157,376
            65    5/1/2009   157,022
            66    6/1/2009   156,665
            67    7/1/2009   156,307
            68    8/1/2009   155,947
            69    9/1/2009   155,584
            70   10/1/2009   155,220
            71   11/1/2009   154,853
            72   12/1/2009   154,484
            73    1/1/2010   154,113
            74    2/1/2010   153,740
            75    3/1/2010   153,365
            76    4/1/2010   152,987
            77    5/1/2010   152,608
            78    6/1/2010   152,226
            79    7/1/2010   151,842
            80    8/1/2010   151,455
            81    9/1/2010   151,067
            82   10/1/2010   150,676
            83   11/1/2010   150,282
            84   12/1/2010   149,887
            85    1/1/2011   149,489
            86    2/1/2011   149,089
            87    3/1/2011   148,687
            88    4/1/2011   148,282
            89    5/1/2011   147,875
            90    6/1/2011   147,465
            91    7/1/2011   147,053
            92    8/1/2011   146,639
            93    9/1/2011   146,222
94    10/1/2011   145,803
95    11/1/2011   145,381
96    12/1/2011   144,957
97     1/1/2012   144,531
98     2/1/2012   144,102
99     3/1/2012   143,670
100    4/1/2012   143,236
101    5/1/2012   142,799
102    6/1/2012   142,360
103    7/1/2012   141,919
104    8/1/2012   141,474
105    9/1/2012   141,027
106   10/1/2012   140,578
107   11/1/2012   140,126
108   12/1/2012   139,671
109    1/1/2013   139,214
110    2/1/2013   138,754
111    3/1/2013   138,291
112    4/1/2013   137,825
113    5/1/2013   137,357
114    6/1/2013   136,886
115    7/1/2013   136,413
116    8/1/2013   135,936
117    9/1/2013   135,457
118   10/1/2013   134,975
119   11/1/2013   134,490
120   12/1/2013   134,003
121    1/1/2014   133,512
122    2/1/2014   133,019
123    3/1/2014   132,523
124    4/1/2014   132,024
125    5/1/2014   131,522
126    6/1/2014   131,017
127    7/1/2014   130,509
128    8/1/2014   129,998
129    9/1/2014   129,484
130   10/1/2014   128,967
131   11/1/2014   128,448
132   12/1/2014   127,925
133    1/1/2015   127,399
134    2/1/2015   126,870
135    3/1/2015   126,338
136    4/1/2015   125,803
137    5/1/2015   125,264
138    6/1/2015   124,723
139    7/1/2015   124,178
140    8/1/2015   123,631
141    9/1/2015   123,080
142   10/1/2015   122,525
143   11/1/2015   121,968
144   12/1/2015   121,407
145    1/1/2016   120,843
146    2/1/2016   120,276
147    3/1/2016   119,706
148    4/1/2016   119,132
149    5/1/2016   118,555
150    6/1/2016   117,974
151    7/1/2016   117,390
152    8/1/2016   116,803
153    9/1/2016   116,212
154   10/1/2016   115,618
155   11/1/2016   115,020
156   12/1/2016   114,419
157    1/1/2017   113,814
158    2/1/2017   113,206
159    3/1/2017   112,594
160    4/1/2017   111,979
161    5/1/2017   111,360
162    6/1/2017   110,737
163    7/1/2017   110,111
164    8/1/2017   109,481
165    9/1/2017   108,848
166   10/1/2017   108,211
167   11/1/2017   107,570
168   12/1/2017   106,925
169    1/1/2018   106,277
170    2/1/2018   105,624
171    3/1/2018   104,968
172    4/1/2018   104,309
173    5/1/2018   103,645
174    6/1/2018   102,977
175    7/1/2018   102,306
176    8/1/2018   101,631
177    9/1/2018   100,951
178   10/1/2018   100,268
179   11/1/2018    99,581
180   12/1/2018    98,889
with balloon at 15 years
Variable rate 3+ market

payment required at 7%




Payment        Interest       Principle

$   1,272.14   $   1,026.67   $   245.47
$   1,272.14   $   1,025.23   $   246.91
$   1,272.14   $   1,023.79   $   248.35
$   1,272.14   $   1,022.35   $   249.79
$   1,272.14   $   1,020.89   $   251.25
$   1,272.14   $   1,019.42   $   252.72
$   1,272.14   $   1,017.95   $   254.19
$   1,272.14   $   1,016.47   $   255.67
$   1,272.14   $   1,014.97   $   257.17
$   1,272.14   $   1,013.47   $   258.67
$   1,272.14   $   1,011.97   $   260.17
$   1,272.14   $   1,010.45   $   261.69
$   1,272.14   $   1,008.92   $   263.22
$   1,272.14   $   1,007.39   $   264.75
$   1,272.14   $   1,005.84   $   266.30
$   1,272.14   $   1,004.29   $   267.85
$   1,272.14   $   1,002.73   $   269.41
$   1,272.14   $   1,001.15   $   270.99
$   1,272.14   $     999.57   $   272.57
$   1,272.14   $     997.98   $   274.16
$   1,272.14   $     996.38   $   275.76
$   1,272.14   $     994.78   $   277.36
$   1,272.14   $     993.16   $   278.98
$   1,272.14   $     991.53   $   280.61
$   1,272.14   $     989.89   $   282.25
$   1,272.14   $     988.25   $   283.89
$   1,272.14   $     986.59   $   285.55
$   1,272.14   $     984.93   $   287.21
$   1,272.14   $     983.25   $   288.89
$   1,272.14   $     981.56   $   290.58
$   1,272.14   $     979.87   $   292.27
$   1,272.14   $     978.16   $   293.98
$   1,272.14   $     976.45   $   295.69
$   1,272.14   $     974.72   $   297.42
$   1,272.14   $     972.99   $   299.15
$   1,272.14   $     971.24   $   300.90
$   1,272.14   $     969.49   $   302.65
$   1,272.14   $     967.72   $   304.42
$   1,272.14   $     965.95   $   306.19
$   1,272.14   $     964.16   $   307.98
$   1,272.14   $   962.37   $   309.77
$   1,272.14   $   960.56   $   311.58
$   1,272.14   $   958.74   $   313.40
$   1,272.14   $   956.91   $   315.23
$   1,272.14   $   955.07   $   317.07
$   1,272.14   $   953.22   $   318.92
$   1,272.14   $   951.36   $   320.78
$ 1,272.14     $   949.49   $   322.65
$ 1,272.14     $   947.61   $   324.53
$ 1,272.14     $   945.72   $   326.42
$ 1,272.14     $   943.81   $   328.33
$ 1,272.14     $   941.90   $   330.24
$ 1,272.14     $   939.97   $   332.17
$ 1,272.14     $   938.03   $   334.11
$ 1,272.14     $   936.09   $   336.05
$ 1,272.14     $   934.13   $   338.01
$ 1,272.14     $   932.15   $   339.99
$ 1,272.14     $   930.17   $   341.97
$ 1,272.14     $   928.18   $   343.96
$ 1,272.14     $   926.17   $   345.97
$ 1,272.14     $   924.15   $   347.99
$ 1,272.14     $   922.12   $   350.02
$ 1,272.14     $   920.08   $   352.06
$ 1,272.14     $   918.03   $   354.11
$ 1,272.14     $   915.96   $   356.18
$ 1,272.14     $   913.88   $   358.26
$ 1,272.14     $   911.79   $   360.35
$ 1,272.14     $   909.69   $   362.45
$ 1,272.14     $   907.58   $   364.56
$ 1,272.14     $   905.45   $   366.69
$ 1,272.14     $   903.31   $   368.83
$ 1,272.14     $   901.16   $   370.98
$ 1,272.14     $   898.99   $   373.15
$ 1,272.14     $   896.82   $   375.32
$ 1,272.14     $   894.63   $   377.51
$ 1,272.14     $   892.43   $   379.71
$ 1,272.14     $   890.21   $   381.93
$ 1,272.14     $   887.98   $   384.16
$ 1,272.14     $   885.74   $   386.40
$ 1,272.14     $   883.49   $   388.65
$ 1,272.14     $   881.22   $   390.92
$ 1,272.14     $   878.94   $   393.20
$ 1,272.14     $   876.65   $   395.49
$ 1,272.14     $   874.34   $   397.80
$ 1,272.14     $   872.02   $   400.12
$ 1,272.14     $   869.69   $   402.45
$ 1,272.14     $   867.34   $   404.80
$ 1,272.14     $   864.98   $   407.16
$ 1,272.14     $   862.60   $   409.54
$ 1,272.14     $   860.21   $   411.93
$ 1,272.14     $   857.81   $   414.33
$ 1,272.14     $   855.39   $   416.75
$ 1,272.14     $   852.96   $   419.18
$ 1,272.14   $   850.52   $   421.62
$ 1,272.14   $   848.06   $   424.08
$ 1,272.14   $   845.58   $   426.56
$ 1,272.14   $   843.10   $   429.04
$ 1,272.14   $   840.59   $   431.55
$ 1,272.14   $   838.08   $   434.06
$ 1,272.14   $   835.54   $   436.60
$ 1,272.14   $   833.00   $   439.14
$ 1,272.14   $   830.43   $   441.71
$ 1,272.14   $   827.86   $   444.28
$ 1,272.14   $   825.27   $   446.87
$ 1,272.14   $   822.66   $   449.48
$ 1,272.14   $   820.04   $   452.10
$ 1,272.14   $   817.40   $   454.74
$ 1,272.14   $   814.75   $   457.39
$ 1,272.14   $   812.08   $   460.06
$ 1,272.14   $   809.40   $   462.74
$ 1,272.14   $   806.70   $   465.44
$ 1,272.14   $   803.98   $   468.16
$ 1,272.14   $   801.25   $   470.89
$ 1,272.14   $   798.50   $   473.64
$ 1,272.14   $   795.74   $   476.40
$ 1,272.14   $   792.96   $   479.18
$ 1,272.14   $   790.17   $   481.97
$ 1,272.14   $   787.36   $   484.78
$ 1,272.14   $   784.53   $   487.61
$ 1,272.14   $   781.68   $   490.46
$ 1,272.14   $   778.82   $   493.32
$ 1,272.14   $   775.94   $   496.20
$ 1,272.14   $   773.05   $   499.09
$ 1,272.14   $   770.14   $   502.00
$ 1,272.14   $   767.21   $   504.93
$ 1,272.14   $   764.26   $   507.88
$ 1,272.14   $   761.30   $   510.84
$ 1,272.14   $   758.32   $   513.82
$ 1,272.14   $   755.32   $   516.82
$ 1,272.14   $   752.31   $   519.83
$ 1,272.14   $   749.28   $   522.86
$ 1,272.14   $   746.23   $   525.91
$ 1,272.14   $   743.16   $   528.98
$ 1,272.14   $   740.07   $   532.07
$ 1,272.14   $   736.97   $   535.17
$ 1,272.14   $   733.85   $   538.29
$ 1,272.14   $   730.71   $   541.43
$ 1,272.14   $   727.55   $   544.59
$ 1,272.14   $   724.37   $   547.77
$ 1,272.14   $   721.18   $   550.96
$ 1,272.14   $   717.96   $   554.18
$ 1,272.14   $   714.73   $   557.41
$ 1,272.14   $   711.48   $   560.66
$ 1,272.14   $   708.21   $   563.93
$ 1,272.14   $   704.92   $   567.22
$ 1,272.14   $   701.61   $   570.53
$ 1,272.14   $   698.28   $   573.86
$ 1,272.14   $   694.94   $   577.20
$ 1,272.14   $   691.57   $   580.57
$ 1,272.14   $   688.18   $   583.96
$ 1,272.14   $   684.78   $   587.36
$ 1,272.14   $   681.35   $   590.79
$ 1,272.14   $   677.90   $   594.24
$ 1,272.14   $   674.44   $   597.70
$ 1,272.14   $   670.95   $   601.19
$ 1,272.14   $   667.44   $   604.70
$ 1,272.14   $   663.92   $   608.22
$ 1,272.14   $   660.37   $   611.77
$ 1,272.14   $   656.80   $   615.34
$ 1,272.14   $   653.21   $   618.93
$ 1,272.14   $   649.60   $   622.54
$ 1,272.14   $   645.97   $   626.17
$ 1,272.14   $   642.31   $   629.83
$ 1,272.14   $   638.64   $   633.50
$ 1,272.14   $   634.95   $   637.19
$ 1,272.14   $   631.23   $   640.91
$ 1,272.14   $   627.49   $   644.65
$ 1,272.14   $   623.73   $   648.41
$ 1,272.14   $   619.95   $   652.19
$ 1,272.14   $   616.14   $   656.00
$ 1,272.14   $   612.32   $   659.82
$ 1,272.14   $   608.47   $   663.67
$ 1,272.14   $   604.60   $   667.54
$ 1,272.14   $   600.70   $   671.44
$ 1,272.14   $   596.78   $   675.36
$ 1,272.14   $   592.84   $   679.30
$ 1,272.14   $   588.88   $   683.26
$ 1,272.14   $   584.90   $   687.24
$ 1,272.14   $   580.89   $   691.25
$ 1,272.14   $   576.86   $   695.28




             Balloon payment
             This will likely need to be refinanced
                                            Projection Worksheet (Template)
                                                      Balance Sheet
                                                       Projections
                                                                       This has not been updated.
                                                      Actuals as of                   December 31,
                                                        31-Dec             2008           2009       2010
Assets
      Current Assets
          Checking
Total Checking/Saving

Other Current Assets
      misc current assets
Total Current Assets

Fixed Assets, net
Building and land

Total Assets

Liabilities & Equity
Liabilities
            Current payroll liabilities                                                                     = last month of payroll expense
            Past payroll liabilities
            other misc current liab
Total Current Liabilities

Total Current Liabilities

Long Term Liability
      PeopleFund loan
      Other bank loans
      Owner financed loan
      Related party loan
Total Long Term Liability


Equity
      Owners Contributions
      Owners Draws
      Current Earnings
      Retained Earnings
Total Owner Capital

Total Liability & Equity
                       Chk figure s/b = 0




                                                                 Full fs projection worksheet

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:44
posted:5/17/2012
language:English
pages:24
fanzhongqing fanzhongqing http://
About