Scribd
Upload
8 views9 pages

Small Business Cash Flow Analysis

The document provides a cash flow projection for a small business called Economic Smartphones over a 12 month period from January 2017 to December 2017. It forecasts sales, expenses, and cash flow on a monthly basis. The projection shows that the business will have an ending cash balance of ₹2,870.76 after the first year. It assumes an annual sales growth rate of 20% and estimates sales, costs of goods sold, advertising expenses, and labor costs each month to project the monthly and ending cash balances.

Uploaded by

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

Small Business Cash Flow Analysis

The document provides a cash flow projection for a small business called Economic Smartphones over a 12 month period from January 2017 to December 2017. It forecasts sales, expenses, and cash flow on a monthly basis. The projection shows that the business will have an ending cash balance of ₹2,870.76 after the first year. It assumes an annual sales growth rate of 20% and estimates sales, costs of goods sold, advertising expenses, and labor costs each month to project the monthly and ending cash balances.

Uploaded by

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

SMALL BUSINESS CASH FLOW PROJECTION

Economic Smartphones

Starting date 1/1/2017


$0.00 $0.00
Cashflow minimum (270.36)
Margin 15.61%
End period cash balance 2,870.76

Return rate 10%


Annual sales growth rate 20%
Unit price 89
Advertising budget 200 200 200

SALES FORECAST Jan Feb


Prior year speaker sales 10 9
Projected sales 12 11

CASHFLOW PROJECTION Beginning Jan Feb


Cash on hand (beginning of month) 50 50 -126
Cash on hand (end of month) 50 -126 -270

CASH RECEIPTS
Cash sales 1,068 961
Returns and allowances 107 0
TOTAL CASH RECEIPTS 961 961
Total cash available 50 1,011 835

CASH PAID OUT


Advertising 200 200
Contract labor 600 600
Materials and supplies (in COGS) 320 288
TOTAL CASH PAID OUT 1,137 1,105
Cash on hand (end of month) 50 -126 -270
CTION

$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

200 200 200 200 200 200 400 400 400

Mar Apr May Jun Jul Aug Sep Oct Nov


12 14 16 15 18 17 13 15 19
14 17 19 18 22 20 16 18 23

Mar Apr May Jun Jul Aug Sep Oct Nov


-270 -190 39 419 723 1,252 1,706 1,660 1,765
-190 39 419 723 1,252 1,706 1,660 1,765 2,168

1,282 1,495 1,709 1,602 1,922 1,816 1,388 1,602 2,029


0 0 0 0 0 0 0 0 0
1,282 1,495 1,709 1,602 1,922 1,816 1,388 1,602 2,029
1,011 1,305 1,748 2,021 2,645 3,067 3,094 3,262 3,794

200 200 200 200 200 200 400 400 400


600 600 600 600 600 600 600 600 600
384 449 513 481 577 545 417 481 609
1,201 1,266 1,330 1,298 1,394 1,362 1,434 1,498 1,626
-190 39 419 723 1,252 1,706 1,660 1,765 2,168
$0.00

400

Dec
23
28

Dec Total
2,168
2,871

2,456 19,331
0 107
2,456 19,438
4,625

400 3,200
600 7,200
737 5,799
1,754 16,403
2,871
SMALL BUSINESS CASH FLOW PROJECTION
Economic Smartphones

Starting date 1/1/2017


$0.00 $0.00
Cashflow minimum (164.97)
Margin 15.22%
End period cash balance 2,959.77

Return rate 1% 1% 1%
Sales growth rate prior year 20% 20% 20%
Unit price 89 89 89
Advertising budget 200 200 200

SALES FORECAST Jan Feb


Prior year speaker sales 10 9
Projected sales 12 11
Actual sales 9 14
Cumulative prior years sales 10 19
Cumulative projected sales 12 23
Cumulative actual sales 9 23

CASHFLOW PROJECTION Beginning Jan Feb


Cash on hand (beginning of month) 50 50 -20
Cash on hand (end of month) 50 -20 -165

CASH RECEIPTS
Cash sales 1,068 961
Returns and allowances 1 1
TOTAL CASH RECEIPTS 1,067 961
Total cash available 50 1,117 940

CASH PAID OUT


Advertising 200 200
Contract labor 600 600
Materials and supplies (in COGS) 320 288
SUBTOTAL 1,142 1,110
TOTAL CASH PAID OUT 1,137 1,105
Cash on hand (end of month) 50 -20 -165
CTION

$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

1% 1% 1% 1% 1% 1% 1% 2% 2%
20% 20% 20% 20% 20% 20% 20% 20% 20%
89 89 89 89 89 89 89 89 89
200 200 200 200 200 200 400 400 400

Mar Apr May Jun Jul Aug Sep Oct Nov


12 14 16 15 18 17 13 15 19
14 17 19 18 22 20 16 18 23
11 19 24 12 20 20 19 18 27
31 45 61 76 94 111 124 139 158
37 54 73 91 113 133 149 167 190
34 53 77 89 109 129 148 166 193

Mar Apr May Jun Jul Aug Sep Oct Nov


-165 -86 143 521 824 1,351 1,804 1,758 1,861
-86 143 521 824 1,351 1,804 1,758 1,861 2,261

1,282 1,495 1,709 1,602 1,922 1,816 1,388 1,602 2,029


1 1 1 1 1 1 1 1 3
1,281 1,494 1,708 1,601 1,921 1,814 1,387 1,601 2,026
1,116 1,408 1,850 2,122 2,745 3,166 3,192 3,359 3,887

200 200 200 200 200 200 400 400 400


600 600 600 600 600 600 600 600 600
384 449 513 481 577 545 417 481 609
1,206 1,271 1,335 1,303 1,399 1,367 1,439 1,503 1,631
1,201 1,266 1,330 1,298 1,394 1,362 1,434 1,498 1,626
-86 143 521 824 1,351 1,804 1,758 1,861 2,261
$0.00

2%
20%
89
400

Dec
23
28
34
181
217
227

Dec Total
2,261
2,960

2,456 19,331
4 18
2,452 19,349
4,714

400 3,200
600 7,200
737 5,799
1,759 16,463
1,754 16,403
2,960
Historical sales
Jan Feb Mar Apr May Jun
2016 43 40 39 40 37 46
2017 39 42 51 52 35 44
2018 60 56 60 52 38 53

Projected sales
Jan Feb Mar Apr May Jun
2019
1
2
3
4
5
6
7
8
9
10
Jul Aug Sep Oct Nov Dec Min
33 31 41 37 46 30
49 44 47 40 51 39
47 57 47 54 43 41

Jul Aug Sep Oct Nov Dec Min


Max Average Stdev Total Y/Y

Max Average

You might also like