Arithmetic Challenged
1) -8055.00 / -23445.00 = 34.36%
2) 60267.55 / 173953.28 = 34.65%
Should #1 above actually be a negative percent?
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!
Dear Admin,
I got one excel file, I wish to do some calculation base on some condition. However, I tried quite a number of formula but can not get it done. Please refer to the attachment, I already mention all the things clearly in the file, Thanks a lot
Hi there! I need a 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 hate asking for help on my first post but i am at a loss.
here is what i need help with
i need to distribute a whole# between 4-5 cells based on the percentage and still equal that number. for example
my number is 10
cell percentage 20% 20% 20% 40%
distributed # should = 2 2 2 4
not hard
but when the number is 9
should look like 23% 33% 22% 22%
distributed # should = 2 3 2 2
thanks for all the help
I am using Excel to balance my checkbook. How do I enter a debit or credit in one column and then have the next column automatically display the new balance?
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 hope somebody can help with this. I very rarely use Excel and have no idea where to start. Need to know how to input this formula in Excel (2004-Mac): (numbers put in for example)
2.50
X 1.04
/.85
+ 2.00
/.65
X 1.1
= ____
Could somebody with some mathskills help me.
I'm trying to convert this excel formula to a regular math formula.
Code:
-ATAN(((L11*SIN((PI()/180)*((K11-M11)-180))/J11)))/(PI()/180))
L11 = X
K11 = Y
M11 = Z
J11 = K
Are anyone here man enough to do it?
Hello,
I would like to know the formula used in excel for rate function. Anybody knows and can share with me ? as i need to use that in other programmining language where these financial functions are not available.
Thanks
dmkrish
