YouSigma
Comment On the Article

Email this page

 Submit An Article

Download Excel Template
* Enter Data in Yellow Cells, Dark gray cells will be calculated for you.                                
           
  Rolling Budget and Forecast          
           
           
  Model Key                
  Numbers in black represent budget numbers or actuals for the current or prior year.        
  Numbers in blue represent forecast numbers for the current year.            
  Italicized numbers in gray cells are calculations that generally should not be altered.          
           
           
  Line Item January February March Q1 April May June Q2 July August September Q3 October November December Q4 Annual  
  PROFIT AND LOSS                                    
  Revenue                            
  Budget  
  Actual  
  Budget variance (Actual – Budget)  
  Prior year  
  Prior year variance (Actual – Prior year)  
  Cost of Goods Sold                            
  Budget  
  Actual  
  Budget variance (Budget – Actual)  
  Prior year  
  Prior year variance (Prior year – Actual)  
  Sales and Marketing Costs                            
  Budget  
  Actual  
  Budget variance (Budget – Actual)  
  Prior year  
  Prior year variance (Prior year – Actual)  
  Labor Expense                            
  Budget  
  Actual  
  Budget variance (Budget – Actual)  
  Prior year  
  Prior year variance (Prior year – Actual)  
  General and Administrative                            
  Budget  
  Actual  
  Budget variance (Budget – Actual)  
  Prior year  
  Prior year variance (Prior year – Actual)  
  Operating Income                            
  Budget  
  Actual  
  Budget variance (Actual – Budget)  
  Prior year  
  Prior year variance (Actual – Prior year)  
  BALANCE SHEET                                    
  Cash                            
  Budget  
  Actual  
  Budget variance (Actual – Budget)  
  Prior year  
  Prior year variance (Actual – Prior year)  
  Inventory                            
  Budget  
  Actual  
  Budget variance (Actual – Budget)  
  Prior year  
  Prior year variance (Actual – Prior year)  
  Accounts Receivable                            
  Budget  
  Actual  
  Budget variance (Actual – Budget)  
  Prior year  
  Prior year variance (Actual – Prior year)  
  Net Fixed Assets                            
  Budget  
  Actual  
  Budget variance (Actual – Budget)  
  Prior year  
  Prior year variance (Actual – Prior year)  
  Accounts Payable                            
  Budget  
  Actual  
  Budget variance (Actual – Budget)  
  Prior year  
  Prior year variance (Actual – Prior year)  
  Long-Term Debt                            
  Budget  
  Actual  
  Budget variance (Actual – Budget)  
  Prior year  
  Prior year variance (Actual – Prior year)  
             

underline
Arts & Humanities (90+) Business & Economy (3250+) Computers & Internet (30+) Entertainment (80+)
Health (300+) Kids & Teens (250+) Regional (600+) Society & Culture (2000+)
General Knowledge (70+)
underline
About YouSigma Copyright and Disclaimer Submit Your Article Please Submit Your Feedback
Email this page