Peter Orr builds an Excel model of a $100 million, 20 year (serial bonds), level debt service public finance bond deal. He details the building of Sources and Uses of Funds and ultimately the debt service schedule to be paid by the borrower. Goal seek is used to determine the amount of annual debt service required to properly size the issue and minimize annual debt service cost.

Loading more stuff…

Hmm…it looks like things are taking a while to load. Try again?

Loading videos…