When you open the budget worksheet, you will see an area to enter your expense line items. It is important that you do not delete or add rows or columns to this area of the model. If you delete or add rows or columns, the model will not return accurate results. This section is broken into two areas. The top area is for entering Fixed Expenses, and the bottom area is for Variable Expenses.
To add an expense, first decide whether the expense is Fixed or Variable. Then go to the appropriate area and simply type over the item description and enter the
annual amount of the expense. If you do not need the additional spaces, just delete the description and the annual cost. To learn more about fixed and variable expenses, see:
Real Estate Dictionary
 Enter the Expense Name
Enter the name of the expense line item here. This name will be exported to the income and expense statements, and to the lease expense recovery section.
|
|
 Annual Cost
Enter the annual amount of the expense here, the model will perform all necessary partial year calculations
|
|
 Percent Change
Use this column to enter a percentage of increase in expenses. You can enter a percentage, or an actual dollar amount for the amount in each year. All entries less than 1 will return a percentage increase. The numbers that you enter here will be reflected in the statements below this section.
|
|