## Decision Analysis

### The Decision Analytic Advantage

### Here's why you should opt for a decision analytic approach

### The Decision Analytic Process

### Take a quick visual tour of a typical decision analytic process

### DPL Tutorial Videos

### Quickly learn DPL modeling basics via a series of six software video tutorials

### Decision Analytic Videos

### Learn about basic decision analytic tools and concepts via short, simple video tutorials using DPL

## Products

### Product Comparison

### Which version of DPL is right for you?

### What's New in DPL 9

### From game-changing analytics to modeling ease of use

### DPL Product Versions

### DPMX

### A decision analytic portfolio management system

### FREE DPL Pro Trial

### Get started with your FREE DPL Pro Trial today!

### FREE DPL Fault Tree Trial

### Get started with your FREE DPL Fault Tree Trial today!

### Order DPL Now

### Start making better decisions for your business today!

## Industries

### All Industry Examples

### View Real-world DPL Examples by Industry

### Customers

### See our list of satisfied customers by industry.

### Partners

### See a list of experienced consultants who use DPL

## Support

### Register DPL

### Get the latest support & product update information

### Downloads

### Knowledge Base

### Training

### Online, group & customized training on DPL

### Purchase Support

### Don't take unnecessary risks! Keep your DPL Support plan current.

## About Syncopation

### Company History

### Find out more about DPL software's history -- one that spans over 20 years

### Our People

### Meet the folks behind the DPL Software

### Opportunities

### Discover opportunities at Syncopation Software

# DPL 9 Help

# Financial Spreadsheet Functions

All of the arguments of these functions (x, y, z, s, and w) are expressions. Series and array subranges are allowed in any argument requiring a series or array (without subscripts). Normally none of the arguments of the financial spreadsheet functions should be a negative number.

DPL | Excel | Action |

@cterm(x,y,z) | NPER(x,,-z,y) | The number of compounding periods for an investment with present value z to grow to future value y, earning a fixed periodic interest rate x. No argument should be 0. |

@ddb(x,y,z,w) | DDB(x,y,z,w) | The double-declining depreciation allowance of an asset in period w, given the original cost x, predicted salvage value y, and the number of periods z in the life of the asset. The third and fourth arguments should not be 0. |

@fv(x,y,z) | FV(y,z,-x) | The future value of a series of equal payments, each equal to x, earning a periodic interest rate y over z periods. Second argument should not be 0. |

@irr(x,s) | IRR(s,x) | The internal interest rate of the series of cash flows in s, computed from a starting guess of x. It is possible for a set of cash flows to have more than one internal rate of return. When this occurs, @irr( ) may not find the same solution in DPL and Excel. This situation will never occur if the initial cash flow has one sign, and all the rest have another. |

@npv(x,s) | NPV(x,a) | The present value of the series of cash flows in s, discounted at a periodic interest rate of x. |

@pmt(x,y,z) | PMT(y,z,-x) | The amount of a periodic payment needed to pay off a principal x at a periodic interest rate of y over z periods. Second and third arguments should not equal 0. |

@pv(x,y,z) | PV(y,z,-x) | The present value of a series of equal payments, each equal to x, discounted at a periodic interest rate of y over z periods. The second argument should not equal 0. |

@rate(x,y,z) | RATE(z,,-y,x) | The periodic interest rate necessary for a present value of y to grow to a future value of x in z periods. Second and third arguments should not equal 0. |

@sln(x,y,z) | SLN(x,y,z) | The straight-line depreciation allowance of an asset, given the original cost x, predicted salvage value y, and the number of periods z in the life of the asset. Third argument should not equal 0. |

@syd(x,y,z,w) | SYD(x,y,z,w) | The sum-of-the-years'-digits depreciation allowance of an asset in period w, given the original cost x, predicted salvage value y, and the number of periods z in the life of the asset. The third argument should not equal 0. |

@term(x,y,z) | NPER(y,-x,,z) | The number of payment periods of an investment, given the amount of each payment x, the periodic interest rate y, and the future value of the investment z. First and second arguments should not equal 0. |

Notes: This information is subject to change. New functions are added from time to time. Contact technical support for the latest compatibility information.

* Versions:* DPL Professional, DPL Enterprise, DPL Portfolio

*See Also*