Financial forecasting in Microsoft Excel

List of Figures and Tables

About the Author

Preface

Acknowledgments

Introduction

1. Creating a Simple Spreadsheet

2. More Power with Functions and Formulas

3. Format of a Cash Flow Forecast

4. Your Sales Forecast

5. Scheduling Your Production Costs

6. Budgeting Overhead Costs

7. Deposits, Loans, Accounts Receivable

8. Expenditures Not on Your Income Statement

9. Equity Needs

10. Creating Financial Statements

11. Structuring a Deal

12. Sensitivity Analysis

13. The Complete Construction Projection

14. Working with Debt

15. Advanced Concepts

16. Final Thoughts Related to Forecasts

Glossary

Index