0% found this document useful (0 votes)
9 views1 page

Vintage Store Cash Flow Projection

The document presents a cash flow projection for 'Your Vintage Store' over a financial period, detailing income, expenses, and net income/loss. Total projected income is $191,038, with total expenses amounting to $143,584, resulting in a net income of $47,454. The cash flow projection shows an ending cash balance of $47,454 by the end of the period.

Uploaded by

Brendi Ameijide
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
9 views1 page

Vintage Store Cash Flow Projection

The document presents a cash flow projection for 'Your Vintage Store' over a financial period, detailing income, expenses, and net income/loss. Total projected income is $191,038, with total expenses amounting to $143,584, resulting in a net income of $47,454. The cash flow projection shows an ending cash balance of $47,454 by the end of the period.

Uploaded by

Brendi Ameijide
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

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%

You might also like