This sheet contains two tables: Income and Expense.
The tables expand vertically and horizontally. The horizontal display (columns) is configured by setting the Show/Hide label in row 6. To toggle the display, click the Show/Hide button. There many columns available for display; depending on the number selected, a landscape page may be a better choice when the table is merged in Word.
Historic income and expense data for up to three years.
The screen shot below shows these tables with several columns hidden.
Further, each of the above can be displayed as $/square foot and $/unit. Unit values are based on SF and Unit counts entered in the Rent Roll or optionally, hand entered.
Square footage information from the Rent Roll is displayed on the right. These values may be selected if there is more than one Rent Roll, or overridden completely.
The Appraisal column is unique because it will auto-populate from the Capitalization worksheet. If there are multiple Capitalization sheets, select the appropriate sheet from the drop-down. Therefore, the Capitalization worksheet needs to be completed before this table can be fully populated. Optionally, data can hand-entered. In that case, clear the formulas via the "Clear Projections" button.
The "Restore Projections" will restore formulas and link to the data source selected in the drop-down.