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
Bookmarks