The Well-Tempered Spreadsheet is dedicated to raising the quality and efficiency of financial analysis. Topics will include modelling tips and mathematical insights.
Win Smith is the author of The Well-Tempered Spreadsheet. His career has centered on quantitative finance but has many facets: programmer, modeller, analyst, teacher, mathematician, inventor, investment banker, financial advisor, CFO and expert witness. Mr. Smith holds an MSc in Mathematical Finance from Oxford University. His Master’s thesis was “Robust Bond Portfolio Optimization.” He also won the Anthony Stanley prize in mathematics as an undergraduate at Yale University.
Mr. Smith is the President of Win Analytics LLC, an independent research and advisory firm. He founded the company in order to provide financial advice, transaction structuring, cash flow modeling, portfolio valuations, research and litigation support to participants in markets such as mortgage-backed securities, asset-backed securities, real estate, education finance, project finance, public finance and renewable energy.
Mr. Smith also serves as the Senior Debt Advisor to Round Rock Partners, LLC, a company that provides financial advisory services to those engaged in renewable energy, community development and corporate social responsibility. In addition, he is a Senior Consultant for Structured Finance Solutions, LLC, an advisory firm with a specialty in real estate finance and real estate capital markets.
The Name of the Blog
The name of this blog alludes to Bach’s Well-Tempered Clavier, which illustrated the versatility of a newer tuning system with keyboard pieces in all major and minor keys. It is “generally regarded as one of the most influential works in the history of Western Classical Music.”
I may have been inspired by all the Bach we play in our house, or by the fact that my uncle, Jack Treynor, has been called the “Bach of Finance.”
Musical keyboards and spreadsheets have some similarities. Their arrays of keys or cells can be manipulated to create either junk or magic. It’s easy to jump right in and pound away, but what does it mean to do it well? I’ve confronted that question for many years, in both cases.
This blog is about financial modeling and math. It will not be confined to spreadsheets: more powerful tools will also be discussed. But “The Well-Tempered MATLAB” doesn’t have much of a ring to it, and “The Well-Tempered Model” sounds like a rarity in Milan.