{"product_id":"the-essentials-of-financial-modeling-in-excel-isbn-9781394157785","title":"The Essentials of Financial Modeling in Excel","description":"\u003cp\u003e\u003cb\u003eA concise and practical guide to financial modeling in Excel\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eIn \u003ci\u003eThe Essentials of Financial Modeling in Excel: A Concise Guide to Concepts and Methods\u003c\/i\u003e, veteran quantitative modeling and business analysis expert Dr. Michael Rees delivers a practical and hands-on introduction to financial modeling in Excel. The author offers readers a well-structured and strategic toolkit to learn modeling from scratch, focusing on the core economic concepts and the structures commonly required within Excel models. \u003c\/p\u003e\u003cp\u003eDivided into six parts, the book discusses the use of models and the factors to consider when designing and building models so that they can be as powerful as possible, yet simple. . Readers will also find: \u003c\/p\u003e\u003cul\u003e \u003cli\u003eThe foundational structures and calculations most frequently used in modeling, including growth- and ratio-based methods, corkscrews, and waterfall analysis\u003c\/li\u003e \u003cli\u003eWalkthroughs of economic modeling, measurement, and evaluation, and the linking of these to the decision criteria. These include breakeven and payback analysis, compounding, discounting, calculation of returns, loan calculations, and others\u003c\/li\u003e \u003cli\u003eStructured approaches for modeling in corporate finance, including financial statement modeling, cash flow valuation, cost of capital, and ratio analysis\u003c\/li\u003e \u003cli\u003eTechniques to implement sensitivity and scenario analysis\u003c\/li\u003e \u003cli\u003eCore aspects of statistical analysis, including data preparation, manipulation, and integration\u003c\/li\u003e \u003cli\u003eThe use of approximately 100 Excel functions within example modeling contexts\u003c\/li\u003e \u003cli\u003eFurther Topics Sections, which introduce advanced aspects of many areas, in order to provide further benefit to more advance readers, whilst presenting the truly essential topics separately. Examples of these include introductions to PowerQuery and PowerPivot, as well as advanced waterfall structures\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eAn invaluable, all-in-one blueprint for learning financial modeling in Excel, this book is ideal for beginning and intermediate financial professionals and students seeking to build and reinforce essential topics in financial modeling. \u003c\/p\u003e\u003cp\u003eAbout This Book\u003c\/p\u003e \u003cp\u003eThe Author\u003c\/p\u003e \u003cp\u003eDedication\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART I: INTRODUCTION TO MODELING\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Modeling and Its Uses\u003c\/p\u003e \u003cp\u003eChapter 2: Principles of Model Design\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART II: ESSENTIALS OF EXCEL\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 3: Menus, Operations, Functions and Features\u003c\/p\u003e \u003cp\u003eChapter 4: Sensitivity and Scenario Analysis\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART III: GENERAL CALCULATIONS AND STRUCTURES\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 5: Growth Calculations for Forecasting\u003c\/p\u003e \u003cp\u003eChapter 6: Modular Structures and Summary Reports\u003c\/p\u003e \u003cp\u003eChapter 7: Scaling and Ratio-driven Forecasts\u003c\/p\u003e \u003cp\u003eChapter 8: Corkscrews and Reverse Corkscrews\u003c\/p\u003e \u003cp\u003eChapter 9: Waterfall Allocations\u003c\/p\u003e \u003cp\u003eChapter 10: Interpolations and Allocations\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART IV: ECONOMIC FOUNDATIONS AND EVALUATION\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 11: Breakeven and Payback Analysis\u003c\/p\u003e \u003cp\u003eChapter 12: Interest Rates and Compounding\u003c\/p\u003e \u003cp\u003eChapter 13: Loan Repayment Calculations\u003c\/p\u003e \u003cp\u003eChapter 14: Discounting, Present Values and Annuities\u003c\/p\u003e \u003cp\u003eChapter 15: Returns and Internal Rates of Returns\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART V: CORPORATE FINANCE AND VALUATION\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 16: The Cost of Capital\u003c\/p\u003e \u003cp\u003eChapter 17: Financial Statement Modeling\u003c\/p\u003e \u003cp\u003eChapter 18: Corporate Valuation Modeling\u003c\/p\u003e \u003cp\u003eChapter 19: Ratio Analysis\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART VI: DATA AND STATISTICAL ANALYSIS\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 20: Statistical Analysis and Measures\u003c\/p\u003e \u003cp\u003eChapter 21: Data Preparation: Sourcing, Manipulation, and Integration\u003c\/p\u003e  \u003cp\u003e\u003cb\u003eMichael Rees\u003c\/b\u003e 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, insur­ance, pharmaceuticals, and other industries.   \u003c\/p\u003e\u003cp\u003e\u003cb\u003eA straightforward and hands-on guide to financial modeling in Excel\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eIn \u003ci\u003eThe Essentials of Financial Modeling in Excel: A Concise Guide to Concepts and Methods\u003c\/i\u003e, 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. \u003c\/p\u003e\u003cp\u003eThe 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. \u003c\/p\u003e\u003cp\u003eAn indispensable, all-in-one blueprint for learning financial modeling in Excel, \u003ci\u003eThe Essentials of Financial Modeling in Excel\u003c\/i\u003e is perfect for novice and intermediate financial professionals and students hoping to build and reinforce foundational skills in the area.\u003c\/p\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47990221308133,"sku":"NP9781394157785","price":55.0,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781394157785.jpg?v=1761786961","url":"https:\/\/k12savings.com\/products\/the-essentials-of-financial-modeling-in-excel-isbn-9781394157785","provider":"K12savings","version":"1.0","type":"link"}