Scribd
Upload
121 views2 pages

Monthly Cash Budget Analysis

The document shows a cash budget for a company from January to May. It tracks cash receipts, cash disbursements, net cash flow, beginning and ending cash balances, and required ending balances. In January, the company had a net cash flow of -$9,700 and an ending cash balance of $40,300 which was below the required $70,000 balance. In the following months, the net cash flow improved and in April and May the company had excess cash balances above the required amount.

Uploaded by

Jasmine Acta
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
121 views2 pages

Monthly Cash Budget Analysis

The document shows a cash budget for a company from January to May. It tracks cash receipts, cash disbursements, net cash flow, beginning and ending cash balances, and required ending balances. In January, the company had a net cash flow of -$9,700 and an ending cash balance of $40,300 which was below the required $70,000 balance. In the following months, the net cash flow improved and in April and May the company had excess cash balances above the required amount.

Uploaded by

Jasmine Acta
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

Cash budget

January February March April May


Cash Receipts 8,800.00 24,200.00 33,000.00 44,000.00 55,000.00
Less: Cash Disbursements 18,500.00 28,125.00 33,625.00 40,500.00 47,375.00
Net Cash Flow (9,700.00) (3,925.00) (625.00) 3,500.00 7,625.00
Add: Beginning Balance 50,000.00 70,000.00 70,000.00 70,000.00 70,000.00
Ending Cash 40,300.00 66,075.00 69,375.00 73,500.00 77,625.00
Required Ending Balance 70,000.00 70,000.00 70,000.00 70,000.00 70,000.00
Required Total Financing (29,700.00) (3,925.00) (625.00)
Excess cash balance 3,500.00 7,625.00

SOLUTION:
January February March April May
Sales 17,600.00 30,800.00 35,200.00 52,800.00 57,200.00
Cost of Sales 11,000.00 19,250.00 22,000.00 33,000.00 35,750.00

Cash receipts January February March April May


January 8,800.00 8,800.00
February 15,400.00 15,400.00
March 17,600.00 17,600.00
April 26,400.00 26,400.00
May 28,600.00
June
Total Cash Receipt per Month 8,800.00 24,200.00 33,000.00 44,000.00 55,000.00

Cash disbursement January February March April May


January 5,500.00 5,500.00
February 9,625.00 9,625.00
March 11,000.00 11,000.00
April 16,500.00 16,500.00
May 17,875.00
June
Payment to Supplier 5,500.00 15,125.00 20,625.00 27,500.00 34,375.00
Rent 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00
Salaries 8,000.00 8,000.00 8,000.00 8,000.00 8,000.00
Taxes
Total Cash Disbursement 18,500.00 28,125.00 33,625.00 40,500.00 47,375.00
June
61,600.00
129,380.00
(67,780.00)
70,000.00
2,220.00
70,000.00
(67,780.00)

June Total
66,000.00 259,600.00
41,250.00

June

28,600.00
33,000.00
61,600.00

June

17,875.00
20,625.00
38,500.00
5,000.00
8,000.00
77,880.00
129,380.00

You might also like