Real Estate Case Study You are evaluating the purchasing a Low-Income Housing Tax Credit (LIHTC) property, Poinciana Crossing LTD, in Fort Lauderdale. The complex is 164 unit made up of 50 one bedrooms, 50 two bedrooms, 50 three bedrooms, and 14 four bedrooms. The property qualifies for tax credits and the rents are capped based on medium incomes in the County. You expect to close on December 20, 2021. The year end is December 31st.

Poinciana Crossing has provided the property income statement and balance sheet for the year ended December 31, 2021. The financial statements fairly reflect the operating condition of the property.

The books are maintained on an accrual basis. To prepare for the sale of the property, Poinciana Crossing made substantial capital repairs. You will not have these expenses in the future.

Rents are: Unit Rent per month 1 bedroom 725 2 bedrooms 825 3 bedrooms 900 4 bedrooms 1050 Purchase price was negotiated at $6,200.000. The purchaser negotiated a new mortgage with the local bank at 80% LTV at 3.50% interest, fixed for 25 years. The bank agreed to the mortgage if the property maintains a minimum DSCR of 1.15. Vacancy is estimated at 3% and collection losses at 1%. Only Gross Potential Rent is expected to grow at 1.5% and expenses at 2 % each year. Based on the property appraisal land value is estimated at $500,000. Taxes are estimated to be $175,0000 and insurance is $125,000. Fixed and variable expenses are expected to be the same. The purchaser requires a capitalization rate of 6.25%.

PLEASE ANSWER THE BELOW PROBLEMS 1-8 using all information provided.

Using the accompanying financial statements calculate; 1. Net operating income for 2022 to 2025. 2. Debit Service (P&I) 3. Annual cash flow 4. DSCR for each year 5. Value of the property based on the 2022 operations. 6. Depreciation in each year 7. Projected Taxable income. 8. Discuss the relationship between depreciation and cash flow.

Poinciana Crossing LTD Balance Sheet December 31, 2021 Poinciana Crossing LTD Balance Sheet December 31. 2021 Poinciana Crossing LTD Income Statement For the year ended December 31, 2021 Income Rental Income Dwelling Rental Income Collection Loss Laundry Income Late Fees Total Income 1,589,500.00(64,000.00)6,700.003,375.001,535,575.00 Expenses Payroll \& Related Administrative Salaries Maintenance Wages Social Security \& Medicare Group Benefits Total Payroll \& Related 87,000.00102,000.0014,450.0030,000.00233,450.00 Administrative Expenses Advertising Auditing Fees Office Supplies Telephones Other administrative expenses Management Fees Total Administrative Expenses 600.0014,500.008,900.003,500.0021,500.0067,000.00116,000.00 Utilities Water \& Sewer Electricity Sewer Expense Garbage and Trash Removal Total Utilities Poinciana Crossing LTD Income Statement For the year ended December 31, 2020 Maintenance \& Repairs General maintenance Exterminator Contract Air Conditioning Contracts Landscaping Contracts Site maintenance Plumbing Repairs Painting Expense Security Expense Total Maintenance \& Repairs 137,500.0015,500.007,800.0018,500.0037,300.006,800.0010,100.0061,850.00295,350.00 Taxes \& Insurance Property \& Liability Insurance Property Taxes Total Taxes \& Insurance 138,000.00164,000.00302,000.00 General Expenses Capital Expenditures Depreciation \& Amortization Expense Interest Expense Total General Expenses Total Expenses Net Income/(Loss) 285,000.00123,400.0066,325.00474,725.001,716,525.00(180,950.00)