How do I calculate the IRR, I keep getting different answers. Thanks
Hi.
I am new to this group.
I am having the values in cells a1 to a23 . 1000 in each cell
In the a24 cell the value entered was 24000
Now I want to have the INTERNAL RATE OF RETURN in the cell a25
I put the formula as =IRR(a1:a24)
Now I have the following error.
"The formula or function used is dividing by zero or empty cell"
Any help is awaited.
TT
I am trying to come up with a formula to provide an IRR for the following data:
Return: 6.25%pa (calculated daily, paid annualy on the 30th June x4)
Term: 4 Years (01/07/2010 - 30/06/2014)
Tax on Earnings: 15% applied once a year on the 30th June x4
Deposit & Tax Schedule:
01/07/2010 $5,850
30/06/2011 TAX
01/07/2011 $5,850
30/06/2012 TAX
01/07/2012 $5,850
30/06/2013 TAX
01/07/2013 $5,850
30/06/2014 TAX
Any help greatly appreciated.
I need an excel formula to calculate the negative nominal rate of return given the negative effective rate and the number of compounding periods per year. Excel's NOMINAL and NPER functions do not work when a negative rate assumption is used resulting in a #NUM! error. The context for this is that I am using MS Excel to to investment analysis. I want to analyse the resulting value of an investment account balance when there is a negative effective rate and corresponding nominal rate of return (mimicing a declining value in a particular investment/account due to negative annual return on investment expressed as a negative annual effective rate of return but that is compounding monthly - and hence the need for the nominal rate and compounding periods). I need to use a calcualtion in Excel that gives me the negative nominal rate of return equivalent to the negative effective rate of return assumtion.
Please help and thank you in advance if you can solve this!
I trade the stock market and am trying to put together a sheet that tracks annual growth rate on investments, but allows for debits and credits to the balance on uneven dates. Want to compare the investment performance against the Dow and S&P 500. Any ideas?
Hi All,
I am trying to build a formula that returns a monthly rate basis a couple of criteria.
I tried using nested if's but something's going wrong.
The rate card below is the basis for my calculation. The logic is: A certain Role against a certain location should return a unique rate.
Rate Card
Offshore Onshore
Developer $10.00 $20.00
Sr Developer $30.00 $40.00
Project Manager $50.00 $60.00
Delivery Lead $70.00 $80.00
For example if I select the role as developer from the Validation and Onshore as location from its validation then formula should return the rate as $20.00.
Rate Role Location
? Developer Onshore
Please help.
Thanks
How create a excel spreadsheet to determine compound rate of return if I know
number of periods
starting value
current value
thanks
I want to calculate the survival rate/failure rate for a product. Usually I use weibull distribution (linear regression followed by the 'WEIBULL' function), but unfortunately the data I have simply won't work with my current methods.
I have 10 different groups of widgets.
Group 1 widgets were installed 1 year ago. A certain percentage of those widgets are failed.
Group 2 widgets were installed 2 years ago. A certain percentage of those widgets are failed.
...
Group 10 widgets were installed 10 years ago. A certain percentage of those widgets are failed.
There are far fewer 10-year widgets than 1-year widgets out there.
The catch is that I don't know if the group 1 widgets will survive year 2, or if year 2 widgets will survive year 3, etc.
I want to create a nice curve that tells me (approximately) how many years the average widget in my sample dies 50% of the time. Unfortunately, there doesn't seem to be any ready-made formula in Excel for this. So I turn to you, brave Excel Board Members, to help me save myself from Math.
Please?
I have an investment that pays dividends on a quarterly basis. If the dividends are re-invested the annual rate of return is 9.33%. How do I calculate the rate of return if the dividends are not re-invested?
Hi, thanks to all for this super-handy forum. I've learned a lot and finally had a reason to post.
I have investments that give me a monthly return, say like a mutual fund. I want to get a yearly number based on this performance.
So for example
Jan. 0.43%
Feb. -0.83%
Mar. 1.76%
Apr. 1.44%
YTD 2.81%
I know it's not a straight sum... so... what is it?
