AI for corporate treasury
Build the daily cash position and the 13-week forecast, pull the fees off the account analyses, and test covenant headroom, from the exports, statements and agreements in your treasury folder. Every number cites the file it came from.
13-week-forecast.xlsxExample| Week ending | Opening | Receipts | Disbursements | Closing | Driver |
|---|---|---|---|---|---|
| Nov 13 | 6,820 | 3,940 | −4,415 | 6,345 | The Nov 11 payroll of $2.8M falls in this week. |
| Nov 20 | 6,345 | 4,210 | −3,880 | 6,675 | No payroll falls here, and receipts follow the AR aging. |
| Nov 27 | 6,675 | 2,960 | −5,610 | 4,025 | Thanksgiving slows receipts, and the Nov 25 payroll lands here. |
| Dec 4 | 4,025 | 3,480 | −4,190 | 3,315 | Note interest of $1.4M and the Dec 1 rent run fall here. |
| Dec 11 | 3,315 | 5,640 | −3,960 | 4,995 | Two annual renewals cover the Dec 9 payroll. |
NoteWeek 4 closes $685k under the $4.0M minimum, so draw $1.0M on the revolver by Dec 1 or move the $1.2M capex payment a week.
Ask it for
“From the AR aging, AP schedule and payroll calendar, build the 13-week forecast and flag every week where closing cash falls below the $4m minimum.”
13-week-forecast.xlsx“Rebuild the fees from the October account analysis statements for all 22 accounts, listed by AFP service code, and show the net fees after the earnings credit.”
Bank-fee-analysis-Oct.xlsx“Check the operating portfolio against the policy’s rating, maturity and issuer limits, list the breaches, and total the unrealized losses for the ASC 320 note.”
Portfolio-policy-check.xlsx“Net the payables and receivables by currency against the forwards on the books, then draft the designation memo for the EUR 5m forward on supplier invoices.”
CFH-designation-memo-EUR5m.docx“Prepare the Q3 compliance certificate from the amended credit agreement and covenant model. Show excess availability against the trigger and the springing FCCR.”
Q3-compliance-certificate.xlsx“Convert the two post-money SAFEs, capped at $18m and $24m, price the Series A on a $30m pre-money, and build the pro forma cap table with the pool top-up.”
Pro-forma-cap-table.xlsx
Inside the Treasury & Capital mode
Cash forecasting
Pulls the daily position and 13-week forecast from the AR aging, the AP schedule and payroll calendar, with last week’s forecast-to-actual variance attached.
Bank account management and fees
Breaks account analysis fees out by AFP code, checks the earnings credit against the balances that earned it, and reviews positive pay and ACH block coverage.
Corporate investment portfolio
Tests the portfolio against the policy limits on rating, maturity and issuer, and produces the ASC 320 or GASB 40 and 72 disclosure schedules.
FX and rate hedging analysis
Nets exposures by currency and flags over-hedged positions, then drafts the designation memos and runs the quarterly dollar-offset test.
Credit underwriting and covenants
Reads the credit agreement and every amendment, sizes baskets and incremental capacity, and builds the covenant model behind the compliance certificate.
Long-range plan and capital raise
Assembles the long-range model with linked statements and dated assumptions, and tests the raise or refinance case against each covenant.
Restructuring and liquidity
Keeps the distressed 13-week and DIP budget tied to weekly actuals, tracks the variance covenants, and models recoveries by class.
Cap table and term sheets
Converts SAFEs and notes into a pro forma cap table, runs the liquidation waterfall at several exit values, and tracks Rule 701, Form D and 83(b) deadlines.
- Office skills
- Excel, Word, PowerPoint, PDF
- Tools
- Read, edit and write files, Search files, Run code, Search and read the web, View images
- Connectors
- SharePoint, Google Drive, Gmail, and additional custom connectors
- House style
- Your fonts, layouts and rules, on every file
How it works
- 1
Drop in the week’s files
The folder takes the bank statements and BAI2 or camt.053 exports, the AR and AP agings, the payroll calendar, investment statements, the account analysis PDFs, and the credit agreement with its amendments.
- 2
Ask for the deliverable
You ask for a rebuilt 13-week with weekly columns, a bank fee schedule by AFP code, a designation memo or a compliance certificate. The file comes back with live formulas and a source note on every tab.
- 3
Review, then act
Anything the mode could not reconcile is flagged, never buried. Re-tie whatever you plan to rely on and make the funding and hedging calls yourself. Nothing posts or moves on its own.
Who it’s for
Corporate treasury teams, from cash analysts to treasurers, at companies, universities, health systems and public entities.
Questions
Can it read BAI2 files, bank statements and account analysis statements?
It reads whatever the folder holds, including BAI2 and camt.053 exports, PDF statements and bank portal downloads. The mode carries the AFP service codes used on account analysis statements, so it can recompute the fees and earnings credit by code. When it cannot find or reconcile something, it says so rather than guessing.
How do I know the covenant math and hedge tests are right?
The schedules are built in Excel with live formulas, the checks run as code, and you can see the file and tab each number came from. Whatever it could not tie out is marked for you to chase down. The dollar-offset test and the leverage calculation are still yours to re-perform before you sign the certificate, and Paper Instruments does not promise that every number is right.
What about amendments that restate the covenant definitions?
Include the original agreement, every amendment and any side letters before you ask about baskets or incremental capacity, because it reads only the versions of the documents that are in the folder. Its skills tell it to stop and note the missing document, not to answer from the agreement as signed. If the agreement’s confidentiality terms allow an upload at all, that is a decision for your company and its counsel, not for the tool.
Is our bank and investment data kept confidential?
Ultramarine Work changes files only in the project’s folder. When a request needs it, it can read files elsewhere on your computer, never passwords, keys or app data, and you can turn that off in settings. The model runs on Paper Instruments’ servers, so the content it works on is sent there to be processed. Paper Instruments is SOC 2 Type II, and our security and compliance details are on our compliance page.