How can I compare mortgages in Numbers?

[adversecamber]

I've found a template for mortgage rates but it's very busy and I can't work out how to set it for interest only products.

Can anyone help? What formula do I need to find out the monthly payments on an interest-only mortgage if I know the loan amount and the interest rate?

 

[MacDawg]

If you don't want to reinvent the wheel, you can just go here. The website does what you are looking for without coding in Numbers.

Woof, Woof – Dawg

 

[adversecamber]

Thanks for that, but I'd rather compile my own comparison table.

 

[chrisadler]

Mortgage Deals

Mortgage Deals

 

[maflynn]

Doesn't numbers of a loan comparison template. You could modify that to suit your needs.