1. Slide the mouse over the cell, click Select, and then double-click to enter the input state.
2. Call the FV function, that is, enter "= Fv"; Excel will automatically match similar functions when inputting, and prompt the functions that can be realized.
3. Set the interest rate for each period. In the example, you should enter "=FV([@ annual interest rate ]/ 12,"; Remember to convert the annual interest rate into the monthly interest rate.
4. Set the total number of payment cycles. In the example, you should enter "=FV([@ annual interest rate ]/ 12, [@ total period (year)] *12"; Pay attention to distinguish between years and months.
5. Set the amount to be paid in each period. For example, you should enter "=FV([@ annual interest rate ]/ 12, [@ total installment (year) ]* 12, [@ monthly savings amount])";
6. Check the results and drag to complete the form.