EMI formula for Qty, half year and yearly payments

[kumartrp]

Sir
we are able to write only for monthly EMI Systems
rate of interest 12%
principal 5 00 000/-
repayment of time 5 years
we are write a formula for emi systems =pmt(12%/12,60,-500000)

but we required a formula for emi systems of Quarterly repayment (Poultry industry) some half year repayments (crop loans ) and yearly repayments (sheep forming loans)
could you give a formula for qty emi + half year emi + year + yearly emi

 

[vletm]

kumartrp
As written above:
a) Upload a Sample File to get a quicker response
b) Use terms which You've explained

 

[kumartrp]

SAMPLE FILE SIR

 

[vletm]

kumartrp
... there were also b)