Question: a) b) please do this in excel and elaborate which formula you used and what you put into the formual. im really struggling with this

please do this in excel and elaborate which formula you used and what you put into the formual. im really struggling with this in excel, please help a sis out. thank you in advance!

Pumpkin Inc has a bond outstanding that makes interest payments of $33 every six months. The bond is a US Corporate coupon bond so has a Par of $1000 that will be paid at maturity. If the bond has 12 years to maturity (so twice as many six month periods) and a required rate of 8% per year (so half of this per six months), what is the value of the bond today? Crayola Corp has an outstanding bond with a coupon rate of 5.1% per year which matures in 2040. If you require a rate of 4.9% per year on this bond, what is the value of the Crayola bond? (Of course the bond is par value $1000 and pays semi- annual coupon payments.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

a) b) c) please use excel and elaborate which formula you used and how you filled in the formula. im still figuring out excel so its a little confusing. please help a sis out. Thank you in advance!...

2. you are estimating the cost of capital at McDonalds the first step is estimating the cost of common stock. If McDonald issues new common stock, and underwire will charge 1.70% McDonalds stock has...

Please use excel and elaborate which formula you used and how you filled in the formula. Im still figuring out excel so its a little confusing. Please help a sis out. Thank you in advance!...

1. You are evaluating the common stock of McDonalds Corp The dividends and times 0 is $4.71 Andy stock price is $214.31 You estimate a constant growth rate of 2.70% And a required rate of 7.00% 2.70%...

a) you plan to buy a house for 220,000 and you have a down payment of $20,000. goven you will make payments at the end of each month for 30 years and bank charges you 5% per year, what are your...

I have the Excel sheet and everything, but I'm really struggling with the questions at the bottom. Please help!!!!!! I've italicized the portion I'm struggling with. If someone knows a formula or...

please help with the first picture! I'm really struggling! and the 2nd picture, I just need help with the top and bottom. Please and thank you :) Show whether the following transactions 1,1,or do not...

Help! I need help to answer this case study. Could you please help me with the questions and each section. The first two question is not really relevant because that is self evident. However question...

Need help on this Comp Sci 1 assignment!! Please and thanks! I'm really struggling here. Tugboat Troubles Objective Give practice with sorting in C. Story The ship's engine has ceased, and now begins...

3-Calculate the concentration of NaCl required to make an ophthalmic solution containing 20 ml of 1.5 % boric acid & 0.15% atropine sulphate, isotonic with lachrymal fluid. Nacl equivalent of boric...

Joginder has been running a business, Joginder Enterprises, in Brisbane where he manufactures kitchen towels. The business has grown significantly in recent months and is now very profitable....

A customer just paid $ 3 1 8 for a weight set. If the cost was 6 0 % of selling price what was the mark up amount? Group of answer choices $ 2 3 7 . 0 8 $ 1 2 7 . 2 0 $ 1 9 8 . 7 5 $ 2 9 8 . 9 2

2023 1040 form 1.Phillip and Claire are married and file a joint return. Phillip is self-employed as a real estate agent, and Claire is a flight attendant. Phillip and Claire have three dependent...