A straightforward and hands-on guide to financial modeling in Excel In The Essentials of Financial Modeling in Excel: A Concise Guide to Concepts and Methods, business analysis and quantitative modeling expert Dr. Michael Rees delivers a practical and to-the-point introduction to financial modeling in Microsoft Excel. In the book, you'll explore a structured and strategic toolkit to learn modeling from scratch, focusing on the core economic concepts and frameworks most commonly employed within Excel models. The author intuitively presents the structures and calculations used most frequently in modeling, including growth- and ratio-based methods, corkscrews, waterfall analysis, walkthroughs of economic modeling, measurement, and evaluation, as well as core aspects of statistical analysis techniques (including data preparation, manipulation, and integration), valuation, and corporate finance modeling techniques. You'll also discover how to use approximately 100 Excel functions in modeling contexts and explore some areas in more depth within the Further Topics sections. An indispensable, all-in-one blueprint for learning financial modeling in Excel, The Essentials of Financial Modeling in Excel is perfect for novice and intermediate financial professionals and students hoping to build and reinforce foundational skills in the area.

Michael Rees is Professor of Finance at Audencia Business School in Nantes, France. He has over 30 years' experience in senior roles at leading firms in finance and strategy consulting, including JP Morgan, Mercer Management Consulting, and Braxton Associates. He has also worked as an independent consultant and trainer, advising clients in private equity, auditing and consulting, finance, banking, insurance, pharmaceuticals, and other industries.

Leseprobe