Completing the Projected Income Statement Worksheet

 

 

 

 

The data for the year- to-date section is supplied by the Data entry (D) worksheet and then annualized by the system to estimate year-end results. The Adjusted Business Plan (current year) and the Preliminary Business Plan (planning year) sections are completed by entering data into the Savings Analysis Chart with Forecast and Loans Analysis Chart with Forecast and the Balance Sheet. In addition, data is also directly entered into this statement. Data placed directly into this statement (using gray data entry buttons) includes: 

 

  • The estimated investment yield

  • Other income (Estimated)

  • Operating expenses (Estimated)

  • Provision for loan losses (based on quality of loan portfolio)

  • Non-operating income or loss (if any)

 

Projecting the current year and the planning year operating results are part of the annual budget process.

Please note that interest Income can be entered as dollars or as an average percentage on the In Sheet.