Muni Bond Default---Modeling Question

Hi all,

I'm trying to create a model to stress test muni bonds for a particular state.

I need the model to be able to run scenarios on how far bond prices must fall to make the state's interest expense exceed revenues, which would trigger a default.

The key point i'm trying to get from this model are:

-What interest rate would this bond price? -What probability is this likely to happen -How much does the risk of state bankruptcy increase over time into 2013, 2014, etc?

I have no credit background and my fixed income knowledge is pretty rusty. Can anyone suggest the best way I go about doing this? If you can direct me to a website or some sort of template that i could take a look at---I would be very grateful and do anything I can to return the favor. Any tips/suggestions are welcome.

Thanks in advance.

-CKA

4 Comments
 

eeeek

Disclaimer for the Kids: Any forward-looking statements are solely for informational purposes and cannot be taken as investment advice. Consult your moms before deciding where to invest.
 

Ah a question I can answer. But before I spend 30 minutes explaining it, have you read other Muni research reports? You can find dozens of them online from MS, GS, etc. They'll give you adequate details for a variety of situations.

If you could answer that q I can answer your three qs.

 
Best Response
vectorandmatricesAh a question I can answer. But before I spend 30 minutes explaining it, have you read other Muni research reports? You can find dozens of them online from MS, GS, etc. They'll give you adequate details for a variety of situations.

If you could answer that q I can answer your three qs.

I've mainly been reading up on how the current Sovereign Default crisis affecting the EU because I figure that a similar methodology can be applied to what I am trying to accomplish. I've also looked over some reports issued by credit agencies and meeting transcripts. I'm also reading about how the default probability of bonds is based on the cost of the CDS. I have no idea how to quantify my findings into an excel model.

All I learned in school about bonds is your basic bond math. Do you think I'm going about this the right way?

Disclaimer for the Kids: Any forward-looking statements are solely for informational purposes and cannot be taken as investment advice. Consult your moms before deciding where to invest.
 

Iure sit maxime illum. Libero libero deleniti corporis amet numquam. Vitae voluptas maxime accusamus. Maiores asperiores qui sequi aliquam ut qui. Dolores ratione ex veritatis sed excepturi.

Disclaimer for the Kids: Any forward-looking statements are solely for informational purposes and cannot be taken as investment advice. Consult your moms before deciding where to invest.

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