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
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
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!
Hi
I want to know the function to calculate the SI and the CI in Excel. I know manually we calculate the Simple Interest = P*R*T and compound Interest = P(1+i)^n . When I calculate the SI using inbuilt function of Excel i.e. PMT as shown in the following link
http://www.ehow.com/how_4813646_calc...est-excel.html
It given right answer. But if on same data i apply P*R*T it gives something different. Also I saw following site
http://www.busysoftorder.com/npv/1.htm
it uses FV function. Kindly advice how to calculate the Si and CI using inbuilt functions. I just want to calculate it when there is no change in the rate of interest in the subsequent years and it will remain same.
Regards
Harbinder Singh
Could anyone please help me to calculate the Rate of Interest of the
Following?
Problem 1:
Intestment Rs. 4384 for Next 20 years. ie Total Investment Rs. 87680
Maturity at the end of 25th year.
Maturity Value = Rs. 265500
I have calculated the Rate of Interest (ROI) as follows:
=ROUND(((265500-87680)/87680*(365/(25*365)))*100,2) ie 8.11%
Problem 2:
Intestment Rs. 6450 for Next 20 years. ie Total Investment Rs. 129000
Maturity at the end of 20th year.
Maturity Received Such as follows:
at the end of 5th year = Rs. 20000
at the end of 10th year = Rs. 20000
at the end of 15th year = Rs. 20000
at the end of 20th year = Rs. 40000
plus interest = Rs. 84000
Total : 184000
I have calculated the Rate of Interest (ROI) as follows:
=ROUND(((184000-129000)/129000*(365/(20*365)))*100,2) ie 2.13%
Is the both procedure of calculation right?
May I know the correct function for solution?
Thanks in advance.
Regards
How do I find the interest for the follwing information in excel?
Total Payments 60
Periodic payments 24,914.31
Total amount to be amort 1,494,858.60
I need to amort the total amount receiving the 24,914 a month for 60 months. What is the interest rate?
I am trying to determine which formula in excel will allow me to calculate the interest rate for an annuity where I know the present value of the payments, the amount of each annual payment and the number of periods.
Any hints would be helpful.
is there anyway to determine the interest rate you would need to have if you have the following information
term = 360 months
wants a payment around = 900
loan amount = 145,000
thanks
Josh
I've just started trading stock via a loan facility...this has presented an interesting problem for tracking profit and loss. I may purchase the stock and day/weeks later the rate will change... then it will change again.
So I need a way of looking up a series and calcuating an effective interest rate. I figure it will end up with a two colums one with date (of rate change) and the other with the rate.
I've then got another worksheet with ...
date of purchase, quantity, purchase price, current value, interest paid.
So can anyone think of a way to lookup from the date purchased to today() and work out the effective interest rate taking in to account the number of days in each period of change?
I've attached what I think I'm looking for (note Australia date format dd/mm/yy)
Thanks heaps...
(Long time lurker first time poster)
Hi There,
Is there a function that calculates what interest rate is needed to turn a $2000 investment into $9000000 in 30 years based on compounding interest?
Cheers
