Question

cash_flow_budget_v3 - Saved B. = Page Layout kosisochukwu oralipor - Draw Formulas Data Review View Help Team Search AutoSave Cab File Home insert Calibri Paste BIU - Com Share 4 = Custom -11 - -A A - A Wrap Text Merge & Center - Insert 33 Delete - ! Format 247 0 Sort & Find & Filter Select $ -% 818 Conditional format as Formatting Table Cell Styles Sensitivity Clipboard Font Alignment Editing Sensitivity February March July August September October November December January 83-M Cash Balance, Beginning Collections 5 Total Cash Available 6 Less Disbursements Inventory Purchases 8 Commissions 830 13 Total Disbursements 14 Excess (deficiency of receipts over disbursements 15 Financing 16 Interest 17 Borrowings 18 Repayment 20 Total Financing 21. Dividends Paid 22 Cash Balance, Ending -200 21000 -410 21000 -620 21000 -1040 22000 -1260 22000 -1480 22000 -1700 22000 -1920 22000 -2140 23000 20000 2 370 23000 21000 0 Inputs Supporting Schedules Operating Budget Cash Budget

what is the formula for finding the beginning cash balance.

Answer 1

First find the ending cash balance for January,

Ending cash balance = Beginning cash balance + Collections - Total Disbursements - Total Financing - Dividends paid.

Now the January ending cash balance will become the beginning cash balance for February.

In this way proceed for all months.

Beginning cash balance is the ending cash balance of the immediately preceding months.

Please give likes for the hard work.