Question: Calculate current bond price using excel formula and cell numbers. Settlement date = D7 Maturity date = D8 Coupon rate = D9 Coupons per year

Calculate current bond price using excel formula and cell numbers.

Settlement date = D7

Maturity date = D8

Coupon rate = D9

Coupons per year = D10

Face value = D11

Yield to Maturity = D12 Calculate current bond price using excel formula and cell numbers. Settlement

A1 Ninja Co. issued 14-year bonds a year ago at a coupon rate of 6.9 percent. The bonds make semiannual payments. If the YTM on these bonds is 5.2 percent, what is the current bond price in dollars? Assume a par value of $1,000 6 Settlement date Maturity date Coupon rate Coupons per year Face value Yield to maturity 1/1/2000 1/1/2013 6.90% 10 902 12 13 14 15 16 17 18 19 20 21 Complete the following analysis. Do not hard code values in your answers. Price . | Sheet1 | +100% Attempt(s)

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!

Settlement date 1/1/2007 Maturity date 1/1/2017 Coupon rate 0.00% Coupons per year 2 Face value 100 Yield to maturity 8.25% Par value $ 10,000 Note: Maturity date - Settlement date = time till...

Settlement date: 1/1/2003 Maturity date: 1/1/2017 Coupon Rate: 0.00% Coupons per year: 2 Face value: 100 Yield to Maturity: 9.25% Par Value: $10,000 Calculate Bond Price.

Question 2 - Calculate the yield to maturity of the following bond with a par value of $1,000 that pays a 3.9% coupon semiannually. The bond was settled on Jan 1, 2010 and matures on Jan 1, 2032. It...

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

Calculate the YTM using excel formula and cells. Settlement date = D7 Maturity date= D8 Annual coupon rate = D9 Coupons per year = D10 Face value = D11 Bond Price = D12 A1 Stone Sour Corp. issued...

Bourdon Software has 6.4 percent coupon bonds on the market with 18 years to maturity. The bonds make semiannual coupon payments and current sell for 106.8 percent of their standard par value. a)...

What is the dollar price of a bond with the following characteristics? The bond price function in Excel is PRICE. Settlement date 1/1/20 Maturity date 1/1/30 Annual coupon rate 7.50% Yield to...

What is the dollar price of a bond with the following characteristics? The bond price function in Excel is PRICE Settlement date 1/1/20 Maturity date 1/1/30 Annual coupon rate 7.50% Yield to maturity...

Calculating the WACC - Excel LE DATA REVIEW E INSERT PAGE LAYOUT FORMULAS VIEW 12 A A Arial Conditional Format as Cell Editing Alignment Number Cells IU Formatting Table Styles board Font Styles C E...

Please the answer in my Ms word need to be inMs Excel. I need professional one to use the Fx in right way and show how to arrive to the answer. You just need to use my answer in Excel. please read...

Compare the code of professional conduct for CPAs to the code of professional conduct for accountants who are non-CPAs. Determine the major ethical issues created by the mergers of public accounting...

Look at the two histograms below. Each involves the same number of data. The data are all whole numbers, so the height of each bar represents the number of values equal to the corresponding midpoint...

Roger contracts with Steinway to buy one of its pianos for $ 2 0 0 0 . Steinway has several of these pianos in stock and can buy an unlimited number from the manufacturer. Roger refused to accept...

Discuss the policy statement concept and identify three focus areas / procedures where a clearpolicy statement / operating procedure

How can you drive more traffi c to your Web site or to your communication channels?

Your boss lets you know that you keep arriving late to staff meetings, and this creates problems for everyone in att endance.

A work colleague criticizes you for your sloppy follow-through: you promised to do something and you didnt.