FIN3010 - WA 6

help

Please need help to calculate attached 2 questions in excel formula    Thanks

vvk.3

N7 Example 61. An investor want to purchase a 3 year Rs 100 face value bond having nominal interest rate of 6%. What should be the purchase price if the investors required rate of return is 8% and the bond is to mature at par. CS Scanned with CamScanner

Last Part of Question D and question E please

H5.

Start with the partial model in the file Ch04 P24 Build a Model.xlsx onthe textbook’s Web site. A 20-year, 8% semiannual coupon bond with a parvalue of $1,000 may be called in 5 years at a call price of $1,040. The bondsells for $1,100. (Assume that the bond has just been issued.)a. What is the bond’s yield to maturity?

INV3 P1a   Bond # 1 2 3 4   1 - year strip bond 2- year strip bond 2-year 6% coupon bond 2-year 7% coupon bond Purchase Price for the bond) 950 ? ? ? Year 1 cash flow 1000 0 60 70 Year 2 cash flow 0 1000 1060 1070 Yield to Maturity ? ? 5.50% ?   Fill in the missing pieces from the following table using the Law of One Price. Assume all these bonds have the same risk, the yield curve is flat, and any coupon payments are paid annually.

Provide correct answer financial accounting question

Please provide answer in excel format  Please provide detailed solution and give the explanation of the concept

What is curren market price bond

F What must be the price of a $2,000 bond with a 5.9% coupon rate, annual coupons, and 25 years to maturity if YTM is 10.2% APR? A. $984.98 B. $1,231.23 OC. $1,723.72 D. $1,477 47 CODE

10

What is the yield to maturity of a bond that just paid an annual coupon payment of $50, has 10 years remaining until maturity, a $1,000 par value when priced at a $965? (please show work or how to enter into a BA II plus) a. 4.95 b. 2.72 c. 5.46 d. 5.00 e. 10.57

mni.3

2:37 a. Compute the bond's yield to maturity. b. Determine the value of the bond to you, given your required rate of return. c. Should you purchase the bond? (Related to Checkpoint 9.2 and Checkpoint 9.3) (Bond valuation) Fingen's 14-year, $1,000 par value bonds pay 9 percent interest annually. The market price of the bonds is $850 and the market's required yield to maturity on a comparable-risk bond is 13 percent. a. What is your yield to maturity on the Fingen bonds given the market price of the bonds? % (Round to two decimal places.) ||| Vo) 1 LTE2 = O 4Gl 41%

Q No 5: An 8 percent semiannual coupon bond matures in 5 years. The bond has a face value of $1,000 and a current yield of 8.21 percent. What are the bonds price and YTM? (Remember Call price is FV when bond is called by company and capital gain is calculated from = (YTM-Current Yield) calculate with formula not on excel

vvk.6

18. Xcel Using a Spreadsheet to Calculate Bond Values: What is the bond quote for a $1,000 face value bond with an 8 percent coupon rate (paid semiannually) and a required return of 7.5 percent if the bond is 6.48574, 8.47148, 10.519, and 14.87875 years from maturity? (LG 6-2) Face Value 100% 100 100 100 Periodic Coupon Payment 6.48574 × 2 = 12.97148%/2 = 4% Total Payments 8.47148 x 2 = 16.94296 10.519 x 2 = 21.0380 14.87875 x 2 = 29.7575 4 4 4 Required Return 7.5% 7.5 7.5 7.5 The Bond Value Will Be 102.531% 103.094 103.594 104.437

Suppose a five- year, $ 1 comma 000$1,000 bond with annual coupons has a price of $ 904.31$ 904.31 and a yield to maturity of 6.1 %6.1% . What is the bond's coupon rate? Question content area bottom Part 1 The bond's coupon rate is enter your response here % . (Round to three decimal places.)

L9

ubject Test Note:- You are attempting question 5 out of 12 Interest rate on 3-year bond is 8% and on a 4-year bond is 9%. The forward rate in year 4 1S- A. 12.06% B. 8% C.7.01% D. 9.26% Answer D Submit Ca Q) ENG

8

vvk.1