Financial Functions

Functions for financial calculations

ACCRINT Function

The Excel ACCRINT function calculates the accrued interest for securities that pay periodic interest, such as bonds or treasury notes. It accounts for different day count conventions and payment frequencies to provide precise interest calculations between issue and settlement dates.

ACCRINTM Function

The ACCRINTM function calculates accrued interest for securities that pay interest at maturity, such as zero-coupon bonds or discount notes. It determines the interest earned from issue date to settlement date based on the specified coupon rate and day count convention.

AMORDEGRC Function

The AMORDEGRC function calculates depreciation for each accounting period using the French accounting system. It applies a depreciation coefficient based on asset life and handles prorated depreciation for assets purchased mid-period. ⚠️ This function is deprecated due to changes in French accounting standards.

AMORLINC Function

The AMORLINC function calculates depreciation for each accounting period using the French linear depreciation method. It accounts for prorated depreciation when assets are purchased mid-period, making it essential for French accounting compliance.

COUPDAYBS Function

The COUPDAYBS function calculates the number of days from the start of the coupon period to the settlement date for bonds or securities, essential for accurate interest calculations in fixed-income investments.

COUPDAYS Function

The COUPDAYS function in Excel calculates the number of days in the coupon period containing the settlement date for bonds or securities. Essential for financial analysis, it helps determine accrued interest periods based on specified day count conventions.

COUPDAYSNC Function

The COUPDAYSNC function calculates the number of days from the bond's settlement date to its next coupon payment date, essential for precise interest calculations in fixed-income securities analysis.

COUPNCD Function

The Excel COUPNCD function calculates the next coupon payment date following the settlement date for a bond or security with periodic interest payments. Essential for financial analysts tracking bond schedules and cash flows.

COUPNUM Function

The COUPNUM function calculates the total number of coupon payments remaining between a bond's settlement date and maturity date, automatically rounding up to the next whole coupon period. Essential for bond traders and financial analysts tracking fixed-income securities.

COUPPCD Function

The Excel COUPPCD function calculates the previous coupon payment date before the settlement date for a bond or security. This financial function is essential for bond pricing and cash flow analysis.

CUMIPMT Function

The CUMIPMT function calculates the total interest paid on a loan over a specific range of payment periods. It's essential for financial analysis, helping users understand interest costs during different phases of loan repayment.

CUMPRINC Function

The CUMPRINC function calculates the total principal portion paid on a loan between two specified payment periods. Essential for loan amortization analysis and financial planning.

DB Function

The DB function calculates depreciation for an asset during a specific time period using the fixed-declining balance method. This approach applies a consistent depreciation rate to the remaining book value each period.

DDB Function

The DDB function calculates depreciation for an asset during a specific period using the double-declining balance method or a custom declining balance rate. This accelerated depreciation approach applies higher charges early in the asset's life, making it ideal for assets that lose value quickly.

DISC Function

The Excel DISC function calculates the annual discount rate for a security that pays interest at maturity, based on its settlement date, maturity date, price, and redemption value. It's essential for analyzing discount securities like Treasury bills.

DOLLARDE Function

The Excel DOLLARDE function converts a dollar amount expressed as an integer plus fraction (like 1.02 meaning 1 + 2/16) into its precise decimal equivalent. Essential for financial calculations involving security prices and fractional denominations.

DOLLARFR Function

The DOLLARFR function converts a standard decimal dollar amount into a fractional dollar representation, commonly used for displaying securities prices and financial instruments that trade in fractional increments.

DURATION Function

The DURATION function calculates the Macaulay duration for a bond assuming a $100 par value. This advanced financial metric measures a bond's price sensitivity to yield changes by computing the weighted average time to receive cash flows.

EFFECT Function

The Excel EFFECT function converts a nominal annual interest rate and compounding frequency into the true effective annual interest rate, accounting for the power of compound interest.

FV Function

The FV function calculates the future value of an investment based on periodic payments and a constant interest rate. It helps forecast how much an investment will grow over time, accounting for regular contributions and compound interest.

FVSCHEDULE Function

The FVSCHEDULE function calculates the future value of an initial principal after applying multiple compound interest rates sequentially. Perfect for investments with variable rates over different periods.

INTRATE Function

The Excel INTRATE function calculates the interest rate for a fully invested security, such as a bond or treasury bill, based on settlement date, maturity date, initial investment amount, and redemption value. Essential for fixed income analysis and security valuation.

IPMT Function

The IPMT function calculates the interest portion of a periodic payment for any specific period in a loan or investment with fixed payments and constant interest rate. Essential for loan amortization schedules and financial analysis.

IRR Function

The Excel IRR function calculates the internal rate of return for a series of cash flows occurring at regular intervals. It determines the discount rate that makes the net present value of all cash flows equal to zero, helping investors evaluate project profitability.

ISPMT Function

The Excel ISPMT function calculates the interest portion of a payment for a specific period in loans or investments that use equal principal repayment schedules. Unlike standard amortization, this function handles loans where the principal repayment remains constant each period while interest decreases over time.

MDURATION Function

The Excel MDURATION function calculates the modified Macauley duration for a security assuming a $100 par value. This financial metric measures a bond's price sensitivity to interest rate changes, helping investors assess interest rate risk.

MIRR Function

The MIRR function calculates the modified internal rate of return for an investment, accounting for both the financing cost of the investment and the reinvestment rate of cash inflows. This provides a more accurate return measure than the standard IRR by using different rates for cash outflows and inflows.

NOMINAL Function

The Excel NOMINAL function converts an effective annual interest rate into its equivalent nominal annual interest rate based on a specified number of compounding periods per year. This is essential for financial analysis comparing rates across different compounding frequencies.

NPER Function

The NPER function calculates the number of payment periods required to reach a specified financial goal given constant payments, interest rate, and present value. It's essential for loan term analysis, savings planning, and investment duration calculations.

NPV Function

The Excel NPV function calculates the net present value of an investment based on a discount rate and a sequence of future cash flows. It discounts future payments (negative values) and income (positive values) to their present value, helping determine investment profitability.

ODDFPRICE Function

The ODDFPRICE function calculates the price per $100 face value of a security with an irregular first coupon period. Ideal for bonds where the initial payment doesn't align with standard coupon intervals.

ODDFYIELD Function

The ODDFYIELD function calculates the yield on a security featuring an irregular first coupon period, essential for bonds with non-standard payment schedules at issuance.

ODDLPRICE Function

The ODDLPRICE function calculates the price per $100 face value of a security with an irregular final coupon period. Perfect for fixed-income analysts pricing bonds with non-standard last interest payments.

ODDLYIELD Function

The Excel ODDLYIELD function calculates the yield for a security featuring an irregular (odd) final coupon period. This advanced financial function is essential for accurately pricing bonds with non-standard last interest periods.

PDURATION Function

The PDURATION function calculates the number of periods needed for an investment to grow from its present value to a target future value at a constant interest rate. It's essential for financial planning and investment analysis.

PMT Function

The PMT function calculates the periodic payment for a loan or investment based on constant payments and a fixed interest rate. It's essential for financial planning, helping users determine affordable loan payments or required savings contributions.

PPMT Function

The PPMT function calculates the principal portion of a periodic payment for a loan or investment with constant payments and interest rate. It isolates how much of each payment reduces the principal balance.

PRICE Function

The Excel PRICE function calculates the price per $100 face value of a bond or security that pays periodic interest. It factors in settlement date, maturity date, coupon rate, yield, redemption value, payment frequency, and day count basis for precise bond valuation.

PRICEDISC Function

The PRICEDISC function calculates the price per $100 face value of a discounted security, such as a Treasury bill, based on settlement date, maturity date, discount rate, and redemption value. Essential for fixed-income analysis and bond pricing.

PRICEMAT Function

The PRICEMAT function calculates the price per $100 face value of a security that pays interest at maturity, essential for bond traders and financial analysts valuing securities bought in the secondary market.

PV Function

The Excel PV function calculates the present value of an investment or loan based on a constant interest rate and equal payments. It's essential for financial analysis, helping determine the current worth of future cash flows from annuities like mortgages, car loans, or savings plans.

RATE Function

The Excel RATE function calculates the interest rate per period for an annuity, making it essential for loan analysis, investment planning, and mortgage calculations. It uses iterative methods to solve for the rate when you know the payment amount, present value, and number of periods.

RECEIVED Function

The RECEIVED function calculates the maturity value of a fully invested security, accounting for the discount rate and time to maturity. It's essential for bond traders and financial analysts working with discounted securities to determine redemption amounts.

RRI Function

The Excel RRI function calculates the equivalent interest rate required for an investment to grow from its present value to a specified future value over a given number of periods. It's a powerful financial tool for reverse-engineering interest rates from investment growth scenarios.

SLN Function

The Excel SLN function calculates straight-line depreciation for an asset over a specified period, providing a consistent annual depreciation expense based on the difference between initial cost and salvage value.

SYD Function

The Excel SYD function calculates depreciation using the sum-of-years' digits method, allocating higher depreciation amounts to earlier years of an asset's useful life. This accelerated depreciation approach matches expense recognition with higher early usage and wear.

TBILLEQ Function

The TBILLEQ function calculates the bond-equivalent yield for a Treasury bill based on its settlement date, maturity date, and discount rate. This conversion standardizes Treasury bill yields for comparison with other fixed-income securities using a 365-day year convention.

TBILLPRICE Function

The TBILLPRICE function calculates the price per $100 face value of a U.S. Treasury bill based on its settlement date, maturity date, and discount rate. This financial function is essential for bond traders and investors analyzing short-term government securities.

TBILLYIELD Function

The TBILLYIELD function calculates the yield on a U.S. Treasury bill based on its settlement date, maturity date, and price per $100 face value. This essential financial function helps investors and analysts determine the effective return on discount Treasury securities.

VDB Function

The VDB function calculates depreciation for any specified period using the variable declining balance method. Unlike fixed-period functions, VDB handles partial periods and customizable depreciation rates, making it ideal for precise financial reporting and tax calculations.

XIRR Function

The Excel XIRR function calculates the internal rate of return (IRR) for a series of cash flows occurring at irregular intervals. Unlike the standard IRR function which assumes periodic payments, XIRR handles real-world scenarios where cash flows happen on specific, non-periodic dates.

XNPV Function

The XNPV function calculates the net present value for cash flows occurring on irregular dates, using actual days between payments based on a 365-day year. Unlike standard NPV which assumes periodic intervals, XNPV handles non-periodic cash flows with precise date-based discounting.

YIELD Function

The YIELD function calculates the annual yield for a bond or security that makes periodic interest payments, helping investors assess return based on current market price and coupon terms.

YIELDDISC Function

The YIELDDISC function calculates the annual yield for a discounted security, such as commercial paper or Treasury bills, based on the purchase price and redemption value. This financial function helps investors determine the effective annualized return on discount instruments that don't pay periodic interest.

YIELDMAT Function

The YIELDMAT function calculates the annual yield for a security that pays interest at maturity, such as certain bonds or notes. This financial function helps investors determine the effective return based on settlement date, maturity, issue details, interest rate, and market price.