Use Cases
Real-world Excel/VBA applications developed from the Founder’s hands-on experience across infrastructure, finance, technology and shipping include:
Built a bespoke multi-phase greenfield wind-power financial model for a project in the Mekong region sponsored by a Japanese utility and renewables developer JV.
1
Aggregating palm oil biogas waste supply, capex and opex costs of multiple mill owners in 1 operating and logistics company under project development
2
Automated retrieval of Bloomberg historical SOFR data to support Cumulative Compounded Rate and benchmark calculations
3
VBA-enhanced keyword parsing to identify patterns and red flags in internal project monitoring reports
4
Compute NPV outcomes for P50 and P90 scenarios using Monte Caro simulation based on oil price and production, cost per barrel and fee.
5
Excel-based dashboards to track milestone delays and extract lessons learned for project performance
6
Dynamic benchmarking of credit metrics across counterparties and debt instruments
7
Vessel voyage planning and port scheduling optimization with cost and performance tracking
8
Planning and rollout modeling for last-mile fibre broadband deployments in commercial assets
9
These models and tools served analytical and operational purposes only. ModelXIRR does not offer advice on securities issuance or regulated corporate finance transactions.