**
Introduction
Eric Soubeiga’s “Mastering Financial Modeling” serves as a comprehensive guide for professionals who are seeking to develop advanced financial modeling skills using Microsoft Excel. The book is structured to cater to both beginners in financial modeling and seasoned professionals wishing to enhance their modeling skills. Soubeiga’s approach is methodical, detailed, and packed with practical examples, ensuring that readers can translate the theoretical knowledge into actionable insights.

1. Fundamentals of Financial Modeling
Soubeiga begins by addressing the foundational concepts necessary for financial modeling. These include understanding financial statements, key financial ratios, and forecasting principles.

Key Action: Master Financial Statements
– Example: One essential exercise is to practice building a basic income statement, balance sheet, and cash flow statement from scratch. The book demonstrates this with a hypothetical company’s data.
– Action: Start with the historical financial statements of a known company, replicate them in Excel, and understand how different statements are interlinked.

2. Mastering Excel for Financial Modeling
Next, the book emphasizes the importance of Excel proficiency. Soubeiga covers essential Excel features and functions that form the backbone of financial models.

Key Action: Enhance Excel Skills
– Example: Usage of functions like VLOOKUP, HLOOKUP, INDEX, MATCH, and various logical functions (IF, AND, OR). The book provides specific scenarios where these functions are applied.
– Action: Create a small project where you compare sales data across multiple years using VLOOKUP and pivot tables, then visualize this data with charts.

3. Building Financial Models
Soubeiga transitions into the actual construction of financial models, highlighting the step-by-step process and best practices, such as model layout, consistency, and clarity.

Key Action: Develop a Structured Approach
– Example: The book introduces a consistent color-coding scheme – blue for inputs, black for formulas, and red for links to other worksheets – to maintain clarity.
– Action: Implement a color-coding convention in your own models to easily distinguish between assumptions, calculations, and references.

4. Modeling Best Practices
Adopting best practices in financial modeling is crucial. Soubeiga provides detailed guidelines to ensure models are robust, flexible, and easily understandable.

Key Action: Follow Best Practices
– Example: Emphasis on modular approach – breaking down the model into manageable sections (revenues, expenses, financing).
– Action: When creating a financial model, break the model down into different sheets or sections such as ‘Revenue Assumptions’, ‘Expense Assumptions’, ‘Debt Schedule’, etc., and use clear labels.

5. Sensitivity and Scenario Analysis
Sensitivity and scenario analysis are critical for assessing the impact of varying assumptions on a model’s outcome.

Key Action: Implement Sensitivity Analysis
– Example: The book explains how to use Excel’s Data Table feature to assess how changes in interest rates and growth rates affect a company’s NPV.
– Action: Create a sensitivity analysis for any model by setting up tables that show how changing one or more inputs affects key indicators like NPV, IRR, or ROI.

6. Valuation Techniques
Soubeiga dedicates a section to valuation techniques, incorporating methods such as Discounted Cash Flow (DCF), Comparable Company Analysis, and Precedent Transactions.

Key Action: Conduct a Valuation
– Example: A detailed walk-through of constructing a DCF model – calculating free cash flows, crafting the discount rate, and deducing the terminal value.
– Action: Choose a public company, gather necessary financial data, and build a DCF model to estimate its intrinsic value. Cross-check this with market valuation for learning purposes.

7. Project Finance Models
Project finance models differ from corporate models due to their specific nature and the focus on a particular project’s cash flows and risks.

Key Action: Build Project-Specific Models
– Example: The book provides a detailed example of a project finance model for a renewable energy project, including debt schedules and equity returns.
– Action: Develop a project finance model for a sector of interest, e.g., real estate, infrastructure. Focus on custom elements like debt structuring and construction periods.

8. Merger and Acquisition Models
M&A models are complex and require integrating multiple company financials, cost synergies, and analysis of accretion/dilution.

Key Action: Create an M&A Model
– Example: Soubeiga showcases a sample M&A model that integrates the financials of two companies, discusses synergies, and performs accretion/dilution analysis.
– Action: Simulate a merger between two hypothetical companies, ensuring to model synergies and perform accretion/dilution calculations.

9. Leveraged Buyout (LBO) Models
Leveraged Buyout models require a deep understanding of debt structuring and projecting the impact of leverage on returns.

Key Action: Develop an LBO Model
– Example: Step-by-step demonstration on building an LBO model, highlighting the layers of debt, equity contribution, and projecting the exit price.
– Action: Build an LBO model for a potential acquisition target, focusing on structuring the debt and calculating the exit IRR.

10. Industry-Specific Models
Soubeiga discusses industry-specific models and their unique requirements, such as banking, real estate, and pharmaceuticals.

Key Action: Tailor Models to Industry
– Example: The book provides examples of models specifically tailored for the banking industry, involving loan loss provisions and interest margins.
– Action: Choose a specific industry and craft a model that includes industry-specific metrics and assumptions, such as occupancy rates for real estate or pipeline valuation for pharmaceuticals.

Conclusion
Key Action: Continuous Learning and Practice
Soubeiga’s comprehensive guide underscores the importance of continual practice and learning to master financial modeling. He encourages readers to practice by evaluating real-world companies and comparing their models to actual financial outcomes.

Final Note:
By following the guidelines, examples, and structured action points provided by Eric Soubeiga in “Mastering Financial Modeling,” professionals can substantially improve their financial modeling capabilities, ensuring their models are accurate, robust, and insightful.