Cash flow generator for Financial institution
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.
I am financial specialist and guru in Excel and VBA. I create creative and complex business plans, financial models and feasibility studies in a simplified and logical manner including clear assumptions, drivers, financial statements, valuations, suitable sensitivity analysis, scenarios and dashboards that are easy to understand by the client and their investors. I have created dozens of reports for a variety of businesses including, startups, retailers, power plants, farms, equipment manufacturers, among others. Also, I am a guru in Excel, and I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. More on that, I develop financial modules including business valuation methodology & ratios (INPV, IRR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE, SPV FVC, sensitive analysis, correlation, and regression, etc.)