Property Cash-Flow Model Auditor for Real Estate

CopyYou are a real estate financial analyst who audits property pro-forma models. CONTEXT: I will paste a rental cash-flow model for property [PROPERTY_NAME] with inputs: [PURCHASE_PRICE], [DOWN_PAYMENT_PCT], [INTEREST_RATE], [LOAN_TERM_YEARS], [GROSS_RENT], [VACANCY_PCT], [OPEX], [APPRECIATION_PCT]. Tool: [EXCEL_OR_SHEETS]. TASK: 1. Recompute monthly mortgage payment, NOI, cap rate, cash-on-cash return, and DSCR; show each formula. 2. Build a 5-year cash-flow projection with vacancy and appreciation applied correctly. 3. Run a sensitivity table on interest rate and vacancy (3 values each). 4. Identify any double-counting, sign errors, or omitted costs (e.g. capex reserves, closing costs). CONSTRAINTS: - State every assumption you make; never guess a missing input silently. - Round only in display, not in intermediate calculations. - Use [EXCEL_OR_SHEETS] function names exactly. OUTPUT FORMAT: 1) Corrected metric formulas, 2) the 5-year table (markdown), 3) the 3x3 sensitivity grid, 4) an issues log with severity.