Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. please answer using excel part 1: i own a securit

Please answer using excel Part 1: I own a security that has the following...

90.2K

Verified Solution

Question

Finance

imageimage

Please answer using excel

Part 1: I own a security that has the following characteristics: Principal Amount: Issue Date: Maturity: Coupon: Coupon Frequency: $100,000,000 9/1/21 9/1/31 2.00% 1st of Every March and September Beginning on 3/1/2022 Assuming a valuation date of September 20, 2021 and a discount rate equivalent to the 10Y U.S. Treasury yield on such day, find the present value of the future coupon payments. Using the cells at the right, please calculate the PV of these coupon payments: Be sure to show all calculations: show the PV of each individual cash flow and the summed total Please do not use any built-in Excel formulas for the PV calculations Part 2: Perform a price sensitivity analysis of the security described in Part 1 based on changes in the yield. Start with the yield that sets the price equal to par ($100). Next, shift the yield up in 25 basis point increments, stopping at a total increase of 200 basis points. Finally, shift the yield down in 10 basis point increments, stopping at a total decrease of 50 basis points. Put this information together in a formatted grid that would be shown in a presentation to a client - for each shift, please make sure to show the resulting yield and price of the security

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students