treasury monitor - caption | eFinancialModels

CFOs are under increasing pressure to manage cash in tough market conditions and volatile economic cycles. Even in stages of business growth, cash becomes the most important asset in fueling the growth of a business. This becomes more significant when a CFO of a group of companies must optimize the use of cash across all entities. It becomes a day-to-day rigorous task for the treasury team to shuffle cash around numerous bank accounts to handle hundreds of payments and make the best use of collections in the group.

This financial model attempts to give a CFO a daily monitor of the existing bank balances for all entities in a multi-currency and multi-entity environment, as well as the future cash position for the current month. This will allow a CFO to have a careful cash planning capability month by month to cover fixed overheads and planned capital expenditures on development projects or buying assets. It also allows tracing of issued cheques, planned payments, and anticipated collections till the end of the month. This model will help avoid cash flow hick-ups that face even the largest and most solvent corporations.

MODEL SPECS
Up to 10 currencies, one base currency and nine others.
One rate for each currency is fixed for the remaining of the month.
Up to 20 different payment categories.
Up to 20 different entities can be defined.
Up to 20 different bank accounts can be defined.
Up to 300 payments can be scheduled for the group.
Up to 300 collections can be scheduled for the group.
Up to 200 issued cheques can be listed.

MODEL STEPS:
1) Setup of accounts, currencies, companies, and payment categories in the SETUP sheet.
2) Insert the report date in the TREASURY POSITION sheet.
3) Insert or update the scheduled payments with dates, amounts, and from which account payments will be made in the PAYMENTS sheet.
4) Insert the expected collections from revenue contracts or daily collections forecasted in the COLLECTIONS sheet.