Как найти уплаченные проценты и основную сумму от суммы EMI и рассрочки нет

---

I want to write a scaler value function for get Interest and Principal Amount of particular Installment from Given EMIAmount,RateOfInterest,LoanPeriod and Principal Amount like
P=100000 (Principal Amount)

I=10 (IntrestRate)

T=24M (LoanPeriod)

EMI=4614.49 (EMIAmount)

Installment No. : 7 (EMINumber)

how to get Interest of 7th EMI from scaler value function

output should be : 640.29

please share formula or code

Что я уже пробовал:

i get this from temp table but scaler value function not allowed create table

---