Summary of Excel financial functions

Excel's financial functions are functions that are used for financial processing.

General financial calculations can be made, such as determining the amount of payment for the loan, the future value or net present value of the investment, and the value of the bond or coupon. There are two common variables in the financial function: F and B. Where F is the number of annual interest payments, if the annual payment, then f=1, in the semi-annual payment, then f=2, pay in the quarter, then f=4. B is the day Count datum type. If the day count Datum is "us (NASD) 30/360", is b=0 or omitted; If the daily Count datum is "actual days/Actual days", then b=1 if the day count datum is "actual days/360", then b=2 if the day count datum is "actual days/365", then b=3; If the day count datum is "Europe 30/360", then b=4.

Parameters that are common in financial functions:

The PMT function can return the per-period payment for a loan based on a fixed interest rate and a constant on-account basis.

Its expression is "PMT (Rate,nper,pv,fv,type)"

The FV function returns the future value of an investment based on a fixed interest rate and a constant, periodic payment.

Its expression is "FV (Rate,nper,pmt,pv,type)"

The PV function can return the present value of an investment. For example, the present value of a loan is the amount of the principal borrowed.

Its expression is "PV (Rate,nper,pmt,fv,type)"

The NPer function can return the total number of periods for an investment based on a fixed interest rate and a constant payment method.

Its expression is "NPER (Rate,pmt,pv,fv,type)"

The VDB function can use the variable balance decrement method to return the depreciation value of an asset for any period specified.

Its function expression is "VDB (Cost,salvage,life,start_period,end_period,factor,no_switch)"

The rate function returns the interest rate for each period of an annuity.

Its function expression is "RATE (nper,pmt,pv,fv,type,guess)".

The effect function calculates a valid annual interest rate based on a given nominal annual interest rate and the number of compounding periods per year.

Its function expression is "EFFECT (nominal_rate,npery)".

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join

Classification:

• Excel Tutorials