Scribd
Upload
269 views2 pages

ABC Company Cash Flow Projection Analysis

The document is a projected cash flow analysis for ABC Company over three years. It shows monthly and annual projections for starting cash balance, cash inflows from revenue and loans, cash outflows for operational expenses and capital expenditures, and the resulting change in cash balance. In year 1, operational cash flows are projected to be negative, but loans and owner capital injections provide positive total cash flow and ending balance. Years 2 and 3 show operational cash flows becoming positive and ending balances increasing each year.

Uploaded by

Pardeep K Aggarwal
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
269 views2 pages

ABC Company Cash Flow Projection Analysis

The document is a projected cash flow analysis for ABC Company over three years. It shows monthly and annual projections for starting cash balance, cash inflows from revenue and loans, cash outflows for operational expenses and capital expenditures, and the resulting change in cash balance. In year 1, operational cash flows are projected to be negative, but loans and owner capital injections provide positive total cash flow and ending balance. Years 2 and 3 show operational cash flows becoming positive and ending balances increasing each year.

Uploaded by

Pardeep K Aggarwal
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
  • Projected Cash Flow Analysis

Projected CashFlow Analysis

ABC Company
CASHFLOW STATEMENT

Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Mo 10

Mo 11

Mo 12

YEAR 1

YEAR 2

STARTING CASH BALANCE

31,990

25,780

21,770

21,860

23,150

25,640

22,530

21,420

15,310

19,600

25,690

31,180

SOURCES OF CASH
Revenue Stream 1
Revenue Stream 2
Other 1
Other 2
Cash Received from Loans
Owners' Cash Capital Injections
TOTAL CASH INFLOWS

7,000
2,000
0
0
65,000
20,000
94,000

8,000
4,000
0
0
0
0
12,000

11,000
8,000
0
0
0
0
19,000

12,000
8,000
0
0
0
0
20,000

15,000
12,000
0
0
0
0
27,000

15,000
14,000
0
0
0
0
29,000

18,000
10,000
0
0
0
0
28,000

17,000
6,000
0
0
0
0
23,000

15,000
8,000
0
0
0
0
23,000

25,000
7,000
0
0
0
0
32,000

20,000
15,000
0
0
0
0
35,000

18,000
16,000
0
0
0
0
34,000

181,000
110,000
0
0
65,000
20,000
376,000

222,000
155,000
0
0
0
0
377,000

Direct Inventory Replenishment


Change in Inventory Levels
Salaries / Benefits
Rent
Utilities
Repairs / Maintenance
Advertising
Commissions
Travel / Entertainment
Mailing Costs
Office Supplies
Professional Services
Insurance
Telephone / Internet
Security System
Leasehold Improvements
Loan Repayment
Owner's Draw
Equipment Lease Expenses
Capital Equipmnt Expenditures
Other 1
Other 2
Other 3
TOTAL CASH OUTFLOWS

3,600
40,000
5,000
1,800
300
50
2,000
0
50
50
100
150
100
100
50
5,000
1,100
0
500
2,000
20
20
20
62,010

4,800
0
5,000
1,800
300
50
2,000
0
50
50
100
150
100
100
50
0
1,100
0
500
2,000
20
20
20
18,210

7,600
0
7,000
1,800
300
50
2,000
0
50
50
100
150
100
100
50
0
1,100
0
500
2,000
20
20
20
23,010

8,000
0
7,000
1,800
300
50
500
0
50
50
100
150
100
100
50
0
1,100
0
500
0
20
20
20
19,910

10,800
0
10,000
1,800
300
50
500
0
50
50
100
150
100
100
50
0
1,100
0
500
0
20
20
20
25,710

11,600
0
10,000
1,800
300
50
500
0
50
50
100
150
100
100
50
0
1,100
0
500
0
20
20
20
26,510

11,200
0
10,000
1,800
300
50
500
0
50
50
100
150
100
100
50
0
1,100
0
500
5,000
20
20
20
31,110

9,200
0
10,000
1,800
300
50
500
0
50
50
100
150
100
100
50
0
1,100
0
500
0
20
20
20
24,110

9,200
5,000
10,000
1,800
300
50
500
0
50
50
100
150
100
100
50
0
1,100
0
500
0
20
20
20
29,110

12,800
0
10,000
1,800
300
50
500
0
50
50
100
150
100
100
50
0
1,100
0
500
0
20
20
20
27,710

14,000
0
10,000
1,800
300
50
500
0
50
50
100
150
100
100
50
0
1,100
0
500
0
20
20
20
28,910

13,600
0
10,000
1,800
300
50
500
0
50
50
100
150
100
100
50
0
1,100
0
500
0
20
20
20
28,510

116,400
45,000
104,000
21,600
3,600
600
10,500
0
600
600
1,200
1,800
1,200
1,200
600
5,000
13,200
0
6,000
11,000
240
240
240
344,820

150,800
5,000
125,000
22,800
4,320
600
12,000
0
800
650
1,500
2,000
1,500
1,500
600
0
13,200
10,000
9,000
0
240
240
240
361,990

CHANGE IN CASH
ENDING CASH BALANCE

31,990
31,990

-6,210
25,780

-4,010
21,770

90
21,860

1,290
23,150

2,490
25,640

-3,110
22,530

-1,110
21,420

-6,110
15,310

4,290
19,600

6,090
25,690

5,490
31,180

31,180
31,180

15,010
46,190

Operational Cash Inflows


Operational Cash Outflows
Operational Cash Change

9,000
60,910
-51,910

12,000
17,110
-5,110

19,000
21,910
-2,910

20,000
18,810
1,190

27,000
24,610
2,390

29,000
25,410
3,590

28,000
30,010
-2,010

23,000
23,010
-10

23,000
28,010
-5,010

32,000
26,610
5,390

35,000
27,810
7,190

34,000
27,410
6,590

291,000
331,620
-40,620

Download this form at [Link] - Go to the "Resources" section, then to the "Accounting" section, then click "download cashflow spreadsheet in EXCEL."

377,000
338,790
38,210

YEAR 3
46,190

277,500
175,000
0
0
0
0
452,500
181,000
5,000
150,000
24,000
5,184
600
15,000
0
1,000
700
1,500
2,200
2,000
2,000
600
0
13,200
10,000
12,000
0
240
240
240
426,704
25,796
71,986

452,500
403,504
48,996

You might also like