Present Value of future cash outflow UNequated monthly installments

[helpexce]

An organization has provided a loan to an staff. She pays her loan in installments whose principle amount is constant and the interest changes. What is the formula to calculate present value of future inflows if the interest at which the organization is providing the loan and discount factor is different. For example, ABC Ltd. has provided 1,000,000 as loan to Ms. D. Ms. D has paid 5 installments in which the installment amount contains 100,000 as principal and interest as accrued. What is the formula to calculated the PV of next 5 installments if installments are paid at the end of the year?

Thanks

 

[helpexce]

Hello Experts,
Bump. Do you need any further explanation?

Thanks