Get documents about "campground
Document Sample
424b9886-24e6-4431-bb9d-17c33dffc814.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%
12/20/2011 4
424b9886-24e6-4431-bb9d-17c33dffc814.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.
12/20/2011 2
424b9886-24e6-4431-bb9d-17c33dffc814.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
12/20/2011 3
424b9886-24e6-4431-bb9d-17c33dffc814.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
12/20/2011 4
