The Essentials of Financial Modeling in Excel: A Concise Guide to Concepts and Methods

ISBN-13: 9781394157785 / Angielski / Miękka / 2023 / 204 str.

Michael (Audencia Business School) Rees

Spis treści

About This BookThe AuthorDedicationPART I: INTRODUCTION TO MODELINGChapter 1: Modeling and Its UsesChapter 2: Principles of Model DesignPART II: ESSENTIALS OF EXCELChapter 3: Menus, Operations, Functions and FeaturesChapter 4: Sensitivity and Scenario AnalysisPART III: GENERAL CALCULATIONS AND STRUCTURESChapter 5: Growth Calculations for ForecastingChapter 6: Modular Structures and Summary ReportsChapter 7: Scaling and Ratio-driven ForecastsChapter 8: Corkscrews and Reverse CorkscrewsChapter 9: Waterfall AllocationsChapter 10: Interpolations and AllocationsPART IV: ECONOMIC FOUNDATIONS AND EVALUATIONChapter 11: Breakeven and Payback AnalysisChapter 12: Interest Rates and CompoundingChapter 13: Loan Repayment CalculationsChapter 14: Discounting, Present Values and AnnuitiesChapter 15: Returns and Internal Rates of ReturnsPART V: CORPORATE FINANCE AND VALUATIONChapter 16: The Cost of CapitalChapter 17: Financial Statement ModelingChapter 18: Corporate Valuation ModelingChapter 19: Ratio AnalysisPART VI: DATA AND STATISTICAL ANALYSISChapter 20: Statistical Analysis and MeasuresChapter 21: Data Preparation: Sourcing, Manipulation, and Integration

O autorze

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.