INCOME & BALANCE SHEET - PROJECTION WORKSHEET
Input only into "YELLOW" cells, remaining calculation cells.
These worksheets allow you to create a projected Balance Sheet. You will first
need to estimate your projected income prior to creating and estimated Balance Sheet.
1). With an actual Financial Statement, input data into the Projected Income Statement.
2). Project sales growth for each department and estimated % of retained as gross profit.
3). Estimate expense %'s per department.
4). Enter any miscellaneous adjustment to Net Income.
5). Enter inventory values to calculate inventory turn ratios.
6). Enter actual Balance Sheet values into Projected Balance Sheet.
	REMEMBER ASSETS = LIABILITIES + EQUITY,  verify statement balances.
7). Finally, enter override value to fine turn your projected Balance Sheet.
You will find many comment boxes  to assist you within the worksheets. (Look Red Triangle Indicators)
You can create an endless copies to the Projected Balance Sheet, Simply by:
	Right Click on Sheet Tab.
	Select "Move or Copy".
	Click on "Create an Copy" box.
	Then Click "OK"
You may than rename your worksheet, Simply by:
	Right Click on Sheet Tab.
	Select "Rename".
	Then type new name in highlighted tab area.
Worksheets are protected, NO password.
Worksheets contain NO Macros.
Feeling creative chart your Balance Sheet for Account changes.