Reimbursables

This option is a sub-section item on the Income tab. These are expense items passed through to or reimbursed to the property owner(s) by the tenants.


Expenses may be reimbursed according to the tenant's proportional square foot area or proportional income contribution, or user-defined. 

Navigation: The drop-down menus and arrows at the top left corner of sheet are used to select the tenant/income stream, for years 1-11

Important: You must use the Navigation Tools (top left) to make access the various sections of the reimbursement schedule before you edit reimbursements.The navigation tools also load the settings for the individual tenants for year year of the holding period. 


With 30 tenants and 11 years of income projection, there is a maximum of 330 reimbursement schedules. Of course, the vertical and horizontal scroll bars can also be used to navigate the sheet, but this method of navigation will not load the settings for the portion of the reimbursement schedule being viewed. 

Printing: As noted above, the expense reimbursement sheet is large, with detail for each tenant, expense amount, stop amount and reimbursement amount for each year. For 30 tenants the print-out is over 100 pages. For this reason ranges to print are user-defined. Click the print button (left) to activate the print dialog, then click the print range button. This will minimize the print dialog so you can select the range on the sheet to print. Click and drag to define the range, then click the print dialog to expand it back to normal size. Then click the "Print Selected Range" button. 

Expense Reimbursement Methods: 

There are four options. 

  1. "% of Area" will calculate the proportional share of each expense, based on the tenant's proportion of building area. To set the building area, click the Property Info button on the main menu. 

  2. "% of Income" will calculate the proportional share of the expense, based on the tenant's share of the the income stream. This is based on potential gross income.

  3. "User-Defined" unlocks the Tenant column (this column is for the Tenant's share of the expense), and allows the user to enter amounts directly in this column. Note that the Reimbursement column reads from the Tenant column and subtracts and Stop amounts, if any. Note: This will over-write the formulas in the cells, and they cannot be restored. 

  4. "None" will set the reimbursements to zero.
Expense Stops: Enter the amount of the expense not reimbursed by the tenant. This amount is deducted from the reimbursement amount allocated to the tenant.

Other Notes
Each expense has a Yes/No option to activate or deactivate reimbursement calculations. You can toggle between Yes and No by double-clicking on the cell. All reimbursements are automatically adjusted for vacancy. For example, if an income stream has a 5% vacancy assigned, 5% will be deducted from the reimbursement amount.  


To save data entry time, you can set the reimbursement variables for future years equal to the settings for current year. Subsequent years can be further edited, if desired. To activate this option, click the "Project Fwd." button (left). The  "Project Fwd." function is not available for user-defined expense reimbursements. 

Note: This option will over-write any previous edits.


Comments