Category Modeling

The Mathematics of Leverage

I think this is one of the most important lessons of the course. This chart is clickable.  The starting base case is an asset that pays a 10% yield, that is purchased with 75% debt at 8%.

FAST rules of Financial Modeling and 20 Principles of Good Spreadsheet Practice

When I was a sophomore at Middlebury, I was told to pick up a copy of Strunk and White’s classic, “Elements of Style“, and stay close to its guidance on writing conventions. In no small way, has helped guide generations of writers to draft better, clearer compositions. There are no such broadly accepted standards in the world of spreadsheet programming.  However, […]

Resources for Learning Visual Basic

Here are a few resources from Microsoft on learning Visual Basic, courtesy of the nice people at MSDN, which stands for Microsoft Developer Network. User Defined Functions and Subs Sub Statement Function Statement Data Types Data Types DIM Statement Option Explicit Built in VBA Functions String Functions Math Functions Comparison Operators Statements If Then Else […]