View Single Post
  #32   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] fernacontreras1@gmail.com is offline
external usenet poster
 
Posts: 1
Default How do I caluclate an Annual Percentage Rate in Excel?

This is an old post but I dont seem to find an answer to this question anywhere online:
CAN YOU TELL ME HOW TO ADD PMI INTO THIS CALCULATION? FOR EXAMPLE, IF THE PMI IS $43.22/MO FOR 58 MONTHS UNTIL IT REACHES 78% LTV... HOW WOULD I MODIFY THE "RATE" CALCULATION TO CONSIDER THIS INTO THE APR?