Table of Contents

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