Question: IN EXCEL FORMULA PLEASE! PLEASE WRITE DOWN THE FORMULA CLEARLY THANKS! 3 Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon

IN EXCEL FORMULA PLEASE! PLEASE WRITE DOWN THE FORMULA CLEARLY THANKS!

3 Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.9 percent paid semiannually and 13 years to maturity. The yield to maturity of the bond is 3.8 percent. What is the dollar price of the bond? 4 5 6 7 8 9 Settlement date Maturity date Coupon rate Coupons per year Redemption value (% of par) Yield to maturity Par value $ 1/1/2000 1/1/2013 4.90% 2 100 3.80% 2,000 10 11 12 13 14 15 Complete the following analysis. Do not hard code values in your calculations. Leave the "Basis" input blank in the function. You must use the built-in Excel function to answer this question. 16 17 Dollar price 18 19 Sheet1 READY 100% Attempt(s) 3/3 Hint Step: Use the PRICE function to find the price of a bond. Remember, Excel calculates the price as a percentage of par

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!

Yan Yan Corp. has $2,000 par value bond outstanding with a coupon rate of 4.9 percent paid semiannually and 13 years to maturity. The yeild of the bond is 3.8 percent. What is the dollar price of the...

All answers must be entered as a formula Click OK to begin. OK 5 1 ? x XD FILE . HOME Calculating a bond price - Excel FORMULAS DATA REVIEW - Sign In INSERT PAGE LAYOUT VIEW 19 Calibri -11-AA Paste B...

Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.9 percent paid semiannually and 13 years to maturity. The yield to maturity on this bond is 3.8 percent. What is the...

2 This worksheet was designed to teach you how to work TVM, Stock and Bond problems and equations in Excel Worksheet Instructions This is stool to help you learn how to enter formules into extel to...

Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.9% paid semiannually and 13 years to maturity. The yield to maturity of the bond is 3.8%. What is the dollar price of the...

X H5 = Calculating a bond price - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign In Arial 12 Paste BIU % Alignment Number Conditional Format as Cell Formatting Table Styles Styles...

13 fo Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.9 A B D E G Yan Yan Corp has a $2,000 par value bond outstanding with a coupon rate of 4.9 percent paid...

Please use the excel formulas. See my instructor's email for information. 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...

please answer question in excel and show the formula to get the answer ( I must have the formula) Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.9 percent paid...

please provide full Excel formula along with numbers used. Thank You! Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.9 percent paid semiannually and 13 years to...

Nine frefghting teams are currently available for assignment. Six forest fres are burning out of control in different locations around the state. If only one team will be assigned to each fre, how...

The case company is JUMBO Group Limited and its subsidiaries ("the Group"). The Group has a portfolio of several F&B brands including its anchor brand, JUMBO Seafood, operates 4 Tsui Wah Hong...

What two events must have occurred to meet the all - events test? When the teertrs and conditions of a job or project have been negotiated and a contract has been sligned When al events have occurred...

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

5. Identify three characteristics of the dialectical approach.

2. How did business and political interests influence what early intercultural communication researchers studied and learned?

2. Intercultural Encounter. Describe and analyze a recent intercultural encounter. This may mean talking with someone of a different age, ethnicity, race, religion, and so on.