0

Iceberg Whitepine Debt Quote

Fresh

Whitepine — debt quote update: 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.

Whitepine — debt quote update

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-whitepine-debt-quote

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

python -m iceberg_finance_whitepine ./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

WHITEPINE — DEBT QUOTE UPDATE

BUSINESS ASSIGNMENT Replace the financing in an acquisition model with an indicative quote. Size the loan to the most restrictive lender test and show the impact on equity, annual debt service, payoff and levered returns. This is a property-level financing task, not an LP-equity waterfall update.

CONTENTS Starting Model: RV_Pro Forma_7600 Whitepine_Final.xlsx — supplied six-tab property model. Reference Files: Integrated Global Richmond - OM.pdf — original property background. Retain the model's operating assumptions for this assignment rather than re-underwriting the OM. Synthetic References:

  • Whitepine - Indicative Loan Quote.docx
  • Whitepine - Underwriting Email.docx Both documents are synthetic and authored for this package. The quote is not an actual lender commitment. Proposed GT: Whitepine - Revised Debt Underwriting.xlsx — newly authored derivative of the starting model, with an explicit Loan Sizing sheet and revised financing links. Request.txt — suggested business assignment.

CORE TERMS Lowest of 70% of purchase price/agreed value, a 1.35x DSCR test, and 10% debt yield. Use first full projected year NOI, 8.25% annual interest, interest-only debt service and rounding down to $1,000. Three-year term with payoff at the modeled year-three sale; no refi. Origination 1%; existing mortgage brokerage 0.75%; equity funds fees. Preserve the original property and exit assumptions. Actual LTV is the result of the binding sizing test; it is not necessarily the 70% ceiling. Do not leave the old purchase-price-times-LTV loan formula linked circularly to an effective-LTV output.

SME PROMPT IDEAS Use Request.txt with the starting model and synthetic documents. The original OM is optional context. Ask for an Excel model with visible sizing and a concise investment comparison, including the trade-off between reduced leverage and a higher rate. Withhold Proposed GT and this guide from the model. The SME owns scope, final task and scoring.

LEAN GRADING / VERIFIER HINTS

  1. Correct sizing: all three limits, NOI basis, binding test and commitment rounding; fees use the sized loan, not the LTV cap.
  2. Financial integration: loan, rate and fees flow into initial equity, debt service and payoff without circularity or double counting. Property NOI and sale assumptions remain consistent.
  3. Useful comparison: distinguish rate from total interest dollars and explain the effect on required equity, coverage and levered returns. Compare numeric sizing outputs and a small set of linked financial outputs after native recalculation, plus review formulas and explanation. Exact sheet layout is not required. No final automated verifier is supplied.

SME CHECKPOINTS Using the source's stored year-one NOI of $589,977.8425125, the DSCR limit binds. Round down to a $5,297,000 loan; annual interest-only debt service is $437,002.50 and the origination fee is $52,970. These checkpoints are for SME review, not model inputs in a reconstruction task. The proposed target was authored for this synthetic quote; no historical model is claimed to implement these exact terms. An independent calculation checks sizing, coverage and fees. Native Excel recalculation and full return-output validation have not been performed. Recalculate and approve the target before authoritative scoring.

SOURCE MODEL REVIEW NOTES The source model contains a legacy Pro Forma_LEX sheet with many pre-existing #REF! formulas, and Leasing!F12 also contains a pre-existing #REF!. They have not been silently repaired. The active assignment concerns the Pro Forma sheet. Review dependency impact and calculated outputs before treating the target as grading-ready; do not assume every workbook error is introduced by the model being evaluated. The source asset-type label says Retail despite the industrial property context. Treat this as inherited metadata to review, not a new business assumption. Original files remain unchanged.

OTHER TASK IDEAS A. Amortizing quote Add a different rate/amortization term and specify annual versus monthly payment conventions. Judge sizing from amortizing debt service and the remaining principal at sale. Requires adapted GT. B. Two lender offers Supply a second quote with different limits, fees and prepayment terms. Judge complete equity and return effects, not merely the lowest coupon. Requires adapted GT. C. NOI sensitivity Supply revised lender NOI or define the permitted underwriting adjustments. Judge whether the binding sizing constraint changes. Requires adapted GT. D. Refinance instead of sale Specify timing, new sizing terms and transaction costs. Judge replacement debt, payoff, net proceeds and post-refinance returns. Requires adapted GT.

WHY THIS CANDIDATE A familiar property model makes the business assignment clear while lender constraints require financial reasoning. The task connects a commercial quote to formula-driven loan sizing and investment economics without requiring another real-estate software tool.

STATUS Local review pack, not a certified evaluation. No de-identification, model runs or Prime upload. Historical ambiguous LP-equity models are excluded. Target and synthetic documents need SME approval; native recalculation remains outstanding.