Financial Functions

This function calculates the price of a fixed-income security (loan), meaning the purchase price excluding any accrued interest. Syntax. PRICE(Settlement; Maturity; Rate; Yield; Redemption; Frequency; Basis) Arguments Settlement (required): The date on which the ownership of the security changes. Maturity

Its calculates the principal payment portion of a fixed payment (annuity) for a specific period of an investment or loan with constant payments and interest rate. Syntax PPMT(Rate; Per; Nper; Pv; [Fv]; [Type]) Arguments Argument Requirement Description Rate Required Interest

Calculates the periodic payment amount (annuity) for a loan or investment based on constant payments and a constant interest rate. For loan repayment calculations, this represents the fixed payment amount that includes both principal and interest. Syntax PMT(Rate; Nper; Pv;

Its calculates the yield of a fixed-interest security with an irregular final interest period (different length from previous regular periods), using simple interest (no compounding). Syntax ODDLYIELD(Settlement; Maturity; Last_Interest_Date; Rate; Price; Repayment; Frequency; [Basis]) Arguments Parameter Requirement Description Settlement Required

Its calculates the price of a fixed-interest security with a final interest period that differs in length from previous regular periods, without considering compound interest. Syntax ODDLPRICE(Settlement; Maturity; Last_Interest_Date; Rate; Yield; Repayment; Frequency; [Basis]) Arguments Settlement (required): Date when ownership of

Its calculates the yield of a fixed-interest security from the settlement date to maturity, accounting for a first interest period that may be shorter or longer than subsequent regular periods. Syntax ODDFYIELD(Settlement; Maturity; Issue; First_Interest_Date; Rate; Price; Repayment; Frequency; [Basis])

Calculates the price of a fixed-interest security, accounting for a first interest period that is either shorter or longer than subsequent regular periods (quarterly, semi-annual, or annual). Syntax ODDFPRICE(Settlement; Maturity; Issue; First_Interest_Date; Rate; Yield; Repayment; Frequency; [Basis]) Arguments Settlement (required) – The

This function calculates the net present value of future period surpluses (cash flows) of an investment based on a given discount rate. Syntax NPV(Rate; Value1; Value2; …) Arguments Rate (required) – The discount rate supplied by the investor. Value1, Value2, … (required) – The

The NPER() function calculates the duration of a compound interest process, annuity calculation, or repayment plan. It is based on regular payments of the same amount and/or one-time payments at the beginning or end of the period, following the financial mathematical benefit principle:

This function calculates the nominal interest rate that (mathematically, in finance) results in equivalence to a given effective interest rate. Syntax: NOMINAL(Effect_Rate; Periods) Arguments: Effect_Rate (required) – The given effective annual interest rate, derived from the compound interest of an intra-annual yield.

This function calculates the modified internal rate of return (MIRR), evaluating negative cash flows (disbursements) and positive cash flows (deposits) at different interest rates. Syntax: MIRR(Values; Investment; Reinvestment) Arguments Values (required) A range of cash flows (disbursements and deposits) arranged chronologically. Each

This function calculates the modified duration for fixed-interest securities. Syntax: MDURATION(Settlemen; Maturity; Nominal_Interest; Yield; Frequency; Basis) Arguments: Settlement (required) – The date when ownership of the security is transferred. Maturity (required) – The date when the loan (represented by the security) is repaid. Nominal_Interest (required) – The annual

Calculates the simple interest accrued for a specific period within a year, based on a fixed annual interest rate. Unlike standard compound interest functions, ISPMT() assumes no intra-period compounding. Syntax ISPMT(Rate; Per; Nper; Pv) Arguments Argument Description Rate Annual interest rate (e.g., 6%). Per Period number

Calculates the Internal Rate of Return (IRR)—the discount rate that makes the Net Present Value (NPV) of a series of cash flows equal to zero. Syntax IRR(Values; [Guess]) Arguments Argument Description Values (required) A range/array of cash flows (negative = outflows, positive

Its calculates the interest portion of a fixed periodic payment (annuity) for a loan or investment under the annuity repayment method. Syntax IPMT(Rate; Per; Nper; Pv; [Fv]; [Type]) Arguments Argument Description Rate (required) Periodic interest rate (e.g., 5.5%/12 for monthly payments). Per (required) Specific period number