Support > Repository > Function > Finance
ja | en

We introduce four functions related to financial processing.

FV |  NPV |  PMT |  PV

FV

We will calculate reserve funds.Calculate the future value of initial investment based on a certain interest rate, payment amount, payment period.

Figure 1 Example of executing FV function
ROUND(FV(${interestRates}/100/12,${periods}*12,${payment}),0)

NPV

Calculate the net present value.Calculate the net present value when periodically receiving different payment amounts each time assuming the interest rate is fixed during the period.

Figure 2 Example of executing NPV function
ROUND(NPV(${interestRates}/100,${loan_amount},${cont/value}),0)

PMT

Calculate loan repayment.Calculate the borrower's principal interest rate, the repayment amount for each period necessary to repay the loan at the specified period.

Figure 3 Execution example of PMT function
PMT(${interestRates}/100/12,${periods}*12,${payment})

PV

I will calculate the loan borrowing.Calculate the net present value when you regularly receive the same payment amount every time assuming the interest rate during the period as a fixed interest rate.

Figure 4 Example of PV function execution
ROUND(PV(${interestRates}/100/12,${periods}*12,${payment}),0)