Five Year Planning Sheet Issues

1.      I want to use my 2006 Year End data as a basis for my Five Year projections in the Five Year planning sheets (reddish tabs).  How do I do this?

On the Five Year sheets, in the top right hand corner of the sheet, to the left of the Column Options button, there is a button that determines what data your projections are based on.  You can toggle the button to choose options like "2005 Year End," or "2006 YTD Balances" as the data basis for your five year projections.

2.      I do not see an option to use “2007 Business Plan Data” as the basis for my Five Year projections. 

You will be able to run five year projections based on your 2007 Business Plan after you enter your 2007 Business Plan on the L and S sheets. 

3.      I am getting an error on the Balance Sheet (F-5YR) sheet.  It says that my assets and equity are off.  What do I do?

The (F-5YR) chart now will issue a warning when your assets and Equity (Net Capital) are off.

It is necessary that you adjust the income statement so that the ROA necessary to achieve the credit union's 5 year Growth Chart goals match the projected income statement.

The default figures for the Income Statement simply maintain the same percentage to assets of the figures being used for the projection (actual data, current and future year’s projection data, etc.), which very likely will not achieve the Growth Chart goals.

The only way to change equity is through the income statement - the income you are projecting for 2007 because it adds it Net Income on IN sheet (Q38) to balance of year end capital - F16 to come up with net capital.

You can increase the investments and the equity by increasing savings on the S sheet.  If you make adjustments there to reflect the additional investment dollars, the other numbers (total assets/total liabilities/equity) will automatically adjust.