# IPmt (FV)

| **Name**    | ***IPmt (FV)***                                                                                                                                                                 |
| ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Syntax      | IPmt (Real Rate, Real Periods, Real numPeriods, Real PV, Real FV)                                                                                                               |
| Purpose     | To return a value by applying the interest payment function on specified values.                                                                                                |
| Description | Returns the interest payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate. Also takes into account, the specified Future Value. |
| Return Type | Double                                                                                                                                                                          |
| Parameters  | <p>Rate \[System.Double]</p><p>periods \[System.Double]</p><p>numPeriods \[System.Double]</p><p>PV \[System.Double]</p><p>FV \[System.Double]</p>                               |

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/0%20\(38\).png)

### **Example**

In this example, we will be passing the required parameters to the function transformation object using a *Variables* object.

Where,

*rate* = 3

*periods* = 5

*numPeriods* = 100

*PV* = 5000000

*FV* = 1000

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/1%20\(39\).png)

Right-click on the function transformation object and select *Preview Output.* You can see that Astera Data Stack has applied the IPmt function, and returned the interest amount of an annuity, dependent on a specified period and period amount and Future Value.

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/2%20\(39\).png)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://documentation.astera.com/astera-data-stack-v6/functions/financial/ipmt-fv.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.