Corporate Treasury & Liquidity Engineering by Santiago Gonzalez

Corporate Treasury & Liquidity Engineering by Santiago GonzalezCorporate Treasury & Liquidity Engineering by Santiago Gonzalez

Corporate Treasury & Liquidity Engineering

Santiago Gonzalez

Contact for pricing

About this service

Summary

I provide an automated "Financial Command Center" that bridges the gap between daily tactical survival and long-term board-level strategy. Beyond building custom VBA and Google Sheets ecosystems, I leverage these tools to analyze complex financial structures, simulate restructuring scenarios, and optimize the Net Present Value (NPV) of corporate liabilities. My unique approach offers a 15-day liquidity "early warning" window while ensuring annual dividend targets remain secured and visible to stakeholders.

What's included

Executive Treasury & Liquidity Assets
Custom VBA Treasury Engine (Excel): A fully automated, macro-driven file featuring the "15-day early warning" logic and automated data aggregation. Dual-Horizon Dashboard: A high-level visual interface for switching between daily tactical liquidity and 12-month strategic fiscal planning. Financial Restructuring Simulator: A specialized module to model structured loans, calculate WACC per currency, and optimize the Net Present Value (NPV) of liabilities. Automated Receivables/Payables Portfolio: A document-level tracking system that includes overdue forecasting, procurement term analysis, and settlement reprogramming. Google Sheets Integrated Workflow: A cloud-based version of the core tracking modules for real-time team collaboration and remote data entry. Technical User Manual & Logic Map: Documentation explaining the underlying parametric structure and how to update variables for instant simulation results.

Skills and tools

Financial Advisor

Financial Analyst

Excel VBA

Google Sheets

Microsoft Power BI

Industries

FinTech & Payments

More services

Automated Treasury Ecosystem & 15-Day Liquidity Forecasting

Contact for pricing