FinancialXLA built a Cash flow Application which manages the cash-in and the cash-out for various financial products. Cash accounted for includes the cash flow for both loans and interest.
This spreadsheet functions as daily management tools that enable the CFO to obtain precise information regarding the account balances for each day plotted against short-term periods and retrieved weekly/monthly/yearly reports in the long term. It provides substantial insight to properly understand deficits/surplus and hence, proper management of the cash flow of the institute. The application tabulates the Notional and Interest of each product and adds the results to the cash flow by corresponding maturity buckets (O/N T/N S/N 1W 2W 3W 1M 2M…12M…2Y….15Y).
The process was created using Microsoft Excel through visual basic applications, pivot tables and advanced formulas that show at the end the results along the template reports which provide by the user. Microsoft Excel captures the input data (such as loans/bonds/deposits/IB in/out and their contracts), creates transactions for each product (inclusive of opening balance, scheduled repayments, and interests), records them in one structured database and automatically update the built-in reports with the new results.