000 08253cam a2200841 i 4500
001 ocn893974584
003 OCoLC
005 20171026094243.0
006 m o d
007 cr |||||||||||
008 141027s2015 enk ob 001 0 eng
010 _a 2014042475
020 _a9781118921098
_q(epub)
020 _a1118921097
_q(epub)
020 _a9781118921104
_q(pdf)
020 _a1118921100
_q(pdf)
020 _a9781118921111
020 _a1118921119
020 _z9781118921081
_q(cloth)
020 _a1118921089
020 _a9781118921081
029 1 _aCHBIS
_b010442367
029 1 _aCHVBK
_b334092205
029 1 _aDEBBG
_bBV042739950
029 1 _aDEBSZ
_b431873968
029 1 _aNZ1
_b15914909
029 1 _aDEBSZ
_b44947707X
029 1 _aNZ1
_b16231895
029 1 _aDEBBG
_bBV043615961
029 1 _aDEBBG
_bBV043397236
035 _a(OCoLC)893974584
_z(OCoLC)905230295
_z(OCoLC)961649900
_z(OCoLC)962679613
037 _a8EFBDEF1-D12C-42EE-BFE8-C91D39075161
_bOverDrive, Inc.
_nhttp://www.overdrive.com
040 _aDLC
_beng
_erda
_epn
_cDLC
_dYDX
_dN$T
_dEBLCP
_dYDXCP
_dTEFOD
_dDG1
_dOCLCF
_dRECBK
_dCDX
_dRRP
_dDEBSZ
_dUMI
_dOCLCO
_dOCLCQ
_dOCLCO
_dTEFOD
_dCOO
_dOCLCO
_dB24X7
_dSTF
_dFUG
_dOCLCO
_dDEBBG
_dD6H
_dEZ9
_dOCLCO
042 _apcc
049 _aMAIN
050 0 0 _aHG4012
072 7 _aBUS
_x082000
_2bisacsh
072 7 _aBUS
_x041000
_2bisacsh
072 7 _aBUS
_x042000
_2bisacsh
072 7 _aBUS
_x085000
_2bisacsh
082 0 0 _a658.1501/12
_223
100 1 _aSamonas, Michael.
245 1 0 _aFinancial forecasting, analysis, and modelling : a framework for long-term forecasting /
_cMichael Samonas.
_h[electronic resource]
264 1 _aChichester, West Sussex, United Kingdom :
_bJohn Wiley & Sons,
_c2015.
300 _a1 online resource.
336 _atext
_btxt
_2rdacontent
337 _acomputer
_bc
_2rdamedia
338 _aonline resource
_bcr
_2rdacarrier
490 1 _aWiley Finance series
504 _aIncludes bibliographical references and index.
505 0 _apt. ONE Developing Corporate Finance Models -- ch. 1 Introduction -- 1.1. What is Financial Modelling? -- 1.2. Defining the Inputs and the Outputs of a Simple Financial Model -- 1.3. The Financial Modelling Process of More Complex Models -- 1.3.1. Step 1: Defining the Problem the Model Will Solve: The Fundamental Business Question -- 1.3.2. Step 2: Specification of the Model -- 1.3.3. Step 3: Designing and Building the Model -- 1.3.4. Step 4: Checking the Model's Output -- 1.4. Excel as a Tool of Modelling: Capabilities and Limitations -- ch. 2 A Short Primer in the Accounting of Financial Statements -- 2.1. The Accounting Equation -- 2.2. The Balance Sheet -- 2.3. The Income Statement -- 2.3.1. Cash Accounting Versus Accrual Accounting -- 2.4. The Cash Flow Statement -- 2.4.1. Operating Activities -- 2.4.2. Investing Activities -- 2.4.3. Financing Activities -- 2.4.4. Income Flows and Cash Flows -- 2.4.5. Preparing the Statement of Cash Flows.
505 8 _a2.5. The Articulation of Income Statement, Balance Sheet, and Cash Flow Statements -- 2.6. Financial Statement Analysis: Ratio Analysis -- 2.6.1. Profitability Ratios -- 2.6.2. Liquidity Ratios -- 2.6.3. Solvency Ratios -- 2.6.4. Other Ratios -- 2.6.5. The Limitations of Financial Ratios -- ch. 3 Financial Statement Modelling -- 3.1. Introduction -- How Financial Models Work -- 3.2. Collecting and Analyzing Historical Data -- 3.3. Selecting the Key Forecast Drivers -- 3.4. Modelling the Income Statement -- 3.5. Modelling the Balance Sheet -- 3.6. Modelling Interest and Circular References -- 3.7. Modelling the Cash Flow Statement -- ch. 4 Forecasting Performance -- 4.1. Introduction: Designing a Dashboard-like Control Panel -- 4.2. Basic Statistical Methods Used for Forecasting -- 4.3. Forecasting Sales -- 4.3.1. Bottom-up Versus Top-down Forecasting -- 4.3.2. Forecasting Sales of Existing Products or Services -- 4.4. Forecasting Costs.
505 8 _a4.5. Forecasting CAPEX and Depreciation -- 4.5.1. Forecasting CAPEX and Depreciation for Existing Companies -- 4.6. Forecasting Working Capital and Funding Needs -- 4.6.1. Forecasting Funding Needs -- ch. 5 Business Valuation -- 5.1. Valuation Approaches -- 5.2. Steps for Applying the DCF Method -- 5.3. Rewriting Financial Statements -- Calculation of Free Cash Flows -- 5.4. Calculating the Weighted Average Cost of Capital -- 5.4.1. Calculating the Weighted Average Cost of Capital of SteelCo -- 5.5. Estimating the Terminal Value -- 5.6. DCF Summary -- Enterprise Value Adjustments -- pt. TWO Planning for Uncertainty -- ch. 6 Using Sensitivity Analysis -- 6.1. Introduction -- 6.2. One-Dimensional and 2-Dimensional Sensitivity Analysis -- 6.3. Choosing the Variables to Change -- 6.4. Modelling Example -- 6.4.1. Selecting the Variables to Change -- 6.4.2. Assigning a Range of Values -- 6.4.3. Constructing the 2-dimensional Sensitivity Analysis Table.
505 8 _a6.4.4. Interpreting the Results -- ch. 7 Using Scenarios -- 7.1. Introduction -- 7.2. Using Scenario Analysis with Excel's Scenario Manager -- 7.2.1. Adding 2 More Scenarios -- 7.3. Alternative Ways to Create Scenarios in Excel -- 7.4. Applying Scenarios to SteelCo's Case -- 7.4.1. Deciding on the Number of Scenarios and Input Variables under each Scenario -- 7.4.2. Deciding on the Output Variables -- 7.4.3. Assigning Values to the Input Variables under Each Scenario -- 7.4.4. Building the Scenarios in Excel's Scenario Manager -- 7.4.5. Interpreting the Results -- ch. 8 Using Monte Carlo Simulation -- 8.1. Introduction -- 8.2. Building Uncertainty Directly Into the Modelling Process -- 8.3. Probabilities, Cumulative Probabilities, and Frequency Distribution Charts -- 8.4. Modelling Example -- 8.4.1. Identifying the Key Risk Variables -- 8.4.2. Choosing a Probability Distribution for Each Input Variable -- 8.4.3. Performing the Simulation Runs.
505 8 _a8.4.3.1. The Simple VBA CODE -- 8.4.4. Creating a Histogram (Frequency Distribution Chart) in Excel -- 8.4.5. Interpreting the Results -- 8.4.6. Some Issues of Concern -- Appendix -- 1. Walking through the Excel Model Provided with the Book (SteelCo SA. 4yr Business Plan) -- Introduction -- Structure of the Model -- 2. Other Excel Files Provided with the Book.
520 _aThis book 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, it guides readers 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. You will 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. --
_cEdited summary from book.
588 0 _aPrint version record and CIP data provided by publisher.
650 0 _aCorporations
_xFinance
_xMathematical models.
650 0 _aCorporations
_xFinance
_xForecasting.
650 7 _aBUSINESS & ECONOMICS
_xIndustrial Management.
_2bisacsh
650 7 _aBUSINESS & ECONOMICS
_xManagement.
_2bisacsh
650 7 _aBUSINESS & ECONOMICS
_xManagement Science.
_2bisacsh
650 7 _aBUSINESS & ECONOMICS
_xOrganizational Behavior.
_2bisacsh
650 7 _aCorporations
_xFinance
_xForecasting.
_2fast
_0(OCoLC)fst00879851
650 7 _aCorporations
_xFinance
_xMathematical models.
_2fast
_0(OCoLC)fst00879860
655 4 _aElectronic books.
655 0 _aElectronic books.
655 7 _aElectronic books.
_2local
776 0 8 _iPrint version:
_aSamonas, Michael.
_tFinancial forecasting, analysis, and modelling.
_dChichester, West Sussex, United Kingdom : John Wiley & Sons, 2015
_z9781118921081
_w(DLC) 2014040071
830 0 _aWiley finance series.
856 4 0 _uhttp://onlinelibrary.wiley.com/book/10.1002/9781118921111
_zWiley Online Library
942 _2ddc
_cBK
999 _c207729
_d207729