Financial Forecasting in Microsoft Excel

by Jeffrey Kenneth Prager

Overview

4 out of 5 businesses fail due to cash problems – needlessly. Every business owner has the tools to accurately forecast cash flow, they just don’t know it. Financial Forecasting in Microsoft® Excel shows small- to medium-sized businesses how to achieve the same forecasting power as larger companies. Filled with a wealth of illustrations and how-to templates, the book is written to help you make better, more educated decisions that result in more stable, enduring companies. Author Jeff Prager shows you how to use Excel to run “if/then” scenarios, calculate cash flow projections, structure partnerships and financing, and test how changes in the market or pricing will affect the bottom line. Financial Forecasting in Microsoft Excel provides step-by-step instructions for creating financial forecasts with Microsoft Excel 2010 so you can: Assess project feasibility Fund company cash needs Determine financial feasibility of a project before committing Identify problems before they become major By following the guidelines presented in this book, you will give a potential funding source the necessary information to make an investment decision. And when they see the information they want to see, you’ll hear the words you want to hear: “Here’s your check.” “Forecasts must be meaningful and explainable. Jeff Prager's financial mastery has allowed my companies to make profitable decisions, change course when necessary and maintain relevance in our industry for more than 20 years.” —Joel Farkas, Principal Gateway American Resources Denver, CO

Product Details

ISBN-13:	9780867187335
Publisher:	National Association of Home Builders
Publication date:	02/01/2015
Edition description:	None
Pages:	220
Product dimensions:	7.00(w) x 10.00(h) x 0.50(d)

About the Author

Jeffrey Kenneth Prager is the founder of Backroom Management Services, a construction software publisher and accounting firm. He has been a CPA, business owner and entrepreneur for over 35 years. Jeff has built multi-million dollar companies abd helped companies raise over $1 billion.

Table of Contents

List of Figures and Tables vii

About the Author xiii

Preface xv

Acknowledgments xix

Introduction 1

1 Creating a Simple Spreadsheet 5

2 More Power with Functions and Formulas 17

3 Format of a Cash Flow Forecast 27

4 Your Sales Forecast 35

5 Scheduling Your Production Costs 41

6 Budgeting Overhead Costs 55

7 Deposits, Loans, Accounts Receivable 59

8 Expenditures Not on Your Income Statement 69

9 Equity Needs 75

10 Creating Financial Statements 81

11 Structuring a Deal 113

12 Sensitivity Analysis 133

13 The Complete Construction Projection 139

14 Working with Debt 157

15 Advanced Concepts 169

16 Final Thoughts Related to Forecasts 189

Glossary 193

Index 197