Working out APR in Excel

  VNAM75 12:50 09 Jun 2006
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 2006
  VNAM75 13:05 09 Jun 2006

Thanks VoG, the article seems perfect.

  pj123 14:27 09 Jun 2006

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 2006
  VNAM75 18:24 11 Jun 2006

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

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

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Microsoft Paint set to die after 32 years

Mac power user tips and hidden tricks

Comment désactiver la saisie intuitive et paramétrer votre clavier ?