Prompt Details
Model
(claude-5-opus)
Token size
872
Example input
[FINANCIAL_DATA]: Asset: Sunbelt Vista Apartments (120 units). Asking Price: $14,500,000. Broker Stated T12 NOI: $870,000. Target Capitalization Rate: 6.0%. Anomalies noted in ledger: T12 Maintenance is logged at $42,000 ($350/unit/yr). T12 Payroll is logged at $80,000.
[PHYSICAL_AND_CONTRACT_DATA]: Physical inspection notes elevated moisture readings behind drywall in 15 first-floor units; plumbing infrastructure is original cast iron. Property management contract specifies it auto-renewed 30 days ago for a 3-year term at 6% of gross revenue, includes a 3% disposition fee upon asset sale, and enforces a $150,000 successor buyout penalty if terminated by a new owner.
Example output
Example 1: Class B Multifamily Value-Add Acquisition Audit
[INPUTS]
Broker T12 & Target Cap Rate: Asset: Sunbelt Vista Apartments (120 units). Asking Price: $14,500,000. Broker Stated T12 NOI: $870,000. Target Capitalization Rate: 6.0%. Anomalies noted in ledger: T12 Maintenance is logged at $42,000 ($350/unit/yr). T12 Payroll is logged at $80,000.
Inspection & Contract Data: Physical inspection notes elevated moisture readings behind drywall in 15 first-floor units; plumbing infrastructure is original cast iron. Property management contract specifies it auto-renewed 30 days ago for a 3-year term at 6% of gross revenue, includes a 3% disposition fee upon asset sale, and enforces a $150,000 successor buyout penalty if terminated by a new owner.
[SIMULATED OUTPUT]
Forensic Pro Forma Audit
The structural audit of Sunbelt Vista Apartments reveals a discrepancy of $102,000 between the broker's stated NOI of $870,000 and the normalized NOI of $768,000. The seller has aggressively engineered the T12 ledger by operating without on-site management and deferring critical plumbing maintenance, artificially inflating the yield to meet the target valuation parameters of retail buyers.
The physical asset is operating in a state of terminal degradation masked by cosmetic neglect. The reported maintenance expenditure of $350 per unit annually is an impossibility for a 120-unit asset with original cast iron plumbing. The moisture readings in the first-floor units indicate systemic sub-slab pipe failure, not isolated tenant damage. Furthermore, the recently renewed property management contract is a hostile encumbrance designed to extract capital from the incoming ownership group.
The Financial Threat Matrix
OpEx & Labor Deficit: $102,000 (Payroll must be normalized by +$60,000 to sustain a full-time on-site manager and maintenance technician; routine maintenance reserves must be normalized by +$42,000 to match institutional baselines of $700/unit/yr).
Hidden CapEx Threat: $185,000 (Required on day one for sub-slab cast iron plumbing extraction, replacement, and subsequent drywall remediation across 15 first-floor units to halt active water intrusion).
Contractual Liability Exposure: $150,000 (Liquidated damages penalty required to buy out the predatory, auto-renewed property management contract and assume operational control).
Total Immediate Capital Exposure: $335,000
Valuation Recalculation
Based on the normalized NOI of $768,000 and the target capitalization rate of 6.0%, the true operational valuation of the asset is $12,800,000. The broker's asking price of $14,500,000 represents a $1,700,000 overpayment for fabricated yield.
Operational Retrade Directive
Pursuant to the findings of our due diligence physical and financial audit, the buyer requires a mandatory purchase price reduction to $12,800,000 to reflect the stabilized NOI of $768,000. In addition, the buyer requires a firm seller credit at closing in the amount of $335,000 to offset the immediate capital requirements for the cast iron plumbing remediation and the termination penalty for the existing property management contract. Execution of this transaction is strictly contingent upon the seller clearing these encumbrances prior to the expiration of the inspection period.
By purchasing this prompt, you agree to our terms of service
CLAUDE-5-OPUS
Streamline your commercial real estate due diligence. This prompt analyzes user-provided text from T12 financials, physical inspection notes, and vendor contracts. Instead of manually cross-referencing disparate files, the AI structures your pasted data into a clear operational vulnerability summary and drafts negotiation talking points based strictly on the text provided, helping you organize your acquisition data.
...more
Added 1 day ago
