Question: Find the Price using Excel formulas. You find a zero coupon bond with a par value of $10,000 and 24 years to maturity. If the

Find the Price using Excel formulas.

You find a zero coupon bond with a par value of $10,000 and 24 years to maturity. If the yield to maturity on this bond is 4.2 percent, what is the dollar price of the bond? Assume semiannual compounding periods. (Use cells A6 to B12 from the given information to complete this question. You must use the built-in Excel function to answer this question. Leave the "Basis" input blank in the function. You may enter a constant as a hard coded value.)

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!

Accessibility tab summary: Students please use the information below to complete the question completing the required cells. Given information for this question is presented in rows 6 through 1 2 ....

Find the EAR of a 90-day Treasury bill with a bank discount yield of 5%. Find the YTM of a $10,000 face value treasury STRIPS with a quoted price of 43.985. Assume the Treasury bill has 7.5 years to...

You find a zero coupon bond with a par value of$10,000 and 13 years to maturity. If the yield to maturity on this bond is 4.7percent, what is the price of the bond? Assume semiannual...

Kindly give all answers as a formula please. E l Calculating a bond FORMULAS DATA HOME INSERT PAGE LAYOUT VW VW BIL BIU.E. - Alignment Number Fo n g Table Styles You find a zero coupon bond with a...

answers should be in excel formulars Calculating a bond price - Excel 73 - X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calib - 11 Paste Colls Editing A Alignment Number...

You find a zero coupon bond with a par value of $10,000 and 17 years to maturity. If the yield to maturity on this bond is 4.9 percent, what is the price of the bond? Assume semiannual compounding...

You find a zero coupon bond with a par value of $10,000 and 24 years to maturity. If the yield to maturity on this bond is 4.2 percent, what is the dollar price of the bond? Assume semiannual...

4. Zero coupon bonds with a par value of $1,000,000 have a maturity of 10 years, and a required rate of return of 9 percent. What is the current price? 5. Assume that the price of a $1,000 zero...

XI Calculating a bond price - Excel 7 - X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri Dili M Paste BIU - A A % A Alignment Number Conditional Format as Cell Formatting...

Ritter Razors produces deluxe razors that compete with Gillettes Mach line of razors. Total manufacturing costs are $100,000 when 20,000 packages are produced. Of this amount, total variable costs...

It takes Susan 30 minutes to solder 10 circuit boards to fill a container and 2 minutes to transport the container to the next station, where John works. John's process takes about 45 minutes. The...

*13112. The ball has a mass of 2 kg and a negligible size. It is originally traveling around the horizontal circular path of radius r0 = 0.5 m such that the angular rate of rotation is u . 0 = 1...

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".