{"product_id":"financial-forecasting-analysis-and-modelling-isbn-9781118921081","title":"Financial Forecasting, Analysis, and Modelling","description":"\u003cb\u003eRisk analysis has become critical to modern financial planning\u003c\/b\u003e  \u003cp\u003e\u003ci\u003eFinancial Forecasting, Analysis and Modelling\u003c\/i\u003e provides a complete framework of long-term financial forecasts in a practical and accessible way, helping finance professionals include uncertainty in their planning and budgeting process. With thorough coverage of financial statement simulation models and clear, concise implementation instruction, this book guides readers step-by-step through the entire projection plan development process. Readers learn the tools, techniques, and special considerations that increase accuracy and smooth the workflow, and develop a more robust analysis process that improves financial strategy. The companion website provides a complete operational model that can be customised to develop financial projections or a range of other key financial measures, giving readers an immediately-applicable tool to facilitate effective decision-making.\u003c\/p\u003e \u003cp\u003eIn the aftermath of the recent financial crisis, the need for experienced financial modelling professionals has steadily increased as organisations rush to adjust to economic volatility and uncertainty. This book provides the deeper level of understanding needed to develop stronger financial planning, with techniques tailored to real-life situations.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eDevelop long-term projection plans using Excel\u003c\/li\u003e \u003cli\u003eUse appropriate models to develop a more proactive strategy\u003c\/li\u003e \u003cli\u003eApply risk and uncertainty projections more accurately\u003c\/li\u003e \u003cli\u003eMaster the Excel Scenario Manager, Sensitivity Analysis, Monte Carlo Simulation, and more\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eRisk plays a larger role in financial planning than ever before, and possible outcomes must be measured before decisions are made. Uncertainty has become a critical component in financial planning, and accuracy demands it be used appropriately. With special focus on uncertainty in modelling and planning, \u003ci\u003eFinancial Forecasting, Analysis and Modelling\u003c\/i\u003e is a comprehensive guide to the mechanics of modern finance.\u003c\/p\u003e \u003cp\u003ePreface xi\u003c\/p\u003e \u003cp\u003eAcknowledgments xiii\u003c\/p\u003e \u003cp\u003eAbout the Author xv\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart one Developing Corporate Finance Models 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1 Introduction 3\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e1.1 What is Financial Modelling? 3\u003c\/p\u003e \u003cp\u003e1.2 Defining the Inputs and the Outputs of a Simple Financial Model 6\u003c\/p\u003e \u003cp\u003e1.3 The Financial Modelling Process of More Complex Models 9\u003c\/p\u003e \u003cp\u003e1.3.1 Step 1: Defining the Problem the Model Will Solve: The Fundamental Business Question 9\u003c\/p\u003e \u003cp\u003e1.3.2 Step 2: Specification of the Model 10\u003c\/p\u003e \u003cp\u003e1.3.3 Step 3: Designing and Building the Model 11\u003c\/p\u003e \u003cp\u003e1.3.4 Step 4: Checking the Model’s Output 13\u003c\/p\u003e \u003cp\u003e1.4 Excel as a Tool of Modelling: Capabilities and Limitations 13\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 A Short Primer in the Accounting of Financial Statements 17\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e2.1 The Accounting Equation 17\u003c\/p\u003e \u003cp\u003e2.2 The Balance Sheet 20\u003c\/p\u003e \u003cp\u003e2.3 The Income Statement 23\u003c\/p\u003e \u003cp\u003e2.3.1 Cash Accounting Versus Accrual Accounting 26\u003c\/p\u003e \u003cp\u003e2.4 The Cash Flow Statement 26\u003c\/p\u003e \u003cp\u003e2.4.1 Operating Activities 27\u003c\/p\u003e \u003cp\u003e2.4.2 Investing Activities 27\u003c\/p\u003e \u003cp\u003e2.4.3 Financing Activities 27\u003c\/p\u003e \u003cp\u003e2.4.4 Income Flows and Cash Flows 27\u003c\/p\u003e \u003cp\u003e2.4.5 Preparing the Statement of Cash Flows 28\u003c\/p\u003e \u003cp\u003e2.5 The Articulation of Income Statement, Balance Sheet, and Cash Flow Statements 29\u003c\/p\u003e \u003cp\u003e2.6 Financial Statement Analysis: Ratio Analysis 32\u003c\/p\u003e \u003cp\u003e2.6.1 Profitability Ratios 35\u003c\/p\u003e \u003cp\u003e2.6.2 Liquidity Ratios 37\u003c\/p\u003e \u003cp\u003e2.6.3 Solvency Ratios 38\u003c\/p\u003e \u003cp\u003e2.6.4 Other Ratios 39\u003c\/p\u003e \u003cp\u003e2.6.5 The Limitations of Financial Ratios 40\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 Financial Statement Modelling 43\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e3.1 Introduction – How Financial Models Work 43\u003c\/p\u003e \u003cp\u003e3.2 Collecting and Analyzing Historical Data 47\u003c\/p\u003e \u003cp\u003e3.3 Selecting the Key Forecast Drivers 53\u003c\/p\u003e \u003cp\u003e3.4 Modelling the Income Statement 59\u003c\/p\u003e \u003cp\u003e3.5 Modelling the Balance Sheet 63\u003c\/p\u003e \u003cp\u003e3.6 Modelling Interest and Circular References 66\u003c\/p\u003e \u003cp\u003e3.7 Modelling the Cash Flow Statement 69\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 Forecasting Performance 75\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e4.1 Introduction: Designing a Dashboard-like Control Panel 75\u003c\/p\u003e \u003cp\u003e4.2 Basic Statistical Methods Used for Forecasting 88\u003c\/p\u003e \u003cp\u003e4.3 Forecasting Sales 93\u003c\/p\u003e \u003cp\u003e4.3.1 Bottom-up Versus Top-down Forecasting 97\u003c\/p\u003e \u003cp\u003e4.3.2 Forecasting Sales of Existing Products or Services 97\u003c\/p\u003e \u003cp\u003e4.4 Forecasting Costs 99\u003c\/p\u003e \u003cp\u003e4.5 Forecasting CAPEX and Depreciation 103\u003c\/p\u003e \u003cp\u003e4.5.1 Forecasting CAPEX and Depreciation for Existing Companies 108\u003c\/p\u003e \u003cp\u003e4.6 Forecasting Working Capital and Funding Needs 110\u003c\/p\u003e \u003cp\u003e4.6.1 Forecasting Funding Needs 113\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 Business Valuation 115\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e5.1 Valuation Approaches 115\u003c\/p\u003e \u003cp\u003e5.2 Steps for Applying the DCF Method 120\u003c\/p\u003e \u003cp\u003e5.3 Rewriting Financial Statements – Calculation of Free Cash Flows 121\u003c\/p\u003e \u003cp\u003e5.4 Calculating the Weighted Average Cost of Capital 124\u003c\/p\u003e \u003cp\u003e5.4.1 Calculating the Weighted Average Cost of Capital of SteelCo 128\u003c\/p\u003e \u003cp\u003e5.5 Estimating the Terminal Value 131\u003c\/p\u003e \u003cp\u003e5.6 DCF Summary – Enterprise Value Adjustments 132\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart two Planning for Uncertainty 137\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 Using Sensitivity Analysis 139\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e6.1 Introduction 139\u003c\/p\u003e \u003cp\u003e6.2 One-Dimensional and 2-Dimensional Sensitivity Analysis 140\u003c\/p\u003e \u003cp\u003e6.3 Choosing the Variables to Change 145\u003c\/p\u003e \u003cp\u003e6.4 Modelling Example 149\u003c\/p\u003e \u003cp\u003e6.4.1 Selecting the Variables to Change 149\u003c\/p\u003e \u003cp\u003e6.4.2 Assigning a Range of Values 149\u003c\/p\u003e \u003cp\u003e6.4.3 Constructing the 2-dimensional Sensitivity Analysis Table 151\u003c\/p\u003e \u003cp\u003e6.4.4 Interpreting the Results 153\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 Using Scenarios 157\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e7.1 Introduction 157\u003c\/p\u003e \u003cp\u003e7.2 Using Scenario Analysis with Excel’s Scenario Manager 158\u003c\/p\u003e \u003cp\u003e7.2.1 Adding 2 More Scenarios 159\u003c\/p\u003e \u003cp\u003e7.3 Alternative Ways to Create Scenarios in Excel 163\u003c\/p\u003e \u003cp\u003e7.4 Applying Scenarios to SteelCo’s Case 167\u003c\/p\u003e \u003cp\u003e7.4.1 Deciding on the Number of Scenarios and Input Variables under each Scenario 167\u003c\/p\u003e \u003cp\u003e7.4.2 Deciding on the Output Variables 168\u003c\/p\u003e \u003cp\u003e7.4.3 Assigning Values to the Input Variables under Each Scenario 170\u003c\/p\u003e \u003cp\u003e7.4.4 Building the Scenarios in Excel’s Scenario Manager 173\u003c\/p\u003e \u003cp\u003e7.4.5 Interpreting the Results 176\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 Using Monte Carlo Simulation 179\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e8.1 Introduction 179\u003c\/p\u003e \u003cp\u003e8.2 Building Uncertainty Directly Into the Modelling Process 180\u003c\/p\u003e \u003cp\u003e8.3 Probabilities, Cumulative Probabilities, and Frequency Distribution Charts 182\u003c\/p\u003e \u003cp\u003e8.4 Modelling Example 187\u003c\/p\u003e \u003cp\u003e8.4.1 Identifying the Key Risk Variables 188\u003c\/p\u003e \u003cp\u003e8.4.2 Choosing a Probability Distribution for Each Input Variable 188\u003c\/p\u003e \u003cp\u003e8.4.3 Performing the Simulation Runs 190\u003c\/p\u003e \u003cp\u003e8.4.3.1 The Simple VBA CODE 192\u003c\/p\u003e \u003cp\u003e8.4.4 Creating a Histogram (Frequency Distribution Chart) in Excel 195\u003c\/p\u003e \u003cp\u003e8.4.5 Interpreting the Results 200\u003c\/p\u003e \u003cp\u003e8.4.6 Some Issues of Concern 201\u003c\/p\u003e \u003cp\u003e\u003cb\u003eAppendix 203\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e1. Walking through the Excel Model Provided with the Book (SteelCo SA 4yr Business Plan) 203\u003c\/p\u003e \u003cp\u003eIntroduction 203\u003c\/p\u003e \u003cp\u003eStructure of the Model 204\u003c\/p\u003e \u003cp\u003e2. Other Excel Files Provided with the Book 205\u003c\/p\u003e \u003cp\u003eIndex 207\u003c\/p\u003e  \u003cp\u003e\u003cb\u003eMICHAEL SAMONAS\u003c\/b\u003e is a finance professional with extensive experience in Financial Planning, Analysis and Modelling. He is currently the Group CFO of SIDMA S.A, a member of Viohalco Group of companies. He has worked in the past for various multinationals including Vodafone S.A. and Hellenic Telecommunications Organization conducting a range of models for business planning, valuations, mergers, projects and data analysis. For a number of years Michael was instructor at the School of Business \u0026amp; Economics of the University of Laverne, Athens Campus.\u003c\/p\u003e  \u003cp\u003eIn today's uncertain economy, companies need to evaluate their level of risk by making informed decisions by using proper financial models that incorporate the possibilities of alternative outcomes.\u003c\/p\u003e \u003cp\u003e\u003ci\u003eFinancial Forecasting, Analysis, and Modelling\u003c\/i\u003e provides a complete framework for creating reliable long-term financial forecasts that is written in practical and accessible terms. The book includes thorough coverage of financial statement simulation models and clear, concise implementation instruction that gives finance professionals a step-by-step guide through the projection plan development process.\u003c\/p\u003e \u003cp\u003eThis comprehensive resource offers a wealth of tools, techniques, and strategies that are designed to increase accuracy and make the workflow process easier whilst helping to develop a more robust analysis process that improves financial strategy. The book's companion website (www.wiley.com\/go\/Samonas) includes an operational model that can be tailored to develop financial projections or a number of other important financial measures. The website is a key resource for helping professionals make immediate and effective decisions.\u003c\/p\u003e \u003cp\u003eAs the author explains, risk is playing a more central role in financial planning than ever before, and possible outcomes must be measured before decisions are made. Uncertainty has become a critical component in financial planning, and accuracy demands it be used appropriately. With special focus on uncertainty in modelling and planning, \u003ci\u003eFinancial Forecasting, Analysis, and Modelling\u003c\/i\u003e is a comprehensive guide to the fundamentals of modern finance.\u003c\/p\u003e \u003cp\u003e\u003ci\u003eFinancial Forecasting, Analysis, and Modelling\u003c\/i\u003e gives financial modelers, financial planning \u0026amp; analysis managers, credit officers to business owners and entrepreneurs a vital resource for meeting the challenges of today's volatile economy.\u003c\/p\u003e  \u003cp\u003e\u003cb\u003ePraise for Financial Forecasting, Analysis, and Modelling\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\"Modeling is one of the tools that you need in your tool kit to do valuation, and this book will help you get more facile with that tool\".\u003cbr\u003e \u003cb\u003e—Aswath Damodaran,\u003c\/b\u003e Professor of Finance at the Stern School of Business at New York University (Kerschner Family Chair in Finance Education)\u003c\/p\u003e \u003cp\u003e\"An excellent and unique piece of work clearly done by someone who does not only have a deep sectoral but also a comprehensive knowledge of the subject\".\u003cbr\u003e \u003cb\u003e—Marios T. Kyriacou,\u003c\/b\u003e Senior Partner of KPMG\u003c\/p\u003e \u003cp\u003e\"This book is an excellent guide to financial forecasting, analysis and modelling, covering key areas well and providing thoroughly worked examples that are clear and helpful. I consider this being a most useful book for the novice and the professional alike\".\u003cbr\u003e \u003cb\u003e—Vassili Christidis,\u003c\/b\u003e CEO, Euler Hermes Hellas\u003c\/p\u003e \u003cp\u003e\"This book builds around a full-length case study of a real world company and walks readers through all the steps of developing a sophisticated financial model which includes business valuation and applied Monte Carlo analysis. The author is clearly intimately familiar with financial modelling, a craft that is nowadays a prerequisite for the finance practitioner\".\u003cbr\u003e \u003cb\u003e—Daniel Benardout,\u003c\/b\u003e Member of the Board of Governors of Technion Israel Institute of Technology\u003c\/p\u003e \u003cp\u003e\"\u003ci\u003eFinancial Forecasting, Analysis, and Modelling\u003c\/i\u003e is packed with invaluable material for anyone looking to plan effectively for the future of a business. The author provides incisive analysis of financial modeling tips, techniques and templates in Excel for analyzing a company's current financial performance as well as forecasting its future one. Everyone interested in the application of financial forecasting and modeling – whether student or seasoned businessman – would profit from reading this book.\"\u003cbr\u003e \u003cb\u003e—Alex Ypsilanti,\u003c\/b\u003e CEO and Co-Founder of Quantifeed, Hong Kong (previously served as Managing Director and research analyst in equity derivatives and quantitative investment strategies with Morgan Stanley and Merrill Lynch)\u003c\/p\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989210022117,"sku":"NP9781118921081","price":105.0,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781118921081.jpg?v=1761783219","url":"https:\/\/k12savings.com\/products\/financial-forecasting-analysis-and-modelling-isbn-9781118921081","provider":"K12savings","version":"1.0","type":"link"}