Taming Premium Bonds

Premiums 15-Year
The Bond Buyer published my commentary Taming  Premium Bonds earlier today.  Although callable premium bonds are very popular in the municipal market, I argue that they hurt issuers and the market.  Market rules dictate that the proceeds to the issuer compensate only for high coupons to the call date.  The compensation for high coupons past the call date is buried inside the call option, making a refunding almost inevitable.  These bonds also make the market more opaque.  As a solution, I propose that the call premiums be set to breakeven levels so that the price-to-call matches the price-to-maturity.  Please see the article for the details.

Update: This not a new idea.  I applied it as a financial advisor many years ago, and it is also the basis for one of the puzzles on this blog.

Posted in Bonds | Tagged , , | Leave a comment

Fifth Annual Municipal Finance Conference

On July 12, this year’s Municipal Finance Conference will be held for the first time at the Brookings Institution in Washington, D.C.   The other sponsors are the Brandeis International Business School and the Olin Business School at Washington University in St. Louis.

The purpose of the conference is to bring municipal finance professionals together with academics to encourage useful research and better practice.  This year’s program will include several papers on financial distress and other challenges for municipalities.  The keynote speaker will be Governor Alejandro Garcia Padilla of Puerto Rico.

As a discussant, I will respond to a paper  that attempts to account for the potential benefits of future refundings within the interest cost of a bond or bond issue.

I understand that there may still be openings for the conference.  Click here for more information, and to register.  I hope to see you there.

Posted in Bonds, Economics | Tagged , , , | Leave a comment

Generating Sitemap Links with Excel

We have become good friends with the Ysais family of Kyle, Texas.  They visited us in Colorado last summer and we all had a great time.  Corrina stays in touch with Marie almost every day, our daughter Skypes and plays Minecraft with the two boys, and Michael taunts me with mouthwatering photos of his smoked brisket.

Marie runs Ysais SEO, which helps businesses optimize their search engine results.  She asked me to help with an Excel workbook to create Google sitemap links.  I took the file she sent and worked it into a tool that can create several links for each specified website.

I thought I would share the workbook because it makes a good example of how to use Excel’s table feature and its HYPERLINK function.  With Marie’s consent, here is the workbook. Click on the image to open the file.

sitemap generator

There are four sheets, each with its own table (note that these are not “data tables”).  The first three tables provide the building blocks for the links: the Google sitemap text (the “prefix”), the domain names, and part specifiers (the “suffix”).  On “SiteMaps”, the last tab, a table generates hyperlinks for all possible combinations of the three text blocks.

To use the workbook, make sure that the prefix text meets your needs.  As with all inputs in this workbook, the prefix text is colored blue.  You can insert rows above if you need more than one prefix. Next, enter the domain names.  There is room for 500 domain names.  Blanks are fine, and you can always insert more rows if you need more.  The final input step is to review the suffix text.  You can insert more suffix items if you need more.

Now go to the sitemap generator on the last sheet.  Click on the “Good?” filter and select “TRUE” only.  This will hide the blank links.  Be sure that the bottom of the “Last?” column shows a “TRUE” value.  This insures that the last possible combination of your text blocks has been reflected in the sitemap list.  If not, you will need to insert more rows into this table.

Marie reports that the workbook also made it easy for her to create Bing sitemaps.

Note: a good way to insert rows into any of these tables is to click on the cell labelled “Count” at the bottom of the first column.  Insert the number of needed rows and copy down any formulas from above as needed.

Please let me know if you have any questions.

Posted in Spreadsheet Tips | Tagged , , , , | Leave a comment

Spaghetti Puzzle #1

About a month ago, math educator Marilyn Burns tweeted this puzzle:


Spoiler Alert: Stop here if you want to solve the puzzle yourself!  Answers (some correct and some not) will be given below.

This innocent-seeming puzzle stirred several math teachers to exchange ideas, diagrams and animations.  Some of them changed their minds about it as they worked through the problem.  For example, Simon Gregg first thought that the answer is 1/4:

Upon further reflection, he changed his answer to 1/3:

There were some who used calculus to find a probability of 0.386.  Gregg came to suspect they were right:


My Attempts

I approached the problem in a few ways myself.  I thought about the sample space as sketched by Kaleb Allinson:

Assuming the spaghetti stick is one unit long, the horizontal axis represents the length of the shorter piece after the first break.  Let’s call this A.  It must range between 0 and 1/2.  The longer piece is then itself broken into a left piece with length B and a right piece with length C.  I interpret the vertical axis in Allinson’s chart as the length B.  It could range between just above zero to nearly one if A is very small, and it could range between between zero and around 1/2 if A itself is close to 1/2.  The length C of the third side is not displayed in this diagram, but we can find it for any point (A,B) by using C = 1 - A - B.

The sample space of possible (A,B) points combines the three right triangles in Allinson’s diagram.  The shaded area in the middle represents the combinations of A and B that can lead to a spaghetti triangle.  These combinations work because of the triangle inequalities, which require that no side be longer than the sum of the other two sides.  Otherwise, the two shorter sides might just dangle pathetically off the long side like the arms of a T-Rex.

Allinson saw that one-third of the sample space corresponded to valid triangles, and so concluded that the probability of forming a triangle is 1/3.  However, all parts of the diagram are not equally likely.  All permitted values of A are equally likely, but the distribution of B depends on A.  When A is very small, there is about a 50% chance that B is less than 1/2.  In contrast, when A is near 1/2, there is almost a 100% change that B is less than 1/2.  The probability density in the diagram is not uniform; it increases from left to right.

In my mind, I pictured the probability density as a slanted roof above the diagram (in a third dimension).  By some mental calculation I concluded that the probability of landing in the shaded area (what we might call the “triangle of triangles”) was 1/2.

To check my result, I made a spreadsheet to simulate many random spaghetti snaps.  For each simulation, I sampled values for two random variables X and Y, each uniformly distributed from 0 to 1.  I used X to set A, the length of the shorter piece after the first break.  We can let A equal the lesser of X and 1-X.  We then find the next piece with B=Y\times (1-A).  As mentioned above, the third piece C=1-A-B.   I set up the model to run 10,000 simulations and flag which ones could form triangles.

Spaghetti sides

This is the result of one run with the A and b values plotted for each simulation.  The blue dots indicate valid triangles.  It looks like one-third of the points are good for triangles.  However,  the points are more crowded on the right than the left, and there are 3,823 blue dots out of 10,000 total.  The blue triangle is denser than the orange areas and gets more than its share of the simulations.

spaghetti random 2

Here is the same run plotted against the random variables X and Y.  The blue dots take up about 38% of the area of this evenly distributed chart.

I ran the spreadsheet several times and each time about 38% or 39% of the simulations allowed triangles.  I had to doubt my answer of 1/2.  I realized that the probability surface was not simply flat incline but something with a curve to it.

I communicated by Twitter and email with Mike Andrejkovics, a math teacher and math rapper(!) .  He thought at first that the answer was 1/4 and he created a cool video to make his case.  Mike then realized that his solution applied to a slightly different problem (see Variations below).

Like some of the other math teachers on Twitter, Mike used calculus to find the answer of .386 for the Marilyn Burns version of the problem.  I decided to work through the calculus for myself.  Mike had gotten me thinking some more about the probability density.  None of the calculus solutions I had seen had provided an explicit formula for the probability density, but I thought that such a formula would clarify the problem for me.

Let f(x,y) be our probability density function (“pdf”) over the sample space in Kaleb Allinson’s diagram.  This space ranges from 0 to 1/2 for the x coordinate and from 0 to 1-x for the y coordinate.  We use x to represent the length of the shorter piece after the first break.  After the longer piece is broken into two pieces, the new piece on the left has length y.  The total probability over this space should equal one.  In calculus notation, this means

\iint_{S}f(x,y)dydx=1  or


The first statement integrates f over the sample space S.  The second statement is equivalent.  Working from the inside out, we begin by integrating f as y ranges from 0 to 1-x.  This integral is basically just a function of x, so we can write g(x)=\int_{0}^{1-x}f(x,y)dy.  Now our double integral becomes the single integral


We want g(x) to be constant, because we assume that  x is uniformly distributed from 0 to 1/2.  The probability density in the sample space for each value of x should be the same.  Now if g(x) is constant, then it must equal 2 so that \int_{0}^{1/2}g(x)=1.  Now we work back to the function f.   We need


which works with the pdf f(x,y)=\dfrac{2}{1-x}.  Note that f is  a function of x but not of y.  It grows along a curve from left to right.

Let’s look at this probability density function over the sample space.  The volume enclosed by the figure is exactly one cubic unit, as required.

sample space

I like this shape.  Every side could be made from a flat or rolled sheet of paper.  Maybe architects should study probability density functions for inspiration!

Now let’s complete the solution to the spaghetti problem.  We want to know the probability of landing in the shaded “triangle of triangles.”  Call this region T.  Then the probability of making a triangle is





=2ln(2)-1\approx 0.386

where ln represents the natural logarithm.  I hope you don’t mind that I skipped over some of the integration steps at the end.

Let’s see what the solution looks like.  Here is the probability density with the region for valid triangles colored in red.  The volume of the red portion is 0.386.

triangle solution



The first version of the puzzle that Mike Andrejkovics solved appears as the “Walking Stick Puzzle” (#120) in The Puzzle Universe by Ivan Moscovich.  This book was a great Christmas present from my wife.  In the Walking Stick problem, the two breaks are made independently.  It is not required that the second break occur along the longer piece after the first break.

I told my daughter (with whom I blog at Zeno’s Meatball) about the spaghetti puzzle.  She interpreted the problem in physical terms.  How do spaghetti strands really break?  Aren’t they more likely to break near the middle than near the ends?  Perhaps we grownups have been too simplistic with our uniform distributions.

Stayed tuned for a new variation on the puzzle that I will present in an upcoming post.  I hope you enjoy it.

Copyright 2016.  All Rights Reserved.

Posted in Fun, Puzzles | Tagged , , , , | 6 Comments

A Mathematician’s New Year’s Resolutions

Speaking of the new year, here are some funny resolutions from the “Math with Bad Drawings” blog. I like the one about completing chores in finite time. I bet Zeno never finished cleaning his room!

Math with Bad Drawings

Mathematician New Years 0Mathematician New Years 1

View original post

Posted in Uncategorized | Leave a comment

Happy 5 2 0 1!

Last year,  in Happy 0 0 1 0 0 1 0 0 0 0 1!, I discussed an interesting way to represent numbers based on their prime factorization.  For example, 63 is represented by 0 2 0 1 because 63 = 20 x 32 x 50 x 71.

In the prime power representation, 2015 was 0 0 1 0 0 1 0 0 0 0 1. However, with 2016 = 25 x 32 x 50 x 71, this year can be represented by the more concise  5 2 0 1.

I doubt you can express next year’s greeting in a single breath.  Because 2017 is the 306th prime, it will take the form “Happy 0 0 0  …  0 0 0 1!“, where the one is preceded by 305 zeros.


Posted in Math | Tagged , , | Leave a comment

The Money We Live With


My friend Matt Hergott has just published The Money We Live With: Understanding the World Through the Prism of Modern Money, an Amazon eBook.

From the Introduction:

This book is about contemporary money, how it is used by policymakers to try to achieve specific outcomes, and what it all means for ordinary people.  With a better understanding of modern money, people will be able to interpret more clearly the flow of history, understand better why those in positions of authority make the historic decisions they do, and better assess how those choices can affect the lives of ordinary people.

Matt is an astute analyst of investments and economics.  He gave a presentation about hedge fund replication to the Denver Chapter of the Global Association of Risk Professionals  (“GARP”) in 2013.

I look forward to reading his book, and I will share my comments in a future post.

Posted in Economics | Tagged , , , | Leave a comment