Excel Modeling and Estimation Corporate Finance

For more than 20 years, since the emergence of PCs, Lotus 1-2-3, and Microsoft Excel in the 1980’s, spreadsheet models have been the dominant vehicles for finance professionals in the business world to implement their financial knowledge. Yet even today, most Corporate Finance textbooks rely on calculators as the primary tool and have little coverage of how to build and estimate Excel models. This book fills that gap. It teaches students how to build and estimate financial models in Excel. It provides step-by-step instructions so that students can build and estimate models themselves (active learning), rather than being handed already completed spreadsheets (passive learning). It progresses from simple examples to practical, real-world applications. It spans nearly all quantitative models in corporate finance. My goal is simply to change finance education from being calculator based to being Excel based. This change will better prepare students for the 21st century business world. This change will increase student evaluations of teacher performance by enabling more practical, real-world content and by allowing a more hands-on, active learning pedagogy.