TREASURY MONITOR

Description
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 with the treasury team to shuffle cash around numerous bank accounts to handle hundreds of payments and make the best of 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 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 fixed for 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.


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