Business Name YOUR VINTAGE STORE Cash Flow Projection Prepared By: YOUR NAME
YOUR VINTAGE STORE Financial Period BEGINING DATE _ ENDING DATE Financial Report
Accounting Basis Cash Date: DATE
Accounting Period 1 2 3 4 5 6 7 8 9 10 11 12 TOTAL
January February March April May June July August September October November December
Income
Gross Receipts Billed - Accrual Basis OR -
Gross Revenue - Cash Basis 12,521 12,833 16,959 17,522 15,815 16,061 14,668 18,341 15,483 21,688 15,065 14,082 191,038
Expenses:
Officers Salaries -
Salaries & Compensation 3,340 3,340 3,340 3,340 3,340 3,340 3,340 3,340 3,340 3,340 3,340 3,340 40,080
Payroll Taxes 334 334 334 334 334 334 334 334 334 334 334 334 4,008
Cost of Goods Sold 3,005 3,080 4,070 4,205 3,796 3,855 3,520 4,402 3,716 5,205 3,616 3,380 45,849
Bad Debts 100 100 100 100 100 100 100 100 100 100 100 100 1,200
Rents 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
Taxes & Licenses 1,033 1,059 1,399 1,446 1,305 1,325 1,210 1,513 1,277 1,789 1,243 1,162 15,761
Depreciation & Amortization - - - - - - - - - - - - -
Advertisign & Selling Expenses 500 500 500 500 500 500 500 500 1,500 500 500 500 7,000
Investor Payments 300 300 300 300 300 300 300 300 300 300 300 300 3,600
Employee Benefit Programs 100 100 100 100 100 100 100 100 100 100 100 100 1,200
Contract Labor - - - - - - - - - - - - -
Insurance 78 78 78 78 78 78 78 78 78 78 78 78 936
Professional Fees / Dues / Charges 100 100 100 100 100 100 100 100 100 100 100 100 1,200
Auto Expenses -
Office Supplies 50 50 50 50 50 50 50 50 50 50 50 50 600
Utilities 300 300 300 300 400 400 400 450 350 300 300 350 4,150
Repairs & Maintenance - - - - - - - - - - - - -
Other - - - - - - - - - - - - -
Other - - - - - - - - - - - - -
Total Expenses 10,740 10,841 12,171 12,353 11,902 11,982 11,533 12,767 12,745 13,696 11,560 11,293 143,584
Net Incom/Loss Before Interest & Taxes - Cash
Basis OR 1,781 1,992 4,788 5,169 3,912 4,080 3,136 5,574 2,738 7,992 3,504 2,788 47,454
CASH FLOW PROJECTION
Begining Cash Balance - 1,781 3,773 8,561 13,730 17,643 21,722 24,858 30,432 33,170 41,162 44,666
Cash Receipts of AR or Cash Revenue 12,521 12,833 16,959 17,522 15,815 16,061 14,668 18,341 15,483 21,688 15,065 14,082 191,038
Cash Outflows:
Total Expenses Before Interest 10,740 10,841 12,171 12,353 11,902 11,982 11,533 12,767 12,745 13,696 11,560 11,293 143,584
Depreciation/Amortization Expenses -
-
Estimate Income Taxes -
Loan Interest -
Other: -
Ending Cash Balance 1,781 3,773 8,561 13,730 17,643 21,722 24,858 30,432 33,170 41,162 44,666 47,454
FIGURE 1.6 cost of goods sold 24%
(YOUR VINTAGE STORE) GROSS PROFIT 76%
Fiscal (YEAR) Budget labor expenses 33%
notes: operating expenses 3%
Numbers on FIGURE 1.6 are averages of anticipated sales taken from actual vintage stores past years performance. established overhead 16%
No owners draw shown causing Net Profit to increase other expenses 0%
NET PROFIT 25%