Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
a function of the investment calculation Calculation function can be divided into investment and the future value of fv, and with the payment of the pmt, pv and the present value, and with compound interest to calculate the number of the relevant period and several types of function. 1, and the future value of fv-related function - FV, FVSCHEDULE 2, with the payment of the pmt function - IPMT, ISPMT, PMT, PPMT 3, and is a function of the pv value - NPV, PV, XNPV 4, with the function to calculate the compound interest - EFFECT, NOMINAL 5, and during the related function - NPER Calculation in the investment function, I will focus on the FV, NPV, PMT, PV function. (A) an investment for the future value of FV In their daily work and life, we often encounter to calculate the future value of an investment in the situation, when using Excel functions to calculate FV, you can help us carry out some planned, the purpose of cost-effective investment. FV function and based on a fixed rate of interest equal installments, the return value of an investment in the future. Grammatical form of FV (rate, nper, pmt, pv, type). For the period in which interest rate is a fixed value, nper for a total investment (or loan), that the investment (or loan) the total number of payment period, pv for the period due to (or receive) the amount, its value in the annuity period (during or investment) remain unchanged, Pv usually include principal and interest, but does not include other fees and taxes, pv is the present value, or a series of future payments and the current cumulative value, also known as the principal, if omitted pv, is the assumption that its value is zero, type for the number of 0 or 1, for the designated time period for payment in the beginning or end, if omitted from t, then the assumption that its value is zero. For example: after two years if a person needs to learn a relatively large expenditure is planned from the beginning of each month from now on deposit of 2,000 yuan, according to annual 2.25% monthly interest-bearing (Yueli 2.25% / 12), then After two years the amount of the deposit account would be how much? Write the formula for: FV (2.25% / 12, 24, -2000,0,1)
|
