This is for excel.

I don't understand the formula that I would need to use.

ep 38 of N K E C G January February March April May June July August September October November December Totals 20,000 Cash Balance, Beginning Collections Total Cash Available Less Disbursements Add formulas to cells C2:M2 and B3:M3 to build out the Cash Available section of the spreadsheet. The values in B3:M3 will be carried over from the Supporting Schedules worksheet. 1 Total Disbursements Excess (deficiency) of receipts over disbursements Financing Interest Borrowings Repayments Total Financing Dividends Paid Cash Balance, Ending