LT Financials Report
The LT Financials Report is available in the Reports panel.
The LT Financials Report displays financial data points for the lower tier deals directly associated to upper tier funds as well as lower tier deals that pass through a middle tier before the upper tier fund. The financial data points are not displayed in the same manner as the line items found on the Income Statement or Balance Sheet of the Financials. Instead, they are rolled up into report-specific categories. This reporting is usually provided to the fund’s investors. This report is only available in a Microsoft Excel format.
Report requirements:
At least one financial record for the selected Year and Quarter needs to exist for a lower tier deal associated to the fund.
The Fund Abbrev. must be populated exactly as it appears on the Fund Details page.
To generate the report:
Enter the Fund Abbrev.
Select the Deal Phase.
Select the Year.
Select the Quarter End.
Click Run Report.
Report Category | Financial Line Items |
|---|---|
Balance Sheet | |
Property and equipment, net | Land Land Improvements Buildings Furnishings and Equipment (Accumulated Depreciation) |
Cash and cash equivalents | Cash |
Reserves and escrows | Replacement Reserves Tax and Insurance Escrow Operating Reserves DSCR Reserve Other Reserves Working Capital Reserves Construction Escrow |
Prepaid Insurance | Prepaid Insurance |
Accounts receivable, net | A/R - Tenant A/R – Subsidies A/R – Related Parties A/R – Other |
Deferred costs, net | A/R – Syndication Proceeds Amortized Expenses Deferred Costs, net |
Other assets | Prepaid Expenses Tenant Security Deposits Other Current Assets Other Assets Utility Deposits |
Total Assets | Sum of all line items under assets |
Mortgage Payable | Hard Long Term Debt Hard Long Term – 2nd Priority Current Notes Payable Mortgage Notes Payable - Hard |
Developer fees payable | Developer Fee Payable Developer Fee Interest Payable |
Accounts payable and accrued expenses | Accounts Payable – operations Accrued Expenses Accrued Interest Payable – Debt Accrued Interest Hard Debt A/P – Construction/Development Accrued Interest Payable – 2nd Debt Priority |
Advances from Members and affiliates | Advances from Member and Affiliates Debt Added/Affiliate Advances GP Loans Accrued LP Fees Payable Accrued GP Fees Payable |
Investors fees payable | Accrued Investor Fees |
Other soft loans payables | Deferred/Soft Debt Deferred/Soft Debt Interest Other Long Term Debt Accrued Interest Soft Debt Mortgage Notes Payable – Soft Construction Loan Payable |
Management and bookkeeping fee payable | Management Fee Payable Incentive Management Fee Payable |
Real estate taxes payable | Accrued Property Tax |
Other payables | Accrued Property Management Fee Tenant Deposits Held in Trust Prepaid Rent Other Current Liabilities Accrued Property Insurance Retained Earnings Other Long Term Liabilities |
Total Liabilities | Sum of all line items under Liabilities |
Investor Limited Partner | Investor Limited Partner’s Equity Limited Partners Capital |
Other partners | General Partners Capital Other Capital Account Other Partner’s Equity |
Total partners’ equity (deficit) | Sum of Investor Limited Partner + Other Partners |
Total liabilities and partners’ equity (deficit) | Sum of Total Liabilities + Total Partner’s equity |
Check | Total Liabilities and partners’ equity (deficit) – Total Assets |
Income Statement | |
Rental and other income | Gross Potential Rent Tenant Assistance Payments Commercial Income Interest Credit Subsidy Hotel – Rooms Subsidy Revenue Miscellaneous Other Rent Laundry & Vending Tenant Charges Forfeited Deposits Garage & Parking Special Claims Common Area Maintenance Income Solar/Other Income Hotel – Food & Beverage Misc. - Income |
Vacancy, concessions and bad debt | (Apartment) (Commercial) (Bad Debt) (Rent Free Units) (Loss to Lease) (Concessions) (Misc. – Vacancies) |
Total operating revenue | Sum of Rental and other income + Vacancy, concessions and bad debt |
General and administrative | Office Supplies Renting Expense Legal Expenses Misc. – Admin Expenses Telephone, Cable, and Interest Other (under Insurance) Supportive Services |
Audit and tax preparation fee | Audit and tax preparation fee |
Marketing | Marketing |
Payroll | Employee Benefits Payroll Taxes Workers Comp Mgr/Superintendent Assistance Manager Leasing Coordinator Misc. – Admin Payroll Supervisor Assistants Misc. – Maint Payroll |
Management and bookkeeping | Bookkeeping Fee Property Management Fee Management Fee Bookkeeping |
Insurance | Property & Liability Flood Earthquake |
Real estate taxes | Real Estate Taxes |
Repairs and maintenance | General Supplies Contracts Elevator Security Pest Control Pool Supplies/Service Grounds Maintenance Heating/Cooling Snow Removal Misc. – Ops &; Maint Repairs and Maintenance Decorating and Janitorial |
Utilities | Fuel Oil/Coal Gas Electricity Water Sewer Trash Other Water/Sewer |
Total operating expense | Sum of Expense line items |
Net operating income | Total Operating revenue - Total Operating expense |
Interest income | Other Accounts Interest Interest Income |
Investor fee | Investors Fees |
Interest expense – hard debt | Hard Debt Interest |
Interest expense – soft debt | Soft Debt Interest |
Financing and compliance Fees | Mortgage Insurance Premium Misc. Financial Expenses |
Incentive management fees | Incentive Management Fee |
Other non-operating expenses | Common Area Maintenance Expense Fidelity Bonds Ins. Franchise Tax Personal Property Compliance Fees Hotel – Rooms Hotel – Food & Beverage Hotel Incentive Fee Other Non Recurring Items Other Income/(Loss) Misc. – Other Expenses Loss On Impairment on Fixed Assets (Partnership Fees) |
Depreciation and amortization | (Depreciation) (Amortization) |
Total other income (expenses) | Sum of Other income (expenses) line items |
Net (loss) income | Net Operating Income minus Total Other Income (expenses) |
Investor limited partner’s share of net (loss) income | Net (loss) income X Percentage |
Percentage | The Ownership percentage for the selected Syndicated Fund |