Excel® 2013 On Demand

Using Financial Functions

You can use financial functions to help you work with formulas related to business, accounting, and investment. You can use formulas for depreciation, such as SLN (Straight-Line Depreciation) and SYD (Sum-of-Years’ Digits), or formulas for interest and investments, such as FV (Future Value of an investment), EFFECT (Effective annual interest rate) IPMT (Interest Payment for an investment or loan), PDURATION (number of periods needed to reach a value) (New!) and RRI (equivalent interest rate for investment growth) (New!). Many of the investment functions use the following arguments: rate, nominal_rate, per, nper, pv, fv, pmt, and type. Rate is the interest rate per period; Nominal_rate is the nominal interest rate; Per ...