cashflow by xiuliliaofz

VIEWS: 4 PAGES: 3

									Prepared by the Maine Small Business Development Centers as part of the Cycle-Rama Business Plan

                                                                                      Cycle-Rama Cash Flow Statement

                                 PRE-START      Apr-05        May-05       Jun-05        Jul-05      Aug-05     Sep-05     Oct-05     Nov-05     Dec-05     Jan-06     Feb-06     Mar-06     TOTAL
CASH ON HAND                        $25,000      $11,500       $13,687      $18,978       $23,786     $27,708    $32,581    $37,356    $40,360    $41,649    $41,816    $43,363    $46,057     $25,000
CASH RECEIPTS
Cash Sales                               $0       $31,572      $34,815      $38,415        $40,315    $39,190    $33,065    $27,515    $19,565    $19,815    $15,315    $19,015    $20,065   $338,662
Service Income                           $0        $3,919       $3,919       $3,919         $3,919     $3,919     $3,919     $3,919     $3,919     $3,919     $3,919     $3,919     $3,919    $47,025
Loans/Other                         $80,000            $0           $0           $0             $0         $0         $0                    $0         $0         $0         $0         $0    $80,000
TOTAL CASH RECEIPTS                 $80,000       $35,491      $38,734      $42,334        $44,234    $43,109    $36,984    $31,434    $23,484    $23,734    $19,234    $22,934    $23,984   $465,687
TOTAL CASH AVAILABLE               $105,000       $46,991      $52,420      $61,312        $68,020    $70,817    $69,565    $68,789    $63,843    $65,383    $61,050    $66,297    $70,040   $490,687
CASH PAID OUT
Purchases ( % of Sales)1            $80,000       $21,785      $24,022      $26,506        $27,817    $27,041    $22,815    $18,985    $13,500    $13,672    $10,567    $13,120    $13,845   $313,677
                           2
Gross Wages (Employees)                  $0        $2,000       $2,000       $3,000         $3,000     $3,000     $1,500     $1,500     $1,000     $1,000         $0         $0     $1,000    $19,000
                         3
Payroll Taxes & Benefits                 $0          $300         $300         $450           $450       $450       $225       $225       $150       $150         $0         $0       $150     $2,850
Outside Services4                        $0          $100         $100         $100           $100       $100       $100       $100       $100       $100       $100       $100       $100     $1,200
Supplies (Office & Operating)5       $1,000          $200         $200         $200           $200       $200       $200       $200       $200       $200       $200       $200       $200     $3,400
Repairs and Maintenance6                 $0          $150         $150         $150           $150       $150       $150       $150       $150       $150       $150       $150       $150     $1,800
Advertising ( % of Sales)7               $0        $4,150       $1,850       $1,350         $2,850       $550       $450       $450       $250     $1,450       $100       $100       $450    $14,000
Car, Delivery & Travel8                  $0          $100         $100         $100           $100       $100       $100       $100       $100       $100       $100       $100       $100     $1,200
Accounting & Legal9                      $0          $150         $150         $150           $150       $150       $150       $150       $150       $150       $150       $150       $150     $1,800
Rent10                                   $0        $1,500       $1,500       $1,500         $1,500     $1,500     $1,500     $1,500     $1,500     $1,500     $1,500     $1,500     $1,500    $18,000
             11
Telephone                              $200          $200         $200         $200           $200       $200       $200       $200       $200       $200       $200       $200       $200     $2,600
          12
Utilities                              $300          $250         $250         $200           $175       $175       $200       $250       $275       $275         $0         $0         $0     $2,350
Insurance13                              $0          $300         $500         $500           $500       $500       $500       $500       $500       $500       $500       $500       $500     $5,800
Taxes14                                  $0          $250         $250         $250           $250       $250       $250       $250       $250       $250       $250       $250       $250     $3,000
Miscellaneous ( % of Sales)              $0          $150         $150         $150           $150       $150       $150       $150       $150       $150       $150       $150       $150     $1,800
Loan Interest Payment15                  $0          $700         $691         $682           $673       $664       $655       $645       $636       $626       $617       $607       $597     $7,794
SUBTOTAL                            $81,500       $32,285      $32,413      $35,488        $38,265    $35,180    $29,144    $25,356    $19,111    $20,474    $14,584    $17,128    $19,342   $400,270
Loan Principal Payment                   $0        $1,020       $1,028       $1,037         $1,047     $1,056     $1,065     $1,074     $1,084     $1,093     $1,103     $1,112     $1,122    $12,840
Capital Purchases                        $0            $0           $0           $0             $0         $0         $0         $0         $0         $0         $0         $0         $0         $0
Other Start-up Costs16              $12,000            $0           $0           $0             $0         $0         $0         $0         $0         $0         $0         $0         $0    $12,000
Other Withdrawal                         $0            $0           $0           $0             $0         $0         $0         $0         $0         $0         $0         $0         $0         $0
Owner's Withdrawal                       $0            $0           $0       $1,000         $1,000     $2,000     $2,000     $2,000     $2,000     $2,000     $2,000     $2,000     $2,000    $18,000
TOTAL CASH PAID OUT                 $93,500       $33,304      $33,442      $37,526        $40,312    $38,236    $32,209    $28,430    $22,194    $23,567    $17,687    $20,240    $22,464   $443,111
CASH POSITION                       $11,500       $13,687      $18,978      $23,786        $27,708    $32,581    $37,356    $40,360    $41,649    $41,816    $43,363    $46,057    $47,576    $47,576


TOTAL DEBT                          $80,000       $78,980      $77,952      $76,915        $75,868    $74,812    $73,748    $72,673    $71,590    $70,497    $69,394    $68,282    $67,160

LOAN #1
   AMOUNT                           $80,000       $78,980      $77,952      $76,915        $75,868    $74,812    $73,748    $72,673    $71,590    $70,497    $69,394    $68,282    $67,160
   RATE                              10.50%
   TERM                                    5
   PAYMENT                           $1,720
PRINCIPAL                                          $1,020       $1,028       $1,037         $1,047     $1,056     $1,065     $1,074     $1,084     $1,093     $1,103     $1,112     $1,122
INTEREST                                             $700         $691         $682           $673       $664       $655       $645       $636       $626       $617       $607       $597


Notes to Cash Flow Statement:
 1. Purchases represent 69% of sales (Industry standard found in Financial Studies of Small Business, 13 th Edition).
 2. Gross wages are calculated on a rate of $7.50 per hour for the two employees
 3. Payroll expenses are calculated at 15% of wages, which represent owner’s FICA and state and federal unemployment taxes
 4. This amount has been allocated to meet any unforeseen expenses
 5. Office supplies include a cash register, paper, pens, ledgers, filing cabinets, etc.
 6. This amount was budgeted to meet any maintenance and repair expenses
 7. Advertising expenses include: ads on local television and radio stations, newspaper advertisements, business website, printed promotional materials, and promotional events (such as sponsorship of riders in local rac
 8. This amount has been allocated for the use of the company van for transport of bicycles and equipment to local bike races and promotional events.
 9. Legal expenses include the cost of hiring a lawyer to review the rental agreement. Accounting expenses include the cost of the necessary accounting software.
 10. Cycle-Rama will be able to sign a 3-year lease agreement for $1,500 per month.
 11. Telephone expenses are based on an estimate given by the area phone company
 12. Utility costs were estimated based on information provided by utility company
 13. A rate quote was obtained from an area insurance company
 14. This represents a portion of the property taxes charged by the landlord
 15. Loan payments are for the $80,000 bank loan with a term of 10 years at 10.5%
16. Other Start-up costs include renovations to the building

      Disclaimer: Cycle-Rama is a fictional company created by the Maine SBDC to illustrate the major components of the Business Plan. It in no way depicts or represents any known company.
s in local races).

								
To top