Question
I have tried this a million ways with Excel and it is not coming up with the right information. I need a yield curve (X,Y
I have tried this a million ways with Excel and it is not coming up with the right information. I need a yield curve (X,Y scatterplot) with this info. I have been trying for three hours. Please help me.
| Maturity | 1/8/91 | 1/10/02 | 8/7/07 | 10/9/19 | 11/13/23 |
| Month 1 | N/A | 1.66% | 5.05% | 1.69% | 5.53% |
| Month 2 | N/A | N/A | N/A | 1.70% | 5.55% |
| Month 3 | 6.64% | 1.68% | 4.94% | 1.69% | 5.55% |
| Month 4 | N/A | N/A | N/A | N/A | 549.00% |
| Month 6 | 6.74% | 1.75% | 4.98% | 1.69% | 5.48% |
| Year 1 | 6.75% | 2.10% | 4.84% | 1.59% | 5.37% |
| Year 2 | 7.15% | 2.94% | 4.56% | 1.47% | 5.02% |
| Year 3 | 7.39% | 3.46% | 4.55% | 1.43% | 4.80% |
| Year 5 | 7.74% | 4.27% | 4.60% | 1.40% | 4.66% |
| Year 7 | 8.06% | 4.74% | 4.66% | 1.50% | 4.69% |
| Year 10 | 8.16% | 5.00% | 4.77% | 1.59% | 4.63% |
| Year 20 | N/A | 5.64% | 5.01% | 1.88% | 4.95% |
| Year 30 | 8.37% | 5.42% | 4.92% | 2.08% | 4.75% |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Stock Trading For Beginners How To Start
Authors: Speculazione Duepuntozero
1st Edition
1792767064, 978-1792767067
