Treasury Analyst
Current- Updates collection breakdowns to provide breakdown of each type of collection each week-Utilizes excel models to generate 13-week cash forecast providing a high level view into company receipts and disbursements- Collaborates with European subsidiaries in UK, Denmark, Germany and France to develop overall financial standing in European markets- Develops liquidity reports providing insight into company’s cash position-Ensures that expected cash coming into business aligns with expected #'s via company's ERP system- Develops variance reports showing how collections are performing on a week to week basis- Creates tables within Excel portraying collections per each branch of company- Creates charts within Excel showing forecasted collections for the near future- Utilizes pivot tables to determine which customers are performing best on collections/payments- Creates views that allow high level executives to analyze forecasted ending liquidity week to week- Creates slidedecks portraying European market performance across AR, AP, and liquidity