This spreadsheet offers a format for preparing pro-forma projections that organizes the presentation in categories that communicates key information to investors.  Then the bottom line of the projections worksheet feeds a discounted cash flow model with all the calculations and formulas in place.  A chart showing appropriate discount rate ranges is included with the DCF model.