Skip to main content Home Creators mariourquia cre-skills-plugin reforecast
reforecast Produces a reforecast that inherits actuals through the as-of month, preserves or revises
forward-looking assumptions with citation, and surfaces the delta vs. budget and vs.
prior forecast. Includes forecast-accuracy calibration and NOI sensitivity.
Jump to install Skills Marketplace Discover and explore AI skills built by the community.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Show prompt details A direct command skips the review prompt. Inspect the source before running it.
npx skills add https://github.com/mariourquia/cre-skills-plugin --skill reforecastThe command stays on one line. Scroll horizontally to inspect it before copying.
Prefer a local copy? Download the files currently available to SkillsMP.
Download Zip Downloading... More from this repository
acquisition-underwriting-engine Full-cycle acquisition underwriting engine. Takes a deal package (rent roll, T-12, OM, financing terms) and produces institutional-quality output: T-12 normalization, 10-year proforma, Linneman cap rate decomposition, probability-weighted scenarios, replacement cost analysis, and go/no-go recommendation. Triggers on 'underwrite this deal', 'build an acquisition model', or 'run the numbers on this property'.
amos-icomm-demo-orchestrator Thin demo conductor that sequences the reusable CRE acquisition skills into one end-to-end Investment Committee workflow: data-room intake, document extraction, rent-roll analysis, T-12 normalization, PCA reserve analysis, agency debt analysis, full underwriting, sensitivity stress test, IC memo generation, red-team challenge, source verification, and IC Q&A context. It orchestrates and hands off; it does not re-derive numbers itself. Every stage proposes work for human review and pauses at named gates. Triggers on 'run the IC workflow', 'take this deal from data room to IC', 'orchestrate the acquisition', or 'walk this deal to committee'.
Related occupations SOC
Based on SOC occupation classification
reference_manifest.yaml 2.3 KB name Reforecast slug reforecast version 0.1.0 status draft category residential_multifamily subsystem residential_multifamily pack_type workflow targets ["claude_code"] stale_data Same assumptions as budget_build. Reforecast inherits live actuals through the asof
month and preserves forward-looking assumptions unless overlay cites a change basis.
Forecast accuracy is a trailing-6-month metric; drift informs assumption recalibration.
applies_to {"segment":["middle_market"],"form_factor":["garden","walk_up","wrap","suburban_mid_rise","urban_mid_rise"],"lifecycle":["stabilized","renovation","lease_up","recap_support"],"management_mode":["self_managed","third_party_managed","owner_oversight"],"role":["property_manager","regional_manager","asset_manager","reporting_finance_ops_lead"],"output_types":["operating_review","memo","kpi_review"],"decision_severity_max":"action_requires_approval"} references {"reads":["reference/normalized/payroll_assumptions__{org}.csv","reference/normalized/insurance_tax_assumptions__{market}.csv","reference/normalized/utility_benchmarks__{market}.csv","reference/normalized/market_rents__{market}_mf.csv","reference/normalized/concession_benchmarks__{market}_mf.csv","reference/normalized/collections_benchmarks__{region}_mf.csv","reference/normalized/unit_turn_cost_library__{market}.csv","reference/derived/budget_escalator_assumptions__{market}.csv","reference/normalized/approval_threshold_defaults.csv"],"writes":[]} metrics_used ["noi","noi_margin","forecast_accuracy","revenue_variance_to_budget","expense_variance_to_budget","economic_occupancy","collections_rate","bad_debt_rate","concession_rate","dscr","debt_yield","budget_attainment"] escalation_paths [{"kind":"forecast_final_submission","to":"asset_manager -> finance/reporting lead -> approval_request(row 14 for lender)"},{"kind":"owner_submission","to":"asset_manager -> executive -> approval_request(row 15 or 16)"}] approvals_required ["final_forecast_submission"] description Produces a reforecast that inherits actuals through the as-of month, preserves or revises
forward-looking assumptions with citation, and surfaces the delta vs. budget and vs.
prior forecast. Includes forecast-accuracy calibration and NOI sensitivity.
Reforecast
Workflow purpose
Take the latest actuals, combine with forward assumptions, and produce a reforecast that shows how year-end is likely to land vs. budget and prior forecast. Preserve assumption trail. Cite every revision.
Trigger conditions
Explicit: "reforecast Q2", "update forecast", "year-end landing", "roll forecast through December".Implicit: as-of month closes; material variance vs. prior forecast; market-side event (rent comp update, insurance renewal, tax reassessment).Recurring: per org overlay calendar (often monthly or quarterly).
Inputs (required / optional)
Input Type Required Notes Actuals through asof table required GL closed through month Prior forecast table required for delta tracking Budget table required anchor Rent roll snapshot table required for forward revenue Assumption references csv / yaml required all budget_build refs Change basis notes memo optional any revision > overlay materiality
Outputs
Output Type Shape Reforecast by line item table monthly through year end NOI + margin + covenant view kpi_reviewbudget vs. prior forecast vs. new forecast Delta commentary memorevisions and basis Forecast accuracy view kpi_reviewforecast_accuracy trailing 6Owner submission draft operating_reviewif applicable
Required context
Asset_class, segment, form_factor, lifecycle_stage, management_mode, market.
Process
Snapshot actuals through asof. Confirm GL close; flag any open items.
Compute variance to budget (MTD, YTD, RTG). revenue_variance_to_budget, expense_variance_to_budget. Classify drivers.
Forward revenue. Roll forward leases; apply current market reference and concession posture; revise if actuals show drift.
Forward expense. Apply escalators and assumptions; any revision cites basis (overlay update, re-bid, known scope change).
Recompute NOI, margin, DSCR, DY.
Forecast accuracy calibration. Compute trailing forecast_accuracy; surface systematic bias.
Sensitivity. Overlay stress cases on forward months.
Comparison table. Budget vs. prior forecast vs. new forecast.
Submission path. Owner or lender final submission opens approval_request row 14 / 15 / 16.
Confidence banner. All reference as_of_date and status tags surfaced.
Metrics used noi, noi_margin, forecast_accuracy, revenue_variance_to_budget, expense_variance_to_budget, economic_occupancy, collections_rate, bad_debt_rate, concession_rate, dscr, debt_yield, budget_attainment.
Reference files used Same as budget_build (assumption inheritance).
Escalation points
Final submission: row 14 (lender), 15 / 16 (LP / board).
Assumption revision above overlay materiality: asset_manager sign-off.
Required approvals
Final forecast submission (row 14 / 15 / 16).
Failure modes
Silent assumption change. Fix: every revision cites basis; change basis memo required above materiality.
Not recalibrating when forecast_accuracy shows bias. Fix: calibration is a step.
Forward revenue built on stale market reference. Fix: surface staleness; if > overlay threshold, refresh first via workflows/market_rent_refresh.
Submitting final to lender without approval. Fix: row 14 gate.
Edge cases
Property mid-renovation: split classic and renovated unit lines; distinct assumptions.Debt refi during remaining year: sensitivity on DSCR / DY post-refi; flag timing uncertainty.Insurance renewal pending: hold assumption at current rate with sensitivity; cite pending renewal.Tax reassessment filed: show appeal scenario alongside base.Lease-up still active: stabilization pace remains anchor; reforecast tied to stabilization_pace_vs_plan.
Example invocations
"Reforecast Ashford Park through year end using March actuals."
"How is Willow Creek landing vs. budget this year?"
"Build the quarterly reforecast for the South End portfolio."
Example outputs
Output — Reforecast summary (abridged, Ashford Park, asof 2026-03) Actuals through March. Revenue within band vs. budget; expenses showing utilities drift per seasonal pattern.
Forward revenue. Roll-forward applied; market reference refreshed 2026-03-31; concessions tracking overlay.
Forward expense. Utilities assumption revised with basis memo; insurance held at current rate pending renewal.
Year-end landing. NOI within band of budget; noi_margin within overlay target; dscr and debt_yield meet covenants.
Forecast accuracy. Trailing 6 months within overlay band.
Submission. Owner draft prepared; approval_request row 15 opened.
Confidence banner. Assumption references carry as_of_date and status. Change basis memo attached for utilities revision.
