AHIC Quarterly Report
The AHIC Quarterly Report is available in the Reports panel.
The AHIC Quarterly Report is a standard AHIC report in a Microsoft Excel format, intended to report quarterly financial information that can be included in the Investor Report Package.
To generate the report:
Enter the Deal name to generate the report for a specific deal.
You must enter the deal name exactly as it appears on Deal Details for a match to occur.
Select the Deal Phase to generate the report for deals in a specific phase.
Enter the Fund Abbrev to generate the report for deals associated to a specific fund.
You must enter the fund abbreviation exactly as it appears on Deal Details for a match to occur.
Select the Organizational Portfolio to generate the report for deals in a specific portfolio.
Select the Quarter. The default is All.
Select the Year.
Click Run Report.
Field | Data Source |
|---|---|
Fund | Fund Tracker |
Property Name | Deal - Deal Name |
Current Quarter | Quarter of Record |
Current Year | Year of Record |
Occ LIHTC | Occupancy - 10 Yr TC Units |
Occ Market | Occupancy - Physical Units minus 10 Yr TC Units |
Economic Occ % | Financials - Income Statement - Economic Occupancy |
Tenant Receivables | Financials - Balance Sheet - A/R - Tenant |
Occ Commercial | Financials - Income Statement - Commercial Income |
Gross Income | Financials - Income Statement - Total Income |
Operating Exp | Financials - Income Statement - Total Operating Expense |
NOI Before Debt | Financials - Income Statement - Net Operating Income |
Required Replacement Reserve Deposits | Displays the value of the first reserve with the Type = "Replacement" |
Hard (Must Pay) Interest | Financials - Income Statement - Hard Debt Interest |
Hard (Must Pay) Principal | Financials - Income Statement - Hard Debt Principal |
Debt Coverage | Financials - Income Statement - DSCR |
Expense Coverage Ratio | Financials - Total Income/Total Operating Expense + Required Replacement Reserve Deposits (line item) |
Cash Flow | Financials - Income Statement - Net Cash Flow |
Depreciation | Financials - Income Statement - (Depreciation) |
Net Rental Income | Financials - Income Statement - Net Rental Income |
Real Estate Property Taxes | Financials - Income Statement - Total Real Estate Taxes |
Operating Reserve Balance | Financials - Balance Sheet - Operating Reserves |
Replacement Reserve Balance | Financials - Balance Sheet - Replacement Reserves |
Debt Service Reserve Balance | Financials - Balance Sheet - DSCR Reserve |
Other Reserves Balance | Financials - Balance Sheet - Other Reserve |
Last Visit | Displays the last site visit date from the Inspection record prior to the report date |
Last Compliance Audit | Compliance Events - Start Date |
Risk Rating | Risk Rating - Overall Rating (prior quarter value is displayed if no value for the report period quarter is set) |
Watchlist Comments | Risk - Overall Rating Description only when Overall Rating = C |