Portfolio Details

Treasury Dashboard
Financial Model
Power BI Dashboard

Project Information

  • Category: Corporate Treasury & FP&A
  • Role: Senior Treasury & FP&A Analyst
  • Organization: Sloan Financial Group, LLC
  • Tools Used: Excel, SAP ERP, Power BI, SQL

Corporate Treasury Dashboard & Financial Modeling

Developed comprehensive corporate treasury dashboards and dynamic pro-forma financial models to support executive decision-making at Sloan Financial Group. These tools provide real-time visibility into cash liquidity positions, funding thresholds, and debt covenant obligations across localized asset portfolios valued at up to $18M.

The system integrates advanced Excel modeling capabilities including XLOOKUP functions, nested logic macros, and scenario manager datasets with Power BI visualizations for executive board presentations.

Key Capabilities

Cash Liquidity Monitoring

Real-time tracking of corporate cash positions and treasury funding thresholds across multiple asset portfolios

Debt Covenant Analysis

Dynamic pro-forma models evaluating long-term debt obligations under various interest tier structures and scenarios

CapEx Budget Auditing

Automated authorization auditing against corporate line item budgets to prevent branch operational spending leakage

Executive Reporting

Structured summaries translating complex general ledger trends into board-ready presentations via Power BI dashboards