Equity and Fixed Income Securities

Competency

Equity and Fixed Income Securities.

Evaluate equity and fixed income securities.

Instructions

Wealth investment brokers

You have just completed your first training for the new class of interns at your employer, Bank of Wealth Investment Brokers. Part of your role as the new Portfolio Analyst is to train the new research interns on all of the facets of investing. You have now been asked to solve some time value of money problems in Excel for use with the interns.

You will need to use this Excel spreadsheet and solve the following problems. In addition, you can find extra Excel resources by using this link.

  1. The Piedmont Flyers have issued a 30-year bond with a face value of $1000 and a 5% coupon rate. The market is yielding 7%, what is the current selling price of the bond?
  2. The Piedmont Flyers have issued a 30-year bond with a face value of $1000 that pays semiannually with a 4% coupon rate. The market is yielding 6%, what is the current selling price of the bond?
  3. The Piedmont Flyers have issued a 8-year bond with a face value of $1000. The price of the bond is $880. The market rate is 10% annually. What is the coupon payment?
  4. The Piedmont Flyers have issued a 30-year bond with a selling price of $750 and a coupon payment of $100. The face value is $1000. What is the return on the bond?
#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper #Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational