Read more
Informationen zum Autor Clive Marsh is a Chartered Banker, Fellow of the Chartered Institute of Bankers in Scotland, Associate Chartered Accountant (NZ) and Fellow of the Chartered Management Institute.His past experience includes key roles as Head of Finance & MIS, Director of Commercial Services, Director of Business Development, Divisional Manager of Corporate Services and Group Taxation and Statutory Accountant. Clive Marsh has worked for Shell UK, Shell NZ, Mobil, NatWest UK, NatWest NZ, DataBank (BNZ), A&L Girobank, IBM UK, Cap Gemini Ernst & Young, Link ICA, Sussex Coast College, EUK (Credit Agricole) and a number of niche strategy consulting firms. He now works as a coach and author with financial management skills as his main speciality. Klappentext A good business model should describe how an organization creates and delivers value, meaning that financial modelling is a vital tool for business strategy, allowing hypotheses and scenarios to be translated into numbers. It enables a company to experiment with different ideas and scenarios in a safe, low-risk environment, to consider what it is aiming to achieve, and to prioritize accordingly. Business and Financial Models provides an accessible introduction to these essential strategic practices, with guidance on using Microsoft Excel for projection and analysis. The book takes you through the process of building your model from the initial phase of formulating questions through modelling cash flow, budgets, investment appraisal and 'dashboard' tools for monitoring performance. Ideal for both small and large companies, Business and Financial Models also includes coverage of new visual thinking techniques, like Structured Visual Thinking, and how these can be incorporated into conventional business modelling. Online supporting resources for this book include downloadable figures from the book.Online Resources: downloadable figures from the book Zusammenfassung With worked examples throughout and a range of online templates, Business and Financial Models explains the essential basics of planning, building and using business and financial models. Inhaltsverzeichnis Introduction 1 Stages in the development of a business and financial model Scope The fundamental question A step-by-step approach Skills required Planning the model Data quality Tools Summary 2 Developing the research question and output definition The basic question Output definitions, examples, financial outputs Summary 3 Visual thinking to develop fundamental questions - contributed by John Caswell and Sarah Gall Challenging the traditional business model New methods and approaches -- a business model reflecting the world as it is today Structured Visual Thinking (a trade mark of Group Partners) principles for a dynamic world An architectural approach to building a future 4D (trade mark of Group Partners) approach Summary 4 Input definition Basics of input definition Important variables Summary 5 Scenario identification Determining scenarios Populating the spreadsheet with input values and formulae Running different scenarios Using Excel Scenario Manager for what-if analysis Scenarios versus projections Summary 6 Building a simple model Process Example Data extraction using Excel pivot tables Some reminders of best practice Reasons for failure of a model and how to avoid them Summary 7 Using charts Excel charts Example Using charts to help concentrate on the most important variables in an organization Charts for break-even analysis Chart tools Presenting data and charts to communicate clearly Using Excel pivot charts to show extracted data Summary 8 Modelling budgets Planning and budgeting Departmental budgets and variance analysis Some key departmental budgets Capital budgets ...
