Financial functions in Excel empower users to perform comprehensive financial analysis, model investment scenarios, and manage cash flows with precision — all without the need for complex programming. These powerful tools make it easy to calculate loan payments, interest rates, investment returns, depreciation schedules, and the present or future value of financial instruments. Whether you’re building a budget, evaluating profitability, or forecasting long-term financial outcomes, Excel’s financial functions help analysts, accountants, and decision-makers turn numerical data into meaningful insights. By leveraging these capabilities, users can build robust financial models, optimize resource allocation, and support smarter, data-driven financial decisions directly within Excel.
Its calculates the annual yield of a discounted security (e.g., Treasury bills or commercial paper) that pays no periodic interest but is issued at a discount and redeemed at face value. Syntax YIELDDISC(Settlement; Maturity; Price; Redemption; [Basis]) Arguments Argument Required Description Validation
Its calculates the annual yield of a fixed-interest security (bond) given its price, coupon rate, and maturity date. This represents the effective return an investor would earn if the bond is held to maturity. Syntax YIELD(Settlement; Maturity; Rate; Price; Redemption; Frequency; [Basis])
Its calculates the net present value (NPV) of a series of cash flows occurring at irregular intervals, discounted at a specified annual rate. Unlike standard NPV, XNPV uses exact dates for precise time-adjusted valuation. Syntax XNPV(Rate; Values; Dates) Arguments Argument Required Description
Its calculates the internal rate of return (IRR) for a series of cash flows with irregular timing, providing the annualized effective return rate. Syntax XIRR(Values; Dates; [Guess]) Arguments Argument Required Description Validation Rules Values Yes Array of cash flows (positive for inflows,
Its Calculates depreciation for an asset using the declining balance method, with an optional switch to straight-line depreciation when advantageous. This flexible approach is commonly used for tax purposes. Syntax VDB(Cost; Salvage; Life; Start_Period; End_Period; [Factor]; [No_Switch]) Arguments Argument Required Description
Its calculates the yield to maturity of a U.S. Treasury bill (T-bill) as an annualized percentage, based on the purchase price and time to maturity. Syntax TBILLYIELD(Settlement; Maturity; Price) Arguments Argument Required Description Validation Rules Settlement Yes Trade settlement date (purchase date).
Its calculates the price per $100 face value of a U.S. Treasury bill (T-bill) based on its discount rate. T-bills are short-term securities that are issued at a discount and mature at par value. Syntax TBILLPRICE(Settlement; Maturity; Discount) Arguments Argument
Its Calculates the bond-equivalent yield (annualized return) for a U.S. Treasury bill (T-bill) based on its discount rate, converting the T-bill’s discount yield (360-day basis) to an equivalent investment yield (365-day basis). Syntax TBILLEQ(Settlement; Maturity; Discount) Arguments Argument Required Description Validation Rules
Its calculates the depreciation of an asset for a specified period using the sum-of-the-years’ digits (SYD) method, an accelerated depreciation technique that applies higher depreciation expenses in earlier periods. Syntax SYD(Cost; Salvage; Life; Per) Arguments Argument Required Description Validation Rules Cost
Its calculates straight-line depreciation for an asset over a specified period, allocating equal depreciation expense in each accounting period. Syntax SLN(Cost; Salvage; Life) Arguments Argument Required Description Validation Rules Cost Yes Initial asset value (purchase price + incidental costs) Must
Its calculates the maturity value (redemption amount) for a fully discounted security that uses anticipative interest calculation (interest deducted upfront). Syntax RECEIVED(Settlement; Maturity; Investment; Discount; [Basis]) Arguments Argument Required Description Validation Rules Settlement Yes Trade settlement date Must be valid
Its calculates the periodic interest rate for a loan or investment based on constant periodic payments and/or a lump sum amount. Syntax RATE(Nper; Pmt; Pv; [Fv]; [Type]; [Guess]) Arguments Argument Requirement Description Financial Context Nper Required Total number of periods
Its calculates the present value of an investment based on a constant interest rate and a series of future payments (annuities) and/or a lump sum. Syntax PV(Rate; Nper; [Pmt]; [Fv]; [Type]) Arguments Argument Requirement Description Financial Meaning Rate Required Interest
Its calculates the price per 100 currency units of face value for a security that pays simple interest at maturity (no compounding). Syntax PRICEMAT(Settlement; Maturity; Issue; Rate; Yield; [Basis]) Arguments Argument Requirement Description Validation Rules Settlement Required Trade date Must
Its calculates the price per $100 face value of a discounted security that uses anticipative interest (discount interest applied upfront). Syntax PRICEDISC(Settlement; Maturity; Disc; Repayment; [Basis]) Arguments Argument Requirement Description Validation Settlement Required Trade settlement date Valid date ≤ Maturity
Excel offers far more than just basic formulas. Beyond the Financial functions, there’s a powerful universe of functions designed to help you analyze data, automate tasks, and build dynamic spreadsheets. In this section, you’ll discover key categories such as lookup functions, logical functions, text manipulation, cube formulas, and more — each with clear explanations and real-world examples to help you master them with confidence.
