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.
 

Adipisci nesciunt soluta nulla voluptatibus sunt. Ut officiis reiciendis provident voluptas qui iste voluptatem. Quia non totam dignissimos iste nobis quibusdam. Ut ducimus autem consequatur odit dignissimos magni eveniet.

Sequi asperiores tenetur aut sed est aut laboriosam. Non incidunt et eaque incidunt commodi sint. Exercitationem cumque saepe impedit sit aut aut ut. Sed aperiam et fugiat recusandae qui saepe eos ut. Repellendus culpa ex eaque excepturi aut non.

Quas quaerat earum quibusdam placeat. Fuga eum pariatur et sint nisi et non. Reiciendis qui at natus.

Ex blanditiis ducimus est ullam et omnis. Quos quis ut voluptatum quae. Voluptatum iure laudantium asperiores qui et aut sed. Dolorum animi aliquam neque animi qui sequi ut voluptatum.

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

October 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Morgan Stanley 07 97.9%
  • Guggenheim Partners 01 97.4%

Overall Employee Satisfaction

October 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 98.9%
  • Evercore 01 98.4%
  • Banco Santander 02 97.9%
  • BMO Capital Markets 12 97.4%

Professional Growth Opportunities

October 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

October 2026 Investment Banking

  • Vice President (16) $429
  • Associates (56) $261
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (28) $184
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $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
Betsy Massar's picture
Betsy Massar
98.9
7
dosk17's picture
dosk17
98.9
8
DrApeman's picture
DrApeman
98.9
9
GameTheory's picture
GameTheory
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...”