YTLE#109: Daily Interest RATE Schedule in Excel

I have to undertake a number of financial projections based on an actual annual interest rate where interest is added either daily or weekly. If I have an actual annual interest rate of 5% and divide it by 12 and then compound that figure I get an actual annual interest figure of 5.1162%.

I am therefore looking for a formula that will do this where the only information required is the actual annual interest rate and the number of compounding periods.

Any help would be appreciated.

Thanks in anticipation

Francis

Question in the title really, is there an excel function to calculate a daily interest rate from an APR? The APR is compounded daily, maybe there is another way?

Thanks

hi everyone,

I have some trouble about a calculation. I dont know which function to use, or is there any function about that?
I couldnt attach any file but; there is unsteady daily credit usages and payments for specific dates in 12 years.

I need to find "annual interest rate" for this schedule.

Thakns for helping.

example for first 3 years:

years
Dates Credit Payments 1 01.08.2010 3.700.000 01.09.2010 01.10.2010 01.11.2010 01.12.2010 25.900.000 2 01.01.2011 304.222 01.02.2011 01.03.2011 3.700.000 01.04.2011 01.05.2011 1.850.000 01.06.2011 01.07.2011 1.315.967 01.08.2011 1.850.000 01.09.2011 01.10.2011 01.11.2011 01.12.2011 3 01.01.2012 1.500.144 01.02.2012 01.03.2012 01.04.2012 01.05.2012 01.06.2012 01.07.2012 2.660.000 01.08.2012 01.09.2012 01.10.2012 01.11.2012 01.12.2012

Some years ago I came across a formulae to calculate Daily Interest on a Building Society Savings account in the UK.
I have used this since but find my calculations never work out the same as my BS, although to my advantage!
It is =B3*B4/360*DAYS360(B5,B6,TRUE)
Whe
B3=Capital
B4=Interest Rate
B5=Starting Date
B6=Finishing Date
For some reason the formulae uses 360/year and not 365/year.
Using both still gives wrong answer.
If anyone has an answer or a better formulae I would appreciate it.
Many thanks.
I use Excel 2000

Hi,

I am trying to calculate the interest rate required for a loan of 200,000 with 60 monthly repayments of 6,500 to leave a residual of 60,000.

The rate is approximately 4.88%, calculated by trial and error in a 60 row worksheet, but is there a formula to calculate this figure direct?

Thanks in advance.

Bryan

looking for a free online (or template) that can generate a full amortization
schedule when one variable (usually the interest rate) is unknown. I've
tried bankrate.com but its version can't handle a date prior to current date.
First template I downloaded from microsoft.com didn't have the ability to do
the calculation and print out a schedule. Have numerous clients with loans
that I need to have this schedule in order to apply principal/interest on
monthly payments.

I have the principal, pymts per month, # of years and ending balance. I am looking for a template that calculates the interest rate.

Principal amount $100
interest amount $2
i need to repay $102 in 24 instalments
i want the function in excel to compute the interest rate for the computing
the interest rate one month so that the principal plus the interest for 24
months cumulates to $102

I have a spreadsheet of deposits made on a saving account. I need to compute the daily interest at the various interest rates, the same way the banks would compute the interest, which I think is compounded daily. It would be appreciated if someone could assist

Regards

Howard

******** ******************** ************************************************************************> Microsoft Excel - Bank Interest.xls ___Running: 12.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout I8 I9 =
A B C D E F G H I 1                   2                 3                   4                   5                   6             Interest Rate table     7 DATE Advances Interest Cumulative Interest Int & Advances   Date Int Rate Max Period 8 18/08/2005 R 65,000.00         15/04/2004 9.00%           784  9 02/12/2006 R 25,000.00         08/06/2006 9.50%           189  10 21/01/2007 R 18,200.00         14/12/2006 10.00%   Sheet1  
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

Guys,

Help please. I am trying to make up a simple mortgage calculator.

I have a very boring simple formulae - something like:

Value of property/300* interest rate.

ie Value of property / a repayment term of 25 years times by the interest rate.

The value I get back is incorrect.

Help!