Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Collapse]Spreadsheet
   [Expand]Product Information
    Product Structure
    Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
   [Collapse]Spreadsheet Formulas
    [Collapse]Functions
      Mathematical Functions
      Statistical Functions
      Date and Time Functions
      Text Functions
      Financial Functions
      Logical Functions
      Lookup and Reference Functions
      Engineering Functions
      Information Functions
      Compatibility Functions
      Database Functions
      Web Functions
      User-Defined Functions (UDF)
      Real Time Data (RTD) function
     Operators
     Array Formulas
     Calculation
     Formula Engine
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
    Data Grouping
   [Expand]Pivot Table Overview
   [Expand]Charting Overview
    Printing
    Events
   [Expand]Mail Merge Overview
    Protection
    Find and Replace
   [Expand]Visual Elements
    Services
   [Expand]Shortcuts
   [Expand]Examples
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Financial Functions

This document describes financial functions implemented in the XtraSpreadsheet.

Name

Description

Syntax

ACCRINTMReturns the accrued interest for a security that pays interest at maturity. ACCRINTM(issue, settlement, rate, par, [basis])
COUPDAYBSReturns the number of days from the beginning of the coupon period to the settlement date. COUPDAYBS(settlement, maturity, frequency, [basis])
COUPNCDReturns the next coupon date after the settlement date.COUPNCD(settlement, maturity, frequency, [basis])
COUPNUMReturns the number of coupons payable between the settlement date and maturity date.COUPNUM(settlement, maturity, frequency, [basis])
COUPPCDReturns the previous coupon date before the settlement date.COUPPCD(settlement, maturity, frequency, [basis])
CUMIPMTCalculates the cumulative interest paid between two specified periods.CUMIPMT(rate, nper, pv, start_period, end_period, type)
CUMPRINCCalculates the cumulative principal paid on a loan, between two specified periods.CUMPRINC(rate, nper, pv, start_period, end_period, type)
DBReturns the depreciation of an asset for a specified period by using the fixed-declining balance method.DB(cost, salvage, life, period, [month])
DDBReturns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify.DDB(cost, salvage, life, period, [factor])
DISCReturns the discount rate for a security.DISC(settlement, maturity, pr, redemption, [basis])
DOLLARDEConverts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number.DOLLARDE(fractional_dollar, fraction)
DOLLARFRConverts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction.DOLLARFR(decimal_dollar, fraction)
FVSCHEDULEReturns the future value of an initial principal after applying a series of compound interest rates.FVSCHEDULE(principal, schedule)
EFFECTReturns the effective annual interest rate.EFFECT(nominal_rate, npery)
FVCalculates the future value of an investment with periodic constant payments and a constant interest rate.FV(rate,nper,pmt,[pv],[type])
INTRATEReturns the interest rate for a fully invested security.INTRATE(settlement, maturity, investment, redemption, [basis])
IPMTCalculates the interest payment for a given period of an investment, with periodic constant payments and a constant interest rate.IPMT(rate, per, nper, pv, [fv], [type])
IRRCalculates the internal rate of return for a series of cash flows.IRR(values, [guess])
ISPMTCalculates the interest paid during a specific period of an investment.ISPMT(rate, per, nper, pv)
MIRRCalculates the internal rate of return for a series of periodic cash flows, considering the cost of the investment and the interest on the reinvestment of cash.MIRR(values, finance_rate, reinvest_rate)
NOMINALReturns the annual nominal interest rate.NOMINAL(effect_rate, npery)
NPERReturns the number of periods for an investment with periodic constant payments and a constant interest rate.NPER(rate,pmt,pv,[fv],[type])
NPVCalculates the net present value of an investment, based on a supplied discount rate, and a series of future payments and income.NPV(rate,value1,[value2],...)
PDURATIONReturns the number of periods required by an investment to reach a specified value.PDURATION(rate, pv, fv)
PMTCalculates the payments required to reduce a loan, from a supplied present value to a specified future value.PMT(rate, nper, pv, [fv], [type])
PPMTCalculates the payment on the principal for a given investment, with periodic constant payments and a constant interest rate.PPMT(rate, per, nper, pv, [fv], [type])
PRICEDISCReturns the price per $100 face value of a discounted security.PRICEDISC(settlement, maturity, discount, redemption, [basis])
PVCalculates the present value of an investment (i.e., the total amount that a series of future payments is worth now).PV(rate, nper, pmt, [fv], [type])
RATECalculates the interest rate required to pay off a specified amount of a loan, or reach a target amount on an investment over a given period.RATE(nper, pmt, pv, [fv], [type], [guess])
RECEIVEDReturns the amount received at maturity for a fully invested security.RECEIVED(settlement, maturity, investment, discount, [basis])
RRIReturns an equivalent interest rate for the growth of an investment.RRI(nper, pv, fv)
SLNReturns the straight-line depreciation of an asset for one period.SLN(cost, salvage, life)
SYDReturns the sum-of-years' digits depreciation of an asset for a specified period.SYD(cost, salvage, life, per)
TBILLEQReturns the bond-equivalent yield for a Treasury bill.TBILLEQ(settlement, maturity, discount)
TBILLPRICEReturns the price per $100 face value for a Treasury bill.TBILLPRICE(settlement, maturity, discount)
TBILLYIELD Returns the yield for a Treasury bill.TBILLYIELD(settlement, maturity, pr)
VDBReturns the depreciation of an asset for a specified or partial period by using a declining balance methodVDB(cost, salvage, life, start_period, end_period, [factor], [no_switch]).
YIELDDISCYIELDDISC(settlement, maturity, pr, redemption, [basis])Returns the annual yield for a discounted security; for example, a Treasury bill.
XNPVReturns the net present value for a schedule of cash flows that is not necessarily periodic.XNPV(rate, values, dates)
XIRRReturns the internal rate of return for a schedule of cash flows that is not necessarily periodic.XIRR(values, dates, [guess])

How would you rate this topic?​​​​​​​