Creepy as hell, but excellent attention to detail and use of Excel’s Data Validation feature.
Here’s the spreadsheet (click to enlarge):
Learn Financial Statement Modeling, M&A, LBO, DCF, Comps and essential Excel shortcuts by signing up for Wall Street Prep's free Quicklesson series. We'll email you the first lesson, "A Simple LBO Model," right now.
The Wall Street Prep Quicklesson Series
7 Free Financial Modeling Lessons
Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.