Corporate Treasury & Liquidity EngineeringSantiago Gonzalez
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.
Santiago's other services
Contact for pricing
Tags
Excel VBA
Google Sheets
Microsoft Power BI
Financial Analyst
Financial Advisor
Service provided by
Santiago Gonzalez Santiago, Chile
- 1
- Followers
Corporate Treasury & Liquidity EngineeringSantiago Gonzalez
Contact for pricing
Tags
Excel VBA
Google Sheets
Microsoft Power BI
Financial Analyst
Financial Advisor
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.
Santiago's other services
Contact for pricing