Calculations are based on the Lease dates of the Residents, adjusted by Start Billing, Stop Billing, Move-Out, Pro In, FFP, and Charge Ends. Amounts are reported by period, as defined in the Period Setup, not by calendar month.

The amounts will be the actual amount projected to be charged during that particular Period.

Example:

Assume Periods run from the 25th to the 24th of the month, the charge starts on 6/16/2016 for 600 with an FFP of 7/1/2016.

Period 6 will show a charge of $300 (15 out of 30 days); Period 7 will show $600.

If there are multiple leases they will be added together.

Technical Details on Calculations

Lease Expiration Dates

Lease Expiration Dates & Move-In Assumptions

Select Properties

Click to select properties from the Select Properties pop-up. The report runs for all selected properties.

Print by Building (check box)

Not Checked - When not checked (default), the report prints by unit and there is a property total.

Checked - Check the box to print the report by building. This option is not available when Buildings are not set up.

When printing by building to PDF or Crystal Viewer, each building starts on a new page and building totals appear in the report.

When printing by building to Excel, each building starts on a new page and building totals appear in the report. Units are sorted by building and then unit or unit type, depending on the unit type choice.

From Building / Thru Building

Click the Lookup icon to display the Select pop-up and select range of IDs for the buildings you want to print.

To Print a report for an individual building, select the same ID for both From and Thru.

From Unit / Thru Unit

Click the Lookup icon to display the Select pop-up and select range of IDs for the units you want to print.

To Print a report for an individual unit, select the same ID for both From and Thru.

Print Detail by Unit

Select Yes (default) to print the individual amounts by unit.

Select No (does not apply to Excel output) to not include individual amounts by unit. Note that this option does not apply to Excel with formulas output.

Print Totals by Unit Type

Select Yes (default) to subtotals by unit type. In addition, the units are sorted by unit type and then unit number.

Select No to not include subtotals by unit type.

Starting Period

This field defaults to the next period of the current property. Or, enter another starting period in the format MM/YYYY. Forecasted data is computed as of this period.

Calculation Method (unlabeled)

NOTE that you can select only one of the following three buttons: Rent Forecast (default), Concession Matrix, Selected Income Codes. The option you select may show additional fields after selection. See all subsequent field descriptions below for details.

Rent Forecast (button)

Select the button (default) to include all income codes of type Rent when calculating the values.

Or, select another of the three options.

Concession Matrix (button)

Select the button to include all income codes of type Concession when calculating the values. This option does not allow for forecasting based on Market rents.

Or, select another of the three options.

Selected Income Codes

Select the button to include selected income codes when calculating the values. This option does not allow for forecasting based on Market rents.

Any number of income codes can be selected from the drop-down box that appears. This field is only available if this option is selected.

Or, select another of the three options.

Forecast future amounts

Select Yes (default), and then future lease renewals and projected future amounts are included in the report.

Select No, and then only recurring charges through the end of the current lease are included in the report.

Average Vacant Months

When forecasting future amounts, how many months should the unit be assumed to be vacant?

The default in the field is 1 month. You can click in the field and change the number of months.

NOTE that the other options you see on this line depend on which method you selected: Rent Forecast, Concession Matrix, or Selected Income Codes.

Base On

When forecasting future amounts should the new amount be based on the unit Market rent or on the last rental?

Options are Market and Last Rental Percent, although available options vary depending on previous selections.

NOTE that after selecting an option, enter a percentage in the Last Rental Percent field, if applicable.

Market - Select this option to base it on the unit Market rent.

Last Rental Percent - Select this option to base it on a percentage of the Last Rental.

Next, enter a percentage to be used in the calculation. So, when forecasting, what percentage of that amount should be used?

Examples:

Enter 100 to indicate using 100% of Market rent or of last rental.

Enter 105 to indicate using a 5% increase over the Market rent or last rental.

Last Rental Forecast based on

If forecast amounts are based on the option, Last Rental Percent, then how should the last rental calculation be done? Options are Monthly Average or Prior Frequencies.

Monthly Average - The recurring charges are converted to a monthly basis and the monthly total is used.  

Frequencies - The recurring charge frequencies are based on the prior residents charges.

NOTE that this option only appears if Last Rental Percent is selected, above. (See Average Vacant Months.)

Include Actual Charges

Selecting this option includes actual charges (Transaction types 1, 2, and 9) into the period amounts based on the G/L period of the transaction.

Include Current Name

Selecting this option includes the name of the resident / tenant who is “current” on the starting date of the starting period of the report. Current is defined as having the status of Current, On-Notice, or Transfer Out. If there are multiple such residents/tenants, only one name is shown on the report.

The resident's/tenant's lease Begins and lease Ends date are also included when you select this option.

Report Format

Select a report format for the report.

 

1. From the eSite menu, select Reports—Renewal & Forecast—Rent Forecast.
2. Click Select Properties. Select the properties for which you want to print the report and click Done.
3. Select the information you want to see on the report (refer to the Selection Criteria for this report).
4. Select one of the following Report Printing Options:
• Acrobat Reader: Print the report in PDF format for use in a PDF viewer, such as Acrobat.
• Crystal Viewer: Prints the report in Crystal format.
• Excel (with formulas): Prints the report in an .xlsx spreadsheet with actual values and Excel formulas for the totals, allowing the user to easily manipulate the data for budgeting purposes. A separate worksheet is created for each property.
5. Click Display. If you selected Excel (with formulas), you are prompted to open or save the report Excel file. Otherwise, the report opens in your preferred format.

 

Copyright © 2018 Infor. All rights reserved. www.infor.com.