A properly structured financial model can provide decision makers with a powerful planning tool that helps them identify the consequences of their decisions before they are put into practice. Introduction to Financial Models for Management and Planning, Second Edition enables professionals and students to learn how to develop and use computer-based models for financial planning. This volume provides critical tools for the financial toolbox, then shows how to use them tools to build successful models.
An Overview of Financial Planning and Modeling. Part I: Tools for Financial Planning and Modeling: Financial Analysis. The Tools for Financial Planning I: Financial Analysis. Appendix A: Using Names in the Excel Spreadsheet. Appendix B: Constructing a Data Table. The Tools for Financial Planning II: Growth and Cash Flows. Part II: Tools for Financial Planning and Modeling: Simulation. Financial Statement Simulation. Monte Carlo Simulation. Part III: Introduction to Forecasting Methods. Forecasting I: Time Trend Extrapolation. Forecasting II: Econometric Forecasting. Forecasting III: Smoothing Data for Forecasts. Part IV: A Closer Look at the Details of a Financial Model. Modeling Value. Modeling Long-Term Assets. Debt Financing. Modeling Working Capital Accounts. PART V: Modeling Security Prices and Investment Portfolios. Modeling Security Prices. Constructing Optimal Security Portfolios. Options. Part VI: Optimization Models. Optimization Models for Financial Planning. Planning and Managing Working Capital with LP. References. Index