This book is about managing the task of forecasting profit. It builds a case for using multiple methods, providing examples of each method, and suggesting practical techniques to use in dealing with the issues and problems of accuracy in profit forecasts. All the elements that infringe on profits (costs, sales, budgeting, investment, and loan default) are examined within this framework. In addition to synthesizing the research, Professor Metcalfe has applied his own research work on forecast modeling and judgmental methods. The final result is a practical reference book for making more accurate profit forecasts.
In the first book to look from a thoroughly practical perspective on the crucial business of profits forecasting, Fred Wellings provides an integrated approach to the theories which underpin the forecasting process. This approach also recognises the limitations faced by the outsider in the real world where both time and hard facts may be in equally short supply. It lays emphasis on the patterns of industrial and corporate behaviour and the forecaster's ability to recognise and anticipate these patterns. The first part of the book covers the industrial background within which the individual companies operate, and part two moves the forecaster on from the industry to the company.
Go beyond technique to master the difficult judgement calls of forecasting A variety of software can be used effectively to achieve accurate forecasting, but no software can replace the essential human component. You may be new to forecasting, or you may have mastered the statistical theory behind the software’s predictions, and even more advanced “power user” techniques for the software itself—but your forecasts will never reach peak accuracy unless you master the complex judgement calls that the software cannot make. Profit From Your Forecasting Software addresses the issues that arise regularly, and shows you how to make the correct decisions to get the most out of your software. Taking a non-mathematical approach to the various forecasting models, the discussion covers common everyday decisions such as model choice, forecast adjustment, product hierarchies, safety stock levels, model fit, testing, and much more. Clear explanations help you better understand seasonal indices, smoothing coefficients, mean absolute percentage error, and r-squared, and an exploration of psychological biases provides insight into the decision to override the software’s forecast. With a focus on choice, interpretation, and judgement, this book goes beyond the technical manuals to help you truly grasp the more intangible skills that lead to better accuracy. Explore the advantages and disadvantages of alternative forecasting methods in different situations Master the interpretation and evaluation of your software’s output Learn the subconscious biases that could affect your judgement toward intervention Find expert guidance on testing, planning, and configuration to help you get the most out of your software Relevant to sales forecasters, demand planners, and analysts across industries, Profit From Your Forecasting Software is the much sought-after “missing piece” in forecasting reference.
“The trend is your friend”is a practical principle often used by business managers, who seek to forecast future sales, expenditures, and profitability in order to make production and other operational decisions. The problem is how best to identify and discover business trends and utilize trend information for attaining objectives of firms.This book contains an Excel-based solution to this problem, applying principles of the authors’ “profit system model” of the firm that enables forecasts of trends in sales, expenditures, profits and other business variables. The program, called FIRM, which runs on Windows with Microsoft Excel 2010, useshistorical time series of total sales, total costs, and total assets of the firm from its financial statements (income statements and balance sheets), estimates relationships among these variables, and then employs the estimated relationships to forecasts trends in these vital business variables. Featuring step-by-step case examples, the goal is to equip business managers and students with easy-to-use tools for understanding and forecasting trends in important business variables, thereby empowering them to make better business decisions.
Risk analysis has become critical to modern financial planning Financial Forecasting, Analysis and Modelling 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. In 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. Develop long-term projection plans using Excel Use appropriate models to develop a more proactive strategy Apply risk and uncertainty projections more accurately Master the Excel Scenario Manager, Sensitivity Analysis, Monte Carlo Simulation, and more Risk 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, Financial Forecasting, Analysis and Modelling is a comprehensive guide to the mechanics of modern finance.
This title was first published in 2001. Forecasting is an essential discipline in the planning and running of a business: not only for the business plan and annual budget but for the appraisal of investment projects, the commissioning of research as well as the appraisal of the competition and the feasibility of making acquisitions. Managers are continually confronted with the need to take decisions, and being able to construct a route map of the future is a key way of determining a course of action. This book offers a practical guide to forecasting the environment in which a firm operates. The author goes through the key areas which can affect a business. He includes those which are out of the firm's control such as fiscal and monetary policy, population levels and the labour market; and those that are, such as costs, prices, profits and product development.
