Docstoc

campground

Document Sample
campground Powered By Docstoc
					                                                                                                     ef581c90-1c24-4976-a101-6f1349af1035.xls


                                                                                      12 MONTH CASH FLOW PROJECTIONS
                                                   Month 1      Month 2    Month 3     Month 4    Month 5    Month 6     Month 7      Month 8     Month 9    Month 10    Month 11    Month 12     Totals
                                                   3-May         3-Jun      3-Jul       3-Aug      3-Sep      3-Oct       3-Nov        3-Dec       4-Jan      4-Feb       4-Mar       4-Apr
   Cash Receipts:
   Opening Cash Balance                                           $8,890   $22,980     $38,240    $53,500     $58,160       $54,560    $50,960     $47,360     $43,760     $40,160     $35,590

   FCF Loan                                          $71,400
   Owners Equity                                     $11,500

   Revenue:

   Tent Sites                                         $6,600    $13,200    $13,200     $13,200      $6,600         $0            $0         $0          $0          $0          $0      $3,300     $56,100
   RV pads                                            $3,750     $7,500     $7,500      $7,500      $3,750     $1,800        $1,800     $1,800      $1,800      $1,800      $1,800      $1,800     $42,600
   Cultural Hiking, Fishing Tours & Whale Watching     $300       $600       $600        $600        $300          $0            $0         $0          $0          $0          $0          $0      $2,400

   Total Revenue:                                    $10,650    $21,300    $21,300     $21,300    $10,650      $1,800        $1,800     $1,800      $1,800      $1,800      $1,800      $5,100    $101,100

   Total Cash Receipts (a):                          $93,550    $30,190    $44,280     $59,540    $64,150     $59,960       $56,360    $52,760     $49,160     $45,560     $41,960     $40,690

   Cash Expenditures:
   Start up costs:

   10 RV Pads                                        $15,000
   office furniture, computer, printer                 $5,000
   hydro hook ups                                     $30,000
   electrical hook ups                                $20,000
   Incorporation Costs                                 $1,500
   Trailer Improvements                                 $500

     Borrowers Fee (2%)                               $1,400

   Total Start up costs:
                                                     $73,400
   Operating Costs:

   Loan Repayment                                                                                                                                                                      $15,120     $15,120
   Management Wages                                   $4,000      $4,000     $4,000      $4,000     $4,000     $4,000        $4,000      $4,000     $4,000      $4,000      $4,000       $4,000     $48,000
   Electrical/ Water/ Sewage                           $500        $800       $800        $800       $800       $300          $300        $300       $300        $300        $300         $300       $5,800
   Equipment & Bldg Repair/ Maintenance                            $100       $100        $100       $100       $100          $100        $100       $100        $100        $100         $100       $1,100
   Coin operated washer/ dryer lease                     150         150        150         150        150        150           150         150        150         150         150          150      $1,800
   Bookkeeping/ Accounting                               $60         $60        $60         $60        $60        $60           $60         $60        $60         $60         $60        $250        $910
   Bank, Credit Card & Interac Fees                    $250        $150       $150        $150       $100         $60           $60         $60        $60         $60         $60          $60      $1,220
   Bus. License/ Chamber of Commerce Fees              $400                                                                                                                                           $400
   Business Insurance                                 $1,200                                                                                                                                         $1,200
   Office Supplies                                    $1,500         $50        $50         $50        $50        $50           $50        $50         $50         $50         $50         $50       $2,050
   Marketing: Brochures/ Website/ BC Ferries          $2,500      $1,200        $30         $30        $30        $30           $30        $30         $30         $30      $1,000         $30       $4,970
   Communication: land line/ cell/ fax/ Internet       $200        $200        $200        $200       $200       $150          $150       $150        $150        $150       $150         $150       $2,050
   Grounds landscaping/ maintenance                    $500        $500        $500        $500       $500       $500          $500       $500        $500        $500       $500         $500       $6,000

   Total Operating Costs:                            $11,260      $7,210     $6,040      $6,040     $5,990     $5,400        $5,400      $5,400     $5,400      $5,400      $6,370     $20,710     $90,620

   Total Cash Expenditures (b):                      $84,660      $7,210     $6,040      $6,040     $5,990     $5,400        $5,400      $5,400     $5,400      $5,400      $6,370     $20,710    $164,020

   Closing Balance:                                   $8,890     $22,980    $38,240     $53,500    $58,160    $54,560       $50,960    $47,360     $43,760     $40,160     $35,590     $19,980
                                                                                                                                                                                                           $0
   Assumptions:
   FCF Loan amortized over 7 years @ 12%




5/25/2011                                                                                                               4
                                                 ef581c90-1c24-4976-a101-6f1349af1035.xls



                                          3 YEAR CASH FLOW PROJECTIONS
                                              Year 1     Year 2      Year 3

Cash Receipts:
Opening Cash Balance                                 $0        $19,980         $32,210

TACC FCF Loan                                    $71,400
Owners Equity                                    $11,500

Revenue:

Tent Sites                                    $56,100          $56,100         $56,100
RV pads                                       $42,600          $46,860         $51,546
Cultural Hiking, Fishing Tours & Whale Watching$2,400           $2,640          $2,904

Total Revenue:                                  $101,100      $105,600        $110,550

Total Cash Receipts (a):                        $184,000      $125,580        $142,760


Cash Expenditures:
Start up costs:

10 RV Pads                                       $15,000
office furniture, computer, printer               $5,000
hydro hook ups                                   $30,000
electrical hook ups                              $20,000
Incorporation Costs                               $1,500
Trailer Improvements                                $500

                    Borrowers Fee (2%)            $1,400

                                                 $73,400
Operating Costs:

Loan Repayment                                   $15,120        $15,120         $15,120
Management Wages                                 $48,000        $48,000         $48,000
Electrical/ Water/ Sewage                         $5,800         $6,380          $7,018
Equipment & Bldg Repair/ Maintenance              $1,100         $1,210          $1,331
Coin operated washer/ dryer lease                 $1,800         $1,980          $2,178
Bookkeeping/ Accounting                             $910         $1,001          $1,101
Bank, Credit Card & Interac Fees                  $1,220         $1,342          $1,476
Bus. License/ Chamber of Commerce Fees              $400           $440            $484
Business Insurance                                $1,200         $1,320          $1,452
Office Supplies                                   $2,050         $2,255          $2,481
Marketing: Brochures/ Website/ BC Ferries         $4,970         $5,467          $6,014
Communication: land line/ cell/ fax/ Internet     $2,050         $2,255          $2,481
Grounds landscaping/ maintenance                  $6,000         $6,600          $7,260


Total Operating Costs:                           $90,620       $93,370         $96,395

Total Cash Expenditures (b):                    $164,020       $93,370         $96,395

End of Year Cash Balance (a-b):                  $19,980       $32,210         $46,365

Closing Balance:                                 $19,980       $32,210         $46,365

Assumptions;
sales and costs anticipated to increase at 10% per annum.
tent site revenue not anticipated to increase annually
RV sites increase dependant upon increase numbers of permanent residents.




5/25/2011                                                           2
                                ef581c90-1c24-4976-a101-6f1349af1035.xls


                                       Projected Balance Sheet - 3 year period

                                         End of year1      End of year 2   End of year 3
Assets:
Current Assets:
Cash - Business Account                        $19,980          $32,210           $46,365

Fixed Assets:
Equipment: Office/ Boat                         $15,000         $12,000            $9,600
Depreciation, 20%                               ($3,000)        ($2,400)          ($1,920)
Building & Land                                $178,500        $169,575          $161,096
Depreciation, 5%                                ($8,925)        ($8,479)          ($8,055)
Prepaid Expenses: Incorporation/ Borrowers Fee   $2,900          $2,900            $2,900

Total Assets:                                 $204,455         $205,806          $209,986

Liabilities:
Current Liabilities:

FCF Loan                                       $64,475          $57,322           $49,109

Total Liabilities:                             $64,475          $57,322           $49,109

Owners ' Equity:

Opening Balance                               $134,500         $139,980          $148,484
Add: net income for year                        $5,480           $8,504           $12,393

Owners' Equity - end of year                  $139,980         $148,484          $160,877

Total Equity and Liabilities:                 $204,455         $205,806          $209,986


                                       Projected Income Statement - 3 year period

                                            Year 1            Year 2          Year 3
Income:

Tent Sites                                      $56,100         $56,100           $56,100
RV pads                                         $42,600         $46,860           $51,546
Cultural Hiking, Fishing Tours & Whale Watching  $2,400          $2,640            $2,904

Gross Sales:                                  $101,100         $105,600          $110,550

Expenses:

TACC FCF Loan Interest Expense                   $8,195           $7,967            $6,907
Depreciation expense                           $11,925          $10,879            $9,975
Management Wages                               $48,000          $48,000           $48,000
Electrical/ Water/ Sewage                       $5,800           $6,380            $7,018
Equipment & Bldg Repair/ Maintenance            $1,100           $1,210            $1,331



5/25/2011                                            3
                                   ef581c90-1c24-4976-a101-6f1349af1035.xls


Coin operated washer/ dryer lease                    $1,800        $1,980      $2,178
Bookkeeping/ Accounting                                $910        $1,001      $1,101
Bank, Credit Card & Interac Fees                     $1,220        $1,342      $1,476
Bus. License/ Chamber of Commerce Fees                 $400          $440        $484
Business Insurance                                   $1,200        $1,320      $1,452
Office Supplies                                      $2,050        $2,255      $2,481
Marketing: Brochures/ Website/ BC Ferries            $4,970        $5,467      $6,014
Communication: land line/ cell/ fax/ Internet        $2,050        $2,255      $2,481
Grounds landscaping/ maintenance                     $6,000        $6,600      $7,260


Total Expenses:                                    $95,620        $97,096     $98,157

Net Income:                                          $5,480        $8,504     $12,393

Opening balance includes equity, land, boat and trailer value




5/25/2011                                               4

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:14
posted:5/26/2011
language:English
pages:4