Repo Rate Calculator Excel Template
Repo Rate Calculator Excel Template
Interactive Excel Financial Model
Download, customize, and integrate into your own analysis
What's Included
- Interactive financial model with live Excel formulas
- All formulas visible and fully editable
- Professional formatting with color-coded inputs & outputs
- Formula reference sheet with variable definitions
- Step-by-step instructions sheet
- Compatible with Microsoft Excel 2016 and later
Download Template
Price range: $0.00 through $20.00
Repo Rate Calculator Excel template with forward interest, implied rate, and haircut/margin calculations using Actual/360.
Online Calculator vs Excel Template
| Feature | Online | Excel |
|---|---|---|
| Instant use — no download | ✓ | — |
| Works offline | — | ✓ |
| Customize formulas & layout | — | ✓ |
| Save & share with colleagues | — | ✓ |
| Integrate into your own models | — | ✓ |
| Print-ready formatting | — | ✓ |
About This Template
Model repurchase agreement interest, implied rates, and collateral haircuts with this Repo Rate Calculator Excel template. Whether you are pricing an overnight repo, evaluating a term funding arrangement, or sizing margin requirements, this spreadsheet gives you a portable, formula-driven workspace you can save, share, and customize.
What You Can Calculate
The template computes five key outputs simultaneously across three result groups:
- Repo Interest — the dollar cost of borrowing for the specified term, using Actual/360 day count.
- Repurchase Price — the total amount the borrower repays at maturity (principal plus interest).
- Implied Repo Rate — the annualized rate derived from a known sale price and repurchase price, useful for comparing quoted terms to other money-market benchmarks.
- Haircut Amount — the dollar value of the margin deducted from collateral.
- Maximum Borrowing — the loan capacity remaining after the haircut is applied.
Required Inputs
Enter six values to drive all calculations:
- Principal Amount (Sale Price) — the initial transaction size (default: $10,000,000).
- Repo Rate — annualized interest rate, typically between 0% and 25%.
- Term (Days) — 1 for overnight repos, or the actual term length up to 365 days.
- Repurchase Price — the agreed buyback price (used for implied-rate calculations).
- Collateral Value — current market value of pledged securities.
- Haircut Rate — percentage discount applied to collateral (typical range 0.5%–10%).
Methodology
Interest is calculated as Principal × (Rate / 100) × (Days / 360), following the Actual/360 convention standard for U.S. money-market instruments including repos, T-bills, and commercial paper. The implied rate reverses this relationship to solve for the annualized rate embedded in two known prices.
Assumptions & Limitations
- Actual/360 day count convention (money-market standard).
- Simple interest — no compounding within the repo term.
- Haircut applied to current market value of collateral.
- No transaction costs, margin calls, or substitution rights modeled.
- For educational purposes only — not financial advice.
Frequently Asked Questions
Yes. Save multiple copies of the template or use different rows to compare terms. Enter each offeru0027s principal, rate, and term to see the total interest cost, then compare implied rates if working backward from quoted prices.
Change the Term (Days) input. Enter 1 for overnight repos, or the actual number of days for term repos (e.g., 7, 14, 30). The template calculates interest using Actual/360 day count convention for any term length.
Enter the market value of your collateral and the haircut percentage. The template calculates both the dollar haircut amount and maximum borrowing capacity. Haircut calculations are independent of the repo rate calculations, so you can model different collateral scenarios without affecting interest results.
A fully interactive financial model with live Excel formulas, an Instructions sheet with usage guide, and a Formula Reference sheet with variable definitions and model assumptions. All formulas are visible and editable.
Microsoft Excel 2016 or later. The template uses standard Excel formulas only — no macros, VBA, or add-ins required.
Yes. All cells are fully editable. You can modify any formula, add your own calculations, change formatting, or integrate the model into your existing spreadsheets.
The online calculator runs in your browser for quick calculations. This Excel template gives you a portable, offline financial model you can customize, save, share with colleagues, and integrate into your own analysis.
This template is provided for educational and personal use. You may use it in your own professional analysis and presentations. Redistribution or resale of the template itself is not permitted.
You can re-download the latest version from your account or by requesting a new download link. Free downloads are limited to 5 per email address per month.
