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.
 

Nihil fugiat odit aperiam. Maiores est ipsa deleniti qui earum doloribus ipsa perferendis. Debitis velit omnis repellat et eligendi facere fugit nisi.

Ex pariatur accusantium autem non qui. Temporibus ut enim labore sapiente. Totam occaecati in delectus sit officia voluptatum reiciendis.

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

June 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

June 2026 Investment Banking

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

Professional Growth Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 05 98.3%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (44) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (78) $151
  • 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

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
kanon's picture
kanon
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
CompBanker's picture
CompBanker
98.9
6
GameTheory's picture
GameTheory
98.9
7
DrApeman's picture
DrApeman
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
dosk17's picture
dosk17
98.9
10
bolo up's picture
bolo up
98.8
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...”