Working out APR in Excel

  VNAM75 12:50 09 Jun 06
Locked

How do you calulate Annual percentage rate and what specifically is it, especially in terms of mortgages. I understand it takes account of additional fees as well as the normal monthly interest payments. So, of 2 mortgage products, if one had the lower APR but higher interest rate it would still be the cheaper one. I hope I am correct.

What is the formula to calculate APR in Excel?

  VoG II 12:56 09 Jun 06
  VNAM75 13:05 09 Jun 06

Thanks VoG, the article seems perfect.

  pj123 14:27 09 Jun 06

If it is of any interest to you I have an Excel spreadsheet called Mortgage and Loan Analysis.

If you want to have a look at it contact me via the envelope and I will email it to you.

  Cesar 08:31 11 Jun 06
  VNAM75 18:24 11 Jun 06

Thanks pj123, dont think I need it. Thanks Cesar.

This thread is now locked and can not be replied to.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

1995-2015: How technology has changed the world in 20 years

Hands-on with the Star Wars fighting drones you can fly yourself

15 macOS Sierra tips | How to use macOS Sierra: Secret tricks and best new features in Apple's new…