Spartans Drum and Bugle Corps Cash Flow Projections and by add37610

VIEWS: 79 PAGES: 2

									                 Spartans Drum and Bugle Corps Cash Flow Projections and Budget Through 2010
                                      Quarter 2    Quarter 3    Quarter 4       Quarter 1       Quarter 2         Quarter 3    Quarter 4
                                     Mar-Jun 2009 Jul-Sep 2009 Oct-Dec 2009   Jan-Mar 2010     Apr-Jun 2010      Jul-Sep 2010 Oct-Dec 2010
Cash In
Cash - Beginning Balance               $10,494.00   $26,416.00   $20,716.00       $25,116.00        $39,416.00       $81,716.00    $26,516.00
Membership Dues                                                  $12,500.00   $    37,500.00   $     62,500.00                    $ 15,000.00
Parade / Performance Fees                                                                      $     20,000.00   $ 10,000.00
Home Show                                                                                                        $ 20,000.00
Sponsorships                                                                                                     $ 20,000.00
Clothing Bin                              $822.00     $300.00      $300.00    $      300.00    $       300.00    $    300.00      $      300.00
Sale of Office Equipment                $3,000.00
Building Sale Proceeds                $915,000.00

Total Cash Available                  $929,316.00   $26,716.00   $33,516.00       $62,916.00       $122,216.00   $132,016.00          $41,816.00

Cash Out
US Trustee/Bankruptcy Fees              $1,150.00     $500.00       $500.00   $       500.00   $        500.00   $    500.00      $       500.00
Food                                                                $500.00   $     4,000.00   $      5,000.00   $ 20,000.00      $       500.00
Recruiting misc.                                                  $1,500.00   $     1,000.00                                      $     1,500.00
Rental Space                                                       $500.00    $     1,000.00                                      $       500.00
Promotional/printing                                               $900.00                                                        $       900.00
Instructional staff / writers                                                 $     5,000.00   $      7,000.00   $ 7,000.00
Field Staff                                                                   $          -     $      5,000.00   $ 5,000.00
Bus Charters                                                                  $          -     $     10,000.00   $ 50,000.00
Truck lease                                                                                    $      2,500.00   $ 7,500.00
Misc. travel expense                                                                                             $ 3,000.00
Fuel and payroll for truck drivers                                                             $      2,000.00   $ 4,000.00
CG & unifrom expense                                                          $     5,000.00
Insurance                               $2,700.00    $2,000.00    $2,000.00   $     2,000.00   $      2,000.00   $     2,000.00   $     2,000.00
Equipment repair                                                  $1,500.00   $     1,500.00   $      1,500.00   $     1,500.00   $     1,500.00
Housing fees                                                                                   $      4,000.00   $     4,000.00
Acct/Tax Prep/Misc                        $350.00    $3,500.00    $1,000.00   $     3,500.00   $      1,000.00   $     1,000.00   $     3,500.00
Utilities                               $3,500.00
Interest - Bank of NE                  $21,200.00
Bank of NE Debt Payoff                $849,000.00

Total Cash Out                        $877,900.00   $6,000.00    $8,400.00 $      23,500.00 $       40,500.00 $ 105,500.00 $ 10,900.00
Net Cash Available                     $51,416.00   $20,716.00   $25,116.00       $39,416.00        $81,716.00   $26,516.00   $30,916.00
Less Cash Toward Creditors Acct.       $25,000.00                                                                           $ 15,000.00
Net Operating Cash                     $26,416.00   $20,716.00   $25,116.00       $39,416.00        $81,716.00   $26,516.00   $15,916.00


                                                                                                                                           1 of 2
                Spartans Drum and Bugle Corps Cash Flow Projections and Budget Through 2010
                                          Quarter 2    Quarter 3    Quarter 4             Quarter 1         Quarter 2       Quarter 3    Quarter 4
                                         Mar-Jun 2009 Jul-Sep 2009 Oct-Dec 2009         Jan-Mar 2010       Apr-Jun 2010    Jul-Sep 2010 Oct-Dec 2010
Creditor Cash Flow:

Cash In
Cash Beginning Balance                           $0.00     $37,000.00     $42,500.00        $52,500.00     $   53,500.00   $ 54,000.00    $ 55,000.00
Cash Transfer from Operating Acct.          $25,000.00                                                                                    $ 15,000.00
Alumni Appeal                                               $1,000.00      $1,000.00    $       1,000.00   $    1,000.00   $   1,000.00   $ 1,000.00
Sell Bus fleet                              $15,000.00      $5,000.00
Community event / Golf tournament                                                                                                         $ 16,000.00
Community event / Gala                                                    $12,000.00                                                      $ 15,000.00

Total Cash In                               $40,000.00     $43,000.00     $55,500.00        $53,500.00     $   54,500.00   $ 55,000.00    $ 102,000.00

Cash Out
Bus repair                                   $3,000.00
Golf                                                                                                                                      $   9,600.00
Mailings                                                      $500.00                                      $     500.00
Gala                                                                       $3,000.00                                                      $   3,750.00

Total Cash Out                               $3,000.00       $500.00       $3,000.00    $            -     $      500.00   $       -      $ 13,350.00
Net Cash in Creditors Account               $37,000.00     $42,500.00     $52,500.00    $      53,500.00   $   54,000.00   $ 55,000.00    $ 88,650.00

ASSUMPTIONS:
1. Corps does not perform in 2009.
2. When corps does come out in 2010 it is with 90 dues-paying members at $1,250 each.
3. Golf assumes cost of $75 per player. Revenue is golf fee of $125 plus auction.
4. Gala assumes cost of $30 per plate. Revenue is $100 per plate plus donations and auction.
5. Bus repair is estimate of labor and parts for tune up as required for sale.




                                                                                                                                                 2 of 2

								
To top