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 FV function

ROUND(FV(${interestRates}/100/12,${periods}*12,${payment}),0)

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 NPV function

ROUND(NPV(${interestRates}/100,${loan_amount},${cont/value}),0)

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 Example of PMT function

PMT(${interestRates}/100/12,${periods}*12,${payment})

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 PV function example

ROUND(PV(${interestRates}/100/12,${periods}*12,${payment}),0)