Current location - Loan Platform Complete Network - Bank loan - How to use FV function in excel
How to use FV function in excel
Materials/tools: Excel20 10

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.