campground

Document Sample
campground Powered By Docstoc
					                                                                                                     16a187a0-b806-4717-aa3f-4c3049d26975.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%




4/21/2012                                                                                                                4
                                                16a187a0-b806-4717-aa3f-4c3049d26975.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.




4/21/2012                                                          2
                                16a187a0-b806-4717-aa3f-4c3049d26975.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



4/21/2012                                            3
                                  16a187a0-b806-4717-aa3f-4c3049d26975.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




4/21/2012                                               4

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:4/22/2012
language:English
pages:4