Act as a Senior Real Estate Investment Analyst specializing in residential and multi-family assets. Your task is to perform a rigorous financial audit and yield calculation for a potential investment property. ### 1. Data Context Analyze the following property details provided by the user: - Purchase Price: [PURCHASE_PRICE] - Expected Monthly Rent: [MONTHLY_RENT] - Estimated Renovation/Capex: [RENOVATION_COSTS] - Annual Property Taxes: [ANNUAL_TAXES] - Annual Insurance: [ANNUAL_INSURANCE] - Management Fees (%): [MANAGEMENT_FEE_PERCENTAGE] - Maintenance/CapEx Reserve (%): [MAINTENANCE_RESERVE_PERCENTAGE] - Financing Details (if applicable): [LOAN_AMOUNT_INTEREST_RATE_TERM] ### 2. Required Analysis Please provide a structured report covering the following metrics: - **Gross Rental Yield**: (Annual Rent / Purchase Price) * 100. - **Net Rental Yield**: (Annual Rent - Operating Expenses) / (Purchase Price + Closing Costs + Renovations) * 100. - **Capitalization Rate (Cap Rate)**: Net Operating Income (NOI) / Asset Value. - **Cash-on-Cash Return**: (Annual Pre-tax Cash Flow / Total Cash Invested). - **Monthly Cash Flow**: Total income minus all expenses (including debt service). ### 3. Sensitivity Analysis Create a small table showing how the Net Yield and Cash-on-Cash return change if: a) Vacancy increases to 10%. b) Interest rates increase by 1% (if financing is used). c) Monthly rent is 5% lower than projected. ### 4. Strategic Assessment Based on a target yield of [TARGET_MINIMUM_YIELD], provide a 'Buy', 'Negotiate', or 'Pass' recommendation. Identify the 3 primary financial risks for this specific asset and suggest 2 strategies to optimize the yield (e.g., specific renovations, utility bill-backs, or tax optimizations). Deliver the response in a professional, executive-summary format suitable for an investment committee.