000 07291nam a22005293i 4500
001 EBC1109924
003 MiAaPQ
005 20220119191021.0
006 m o d |
007 cr cnu||||||||
008 211129s2013 xx o ||||0 eng d
020 _a9780749468279
_q(electronic bk.)
020 _z9780749468101
035 _a(MiAaPQ)EBC1109924
035 _a(Au-PeEL)EBL1109924
035 _a(CaPaEBR)ebr10660016
035 _a(CaONFJC)MIL447270
035 _a(OCoLC)828302582
040 _aMiAaPQ
_beng
_erda
_epn
_cMiAaPQ
_dMiAaPQ
050 4 _aHG4026
_b.M3646 2013
082 0 _a658.40352
100 1 _aMarsh, Clive.
_eauthor
245 1 0 _aBusiness and Financial Models /
_c Clive Marsh.
250 _aFirst edition
264 1 _aLondon :
_bKogan Page, Limited,
_c2013.
264 4 _c©2013.
300 _a1 online resource (296 pages)
336 _atext
_btxt
_2rdacontent
337 _acomputer
_bc
_2rdamedia
338 _aonline resource
_bcr
_2rdacarrier
490 1 _aStrategic Success Ser.
505 0 _aIntro -- Contents -- 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 -- 4D™ 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.
505 8 _aSales 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 -- Significance of the cost of capital -- Summary -- 15 BUSINESS VALUATION MODELS -- The value of a business and building value -- Methods of valuing a business -- Who can value a business and what information do they require? -- Examples of valuation methods and their appropriateness to valuation reasons -- Earnings-based valuations -- Cash flow valuation models -- Discounted cash flow (DCF) method of valuation -- Summary -- 16 PERFORMANCE INDICATORS -- Dashboards -- Key performance indicators (KPIs) -- The integrated standard costing system -- Activity-based costing (ABC) -- Summary -- 17 MODELLING THE COMPANY BALANCE SHEET, P&amp -- L AND RATIO ANALYSIS.
505 8 _aPrepare an Excel model -- Analysis and financial ratios -- Ratio analysis -- Summary -- 18 FINANCIAL FUNCTIONS -- Financial formulae and using Excel fx functions -- Excel financial functions -- Summary -- 19 BUILDING A BUSINESS MODEL -- Modelling a start-up business -- Opening balance sheet -- Expected returns for risk - proprietors' pay, bank interest -- Forecast profit and loss statement and sales requirement -- Required marketing and selling activity -- Direct costs required -- Building a model -- Key indicators -- Business plan -- Summary -- 20 MODELLING PROJECTS -- What is a project? -- Critical path analysis (CPA) -- CPA example -- Risk and uncertainty -- Gantt charts and resource planning -- Modelling projects using Excel -- Summary -- 21 INTEGRATION, COMPLEXITY AND BUSINESS MODELS -- The level of integration required -- Data and systems integration -- Cloud computing -- Summary -- 22 BUSINESS MODELS FOR THE GREEN ECONOMY -- Future challenges and opportunities -- Production processes -- Demand for greener products and services -- Investor expectations -- Resourcing -- Effects of climate change and other factors -- Supply chains -- Social responsibility -- Changing models -- Modelling green issues -- Summary -- Appendix 1 Excel shortcut commands -- Appendix 2 Chart for business model build project -- Appendix 3 Discounted cash flow tables -- Index.
520 _aWith 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.
588 _aDescription based on publisher supplied metadata and other sources.
590 _aElectronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2021. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
650 0 _aBusiness enterprises
_967232
_xFinance.
650 0 _aBusiness planning.
655 4 _aElectronic books.
776 0 8 _iPrint version:
_aMarsh, Clive
_tBusiness and Financial Models
_dLondon : Kogan Page, Limited,c2013
_z9780749468101
797 2 _aProQuest (Firm)
830 0 _aStrategic Success Ser.
856 _uhttps://login.ezproxy.pucpr.edu/login?url=https://ebookcentral.proquest.com/lib/pucpr-ebooks/detail.action?docID=1109924
_yAcceso Remoto
856 4 0 _uhttps://ebookcentral.proquest.com/lib/pucpr-ebooks/detail.action?docID=1109924
_yAcceso en el Campus PUCPR
942 _2lcc
_c7
999 _c296901
_d296901