Does anyone have a spreadsheet that is good for calculating interest on bonds. I need one that understands the different market. European bonds are different then US bonds.
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 Ladies and gents,
I work for a construction company where we have to calculate payment bonds for projects that we bid. I am trying to make a spreadsheet that satisfies the perameters, but cannot seem to get the formulas to work out. Bonds on construction projects are "stepped", meaning that as the project cost escalates, the amount of bond you pay per thousand dollars goes down. Bond rate calculation explanation: The first $500,000 ($1 thru $500K) of a project has a bond rate cost of $9.00 per thousand dollars. The next $2,000,000 ($500K thru $2.5M) has a bond rate cost of $7.50 per thousand dollars. The next $2,500,000 ($2.5M thru $5M) has a bond rate cost of $6.00 per thousand dollars. The next $2,500,000 ($5M thru $7.5M) has a bond rate cost of $5.00 per thousand dollars. Any amount over $7.5M has a bond rate cost of $4.00 per thousand dollars. To follow this formula for a project with a total cost of $10,125,000, I would have: (first $500,000/$1,000) 500 * $9.00 = $4,500 ($500K thru $2.5M/$1,000) 2,000 * $7.50 = $15,000 ($2.5M thru $5M/$1,000) 2,500 * $6.00 = $15,000 ($5M thru $7.5M/$1,000) 2,500 * 5.00 = $12,500 ($7.5M thru $10,125,000/$1,000) 2,625 * 4.00 = $10,500 Total Bond = $57,500 Conversely, if I bid a small project, say $2,615,000, it would look like: 500 * $9.00 = $4,500 2,000 * $7.50 = $15,000 115 * $6.00 = $690 Total Bond = $20,190 Could someone please point me in the right direction as to what type of formula I would use to make such a spreadhseet? I tried to do an "If, Then" formula, but couldn't ever get it to work out. Where could I be missing it? Any help would be greatly appreciated. Thanks in advance for any help you could lend. Hello all,
I need to create a variable rate bond table. This table is based off of a changing total. The rates are as follows - first $100,000.00 = $12.00 per $1,000.00. 100K-500K = 49.60 per K. 500K - 2.5M = $8.40 per K. 2.5M - 5M = $7.20 per K. 5M - 7.5M = $6.00 per K. Over 7.5M = $5.40 per K. Any ideas or help in how to create this is appreciated. Also this cost also needs to be included in the total, how can this be accomplished without having a circular reference. Thanks, Mark 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? Hello:
When I use the function wizard in Excel 2007, the wizard returns the correct amount, but the result comes back with a minus sign. I can't understand the rationale of the Excel algorithm here. What is the most logical way to remedy this issue? Thanks. Richard A friend wants to find out the present value of an asset he owns that will generate $5million over next 25 years.
I am assuming that it will be at the rate of $200K p.a. For a discount rate of 10% what is the formula to calculate the present price that he should accept. Thanks Pedro 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 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. |