Property Overview Quarterly Report
The Property Overview Quarterly Report is available in the Reports section of the Reports panel.
The Property Overview Quarterly Report can be run for one specific Property or all Properties associated with a specific Fund or Organizational Portfolio. The data is displayed separately for each Property.
The report displays lower tier deals owned by funds directly or through a middle tier fund. Lower tier deals owned through a middle tier fund are only included when Include Child Funds equals Yes.
To generate the report:
Select whether to search by Property or Fund/Portfolio.
If searching by Property, select the property name.
OR
If searching by Fund/Portfolio, select the fund or portfolio name.
Select whether to include child funds in the results.
Select the Qtr End Month.
Select the Year.
Click View Report.
Save or print the report.
The report output varies depending on your organization. Refer to the section below for the version that your organization uses.
Field | Definition | |||
|---|---|---|---|---|
Quarter End Month | The date requested for the report, in MM/DD/YYYY format. | |||
Property Name | The Property Name. | |||
Location | The City and State from the Property - Main tab. | |||
Property Overview | ||||
Risk Rating Current Period | The Overall Rating on the most recent Risk Review record for the selected quarter, regardless of Risk Rating Status. NoteRisk Review records are by Year and Quarter. The report will use the most recent Year/Qtr for the year, based upon the FYEM on the Deal. For example, Report is requested for February 2018. Deal has a FYEM of December. There are Risk Review records for 2017 Q4 and 2018 Q1. The report will display the Overall Rating from the 2017 Q4 record. If the Deal has a FYEM of October, and the user requests a Report for May 2017, the Risk Review record for Q2 will be used for the report. Q1 Month end = January, Q2 Month end = April, Q3 Month end = July, Q4 Month end = October. | |||
Property Status | The Status from Property - Main tab. | |||
Number of Units | The Property Total Units from Property - Main tab. | |||
Physical Occupancy | The number of 10 Yr TC Units from Occupancy - Occupancy tab, for the quarter-end month selected for the report. | |||
Physical Occupancy Date | The quarter-end date in MM/YYYY format for the requested report date. | |||
GP/MM | The name of the Entity on the Deal with a Deal Role of General Partner. If there is no Entity with a Deal Role of General Partner this will display the name of the Entity with a Deal Role of Managing Member. | |||
Property Manager | The Active Associated Company with a Role of Property Manager. If there are multiples, the first one will be reported. | |||
PM Affiliate of GP/MM | If there is a Property Manager that is associated to the General Partner on the Deal Role then it shows Yes. If there is not a General Partner on the Deal, but there is Managing Member, and there is a Property Manager associated to the Managing Member, it will show Yes. | |||
Fund | Displays all active Entities on the Deal with a role of Syndicated Fund. | |||
Net Equity Committed | The Capital Amount from the Equity Schedule - Equity tab. | |||
Net Equity Disbursed | The total Adjusted Capital amount from the Equity Schedule - Equity tab, where Paid = Yes. | |||
Unfunded Equity | Displays the Total where Paid = No. | |||
Operating Performance Metrics | Selected Month/Year | Selected Month/Prior Year | Current Year Budget | Current Year Forecast Budget |
If the report is selected for the Month that is the Fiscal Year End Month for the deal, the Operating Performance Metrics for the Current YTD and Previous YTD columns will pull from the annual financials instead of the monthly financials IF the Status of the Annual financials is Received or Approved. Otherwise the report displays the monthly financials for the period selected. | If the report is selected for the Month that is the Fiscal Year End Month for the deal, the Operating Performance Metrics for the Current YTD and Previous YTD columns will pull from the annual financials instead of the monthly financials IF the Status of the Annual financials is Received or Approved. Otherwise, the report displays the monthly financials for the period selected. | |||
Total Revenue | The Total Income from Periodic Financial - Income Statement tab for the period selected for the report. | The Total Income from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. | The Total Income from the Budget - Details tab, Budget column, for the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. | The Total Income from the Budget - Details tab, Forecast column, for the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. |
Total Operating Expenses | The Total Operating Expenses from Periodic Financial - Income Statement tab for the period selected for the report. Total Administrative Total Admin Payroll Total Management Fee Total Operations & Maintenance Total Maintenance Payroll Total Utilities Total Real Estate Taxes Total Insurance Total Other Expenses—this total excludes Personal Property, Incentive Management Fee, Investor Fee, and Other Non Recurring Items if those line items are included on the Financial record. | The Total Operating Expenses from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. Total Administrative Total Admin Payroll Total Management Fee Total Operations & Maintenance Total Maintenance Payroll Total Utilities Total Real Estate Taxes Total Insurance Total Other Expenses—this total excludes Personal Property, Incentive Management Fee, Investor Fee, and Other Non Recurring Items if those line items are included on the Financial record. | The Total Operating Expenses from the Budget - Details tab, Budget column, for the year selected for the report. Total Administrative Total Admin Payroll Total Management Fee Total Operations & Maintenance Total Maintenance Payroll Total Utilities Total Real Estate Taxes Total Insurance Total Other Expenses—this total excludes Personal Property, Incentive Management Fee, Investor Fee, and Other Non Recurring Items if those line items are included on the Financial record. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. | The Total Operating Expenses from the Budget - Details tab, Forecast column, for the year selected for the report. Total Administrative Total Admin Payroll Total Management Fee Total Operations & Maintenance Total Maintenance Payroll Total Utilities Total Real Estate Taxes Total Insurance Total Other Expenses—this total excludes Personal Property, Incentive Management Fee, Investor Fee, and Other Non Recurring Items if those line items are included on the Financial record. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. |
NOI | NOI calculation: Total Revenue minus Total Operating Expenses. | NOI calculation: Total Revenue minus Total Operating Expenses. | NOI calculation: Total Revenue minus Total Operating Expenses. | NOI calculation: Total Revenue minus Total Operating Expenses. |
Debt Service | The Hard Debt Principal + Hard Debt Interest from Periodic Financial - Income Statement tab for the period selected for the report. | The Hard Debt Principal + Hard Debt Interest from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. | The Hard Debt Principal + Hard Debt Interest from the Budget - Details tab, Budget column, for the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. | The Hard Debt Principal + Hard Debt Interest from the Budget - Details tab, Forecast column, for the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. |
Replacement Reserve | The Required Replacement Reserve Deposits amount from the Periodic/Annual Financial record for the period selected for the report. | The Required Replacement Reserve Deposits amount from the Periodic/Annual Financial record for the year prior to the period selected for the report. | The Required Replacement Reserve Deposits amount from the Budget - Details tab, Budget column for the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. | The Required Replacement Reserve Deposits amount from the Budget - Details tab, Forecast column for the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. |
Net Cash Flow | NOI minus Debt Service minus Required Replacement Reserves. | NOI minus Debt Service minus Required Replacement Reserves. | NOI minus Debt Service minus Required Replacement Reserves. | NOI minus Debt Service minus Required Replacement Reserves. |
DCR | Displays the DSCR = NOI/Hard Debt from Periodic Financial - Income Statement tab for the period selected for the report. | Displays the DSCR = NOI/Hard Debt from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. | Displays the DSCR = NOI/Hard Debt from the Budget - Details tab, Budget column, for the year selected for the report. | Displays the DSCR = NOI/Hard Debt from the Budget - Details tab, Forecast column, for the year selected for the report. |
Expenses Per Unit | Displays the calculated value of Total Operating Expenses/Total Residential Units from the Property, for the period selected for the report. | Displays the calculated value of Total Operating Expenses/Total Residential Units from the Property, for 1 year prior to the period selected for the report. | Displays the calculated value of Total Operating Expenses/Total Residential Units from the Property, for the Budget year selected for the report. | Displays the calculated value of Total Operating Expenses/Total Residential Units from the Property, for the Forecast Budget year selected for the report. |
Economic Occupancy % | Displays the Economic Occupancy from Periodic Financial - Income Statement tab for the period selected for the report. | Displays the Economic Occupancy from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. | Displays the Economic Occupancy from the Budget - Details tab, Budget column, for the year selected for the report. | Displays the Economic Occupancy from the Budget - Details tab, Forecast column, for the year selected for the report. |
Accounts Payable | Displays the A/P - Operations from the Periodic Financial - Balance Sheet tab for the period selected for the report. | Displays the A/P - Operations from the Periodic Financial - Balance Sheet tab for 1 year prior to the period selected for the report. | Report will show blank. | Report will show blank. |
Operating Reserve Balance | Displays the Operating Reserves from the Periodic Financial - Balance Sheet tab for the period selected for the report. | Displays the Operating Reserves from the Periodic Financial - Balance Sheet tab for 1 year prior to the period selected for the report. | Report will show blank. | Report will show blank. |
Replacement Reserve Balance | Displays the Replacement Reserves from the Periodic Financial - Balance Sheet tab for the period selected for the report. | Displays the Replacement Reserves from the Periodic Financial - Balance Sheet tab for 1 year prior to the period selected for the report. | Report will show blank. | Report will show blank. |
Date and Physical Occ | Displays the Physical Occupancy Date and Physical % from Occupancy - Occupancy tab, for the report date requested, and for the two previous months in MM/YYYY format. | |||
Property Details | ||||
Date Closed | The Effective Date for Actual Closing from the Status History grid on Deal Details page. | |||
Placed In Service Date | The Actual PIS date from Edit Property - Main tab. | |||
End of Compliance | The LIHTC Compliance End Date from Property - LIHTC tab. | |||
Date of Last Site Visit | The Site Visit Date from the most recent Inspection record for the selected quarter for the Property from Inspection - Main tab. | |||
Property Type | The LIHTC Property Type from Property - LIHTC tab. | |||
Population Served | The Tenant Mix from Property - Main tab. | |||
Financing Information | ||||
Lender | The Lender name from Debt/Financing - Debt Details Main tab, for the Debt record that has an Order number of 1. | |||
Loan Type/Lien # | The Debt Instrument Type from Debt/Financing for the Debt record with Order of 1, followed by the Order # (1). | |||
Original Amount | The Actual Amount from Debt/Financing for the Debt record with Order of 1. | |||
Interest Rate | The Rate from Debt/Financing, Debt Details - Rates tab, for the Debt record with Order of 1. | |||
Guarantee Details | ||||
Dev Deficit | Displays the Guarantee Amount, Active status, and Actual Exp Date from the Guarantee record with a Type of Development Completion. Active will display Yes or No based upon the Actual Exp Date. If the date is equal to, or after today's date, the Active column will display Yes. If the date is before today, the report will display No. If the Unlimited checkbox is selected on the Guarantee record, the Amount column will display Unlimited. | |||
Operating Deficit | Displays the Guarantee Amount, Active status, and Actual Exp Date from the Guarantee record with a Type of Operating Deficit. Active will display Yes or No based upon the Actual Exp Date. If the date is equal to, or after today's date, the Active column will display Yes. If the date is before today, the report will display No. If the Unlimited checkbox is selected on the Guarantee record, the Amount column will display Unlimited. | |||
Recapture | Displays the Guarantee Amount, Active status, and Actual Exp Date from the Guarantee record with a Type of Adjusters Compliance. Active will display Yes or No based upon the Actual Exp Date. If the date is equal to, or after today's date, the Active column will display Yes. If the date is before today, the report will display No. If the Unlimited checkbox is selected on the Guarantee record, the Amount column will display Unlimited. | |||
Background | The Property Description from Property, Main tab. | |||
Market | Displays the Market information from Risk Reviews, Investor Notes tab, for the corresponding Year and Quarter of the report. | |||
Recent Updates | Displays the Occupancy information from Risk Reviews, Investor Notes tab, for the corresponding Year and Quarter of the report. | |||
Field | Definition | |||
|---|---|---|---|---|
Quarter End Month | The date requested for the report, in MM/DD/YYYY format. | |||
Property Name | The Property Name. | |||
Location | The City and State from the Property - Main tab. | |||
Property Overview | ||||
Risk Rating Current Period | The Overall Rating on the most recent Risk Review record for the selected quarter, regardless of Risk Rating Status. NoteRisk Review records are by Year and Quarter. The report will use the most recent Year/Qtr for the year, based upon the FYEM on the Deal. For example, Report is requested for February 2018. Deal has a FYEM of December. There are Risk Review records for 2017 Q4 and 2018 Q1. The report will display the Overall Rating from the 2017 Q4 record. If the Deal has a FYEM of October, and the user requests a Report for May 2017, the Risk Review record for Q2 will be used for the report. Q1 Month end = January, Q2 Month end = April, Q3 Month end = July, Q4 Month end = October. | |||
Property Status | The Status from Property - Main tab. | |||
Total LIHTC Units | The Property Total Units from Property - Main tab. | |||
Total Market Rate Units | The Property Total Units from Property - Main tab. | |||
Total Commercial Units | The Property Total Units from Property - Main tab. | |||
Total Units | The Property Total Units from Property - Main tab. | |||
Physical Occupancy | The number of 10 Yr TC Units from Occupancy - Occupancy tab, for the quarter-end month selected for the report. | |||
Physical Occupancy Date | The quarter-end date in MM/YYYY format for the requested report date. | |||
GP/MM | The name of the Entity on the Deal with a Deal Role of General Partner. If there is no Entity with a Deal Role of General Partner this will display the name of the Entity with a Deal Role of Managing Member. | |||
Property Manager | The Active Associated Company with a Role of Property Manager. If there are multiples, the first one will be reported. | |||
PM Affiliate of GP/MM | If there is a Property Manager that is associated to the General Partner on the Deal Role then it shows Yes. If there is not a General Partner on the Deal, but there is Managing Member, and there is a Property Manager associated to the Managing Member, it will show Yes. | |||
Fund | Displays all active Entities on the Deal with a role of Syndicated Fund. | |||
Net Equity Committed | The Capital Amount from the Equity Schedule - Equity tab. | |||
Net Equity Disbursed | The total Adjusted Capital amount from the Equity Schedule - Equity tab, where Paid = Yes. | |||
Unfunded Equity | Displays the Total where Paid = No. | |||
Issues | Displays the Issues information from Risk Reviews, Investor Notes tab, for the corresponding Year and Quarter of the report. | |||
Plan of Action | Displays the Actions Information from Risk Reviews, Investor Notes tab, for the corresponding Year and Quarter of the report. | |||
Operating Performance Metrics | Selected Month/Year | Selected Month/Prior Year | Selected Year Budget | Prior Year Audited Figures |
If the report is selected for the Month that is the Fiscal Year End Month for the deal, the Operating Performance Metrics for the Current YTD and Previous YTD columns will pull from the annual financials instead of the monthly financials IF the Status of the Annual financials is Received or Approved. Otherwise the report displays the monthly financials for the period selected. | If the report is selected for the Month that is the Fiscal Year End Month for the deal, the Operating Performance Metrics for the Current YTD and Previous YTD columns will pull from the annual financials instead of the monthly financials IF the Status of the Annual financials is Received or Approved. Otherwise, the report displays the monthly financials for the period selected. | |||
Total Rent | The Total Rent from Periodic Financial - Income Statement tab for the period selected for the report. | The Total Rent from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. | The Total Rent from the Budget - Details tab, Budget column, for the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. | The Total Rent from the Annual Financials, Actual Column, for the year prior than the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. |
Total Vacancies | The Total Vacancies from Periodic Financial - Income Statement tab for the period selected for the report. | The Total Vacancies from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. | The Total Vacancies from the Budget - Details tab, Budget column, for the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. | The Total Vacancies from the Annual Financials, Actual Column, for the year prior than the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. |
Total Other Income | The Total Vacancies from the Annual Financials, Actual Column, for the year prior than the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. | The Total Income from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. | The Total Other Income from the Budget - Details tab, Budget column, for the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. | The Total Other Income from the Annual Financials, Actual Column, for the year prior than the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. |
Total Revenue | The Total Income from Periodic Financial - Income Statement tab for the period selected for the report. | The Total Income from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. | The Total Income from the Budget - Details tab, Budget column, for the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. | The Total Income from the Annual Financials, Actual Column, for the year prior than the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. |
Total Administrative | The Total Administrative + Total Management Fee from Periodic Financial - Income Statement tab for the period selected for the report. | The Total Administrative + Total Management Fee from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. | The Total Administrative + Total Management Fee from the Budget - Details tab, Budget column, for the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. | The Total Administrative + Total Management Fee from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. |
Total Payroll | The Total Admin Payroll + Total Maintenance Payroll from Periodic Financial - Income Statement tab for the period selected for the report. | The Total Admin Payroll + Total Maintenance Payroll from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. | The Total Admin Payroll + Total Maintenance Payroll from the Budget - Details tab, Budget column, for the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. | The Total Admin Payroll + Total Maintenance Payroll from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. |
Total Operating & Maintenance | The Total Operating & Maintenance from Periodic Financial - Income Statement tab for the period selected for the report. | The Total Operating & Maintenance from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. | Displays the Total Operating & Maintenance from the Budget - Details tab, Budget column, for the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. | The Total Operating & Maintenance from the Annual Financials, Actual Column, for the year prior than the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. |
Total Utilities | The Total Utilities from Periodic Financial - Income Statement tab for the period selected for the report. | The Total Utilities from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. | The Total Utilities from the Budget - Details tab, Budget column, for the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. | The Total Utilities from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. |
Total Taxes and Insurance | The Total Real Estate Taxes + Total Insurance from Periodic Financial - Income Statement tab for the period selected for the report. | The Total Real Estate Taxes + Total Insurance from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. | The Total Real Estate Taxes + Total Insurance from the Budget - Details tab, Budget column, for the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. | The Total Real Estate Taxes + Total Insurance from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. |
Total Other Expense | The Total Other Expense from Periodic Financial - Income Statement tab for the period selected for the report. | The Total Other Expense from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. | The Total Other Expense from the Budget - Details tab, Budget column, for the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. | The Total Other Expense from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. |
Total Operating Expenses | The Total Operating Expenses from Periodic Financial - Income Statement tab for the period selected for the report. Total Administrative Total Admin Payroll Total Management Fee Total Operating & Maintenance Total Maintenance Payroll Total Utilities Total Real Estate Taxes Total Insurance Total Other Expenses—For the report only, Total Other Expenses excludes Personal Property, Incentive Management Fee, Investor Fee, and Other Non Recurring Items if those line items are included on the Financial record. | The Total Operating Expenses from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. Total Administrative Total Admin Payroll Total Management Fee Total Operating & Maintenance Total Maintenance Payroll Total Utilities Total Real Estate Taxes Total Insurance Total Other Expenses—For the report only, Total Other Expenses excludes Personal Property, Incentive Management Fee, Investor Fee, and Other Non Recurring Items if those line items are included on the Financial record. | The Total Operating Expenses from the Budget - Details tab, Budget column, for the year selected for the report. Total Administrative Total Admin Payroll Total Management Fee Total Operating & Maintenance Total Maintenance Payroll Total Utilities Total Real Estate Taxes Total Insurance Total Other Expenses—For the report only, Total Other Expenses excludes Personal Property, Incentive Management Fee, Investor Fee, and Other Non Recurring Items if those line items are included on the Financial record. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. | The Total Operating Expenses from the Annual Financials, Actual Column, for the year prior than the year selected for the report. Total Administrative Total Admin Payroll Total Management Fee Total Operating & Maintenance Total Maintenance Payroll Total Utilities Total Real Estate Taxes Total Insurance Total Other Expenses—For the report only, Total Other Expenses excludes Personal Property, Incentive Management Fee, Investor Fee, and Other Non Recurring Items if those line items are included on the Financial record. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. |
NOI | The Total Revenue minus Total Operating Expenses. NOI is calculated using the values from the report, not the application. | The Net Operating Income from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. NOI is calculated using the values from the report, not the application. | The Net Operating Income from the Budget - Details tab, Budget column, for the year selected for the report. NOI is calculated using the values from the report, not the application. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. | The Net Operating Income from the Annual Financials, Actual Column, for the year prior than the year selected for the report. NOI is calculated using the values from the report, not the application. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. |
Debt Service | The Total Hard Debt from Periodic Financial - Income Statement tab for the period selected for the report. | The Total Hard Debt from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. | The Total Hard Debt from the Budget - Details tab, Budget column, for the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. | The Total Hard Debt from the Annual Financials, Actual Column, for the year prior than the year selected for the report. Calculation is based on the Quarter of the report: Quarter 1 = 25% of the annual amount. Quarter 2 = 50% of the annual amount. Quarter 3 = 75% of the annual amount. Quarter 4 = 100% of the annual amount. |
Replacement Reserve | The Current Year Required Annual Amount from Reserves - View Annual Projection modal for the year of the report. The Required Deposit amount is calculated for the date selected for the report. If the report date is for Q1, the amount will be 25% of the annual amount; if the report date is for Q2, the amount will be 50% of the annual amount; if the report date is for Q3, the amount will be 75% of the annual amount; if the report date is for Q4, the amount will be 100% of the annual amount. | The Current Year Required Annual Amount from Reserves - View Annual Projection modal for the year prior to the year of the report. The Required Deposit amount is calculated for the date selected for the report. If the report date is for Q1, the amount will be 25% of the annual amount; if the report date is for Q2, the amount will be 50% of the annual amount; if the report date is for Q3, the amount will be 75% of the annual amount; if the report date is for Q4, the amount will be 100% of the annual amount. | Report will show 0. | The Prior Year Required Annual Amount from Reserves - View Annual Projection modal for the year prior to the year of the report. The Required Deposit amount will be 100% of the annual amount. |
Net Cash Flow | The Net Cash Flow from Periodic Financial - Income Statement tab for the period selected for the report. For the report only the Net Cash Flow is calculated as NOI minus Debt Service minus Required Replacement Reserves. Values from the report are used for this calculation. | The Net Cash Flow from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. For the report only the Net Cash Flow is calculated as NOI minus Debt Service minus Required Replacement Reserves. Values from the report are used for this calculation. | The Net Cash Flow from the Budget - Details tab, Budget column, for the year selected for the report. For the report only the Net Cash Flow is calculated as NOI minus Debt Service minus Required Replacement Reserves. Values from the report are used for this calculation. | The Net Cash Flow from the Annual Financials, Actual Column, for the year prior than the year selected for the report. For the report only the Net Cash Flow is calculated as NOI minus Debt Service minus Required Replacement Reserves. Values from the report are used for this calculation. |
DCR | Displays the DSCR = NOI/Hard Debt from Periodic Financial - Income Statement tab for the period selected for the report. | Displays the DSCR = NOI/Hard Debt from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. | Displays the DSCR = NOI/Hard Debt from the Budget - Details tab, Budget column, for the year selected for the report. | Displays the DSCR = NOI/Hard Debt from the Annual Financials, Actual Column, for the year prior than the year selected for the report. |
Expenses Per Unit | The calculated value of Total Operating Expenses/Total Residential Units from the Property, for the period selected for the report. Values from the report are used for this calculation. | The calculated value of Total Operating Expenses/Total Residential Units from the Property, for 1 year prior to the period selected for the report. Values from the report are used for this calculation. | The calculated value of Total Operating Expenses/Total Residential Units from the Property, for the Budget year selected for the report. Values from the report are used for this calculation. | The calculated value of Total Operating Expenses/Total Residential Units from the Property, for the Annual Financials, Actual Column, for the year prior than the year selected for the report. Values from the report are used for this calculation. |
Economic Occupancy % | The Economic Occupancy from Periodic Financial - Income Statement tab for the period selected for the report. | The Economic Occupancy from Periodic Financial - Income Statement tab for 1 year prior to the period selected for the report. | The Economic Occupancy from the Budget - Details tab, Budget column, for the year selected for the report. | The Economic Occupancy from the Annual Financials, Actual Column, for the year prior than the year selected for the report. |
Accounts Payable | The A/P - Operations from the Periodic Financial - Balance Sheet tab for the period selected for the report. | The A/P - Operations from the Periodic Financial - Balance Sheet tab for 1 year prior to the period selected for the report. | Report will show blank. | The A/P - Operations from the Annual Financial - Balance Sheet tab for the year prior to the period selected for the report. |
Operating Reserve Balance | The Operating Reserves from the Periodic Financial - Balance Sheet tab for the period selected for the report. | The Operating Reserves from the Periodic Financial - Balance Sheet tab for 1 year prior to the period selected for the report. | Report will show blank. | The Operating Reserves from the Annual Financial - Balance Sheet tab for the year prior to the period selected for the report. |
Replacement Reserve Balance | The Replacement Reserves from the Periodic Financial - Balance Sheet tab for the period selected for the report. | The Replacement Reserves from the Periodic Financial - Balance Sheet tab for 1 year prior to the period selected for the report. | Report will show blank. | The Replacement Reserves from the Annual Financial - Balance Sheet tab for the year prior to the period selected for the report. |
Date and Physical Occ | The Physical Occupancy Date and Physical % from Occupancy - Occupancy tab, for the report date requested, and for the two previous months in MM/YYYY format. | |||
Property Details | ||||
Date Closed | The Effective Date for Actual Closing from the Status History grid on Deal Details page. | |||
Placed In Service Date | The Actual PIS date from Edit Property - Main tab. | |||
End of Compliance | The LIHTC Compliance End Date from Property - LIHTC tab. | |||
Date of Last Site Visit | The Site Visit Date from the most recent Inspection record for the selected quarter for the Property from Inspection - Main tab. | |||
Property Type | The LIHTC Property Type from Property - LIHTC tab. | |||
Population Served | The Tenant Mix from Property - Main tab. | |||
Financing Information | ||||
Hard or Soft | Displays Hard vs. Soft option selected from Debt/Financing - Debt Details - Terms tab. | |||
Lender | The Lender name from Debt/Financing - Debt Details Main tab. | |||
Loan Type/Lien # | The Debt Instrument Type from Debt/Financing - Debt Details - Main tab. | |||
Original Amount | The Actual Amount from Debt/Financing - Debt Details - Main tab. | |||
Interest Rate | The Rate from Debt/Financing, Debt Details - Rates tab. | |||
Guarantee Details | ||||
Dev Deficit | Displays the Guarantee Amount, Active status, Expiration and Guarantee Terms from the Guarantee record with a Type of Development Completion. Active will display Yes or No based upon the Actual Expiration Date. If the date is null, or after today's date, the Active column will display Yes. If the date is equal to, or before today, the report will display No. If the Unlimited checkbox is selected on the Guarantee record, the Amount column will display Unlimited. | |||
Operating Deficit | Displays the Guarantee Amount, Active status, and Actual Expiration Date from the Guarantee record with a Type of Operating Deficit. Active will display Yes or No based upon the Actual Expiration Date. If the date is null, or after today's date, the Active column will display Yes. If the date is equal to, or before today, the report will display No. If the Unlimited checkbox is selected on the Guarantee record, the Amount column will display Unlimited. | |||
Recapture | Displays the Guarantee Amount, Active status, and Actual Expiration Date from the Guarantee record with a Type of Adjusters Compliance. Active will display Yes or No based upon the Actual Expiration Date. If the date is null, or after today's date, the Active column will display Yes. If the date is equal to, or before today, the report will display No. If the Unlimited checkbox is selected on the Guarantee record, the Amount column will display Unlimited. | |||
Background | The Property Description from Property, Main tab. | |||
Recommendation and Justification | Displays the Recommendation and Justification information from Risk Reviews, Investor Notes tab, for the corresponding Year and Quarter of the report. | |||
Recent Updates | Displays the Occupancy information from Risk Reviews, Investor Notes tab, for the corresponding Year and Quarter of the report. | |||