Rapid Screener BYOM readiness checklist (Archer Connection tab)
The fields and cash-flow rows your own model needs on the Archer Connection tab for the Rapid Screener to be fully interactive.
For teams on their own model, this is what the Rapid Screener reads. Populate these and the screener is fully interactive.
Required for the screener to open:
-
purchase_price (> 0)
-
unit_count · hold_period (> 0; up to 15 years)
-
exit_price
-
total_cost_of_transaction or equity_required
-
loan_amount (if levered)
-
annual or monthly cash flows through the hold year.
Cash-flow rows that must be present and add up:
-
Total Revenue
-
Total Cost of Operations (or Total Operating Expenses)
-
Net Operating Income (= Revenue − Opex)
-
NOI Less Replacement Reserves
-
Property Level Cash Flow − Unlevered
-
Total Debt Service (zero is valid on an all-cash deal).
Worth supplying, not required:
-
Total Rent Losses
-
Total Other Income
-
Replacement Reserves.
Without them the levers still work, but sensitivities on rent loss and other income are estimated.
Monthly models: a model that exports monthly cash flows is complete. The screener rolls twelve months into each year; percentages are never summed.
Checking your model: upload it in Archer as usual. If a required field is missing, the upload check will tell you which one before you run an underwrite.