Question: a) b) c) please elaborate how you got the answer. especially if you use excel. excel is still a little foreign to me so please

so please please please show what you did for excel what formula

please elaborate how you got the answer. especially if you use excel. excel is still a little foreign to me so please please please show what you did for excel what formula and how you pluged in the formula so i can truly learn. thank you in adavance!!

Pumpkin Inc has a bond outstanding that makes interest payments of $25 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 26 years to maturity (so twice as many six month periods) and a required rate of 6% 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 6.3% per year which matures in 2040. If you require a rate of 5.3% 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.) A long term FedEx bond that pays a coupon of 5.74% per year with a maturity of 2038. If the current price of the bonds is $1,010.6, what is the yield to maturity of the bonds? Express your answer as a decimal (5.83% is .0583). NOTE: the answer is approximate so your answer may be slightly off but still correct

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 thoroughly show each step/which formulas to use. im still learning how to use excel so filling in the formulas is a little confusing. please help a sis out. Thank you in...

a) b) c) please use excel and thoroughly show each step/ which formulas to use. im still learning how to use excel so filling in the formulas is a little concusing. please help a sis out. Thank you...

a) b) please elaborate how you got this and please please please show what formula and steps you used to fill out the formula to get the answer. excel is still fairly new to me so im really trying to...

Roberts Auto Sales and Service (RASAS) consists of three car dealerships that sell and service several makes and models of American and Japanese cars, two auto parts stores, a large body shop and car...

I have attached the discussion board 6 questions,scenario. and lectures for yourreview and response. I will submit a students questions for a response when I receive one. Thank You MKT500 Discussion...

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!...

I need help in solving my homework 466-566-P12020(2) - Protected View - Saved to this PC 18109361685 X File Home Insert Draw Design Layout References Mailings Review View Help Tell me what you want...

need help, please attached the excel file link too. thank you. Answer all the questions on second page Mini Project Instructions: You'll have to use Microsoft Excel to solve this assignment and...

Please do not use an Excel spreadsheet. Please show how you got the answer and use time value keys if possible so I can work on my calculator. Thanks! Please answer number 2, showing all work and...

Big Zero uses a FIFO periodic Inventory method. On November 1, the company has an inventory balance of 20 units, costing $20 each. The company's physical count at the end of the month gives a total...

Results on seatbelt usage from the 2003 Youth Risk Behavior Survey were published in a USA Today Snapshot on January 13, 2005. The following table outlines the results from the high school students...

Show all work and calculations. On June 3 0 , 2 0 2 5 , Anthony Walker Company issued $ 4 , 3 6 0 , 0 0 0 . 0 0 face value of 1 3 % , 2 0 - year bonds at $ 4 , 6 8 8 , 0 0 0 . 0 0 , a yield of 1 2 %...

To improve the work experience in routine jobs, human resource departments often use a combination of job rotation, job enlargement, job enrichment, employee involvement, and work teams. What is the...

What are the expectations of the organisation(s) with which your research will be concerned? What organisational issues or priorities might affect the methods by which you gather data or the timing...

One of the advantages of mixed methods research is: a Facilitation of different methods in order to answer a research question. b Focus in depth using open interviews. c Theoretical purity. d...

Which of the following approaches to data enable a consideration of change over time? a Cross-sectional one moment in time survey. b Secondary data analysis. c Longitudinal data. d Literature review.