Question: Having issues finding out how to fill out the bond cash flows section. F G . J K L M N 93.2705121 3 year spot

Having issues finding out how to fill out the bond cash flows section.

F G . J K L M N 93.2705121 3 year spot 0.03529789 Double check your rates using 4 year par bond t cf pv.spot pv.fwd 0 1 4 2 4 3 4 4 104 88.7044992 4 year spotr 0.04057149 price: price should be $100 for both methods, if you calculated all rates correctly! A B D E 1 Par interest rate curve 2 3 Year Rate Spot rates 1 year forward rates 4 1 2.00% 2.00% 2.00% 5 2 3.00% 3.02% 4.04% 6 3 3.50% 3.53% 4.57% 7 4 4.00% 4.06% 5.66% 8 9 10 Interest rate volatility 11 15.00% 12 13 14 15 16 Bond 1 information 17 Maturity 4 18 Coupons annual 19 Coupon rate 5.00% 5 20 Default prem 0.00% 21 Options none 22 23 Bond cash flows 24 25 time pv.spot pv.fwd 26 0 27 1 28 2 29 3 30 4 31 32 Price of bond using spot rates 33 34 Price of bond using forward rates 35 36 YTM on bond: 37

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!

Please help with the formulas to double check my rates using the 4 year par bond section. F G H J L M N A B D E 1 Par interest rate curve 2 3 Year Rate Spot rates 1 year forward rates 4 1 2.00% 2.00%...

Hello my friend please assist me with my discussion Interest Rates Negotiation is a soft skill that might just be one of the most important skills you will ever learn. For this Discussion you will...

123please help me with this Winter 1, 2013 7/22/2012 Chapter 4. Ch 04 P35 Build a Model Except for charts and answers that must be written, only Excel formulas that use cell references or functions...

Need help with this assignment.I've attached the excel workbook that should be used to record answers and the case scenario. The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy...

A U.S. company plans to raise 70,000,000. It plans to raise this money by issuing dollar denominated bonds and using a currency swap to convert the dollars to euros. The company expects interest...

IfyouhaveplayedaSimulationcalledProBankerIneedhelpansweringthesequestionsassoonaspossible from the pro bankerassignment attachment..please use spreadsheet and players manual for reference. Need...

You helped me a couple of weeks ago. I was wondering if i could setup a time for tomorrow that you could be available to help me with some questions. I will pay $20 per question. They are short and I...

Please read the attachment chapters and answer the following questions with at least 50 words. Depreciation discussion What are the various methods of determining depreciation and amortization...

hello, please see attached I need help with. I only need the 2 tax memos since I already prepared the tax forms. I need an original paper with proper references APA format. Thanks ACC 700 Milestone...

A machine that is critical to the Phelps-Dodge copper refining operation was purchased 7 years ago for $160,000. Last year a replacement study was performed with the decision to retain it for 3 more...

Suppose you drop a ball from the top of a building that is 1 00 feet tall. (a) Construct a mathematical model to estimate how long it takes the ball to reach the ground. An object falling near the...

Question 7 of 7 - 1 6 The following facts pertain to a non - cancelable lease agreement between Alschuler Leasing Company and Marin Electronics, a lessee, for a computer system. Commencement date...

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

(Appendices) PURCHASES, PURCHASE RETURNS, AND PAYMENT FOR PURCHASES. Jordan Footwear sells athletic shoes. During April Jordan made the following purchases on credit with terms 3/15, n/40: LO4 Assume...

(Appendices) SALES AND SALES RETURNS WITH DISCOUNTS. Fuente Office Supply sells all merchandise on credit with terms 2/10, n/30. Fuente engaged in the following transactions: a) May 1: Fuente sold 50...

(Appendices) Choose five food, beauty, or household products you find in your home. Visit a local store and compare three different sizes of the product and compute unit prices. Compile the...