Excel's answers, in your code
29 of Excel's financial and date functions as an API: XIRR, XNPV, RATE, PMT, YEARFRAC, NETWORKDAYS, PRICE, YIELD and more. Same arguments, same conventions, same results as Excel.
Free plan, no card needed. Test keys are never billed.
curl https://api.curatedapi.com/v1/calc/excel/xirr \
-H "Authorization: Bearer $CURATEDAPI_KEY" \
-H "Content-Type: application/json" \
-d '{
"values": ["-10000", "2750", "4250", "3250", "2750"],
"dates": ["2008-01-01", "2008-03-01", "2008-10-30", "2009-02-15", "2009-04-01"],
"options": {"significant_digits": 7}
}'
{
"calculator": "excel/xirr@1",
"result": {
"xirr": "0.3733625",
"all_rates": [
"0.3733625"
]
}
}
The problem
When a financial model moves from a spreadsheet into an app, the numbers often stop matching. XIRR gives a different rate, YEARFRAC counts the days another way, or RATE gives up with an error. Then someone has to explain to finance why the app disagrees with Excel.
Each function follows Excel's documented arguments and day-count rules, and is checked against Microsoft's published examples and values saved by Excel. RATE, XIRR and YIELD return proven roots instead of stopping after a fixed number of tries.
What you get
- Microsoft's examples run before every release and against the live API every five minutes
- Decimal arithmetic, rounded once, to the digits you choose
- An MCP tool too, so an AI agent can answer "what would Excel say?"
- Free to try on this site, without signing up
What a month costs
Each of these function calls is one call. The cheapest plan for each volume, in US dollars (euro plans cost the same number of euros), before any VAT or sales tax your country charges. A spend cap stops calls at the amount you choose.
| Function calls a month | Plan | Per month |
|---|---|---|
| 1,000 | Free | $0 |
| 50,000 | Starter | $9.00 |
| 500,000 | Pro | $29.00 |
| 2,000,000 | Business | $99.00 |
All plans are on the pricing section of the home page.
Endpoints
Each one is a POST endpoint and an MCP tool. Its page shows the inputs, an example and the sources it is checked against.
Total interest paid on a loan from one period to another, as Excel's CUMIPMT.
Checked against 1 published case
Total principal repaid from one period to another, as Excel's CUMPRINC.
Checked against 1 published case
Days between two dates on a 360-day year, by the US (NASD) or European method, as Excel's DAYS360.
Checked against 3 published cases
Fixed-declining balance depreciation for one period, as Excel's DB, including its three-decimal rate and part-year first and last periods.
Checked against 2 published cases
Double-declining (or any factor) balance depreciation for one period, as Excel's DDB.
Checked against 4 published cases
The Macaulay duration of a bond with periodic coupons, as Excel's DURATION: the average time to its payments, weighted by their present value.
Checked against 1 published case
The same day of the month a number of months before or after a date, as Excel's EDATE.
Checked against 3 published cases
The effective annual rate from a nominal rate and compounding periods, as Excel's EFFECT.
Checked against 1 published case
The last day of the month a number of months before or after a date, as Excel's EOMONTH.
Checked against 2 published cases
The future value of an investment with equal payments, the same as Excel's FV.
Checked against 2 published cases
The interest paid in one period of a loan, the same as Excel's IPMT.
Checked against 2 published cases
The modified Macaulay duration of a bond with periodic coupons, as Excel's MDURATION: the percentage change in price for a change in yield.
Checked against 1 published case
The modified IRR of periodic cash flows with separate finance and reinvestment rates, as Excel's MIRR.
Checked against 2 published cases
Working days between two dates, both included, with holidays and any weekend, as Excel's NETWORKDAYS and NETWORKDAYS.INTL.
Checked against 3 published cases
The nominal annual rate from an effective rate, as Excel's NOMINAL.
Checked against 1 published case
How many periods it takes to pay off a loan or reach a goal, as Excel's NPER.
Checked against 2 published cases
The payment per period for a loan or an investment, the same as Excel's PMT.
Checked against 1 published case
The principal repaid in one period of a loan, the same as Excel's PPMT.
Checked against 2 published cases
The clean price per 100 of a bond paying periodic coupons, from its yield, as Excel's PRICE.
Checked against 1 published case
The present value of a series of equal payments, the same as Excel's PV.
Checked against 1 published case
The interest rate per period of a loan or annuity, as Excel's RATE, proven correct to the last digit.
Checked against 1 published case
Straight-line depreciation for one period, as Excel's SLN.
Checked against 1 published case
Sum-of-years' digits depreciation for one period, as Excel's SYD.
Checked against 2 published cases
Declining-balance depreciation between any two points in an asset's life, switching to straight line, as Excel's VDB.
Checked against 4 published cases
The date a number of working days before or after a date, with holidays and any weekend, as Excel's WORKDAY and WORKDAY.INTL.
Checked against 3 published cases
The annual rate of return of cash flows on any dates, as Excel's XIRR, proven correct to the last digit.
Checked against 1 published case
Net present value of cash flows on any dates, the same as Excel's XNPV.
Checked against 1 published case
The fraction of a year between two dates under Excel's five day-count bases, including Excel's own actual/actual rule.
Checked against 3 published cases
The yield of a bond paying periodic coupons, from its price, as Excel's YIELD, proven correct to the last digit.
Checked against 1 published case
Missing something you need?
Tell us what you need and the source you trust, such as a regulator's example or a spreadsheet. Most new calculators go live within a week, checked against that source. Write to hello@curatedapi.com.