Working out APR in Excel

  VNAM75 12:50 09 Jun 06

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.

Samsung Galaxy S8 review

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

What’s happening in VR right now: From psychedelic art to combat therapy

Siri not working? Try these troubleshooting fixes