i am sending you this question again iwant formula for this and fully explained by you but not in excelCalculate the monthly payment of a $$750,000$ inmortgage. The mortgage has an amortization of $25$ years. The interest rate for a $5-$year term mortgage is $5\mathrm{.}70\%$ compounded semi$-$annually not in advance.

a$)$ $$4,665\mathrm{.}61$

b$)$ $$4,665\mathrm{.}62$

c$)$ $$4,665\mathrm{.}63$

d$)$ $$4,665\mathrm{.}64$

by solving answer is not $4665\mathrm{.}62$