Question: NEED THE EXCEL FUNCTIONS PLEASE! A. Using the PRICE function, calculate the intrinsic value of each bond. Lise an IF statement to decide whether each

NEED THE EXCEL FUNCTIONS PLEASE! A. Using the PRICE function, calculate

NEED THE EXCEL FUNCTIONS PLEASE!

A. Using the PRICE function, calculate the intrinsic value of each bond. Lise an IF statement to decide whether each bond is currently undervalued? B. Calculate the CURRENT YIELD of both bonds. C. Using the YIELD function, calculate the yield to maturity of each bond using the current market prices. D. Calculate the DURATION and MODIFIED DURATION of each bond. Bond B 2/15P 2/15/17 Settlemen Date Maturity Date Coupon Rate Price Face Value Required Retem Frecesine Bond A | 2/15/12 2/15/12 5.00% 690.00 S1.000.00 4.00% 2 $1,040,00 $1.000,00 &.00% 2 Intrinsic Vales Under/Over Vated Current Yield Yield to Maturity Duration Modified Duration Price A Prke B Yield 0% 1% E. Construct a line chart showing the relationship between yield and price for two bonds. Place Chart Here 3% 4% S% 7% 8% 9% 10% 11% 12% 13% 15% 16% 17% 18% 19% 20% Find the percentage change in the price of the bond under the scenarios below. Guide: You may find it easier to use the Bonds' values in your table above. % Change in Price Bond A Bond B Change in Yields -3.00% A. Using the PRICE function, calculate the intrinsic value of each bond. Lise an IF statement to decide whether each bond is currently undervalued? B. Calculate the CURRENT YIELD of both bonds. C. Using the YIELD function, calculate the yield to maturity of each bond using the current market prices. D. Calculate the DURATION and MODIFIED DURATION of each bond. Bond B 2/15P 2/15/17 Settlemen Date Maturity Date Coupon Rate Price Face Value Required Retem Frecesine Bond A | 2/15/12 2/15/12 5.00% 690.00 S1.000.00 4.00% 2 $1,040,00 $1.000,00 &.00% 2 Intrinsic Vales Under/Over Vated Current Yield Yield to Maturity Duration Modified Duration Price A Prke B Yield 0% 1% E. Construct a line chart showing the relationship between yield and price for two bonds. Place Chart Here 3% 4% S% 7% 8% 9% 10% 11% 12% 13% 15% 16% 17% 18% 19% 20% Find the percentage change in the price of the bond under the scenarios below. Guide: You may find it easier to use the Bonds' values in your table above. % Change in Price Bond A Bond B Change in Yields -3.00%

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!

NEED THE EXCEL FORMULAS PLEASE! A. Using the PRICE function, calculate the intrinsic value of each bond. Lise an IF statement to decide whether each bond is currently undervalued? , ? B. Calculate...

a 2. After recently receiving a bonus, you have decided to add some bonds to your investment portfolio. You have narrowed your choice down to the following bonds (assume semiannual payments):...

D Assignment #5.pdf 1 page Q Search 2. After recently receiving a bonus, you have decided to add some bonds to your investment portfolio. You have narrowed your choice down to the following bonds...

Settlement Date Maturity Date Coupon Rate Market Price Face Value Required Retum Bond A 2/15/2017 8/15/2027 4.00% $975 $1,000 4.35% Bond B 2/15/2017 5/15/2037 6.25% $1,062 $1,000 5.50% Bond C...

2. After recently receiving a bonus, you have decided to add some bonds to your investment portfolio. You have narrowed your choice down to the following bonds (assume semiannual payments):...

After recently receiving a bonus, you have decided to add some bonds to your investment portfolio. You have narrowed your choice down to the following bonds (assume semiannual payments): Using the...

Settlement Date Maturity Date Coupon Rate Market Price Face Value Required Retum Bond A 2/15/2017 8/15/2027 4.00% $975 $1,000 4.35% Bond B 2/15/2017 5/15/2037 6.25% $1,062 $1,000 5.50% Bond C...

2. After recently receiving a bonus, you have decided to add some bonds to your investment portfolio. You have narrowed your choice down to the following bonds (assume semiannual payments):...

2. After recently receiving a bonus, you have decided to add some bonds to your investment portfolio. You have narrowed your choice down to the following bonds (assume semiannual payments): Bond A...

2. After recently receiving a bonus, you have decided to add some bonds to your investment portfolio. You have narrowed your choice down to the following bonds (assume semiannual payments) a. Using...

Rs. 68,000 is divided among A, B, and C in the ratio of 1/2:1/4:5/16. The difference between the greatest part and the smallest part is: 1. Rs. 8000 2. Rs. 32000 3. Rs. 9000 4. Rs. 12000 5. None of...

Are you optimistic about our ability to develop a global ethical consensus across our national and religious differences? Why or why not?

Carla Lopez deposits $ 1 0 0 0 every year into her retirement account. If these funds have an average earning of 1 2 percent over the 5 0 years until her retirement, what will be the value of her...

Ken closes his chapter with questions for aspiring social innovators before, during, and after they enact their idea ( pp . 1 8 - 2 0 ) . In light of your reading of Khanna and Zeyen and Beckmann,...

You are taking an online college class and have been offered the final exam from a student who printed a copy for you after taking the exam yesterday. The correct answers are not on the test copy....

You are offered a great job, but you have to relocate to a distant city. Your family agrees that the decision is yours to make, but you know they do not want to move. What do you do?

Your job or career: Where are you working? What are you doing? What is your compensation?