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

50.1K

Verified Solution

Question

Finance

image

image

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

Q

For the following type of data set would you be more interested in Answer The...

Statistics
Q

The Birdstrom Co. just recently paid a dividend of $2.00 per share. Stock market analysts expect...

Finance
Q

Determine the solution of the following initial boundary-value problem using the method of separation of Variables Uxx=4Utt...

Advance Math
Q

Let X and Y have the joint pdf f(x, y) = 8xy, 0 ≤ x...

Basic Math
Q

Sport Psychology Solving Common Problems in PST Assume that you're implementing a psychological skills training program for a...

Psychology
Q

It is distressing to see how many people are willing to use inflammatory, derogatory, and unnecessarily...

Psychology
Q

Suppose this information is available for PepsiCo, Inc. for 2023,2024, and 2025....

Accounting
Q

For each quarter of data, decompose AMCs ROE into the 5 component ratios(net profit margin,...

Accounting
Q

Securing Data" Please respond to the following: In this global age of information, suggest which...

Accounting
Q

4. True or False - Pro-forma financial statements are great when preparing budgets, but actual...

Accounting
Q

Please analyze this component and trend analysis for targets balance sheet for years 2020-2024 ...

Accounting
Q

The Paulson Company's year-end balance sheet is shown below. Its cost of common equity is...

Finance