The PMT function can return the installment amount of the loan according to the fixed interest rate and equal installment. Its expression is "PMT(rate, nper, pv, fv, type)".

FV function can return the future value of investment based on fixed interest rate and equal installment. Its expression is "FV(rate, nper, pmt, pv, type)".

The PV function can return the present value of the investment. For example, the present value of a loan is the amount of principal borrowed. The expression is "PV(rate, nper, pmt, fv, type)".

The NPER function can return the total number of investment periods based on fixed interest rate and equal installment payment. The expression is "NPER(rate, pmt, pv, fv, type)".

By using the variable declining balance method, the VDB function can get the depreciation value of assets in any specified period. The function expression is "vdb (cost, residual value, life, start _ period, end _ period, factor, no _ switch)".

The RATE function can return the interest rate of each annuity period. The function expression is "RATE(nper, pmt, pv, fv, type, guess)".

The EFFECT function can calculate the effective annual interest rate according to the given nominal annual interest rate and the number of compound interest periods each year. Its function expression is "EFFECT(nominal _ rate, npery)".