Scribd
Upload
114 views2 pages

Monthly Cash Flow Analysis Report

The document shows monthly cash flow data for a company over 12 months. It tracks opening cash on hand, receipts from sales, contributions and debtors, capital expenditures on fixed assets and working capital, and operating expenses on wages, inventory, and general expenses. Total receipts were $4.58 million while total capital expenditures and operating expenses were $0.38 million and $0.52 million respectively. Closing cash on hand was $4.05 million at the end of the period.

Uploaded by

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

Monthly Cash Flow Analysis Report

The document shows monthly cash flow data for a company over 12 months. It tracks opening cash on hand, receipts from sales, contributions and debtors, capital expenditures on fixed assets and working capital, and operating expenses on wages, inventory, and general expenses. Total receipts were $4.58 million while total capital expenditures and operating expenses were $0.38 million and $0.52 million respectively. Closing cash on hand was $4.05 million at the end of the period.

Uploaded by

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

M1 M2 M3 M4 M5 M6 M7 M8 M9 M10 M11 M12 Total

Opening 20 993.34 137 049.34 241 449.34 337 229.34 338 729.34 382 029.34 397 334.34 421 684.34 432 414.34 448 214.34 450 614.34 3 607 741.74
cash on hand
RECEIPTS
Sales 80 500 120 000.00 125 000.00 123 300.00 95 000.00 75 500.00 51 000.00 52 000.00 55 000.00 57 000.00 56 500.00 41 000.00 931 800.00
revenues
Cash 10 000.00 - - - - - - - - - - 10 000.00
contributions
Loans - - - - - - - - - - -
Receipts 12 000.00 10 000.00 200.00 500.00 150.00 - 2 000.00 - 3 000.00 1 100.00 950.00 29 900.00
from debtors
A TOTAL 80 500 162 299.34 272 049.34 364 949.34 432 729.34 414 229.34 433 029.34 451 334.34 476 684.34 492 414.34 504 714.34 492 564.34 4 578 497.74
RECEIPTS

2 Capital
Expenditure
Fixed assets 32 602.00 - 5 000.00 150.00 60 000.00 - - - 15 000.00 14 000.00 16 000.00 - 142 752.00
Working 14 419.33 12 500.00 12 300.00 13 500.00 18 000.00 18 300.00 21 000.00 16 500.00 10 000.00 9 600.00 15 000.00 24 000.00 185 119.33
capital
B Total Capital 47 021.33 12 500.00 17 300.00 13 650.00 78 000.00 18 300.00 21 000.00 16 500.00 25 000.00 23 600.00 31 000.00 24 000.00 377 871.33
Expenditure

Estimated
Operating
Expenses
Wages 7000.00 7 000.00 7 000.00 7 000.00 7 000.00 7 000.00 7 000.00 7 000.00 15 000.00 15 000.00 15 000.00 15 000.00 116 000.00
Inventory 1 309.00 750.00 800.00 870.00 1 100.00 900.00 995.00 650.00 770.00 400.00 1 100.00 1 500.00 11 144.00
purchases
General 4 176.33 5 000.00 5 500.00 6 200.00 7 900.00 6 000.00 6 700.00 5 500.00 3 500.00 5 200.00 7 000.00 7 100.00 69 776.33
Operating
Expenses
C TOTAL 59 506.66 25 250.00 30 600.00 27 720.00 94 000.00 32 200.00 35 695.00 29 650.00 44 270.00 44 200.00 54 100.00 47 600.00 524 791.66
OPERATING
EXPENSES

CLOSING
CASH ON 20 993.34 137 049.34 241 449.34 337 229.34 338 729.34 382 029.34 397 334.34 421 684.34 432 414.34 448 214.34 450 614.34 444 964.34 4 052 712.08
HAND

You might also like