View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Formula to calculate interest only on a short term loan?

Assuming you have an annual interest rate, a month's interest is:
=Principal*IntRate/12

This may be good enough for your purposes. Most financial institutions would
calculate the interest based on the number of days in the month, so
something like:
=Principal*IntRate/365*day(eomonth(a1,0))

Regards,
Fred.

"Excel2007Help" wrote in message
...
I am not familiar with Excel 2007 and need to calculate a bridge loan
MONTHLY
INTEREST ONLY scenario, with a fixed %rate, for a range of 1 -6 months.
Not
sure if if interest accrues daily or monthly.