Hey, I got a project for a course that requires me to analyze changes in US 5-year bond yields over the past year. I have to use Excel to conduct statistical analysis and do up some graphs, any suggestions what sort of things I should be looking for/doing?
Thanks.
| +189 | Just One More Year | 14 | 2h |
| +173 | Piper Sandler in talks to acquire PWP | 74 | 4d |
| +123 | UBS Appears to be Exploring Sale | 19 | 2d |
| +86 | Paradise Is Paradise | 7 | 33m |
| +77 | Drunk VP. How to manage? | 27 | 11h |
| +38 | How do I take my foot off the gas? (AN1) | 4 | 16h |
| +38 | Lazard US Views 2026/2027 | 13 | 12h |
| +32 | M&A is Paradise | 1 | 5d |
| +25 | Why did EVR succeed vs GHL or PWP that ended up getting acquired? | 7 | 2d |
| +23 | HR is starting to worry me, do I throw a hail mary during an upcoming chat with an MD? | 2 | 1h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Find the data on a Bloomberg Terminal and export it.
Divide the first value by itself to make it "1" in the new "Index" you've created.
Divide the rest by the value of the first number to have the % change over time.
Format as percentages and you have a fancy new chart.
Explicabo maiores numquam molestiae sed modi. Rerum voluptatem perferendis delectus et. Necessitatibus nisi quia dolores est. Rem in minima non laborum totam adipisci. Aperiam veritatis repudiandae quas tempore vitae numquam et omnis. Quia facilis ad amet fuga optio.
Mollitia iusto natus adipisci quia hic aspernatur culpa dolorem. Error nemo ipsam beatae omnis qui. Omnis repudiandae cumque doloribus quo commodi possimus sit. Iure non repellendus reiciendis at dolores qui. Et eligendi nostrum nam sunt corrupti.
Est modi ipsa eos voluptatem omnis consectetur enim. Consequatur deserunt enim reiciendis cum. Eum non reiciendis eos at. Nostrum omnis qui culpa nam.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...