The auditor wants an independent valuation of our swap

Set the swap up once and revalue it at each month-end off an independent curve, at the same close the bank uses. You get the MtM, PV01 and hypothetical derivative, plus a dated report that traces the mark back to market data, which is what the auditor asks for.

No card needed · 14-day free trial
Excel month-end valuation: MtM and PV01 off the 26 Oct curve, reconciled to the bank’s statement within 1bp, and a 105% dollar-offset ratio
  • ~1bptypical gap to the bank's mark, same close and conventions
  • > 3bpa persistent gap worth querying with the bank
  • $14kthe example’s gap to the bank’s statement, about 1bp of PV01
  • Every inputcurve, date and conventions behind each mark, for the file

Today, and with BlueGamma

How it usually gets done

  • A spreadsheet that discounts the cash flows, built by someone who has since left.
  • The bank's statement: the counterparty marking its own trade, inputs rarely shared.
  • A treasury system or an adviser, at a price built for a much bigger book.

With BlueGamma

  • An independent MtM and PV01 on your exact schedule, amortising included.
  • The valuation timed to the bank's close, so the numbers reconcile.
  • The hypothetical derivative and a dated PDF report, every month-end.

Not the right fit if you want the hedge accounting entries posted for you. BlueGamma produces the valuations and their inputs; your team or adviser posts them.

How it works

  1. 01

    Enter the trade once

    Currency, start date, payment dates, frequency and fixed rate, matched to the confirmation. Paste an amortising notional profile straight from Excel. For hedge accounting, add the hypothetical as a second swap with the critical terms of the hedged debt.

    app.bluegamma.io/swap-mtm
    BlueGamma Swap MtM detail for a demo EUR swap: mark-to-market, PV01, replacement rate and the notional schedule
  2. 02

    Value it at the bank's close

    Pick the valuation date and time: if the bank marks at London 5pm, so do you. PV01 turns any gap into basis points, a number your CFO can set a threshold against.

  3. 03

    File the report

    Download the dated valuation report and the curve inputs behind it, and file both with the hedge documentation. Need the same trade as of several past dates for testing or a late designation? The Excel add-in prices it by as-of date in your own workpapers.

In their words

Inputs, not just the mark
“What we need is not just an MtM at that point. What we need is all the inputs that have gone in determining that MtM.”
Hedge accounting adviser, Big Four firm
“If [our auditors] would come in and audit us in September and I go, yeah, I bootstrap my own curves and this is why we've made all these postings, it gives you less of a confidence interval than 'we've used a tool'.”
Finance manager, UK consumer-leasing fintech

Your options, compared

Your own spreadsheet and the bank's statement aren't independent, and an adviser charges per engagement. BlueGamma gives the auditor an independent value with every input behind it.

CriterionBlueGammaYour own Excel valuationThe bank's statementA valuation adviser
Is it independent of you and the bank?YesNo, you built itNo, it comes from the counterpartyYes
Can it value a hypothetical derivative?Yes, as a second swap on the same curveYes, but you rebuild and maintain itNoYes, for a fee
Does it match the bank's closing time?Yes, pick the date and timeOnly if you pasted rates at that timeYes, by definitionIt uses their own close and method
Can you see the inputs behind the number?Yes, they are downloadableOnly what was pasted inRarelyYes, in their report
What does it cost?A monthly licenceHours of work every month-endBuilt into the trade priceA fee per engagement

Questions teams ask

Have the answer ready before the auditor asks

Load your swap, value it at the bank's close, and file a dated report that traces back to the market.

Value your swap free
No card needed · 14-day free trial