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 ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
