0% found this document useful (0 votes)
40 views11 pages

Cash Flow Projection

This cash flow projection document outlines expected cash inflows and outflows for a business over a 12 month period from January to December 2020. It projects that cash on hand will remain at $0 each month as no cash receipts are expected and no cash will be paid out either. Essential operating data like sales volume and inventory are also included but remain at $0 each month.

Uploaded by

sanjeevpnd439
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
0% found this document useful (0 votes)
40 views11 pages

Cash Flow Projection

This cash flow projection document outlines expected cash inflows and outflows for a business over a 12 month period from January to December 2020. It projects that cash on hand will remain at $0 each month as no cash receipts are expected and no cash will be paid out either. Essential operating data like sales volume and inventory are also included but remain at $0 each month.

Uploaded by

sanjeevpnd439
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
You are on page 1/ 11

###

CASH FLOW PROJECTION

Jan Feb Mar Apr


Initial 2020 2020 2020 2020
Cash on hand (beginning of the month) 0 0 0 0 0

Cash receipts
Cash sales
Returns and allowances
Collections on accounts receivable
Interest, other income
Loan proceeds
Owner contributions
Total cash receipts 0 0 0 0
Total cash available (before cash out) 0 0 0 0

Cash paid out


Purchases (Merchandise)
Gross wages (exludes withdrawals)
Payroll expenses (taxes etc.)
Outside services
Supplies (office and operating)
Repairs and maintenance
Advertising
Auto, delivery and travel
Accounting and legal
Rent
Telephone
Utilities
Insurance
Taxes (real estate, etc.)
Interest
Other expenses 1
Other expenses 2
Other expenses 3
Miscellaneous (unspecified)
Subtotal 0 0 0 0
Loan principle payment
Capital purchases
Other start-up costs
Reserve and/or escrow
Owner's withdrawal
Total cash paid out 0 0 0 0
Cash on hand (at the end of the month) 0 0 0 0

Essential Operating Data


Sales volume (dollars)
Accounts receivable (end of the month)
Bad debt (end of the month)
Inventory on hand (end of the month)
Accounts payable (end of the month)
Depreciation
OW PROJECTION

May Jun Jul Aug Sep Oct Nov Dec


2020 2020 2020 2020 2020 2020 2020 2020 Total
0 0 0 0 0 0 0 0 0

1
0 0.9
0 0.8
0
0.7
0
0 0.6
0 0.5
0 0 0 0 0 0 0 0 0 0.4
0 0 0 0 0 0 0 0 0
0.3
0.2

0 0.1
0 0
0 Initial Jan Feb
0
0
0
0
0
0 1200%
0
1000%
0
0 800%
0
0 600%
0
400%
0
0 200%
0
0 0%
Purchases
0 0 0 0 0 0 0 0 0
0
0
0
0
0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0

0
0
0
0
0
0
1
.9
.8
.7
.6
Inflows
.5
Outflow
.4 Ava.Cash
.3
.2
.1
0
Initial Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Pareto Analysis of Largest 5 Expenditures


200%

000%

800%

600%

400%

200%

0%
Purchases Purchases Purchases Purchases Purchases Others
Inflows
Outflow
Ava.Cash

0 Purcha 0 Purcha 0 Purcha 0 Purcha 0 Purchases


0 Wages 0 Wages 0 Wages 0 Wages 0 Wages
0 Payroll 0 Payroll 0 Payroll 0 Payroll 0 Payroll
0 Outsid 0 Outsid 0 Outsid 0 Outsid 0 Outside Serv.
0 Suppli 0 Suppli 0 Suppli 0 Suppli 0 Supplies
0 Repair 0 Repair 0 Repair 0 Repair 0 Repairs
0 Advert 0 Advert 0 Advert 0 Advert 0 Advertising
0 Auto, 0 Auto, 0 Auto, 0 Auto, 0 Auto,
0 Accoun 0 Accoun 0 Accoun 0 Accoun 0 Accounting
0 Rent 0 Rent 0 Rent 0 Rent 0 Rent
0 Teleph 0 Teleph 0 Teleph 0 Teleph 0 Telephone
0 Utiliti 0 Utiliti 0 Utiliti 0 Utiliti 0 Utilities
0 Insura 0 Insura 0 Insura 0 Insura 0 Insurance
0 Taxes 0 Taxes 0 Taxes 0 Taxes 0 Taxes
0 Interes 0 Interes 0 Interes 0 Interes 0 Interest
0 Other 0 Other 0 Other 0 Other 0 Other 1
0 Other 0 Other 0 Other 0 Other 0 Other 2
0 Other 0 Other 0 Other 0 Other 0 Other 3
0 Misc. 0 Misc. 0 Misc. 0 Misc. 0 Misc.
Others
0 Subtot 0 Subtot 0 Subtot 0 Subtot 0 Subtotal
0 Loan 0 Loan 0 Loan 0 Loan 0 Loan
0 Cap.Pu 0 Cap.Pu 0 Cap.Pu 0 Cap.Pu 0 Cap.Purch.
0 Other 0 Other 0 Other 0 Other 0 Other start-up
0 Reserv 0 Reserv 0 Reserv 0 Reserv 0 Reserve
0 Withdr 0 Withdr 0 Withdr 0 Withdr 0 Withdrawal
Purch ### ### 0
Purch ### ### 0
Purch ### ### 0 Initial Jan Feb Mar Apr May Jun Jul Aug Sep Oct
Purch ### ### 0 Inflow 0 0 0 0 0 0 0 0 0 0 0
Purch ### ### 0 Outfl 0 0 0 0 0 0 0 0 0 0 0
Other ### ### 0 Ava.C 0 0 0 0 0 0 0 0 0 0 0
. 0 0 0 0 0 0 0 0 0 0 0
Nov Dec
0 0
0 0
0 0
0 0
Type the fiscal year of projection:
2020
Fiscal Year
2020 Jan 1/1/2020

1 Jan 1 2020
2 Feb 2 2020
3 Mar 3 2020
4 Apr 4 2020
5 May 5 2020
6 Jun 6 2020
7 Jul 7 2020
8 Aug 8 2020
9 Sep 9 2020
10 Oct 10 2020
11 Nov 11 2020
12 Dec 12 2020

Company name

/2020
1 Jan
2 Feb
3 Mar
4 Apr
5 May
6 Jun
7 Jul
8 Aug
9 Sep
10 Oct
11 Nov
12 Dec

You might also like