Question: need excel formula help asap! Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.7 percent paid semiannually and

need excel formula

help asap!

Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.7 percent paid semiannually and 13 years to maturity. The yield to maturity of the bond is 5.05 percent. What is the dollar price of the bond? input area: 13 (Use cells A6 to 812 from the given information to complete this question. You must use the built-in Excel function to answer 15 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!

3. As a measure (estimate) of FDX's cost of new issued debt. FDX Corp. has a Bond issue outstanding in the market issued on October 17, 2018 of $850,000,000 par value with a coupon rate of 4.950%...

(20 points) 2. You are an intern at FedEx Corporation and the CFO, Ms. Leilani Payas, asked you to estimate the growth rate and cost of equity capital (retained earnings) for FDX. Each FDX stock is...

Help me with these two problems pls! I would also appreciate it if you could provide the inputs for Excel for this as well. Thanks! Here is the data in table form Year FDX (%) Market (%)...

(25 Points) 3. As a measure (estimate) of FDX's cost of new issued debt, FDX Corp. has a Bond issue outstanding in the market that was issued on October 17, 2018 of $850,000,000 par value with a...

***COST OF EQUITY IS 15.20*** (25 Points) 3. As a measure (estimate) of FDX's cost of new issued debt, FDX Corp. has a Bond issue outstanding in the market that was issued on October 17, 2018 of...

Data debt costs may be obtained from: https://fred.stlouisfed.org/series/HQMCB30YR a (25 Points) 3. As a measure (estimate) of FDX's cost of new issued debt, FDX Corp. has Bond issue outstanding in...

(25 Points) 3. As a measure (estimate) of FDX's cost of new issued debt, FDX Corp. has a Bond issue outstanding in the market that was issued on October 17, 2018 of $850,000,000 par value with a...

As a measure (estimate) of FDXs cost of newly issued debt, FDX Corp. has a Bond issue outstanding in the market issued on October 17, 2018, of $850,000,000 par value with a coupon rate of 4.950%...

As a measure (estimate) of FDXs cost of new issued debt, FDX Corp. has a Bond issue outstanding in the market issued on October 17, 2018 of $850,000,000 par value with a coupon rate of 4.950% (paid...

(20 points) 2. You are an intern at FedEx Corporation and the CFO, Ms. Leilani Pavao, asked you to estimate the growth rate and cost of equity capital (retained earnings) for FDX Each FDX stock is...

a. How much will an investment of $100 be worth at the end of 10 years if invested at 15 percent a year simple interest? b. How much will it be worth if invested at 15 percent a year compound...

A string of length L and total mass M is stretched to a tension T. What are the frequencies of the three lowest normal modes of oscillation of the string for transverse oscillations? [I get this...

On January 1 . 2 0 2 6 , Ivanhoe Corporation had 1 1 9 0 0 0 shares of its $ 5 par value common stock outstanding. On June 1 , the corporation acquired 1 0 3 0 0 shares of stock to be held in the...

A node's level is the number of parent's nodes from the root to node. The root is always at level 0. The root's children are a level 1 and so on. A level's width is the number of nodes at the level....