Working Capital Management provide two Excel workbooks which will help you and your staff improve forecasting known and predicted cash flows over the next 1-30 and 1- 100 days ahead.
Provides assistance to your firm to control cash balances – avoiding costly overdrawn fees – minimising interest costs – helping staff to take action on daily late payee alerts.
The AR Control worksheet helps staff identify overdue accounts every day providing an audit trail of actions taken to obtain overdue payments.
There are two versions- all available in the download zip file.
Use version A when receivable and payable accounts due dates are known.
Use version B when you want to use the average number of days to settle.
Use the extra worksheet in both variants when you want to analyse a capital project rate of return based on cash flows.
The working capital worksheets have 2,500 rows each. These can be extended.
View the demo in Excel Online – copy this link into your browser.
Software required. Any version of Excel.
Get Working Capital Management 2016 now:
Purchase the full version for unlimited use
Summary: Working Capital Management, audit trail, 100 days
Concepts: Cash flow, Accounts receivable, Spreadsheet, Rate of return, Money, Internal rate of return, Net present value, Economics terminology
/technology and computing/software
/education/teaching and classroom resources/lesson plans
/technology and computing/software/shareware and freeware
Tags: Working Capital Management, daily late payee, costly overdrawn fees, AR Control worksheet, audit trail, capital project rate, download zip file, Excel.Get Working Capital, Net present value, classroom resources/lesson plans/technology, cash balances, cash flows, overdue payments, overdue accounts, minimising interest costs, Excel workbooks, Cash flow, extra worksheet, payable accounts, Internal rate, capital worksheets, average number, Excel Online, unlimited useSummary, Economics terminologyCategories, version, return, receivable, rows, forecasting, 1-30, assistance, firm, action, staff, alerts, Spreadsheet, Software, dates, actions, variants, daysConcepts, Money, demo, computing/software/education/teaching