|
|
|
|
New Member
|
|
Feb 8, 2009, 09:49 PM
|
|
How to calculate the selling price of a bond
After 3 years you decide to sell at 30 yr bond with a 10% semi annunal coupon rate. Bought at 1200. When you sell it market rates will be 2% higher.
Does that mean I have to calculate NPV after 3 years?
|
|
|
Senior Member
|
|
Feb 8, 2009, 10:29 PM
|
|
Yes your on the right track...
What is your answer and maybe we can help.
Also reading this might help too:
Advanced Bond Concepts: Bond Pricing
|
|
|
New Member
|
|
Feb 8, 2009, 11:25 PM
|
|
I don't have an answer yet I will read and get one to you tomorrow sometime.
Do you by chance know how to work with an excel spreadsheet?
I have to do an amortization table, and it has 60 payments. And I also need to have beginning and ending balances. I have already copy and pasted the month payment using the pmt function.
I was wondering if there was a way to make it so that I could just calculate it all at once. Instead of going line by line if you know what I mean. Since the ending and beginning balances change as well as the interest and principle portion.
Thanks
|
|
|
Senior Member
|
|
Feb 8, 2009, 11:31 PM
|
|
I'll get back to you tomorrow.
|
|
|
New Member
|
|
Feb 8, 2009, 11:32 PM
|
|
Also should I go onto the next page of the website or will I be able to find my answer there?
So far from what I have read, I have
n=60
r=.05 or 50 dollars
y= .06
par value= 1000
But on a financial calculator you don't have all that so what I have so far is because I took away 6 payments
n=54
I=.06
pv=-1200
pmt= 120
fv=1000
but what do I compute then?
|
|
|
New Member
|
|
Feb 8, 2009, 11:35 PM
|
|
I am getting an crazy answer, first I got something like 7,000 then 6,000 both of which I know can't be right.
|
|
|
New Member
|
|
Feb 8, 2009, 11:38 PM
|
|
All right so I took
n=54
I-12
pmt=120
fv=1000
pv=-1000
but I think that is wrong because it should be pmt 60 because it is semi annual and I should be 6 right?
|
|
|
New Member
|
|
Feb 8, 2009, 11:48 PM
|
|
I get -1000 so does that mean I sell the bond for 200?
|
|
Question Tools |
Search this Question |
|
|
Add your answer here.
Check out some similar questions!
Selling price of a bond
[ 3 Answers ]
On December 31, 2005, $210,000 of 11% bonds were issued. The market interest rate at the time of issuance was 12%. The bonds pay interest on June 30 and December 31 and mature in 20 years.
Compute the selling price of a single $1,000 bond on December 31, 2005.
Round all intermediate...
What is the selling price of this bond
[ 1 Answers ]
When the market rate of interest was 11%, a Corporation issued $1000,000.00, 12%, 8 - year bonds that pay interest simiannualy. What is the selling price of this bond?
Determining the selling price of a bond
[ 1 Answers ]
On December 31, 2004, $180,000 of 12% bonds were issued. The market interest rate at the time of issuance was 14%. The bonds pay interest on June 30 and December 31 and mature in 10 years. Required: Compute the selling price of a single $1,000 bond on December 31, 2004. Note: Round all intermediate...
Calculate selling price
[ 0 Answers ]
Assuming the market rate of interest is 10%, calculate the selling price for 500 bonds; $1000 face value; 8% stated rate; 5 years; annual interest payments and semi-annual interest payments.
View more questions
Search
|