Treasury analysts manage the financial lifeblood of an organization — cash positioning, liquidity forecasting, debt compliance, and risk mitigation — often under intense time pressure with incomplete data. AI can accelerate analysis, sharpen your models, and help you communicate complex findings to senior leadership. These 35 prompts are built for corporate treasury professionals.
1. Cash Management & Liquidity
I am a treasury analyst preparing the daily cash position report for a corporate treasury with accounts at [number] banks across [number] countries. Create a standardized daily cash position template covering: opening balances by account and currency, expected inflows (collections, intercompany receipts), expected outflows (payroll, AP disbursements, debt service), net position, and minimum balance targets. Include a variance vs. forecast column.
Our 13-week cash flow forecast is consistently off by more than 10% in weeks 6-13. Identify the most common causes of rolling cash forecast inaccuracy at this horizon and suggest 5 specific process improvements — covering data inputs, forecasting methodology, cross-functional integration, and technology — that could improve accuracy within one quarter.
I need to build a cash concentration strategy for a company with [X] operating entities in [regions]. Compare the following structures: physical notional pooling, zero-balance accounts (ZBA), and target balancing. For each, explain the mechanics, tax and regulatory considerations, bank requirements, and the ideal company profile it suits best.
Write a Python script that reads a CSV file of daily bank account balances (columns: date, account_id, currency, balance_local, exchange_rate_to_USD), converts all balances to USD, calculates daily aggregate cash position, flags any account below its minimum balance target (provided as a separate input dict), and outputs a summary table and a time-series line chart.
Our company is evaluating which excess cash to deploy into short-term investments vs. keeping as operating liquidity. Build a decision framework that covers: minimum liquidity reserve calculation (using [X] days of operating expenses), tiered investment policy (operating tier, reserve tier, strategic tier), approved instrument types per tier, and yield vs. liquidity trade-off analysis. Base the framework on a company with $[amount] in average daily cash.
2. Forecasting & Modeling
Explain three forecasting methodologies I should evaluate for building our annual cash flow forecast: bottom-up direct method, top-down indirect method, and a hybrid statistical approach. For each, describe the data requirements, accuracy profile, implementation effort, and the organizational maturity level where each works best.
Write an Excel VBA macro (or Python/pandas equivalent) that: imports weekly cash flow actuals from a CSV, compares each line item against the forecast, calculates the variance in absolute dollars and percentage, highlights cells where variance exceeds 15%, and exports a formatted variance report to a new worksheet named 'Variance_Report_[date]'.
I need to present a monthly treasury dashboard to our CFO. Design the dashboard layout and specify the 15 KPIs to include, organized into four sections: Liquidity, Debt & Borrowings, FX Exposure, and Investment Portfolio. For each KPI, specify the metric name, formula, data source, and the visualization type (gauge, trend line, table, etc.).
Build a sensitivity analysis for our 12-month cash flow forecast. The three key variables are: [Variable 1, e.g., DSO], [Variable 2, e.g., inventory days], and [Variable 3, e.g., revenue growth rate]. Create a tornado chart data table showing how a ±10% and ±20% change in each variable affects our projected year-end cash balance of $[amount]. Provide the Python code using matplotlib to generate the tornado chart.
My company's cash flow seasonality creates a peak liquidity need of $[amount] in [month]. Model three funding options to cover the seasonal shortfall: (1) drawing on our revolving credit facility, (2) issuing commercial paper, and (3) accelerating collections via supply chain finance. For each option, calculate the all-in cost, show the cash flow timing, and list the key execution risks.
3. Debt, Capital Markets & Financing
Our company has the following debt instruments outstanding: [list instruments with amounts, rates, and maturities]. Create a debt maturity schedule and identify: refinancing risk concentrations, average cost of debt, weighted average maturity, fixed vs. floating rate mix, and covenant compliance summary. Flag the top two near-term risks.
I need to prepare a bank meeting presentation for our annual credit facility renewal. Draft a 10-slide outline covering: company overview, financial performance highlights (key metrics with placeholders), liquidity position, debt structure overview, facility use history, covenant compliance record, proposed terms rationale, and why our credit profile supports the request.
Explain the mechanics of an interest rate swap where our company (fixed rate payer) swaps a [X]% fixed rate on $[notional] of floating-rate debt for [SOFR + spread] for [term] years. Walk through: economic rationale, accounting treatment under ASC 815 hedge accounting, effectiveness testing approach, and the P&L impact if rates move ±100 bps.
Our company is evaluating a $[amount] term loan vs. a bond issuance to fund a capital expenditure program. Compare both options across: cost of capital, covenant flexibility, prepayment optionality, execution timeline, investor/lender diversification, and balance sheet impact. Recommend one with a justification paragraph.
Draft the treasury section of a quarterly earnings call script for our CFO covering: ending cash and liquidity position, revolver availability, debt repayment activity, key debt metrics (leverage ratio, interest coverage), and our liquidity outlook for the next two quarters. Use placeholder figures and professional investor relations language.
4. FX & Commodity Risk Management
Our company has the following FX exposures by currency and tenor: [list currencies, notional amounts, and time horizons]. Build a FX risk management framework that covers: exposure identification methodology (transaction, translation, economic), hedging policy targets (% of exposure to hedge by tenor), approved hedging instruments, hedge accounting election considerations, and governance/approval requirements.
Walk me through how to value a EUR/USD forward contract where we are long EUR forward at a rate of [rate] for a notional of EUR [amount] maturing in [X] days. Use the interest rate parity formula. Then show how a 1% appreciation of EUR vs. USD affects the mark-to-market value of the contract. Provide the Excel formula and the Python calculation.
I need to prepare a monthly FX exposure and hedging report for our CFO. Design the report template with sections for: net open exposure by currency, hedge ratio by currency and tenor, MTM of outstanding hedges, P&L attribution (hedge gains/losses vs. underlying transaction P&L), and forward-looking exposure for the next 12 months.
Our company purchases [commodity, e.g., natural gas] and wants to hedge price risk using NYMEX futures. Explain: how to calculate the hedge ratio using regression analysis, the roll strategy for a 12-month hedging horizon, basis risk considerations, margin call mechanics, and how to account for the hedges under ASC 815 cash flow hedge accounting.
Draft a hedge effectiveness testing memo for our [instrument type, e.g., cross-currency swap] hedge of a [EUR-denominated intercompany loan]. Cover: hedging objective and risk being hedged, critical terms comparison, hypothetical derivative method, quantitative effectiveness test results (use placeholder data), conclusion on effectiveness, and required disclosures under ASC 815.
5. Banking Relationships & Operations
I need to conduct an annual review of our banking panel. Create a bank scorecard with 20 evaluation criteria across: credit facility availability and pricing, transaction banking services, technology and platform capabilities, FX and derivatives execution quality, trade finance capabilities, ESG/sustainability offerings, relationship quality, and fees vs. value delivered. Weight and score each criterion.
Draft an RFP for treasury management services to send to [X] banks. The scope includes: operating account structures, payment processing, liquidity management, and online banking platform. Include: company overview, current banking structure, scope of services required, evaluation criteria, fee transparency requirements, implementation timeline expectation, and RFP response deadline.
Our company is implementing a new TMS (Treasury Management System). Create a 6-month implementation project plan with: phase names and objectives, key milestones, workstreams (data migration, system configuration, integration with ERP, user testing, go-live), stakeholders by workstream, and a risk register with the top 5 implementation risks and mitigations.
Explain how to build a bank fee analysis model to identify cost-saving opportunities in our treasury operations. Describe: how to extract and normalize AFP service code data from bank billing statements, how to benchmark fees against AFP survey data, how to identify the top 5 cost drivers, and how to structure a negotiation conversation with our relationship manager.
Draft talking points for a quarterly treasury review meeting with our lead bank relationship manager. Topics to cover: facility utilization and availability, upcoming financing needs, FX flow trends, new product or service interest, fee performance vs. budget, and two issues I want to raise or negotiate. Keep it as a bullet-point script I can follow during the call.
6. Risk, Compliance & Controls
Build a treasury risk register for our corporate treasury function. For each risk category — liquidity risk, market risk (FX, interest rate, commodity), counterparty/credit risk, operational risk, and compliance risk — provide: risk description, likelihood (1-5), impact (1-5), current controls, residual risk rating, and recommended additional mitigation.
Our treasury needs to implement SOX controls over cash management and financial reporting. Identify the 10 most important treasury-related SOX controls, describe the control objective, the specific control activity, the evidence required for testing, and the common deficiencies found by auditors in each area.
We are onboarding a new banking counterparty and need to complete KYC/AML documentation. Create a counterparty onboarding checklist covering: required entity documentation, beneficial ownership verification, ISDA/CSA agreement requirements, credit risk assessment steps, internal approval workflow, and ongoing monitoring triggers.
Explain the key financial covenants in a typical investment-grade revolving credit agreement: Total Net Leverage Ratio, Interest Coverage Ratio, and Minimum Liquidity covenant. For each: define the formula, explain the calculation using our placeholder financials, describe the cure period mechanics, and identify the early warning KPIs we should monitor monthly to avoid a breach.
Draft a treasury policy document for [company type]'s cash investment policy. Include sections for: policy purpose and scope, approved investment instruments and maximum maturities, counterparty credit quality requirements (minimum ratings), concentration limits, prohibited instruments, reporting requirements, and exception approval process.
7. Communication, Career & Professional Development
I need to write a treasury commentary for our Board of Directors covering Q[X] treasury performance. Draft a 400-word narrative covering: liquidity summary, debt activity and metrics, key market risk exposures and hedging actions taken, notable events or risks, and our treasury priorities for the next quarter. Use executive-level language that is clear to non-treasury board members.
I am preparing for a Treasury Manager interview at a [company type, e.g., large-cap multinational]. Generate 10 behavioral and technical interview questions likely to be asked, covering: cash management, forecasting, FX risk, banking relationships, and leadership. For each, provide a model answer using the STAR method with placeholders for my specific examples.
Suggest a 12-month professional development plan for a treasury analyst who wants to earn the CTP (Certified Treasury Professional) designation while advancing toward a Treasury Manager role. Include: exam preparation timeline, study resources, on-the-job skill-building projects, professional network activities, and a mentorship conversation agenda to have with their manager.
Write a persuasive email to my CFO requesting budget approval for [treasury initiative, e.g., implementing a TMS or joining a supply chain finance program]. Keep it under 300 words. Cover: the business problem we are solving, the proposed solution, key financial benefits (use placeholder ROI figures), implementation risk mitigation, and a request for a 30-minute discussion.
Create a knowledge-transfer document outline for my role as a Treasury Analyst so my backup can cover key functions during my absence. Include sections for: daily tasks with step-by-step instructions, weekly and monthly tasks, key contacts (internal and bank counterparts), system access and login procedures (placeholder), critical deadlines, and escalation contacts for urgent issues.
Get the Complete Treasury Analyst AI Toolkit
Get the complete AI Prompt Toolkit for Treasury Analysts →
Works with Claude, ChatGPT, and DeepSeek. Copy-paste ready.
Top comments (0)