Remember Me?

#1
December 1st 09, 07:20 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Dec 2009 Posts: 1
Formula to calculate interest only on a short term loan?

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.

#2
December 1st 09, 07:43 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jan 2008 Posts: 2,389
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.

#3
December 1st 09, 07:48 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Dec 2007 Posts: 2,722
Formula to calculate interest only on a short term loan?

http://www.microsoft.com/office/comm...b-c0577e005416
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"Excel2007Help" wrote:

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Richard[_10_] Excel Discussion (Misc queries) 2 April 26th 09 07:40 AM CHARI Excel Discussion (Misc queries) 2 March 21st 09 05:24 PM Bartman Excel Worksheet Functions 1 March 20th 09 06:08 AM Willy Verhaegen - Belgium Excel Discussion (Misc queries) 1 June 6th 08 10:26 AM Fred Smith Excel Worksheet Functions 0 January 6th 05 02:33 AM

All times are GMT +1. The time now is 01:47 AM.