Cargando…
Business and financial models /
Financial modelling is a vital tool for business strategists and decision makers. A good business model should describe how an organization creates and delivers value. A tool for business strategy, it enables a company to experiment with different ideas and scenarios in a safe, low-risk environment,...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
London ; Philadelphia, PA :
Kogan Page,
2013.
|
| Colección: | Strategic success series.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- ACKNOWLEDGEMENT; INTRODUCTION; The purpose of business and financial models; Assumed knowledge; About the author; Online resources; 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; Challenging the traditional business model.
- New methods and approaches
- a business model reflecting the world as it is today Structured Visual Thinking (a trademark of Group Partners): principles for a dynamic world; An architectural approach to building a future; 4DTM 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; 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; Summary; 9 SALES BUDGETS.
- Sales budgets and forecasts are key to other budgets Elements of a sales budget; Volume assumptions; Summary; 10 PRODUCTION
- MATERIAL, LABOUR AND DIRECT OVERHEAD BUDGETs; Production budget; Direct materials budget; Direct labour budget; Direct overhead budget; Gross margin and profit budget; Margin and profit sensitivity; Departmental budget spreadsheet; Summary; 11 FIXED ASSETS AND DEPRECIATION; Accounting depreciation, straight line and reducing balance; Additions and disposals of assets; Tax depreciation (capital allowances in the UK); Summary.
- 12 MANAGING AND MODELLING CASH FLOW AND WORKING Capital the cash flow cycle; Working capital ratio; Optimal stock levels; Debtors; Cash models; Cash budget; Summary; 13 INVESTMENT APPRAISAL MODELS; Relevant cash flow; Pay-back period; Return on capital; Accounting rate of return (ARR); Discounted cash flow and net present value/internal rate of return; Capital rationing; Summary; 14 THE COST OF CAPITAL; The average and the marginal costs of capital; Balancing equity and external borrowing; Risk and the cost of capital; Methods of determining the cost of equity.