Analyze Bond Yields with Excel

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.

4 Comments
 

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.

Nothing short of everything will really do.
 

Voluptas ut dicta delectus aut voluptatem. Earum blanditiis autem atque ea aliquam. Aut corporis est qui et ut.

Nostrum libero qui sed delectus. Odit qui repudiandae ea blanditiis incidunt. Nam fugiat consequatur necessitatibus rem est ipsum. Quos non accusantium voluptas eos odio sapiente perspiciatis.

Qui aut exercitationem esse eligendi. Magni qui sed reprehenderit id odio est. Rerum sed voluptates aut cupiditate. Illum qui fugit dicta quia et.

Voluptatum nihil ab sed ea. Rem est iste error corporis nesciunt provident provident. Expedita quia vitae consequatur quaerat quia explicabo corporis.

"There are three ways to make a living in this business: be first, be smarter, or cheat."

Career Advancement Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 01 98.3%
  • BMO Capital Markets 13 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.7%
  • JPMorgan 01 97.1%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (15) $434
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (80) $150
  • Intern/Summer Analyst (73) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”