Rent Roll – data entry

This is a brief explanation of how to enter data on the Rent Roll worksheet of REIA Express Edition.

After you enter the total rentable square feet in cell C6, the rest of your entries will be in rows 12 through 36. Each of these rows represents a group of units with the same square footage and rent.

It’s especially important to enter the number of units in this group in column D. Otherwise, the program will assume this group has no units, and hence generates no income.

In column G, specify how you will enter the rent, as $ / Month, $ / SF / Month, $ / SF / Year or $ / Year. Then enter the average rent per unit for the first year in column I.

Starting in column J, enter the projected average rent for later years. If your entry is greater than 1, it is treated as an actual dollar amount. Otherwise it is taken as a percentage increase over the previous year. For example, 0.02 would indicate a 2% increase over the previous year.

When you are done, the data entry area will look something like this:

RentRoll

If you scroll down, you will see a table starting in row 47 showing the total income for each group of units:

RentRollReport

See the User Guide for more information.