Excel Spreadsheets For Cash Flow Forecasting
Cash Reporting and Forecasting Excel Templates combines up to five individual revenue centers into one overall report. Daily cash receipts, expenses by categories, capital expenditures, loan and lease payments. Daily closing cash balances for p/l centers and combined.
It can forecast closing cash balances up to 100 days ahead by taking receivables and payables list and calculating the banking day of receipt or payment. Input any number of days ahead for a quick snapshot of closing daily cash balance at any future date.
|
