"Integral savings" is a common investment method among working-class people, which requires calculating the future value of the investment to decide whether to choose a certain savings method.
(1) Function decomposition
The FV function returns the future value of an investment based on fixed interest rates and equal installment payments.
Syntax: FV(rate,nper,pmt,pv,type)
Rate is the interest rate in each period; Nper is the total investment period, that is, the total number of payment periods of the investment; Pmt is the amount payable in each period, and its value is throughout the entire annuity The period remains unchanged; Pv is the present value, which is the amount that has been accounted for since the beginning of the investment, or the cumulative sum of the current values of a series of future payments; Type is a number 0 or 1, used to specify the payment time of each period Is it at the beginning or end of the period.
(2) Example analysis
Create a new worksheet and enter "investment interest rate", "investment period", "investment amount" and "account initial amount" in cells A1, B1, C1 and D1 respectively. Assume that the wife creates a new account and deposits 300 yuan at the end of each month, with an annual interest rate of 2.1% (that is, monthly interest of 0.00175), and deposits continuously for 5 years. She can enter "0.00175", "60", and "500" in cells A2, B2, C2, and D2 respectively. ” and “1”.
Then select cell E2 and enter the formula "=FV(A2,B2,-C2,D2,1)" and press Enter to get the total maturity principal of the investment as "￥18,994.67". "-C2" in the formula means that the funds are spent. You don't need to add a negative sign before "C2", so the calculated result will be a negative value.
If the husband also has a "small deposit and round withdrawal" account and deposits 200 yuan at the beginning of each month, the annual interest is 1.28% (that is, the monthly interest is 0.001667), and the husband has deposited continuously for 3 years, he can enter "0.001667" and "0.001667" in cells A3, B3, C3, and D3 respectively. "36", "200" and "0". Then copy the formula in cell E2 to cell E3 (point the cursor to the drag handle of cell E2, and when the black cross cursor appears, drag down one cell) to know the due principal of the investment. The total is "￥7,426.42".
Tip: The above calculation results include principal and interest, but do not include interest taxes and other expenses.