Spreadsheet: phillip_allen__28811__Westgate Proforma-Phillip Allen
Sheet: Cash Flow Forecast

 | Microsoft Business Planner
 | Go to Article:
 | Cash Flow Projections
 | Cash Flow Forecast -12 Months
 | This template provides a pro forma cash flow forecast. Enter your figures in the month you realistically expect them to take place. Start by entering the definite amounts first. You can customize the form by changing the row labels or adding rows. To add a row, select one of the rows labeled "Other," click [NAME] on the Excel menu bar, and then click Rows. You will then need to use the fill handle (see [NAME]) to fill in the formula in the "Totals" column. The cells displaying zeros contain formulas to perform automatic calculations on your data. Do not enter data into these cells because doing so will erase the formulas in them.
 | Note: When you save this template as a workbook, note the workbook's file name and location. To edit the workbook next time, you must open it using Excel. Every time you open this template from Microsoft Business Planner, a new workbook is created.
 |  |  |  |  |  |  |  | © Microsoft, 1998.
 | CASH FLOW FORECAST
 | Month: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36
 |  | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00 | 2002-11-01 00:00:00 | 2002-12-01 00:00:00 | 2003-01-01 00:00:00 | 2003-02-01 00:00:00 | 2003-03-01 00:00:00 | 2003-04-01 00:00:00 | 2003-05-01 00:00:00 | 2003-06-01 00:00:00 | 2003-07-01 00:00:00 | 2003-08-01 00:00:00
 | SOURCES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS | PER UNIT | % SALES
 | Sire Plan Design & Approval
 | Pre Sales |  |  |  |  |  |  | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 | Lot Development
 | Construction Starts |  |  |  |  |  |  |  |  | 10 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 | Completions
 | Equity Investment
 | Loan Funds
 | Lot Improvement Loan
 | Unit Construction |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Total Loan Funds
 | Sales Revenue
 | Total Receipts
 | USES
 | Land Cost | 10000 |  | 4000 | 4000 | 4000 | 4000
 | Professional Fees
 | Lot Improvements
 | Unit Construction - Board & Nail
 | Property Tax
 | Sales Cost - Commissions
 | Sales Cost - Closing Costs
 | Loan Cost
 | Loan Interest
 | Loan repayments
 | Imp. [NAME] With Const. Loan
 | Const. Ln. Payoff On Unit Close
 | Equity Repayment
 | Other
 | Total Payments
 | Cashflow Surplus/Deficit (-)
 | Opening Cash Balance | 0
 | Closing Cash Balance
 | Investment Flow
 | Return on Investment | 0 | 0 | 0 | 0 | 0
 | Total
 | Cummulative
 | Internal Rate of Return
 | Cummulative Use of Loan
 | [NAME]
 | Net Loan Uses
 | Interest