Excel help - Calculating Mortgage Insurance Premiums

[excelamateur]

Hello all,

Could somebody be so kind to help me with this as well?

User inputs the following data:

i) Loan Amount
ii) Loan to Value ratio (LTV)
iii) Loan Tenor (Years)

and Mortgage insurance premiums (Single Initial Payment, Annual Premiumn Payment (First Year), Annual Premium Payment (Renewal)) are calculated according to the attached table.

Can someone show me how to write a clean, neat formula that could do this?

Thank you very much!

Excel Amateur

[vikas.bhandari]

Hmm, well I didnt get much what you exactly want to do???? I am not into the calculating these amounts so I want a little more explanation about it!! Also, rather than JPG, if you can give us HTML/Excel, it will save our time which we may have to waste in typing it in the excel.

Thanks,
Vikas B