how to write a formula for Yearly once repayment of EMI

[GVN KUMAR]

The sheep business borrowed 500,000, but the loan was repaid once a year.
Interest paid quarterly
Principle and Interest paid yearly as EMI system.
How to write a formula to pay for the year EMI.

 

[vletm]

Have You tried to 'google' eg emi formula in excel?

 

[GVN KUMAR]

Search in google sir but not a good result for suitable formulas sir

we are manually emi formula conversions as manually for year emi using sir
total interest and principle adding and distribution year basis

 

[vletm]

What is 'a good result'?

'my google' shows:
The formula which you can use in excel is: =PMT(rate,nper,pv). Let us check the EMI of Suraj by using the above formula. It must be noted that the rate used in the formula should be the monthly rate, that is, 12%/12=1% or 0.01.

as well as
Calculating EMI has a Simple Formula, Which is As Follows: EMI = (P X R/12) X [(1+R/12) ^N] / [(1+R/12) ^N-1].

 

[GVN KUMAR]

thank you sir

 

[vletm]

... What is 'a good result'?

 

[GVN KUMAR]

yes sir