Reserve Forecasting Tool
Does anyone have any automated tools that they use to forecast uncommitted reserve balances? We currently use a combination of spreadsheets and various system reports, but as situations evolve and we need more relevant and up-to-date information the iterations become labour intensive and thus slow. This makes it hard for me to give quick and definitive answers about available capital resources when needed.
Ideally, the tool would have the ability to forecast many years into the future as well.
Our financials come out of JD Edwards 9.20 and we also use Hubble software to do reporting out of JD Edwards.
Any help would be appreciated.