0

Iceberg Broadway Seller Leaseback

Fresh

Broadway — Excel-only leaseback screen: native files for SME-led task creation

Type
RL Env
Publisher
Iceberg
License
unknown
Size
v0.1.0
Published
Nov 2026
Updated
Nov 2026

Cite

Notes

Only stored in your browser.

Broadway — Excel-only leaseback screen

Private pilot review pack for SME-led task creation. The source documents retain real business identifiers; de-identification has not been performed. This package has not been approved for public release.

Includes a native Starting Model, Reference Files, clearly labeled Synthetic References, Proposed GT, a suggested Request.txt and a Start Here.txt guide with task/grading ideas and known limitations.

This is a document bundle, not an executable Verifiers evaluation. No model scores, difficulty calibration, final verifier or independently certified answer key is included. Native Excel recalculation and financial review remain outstanding where described below. Authored/derived GTs are distinguished from existing business-model versions.

Retrieve files

prime env pull iceberg/iceberg-broadway-seller-leaseback

The native files are under iceberg_finance_broadway/materials in the pulled package. From the pulled directory, optionally export into a new folder:

python -m iceberg_finance_broadway ./Financial-Model-Materials

The customer SME receives the full package. Withhold Proposed GT and SME guidance from the model for reconstruction tasks; folder separation alone is not access isolation.

SME guide

BROADWAY — SELLER LEASEBACK

ASSIGNMENT Evaluate a proposed seller leaseback against the existing acquisition case, working entirely in XLSX. Calculate the monthly rent difference and flow it into the existing underwriting. No ARGUS software, file regeneration or model export is required.

FILES Starting Model: 836 Broadway - AREP Run - 7.26.21 v4 (Base Case).xlsx — original supplied model, unchanged. Reference Files:

  • Bullet Points For 836 Broadway(v2).docx — original business overview supporting the leaseback concept.
  • Retail Rent Assumptions.xlsx — prepared input schedule identifying baseline and proposed terms, sources and screening conventions. Synthetic References:
  • Broadway - Seller Leaseback Terms.docx
  • Broadway - Underwriting Email.docx Both Word documents are synthetic and authored for this pack, not historical correspondence. Proposed GT: Broadway - Excel Leaseback Screen.xlsx — newly prepared Excel-only reference calculation, derived from the original base workbook. The historical owner-leaseback model is retained in internal build records, not supplied as this task's answer. Request.txt — suggested business request.

KEY REASONING The ground floor is 8,000 SF and the basement is 6,747 SF. $75/SF applies only to the ground floor; basement use has no separate rent. The 60-month lease begins September 1, 2021; ten free months end June 2022; first payment is July 2022. Annual 2.75% increases begin September 1, 2022, rather than twelve months after the first payment. The baseline rent-roll report commences the ground-floor lease September 1, 2023, at $104/SF with ten free months. The input schedule supplies the full unrounded convention used for the comparison. Do not add new owner rent on top of the existing retail rent without removing the corresponding baseline rent within the screen.

CORE SCOPE This is an initial rent sensitivity over September 2021–August 2026. Hold other original property forecasts fixed, including existing TI, LC, expense recoveries, vacancy/credit-loss amounts, management fees and other operating costs. Preserve existing formula-driven cash-flow, financing and return links. From September 2026 onward, resume the original baseline path with zero incremental leaseback adjustment. This is a deliberate screening convention, not a forecast of actual new leasing at expiry. Legacy export tabs remain baseline data. They need not be regenerated or made to look like a new export. A transparent Excel schedule or equivalent calculation is appropriate. Judge coherent cash flows, not matching a report layout.

SME PROMPT IDEAS Use Request.txt and the selected input files. Ask for a revised native workbook plus a concise investment note. An optional emphasis is whether earlier cash receipts compensate for lower contractual retail rent during the overlap with the baseline lease. Withhold Proposed GT and this guide from the model. The SME owns final task scope, prompt and grading.

LEAN GRADING / VERIFIER HINTS

  1. Correct rent economics: eligible area, no separate basement rent, commencement, ten free months and anniversary escalations.
  2. Correct integration: remove the baseline retail rent contribution when substituting owner rent within the screen, retain other scoped forecasts, and show a transparent monthly bridge with no adjustment after the screen.
  3. Useful analysis: linked model outputs and a clear comparison; explain the held-constant assumptions and what a fuller decision requires. Compare the monthly rent bridge and scoped output differences with a tolerance appropriate to source rounding. Do not require identical cells or tab layout. No final executable verifier is supplied.

PROPOSED GT STATUS The derived workbook adds a live Leaseback Screen and overlays gross-rent and abatement differences into CF. All original source files are preserved. Formula caches have been cleared in the derived target and full recalculation requested; open it in Excel and recalculate before relying on displayed financial outputs. An independent calculation checks rent boundaries and the rent bridge. Native Excel recalculation and full investment-return validation have not been performed. The historical owner-leaseback workbook has broader changes in exported forecasts, costs and occupancy. It is not an exact GT for this scoped screen. The derived target is a proposed reference, pending SME approval.

OTHER TASK IDEAS

  • Full leasing case: add complete leaseback TI/LC, expense-recovery, occupancy-driven cost and post-expiry leasing terms. Supply any baseline tenant schedules needed for replacement. Create an expanded GT; do not use this rent-only screen to grade the full case.
  • Negotiate rent versus free rent: supply alternative LOI terms and compare cash flow or a defined discounted value.
  • Delay commencement or change term: specify who occupies during the gap and the treatment of concessions and expiry; adapt the GT.
  • Break-even leaseback rent: specify a return or value hurdle and fixed comparison assumptions; adapt the GT.

READINESS Local review pack only. No de-identification, model runs or Prime upload. All authored materials and scope changes are identified. No ARGUS license, application or regeneration is needed.