Excel financial functions
Excel's financial, date and depreciation functions with the same arguments and conventions: PMT, RATE, XIRR, YEARFRAC, DAYS360, NETWORKDAYS, PRICE, YIELD, DURATION, DB and VDB among them. Results match Microsoft's published examples and values saved by Excel, and RATE, XIRR and YIELD return proven roots instead of stopping after a fixed number of tries.
Total interest paid on a loan from one period to another, as Excel's CUMIPMT.
Checked against 1 published value
Total principal repaid from one period to another, as Excel's CUMPRINC.
Checked against 1 published value
Days between two dates on a 360-day year, by the US (NASD) or European method, as Excel's DAYS360.
Checked against 3 published values
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 values
Double-declining (or any factor) balance depreciation for one period, as Excel's DDB.
Checked against 4 published values
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 value
The same day of the month a number of months before or after a date, as Excel's EDATE.
Checked against 3 published values
The effective annual rate from a nominal rate and compounding periods, as Excel's EFFECT.
Checked against 1 published value
The last day of the month a number of months before or after a date, as Excel's EOMONTH.
Checked against 2 published values
The future value of an investment with equal payments, the same as Excel's FV.
Checked against 2 published values
The interest paid in one period of a loan, the same as Excel's IPMT.
Checked against 2 published values
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 value
The modified IRR of periodic cash flows with separate finance and reinvestment rates, as Excel's MIRR.
Checked against 2 published values
Working days between two dates, both included, with holidays and any weekend, as Excel's NETWORKDAYS and NETWORKDAYS.INTL.
Checked against 3 published values
The nominal annual rate from an effective rate, as Excel's NOMINAL.
Checked against 1 published value
How many periods it takes to pay off a loan or reach a goal, as Excel's NPER.
Checked against 2 published values
The payment per period for a loan or an investment, the same as Excel's PMT.
Checked against 1 published value
The principal repaid in one period of a loan, the same as Excel's PPMT.
Checked against 2 published values
The clean price per 100 of a bond paying periodic coupons, from its yield, as Excel's PRICE.
Checked against 1 published value
The present value of a series of equal payments, the same as Excel's PV.
Checked against 1 published value
The interest rate per period of a loan or annuity, as Excel's RATE, proven correct to the last digit.
Checked against 1 published value
Straight-line depreciation for one period, as Excel's SLN.
Checked against 1 published value
Sum-of-years' digits depreciation for one period, as Excel's SYD.
Checked against 2 published values
Declining-balance depreciation between any two points in an asset's life, switching to straight line, as Excel's VDB.
Checked against 4 published values
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 values
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 value
Net present value of cash flows on any dates, the same as Excel's XNPV.
Checked against 1 published value
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 values
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 value
As an API
Each of these calculators is a POST endpoint and an MCP tool with the same inputs and results as this site.