Roll Forward Steps & Comparative Projections  
 
Do
Do
 
Go
Go
 
  Step 1 Before roll forward, save this file & then Step 4 Update opening balance sheet  
     resave it with a new name e.g. mm-yy.xls      
  Step 2 Roll forward projections   Step 5 Phase out balance sheet items  
           
  Step 3 Update opening inventory of materials
Go*
Step 5 Review assumptions especially
Go
 
          or goods for resale *           those for the new 12th month  
         
    * If applicable to your type of business  
Help with Roll Forward
 
       
       
 
 
  Key Pre- and Post- Roll Forward Projections for 12 Months  
 
        Values immediately   Latest values   Changes  
        before latest   since last   ( ) signifies  
        roll forward   roll forward   deterioration  
        $000   $000   $000  
  Peak cash surplus 677.2 0.0  (677.2)  
  Peak cash deficit (210.2) (47.0) 163.2  
  Net cashflow   750.8   (16.1)   (766.9)  
  Net cash surplus (deficit):    
      - Opening (110.0) (22.0) 88.0  
      - Closing   640.8   (38.1)   (678.9)