Fifth Avenue — preferred investor within the club
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-fifth-avenue-preferred-investor
The native files are under iceberg_finance_fifth_avenue/materials in the pulled package. From the pulled directory, optionally export into a new folder:
python -m iceberg_finance_fifth_avenue ./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
FIFTH AVENUE — PREFERRED INVESTOR WITHIN THE CLUB
BUSINESS ASSIGNMENT An investment team is replacing an anchor common-equity proposal with preferred capital inside the investment club. Update the allocation of funding, annual cash flows and exit proceeds, and explain the effect on investor returns. The work is entirely in Excel.
CONTENTS Starting Model: Fifth Ave Model_Updated Structure_April 22 2025.xlsx Proposed GT: Fifth Ave Model_Updated Structure_April 22 2025_PREF IN CLUB.xlsx Reference Files: Egide - US Investment Vehicle Term Sheet - LRT draft 6 Feb 2025(42896090.5).docx Synthetic References: Fifth Avenue - Preferred Investor Proposal.docx Request.txt: suggested assignment.
The preferred investor proposal is synthetic correspondence authored for this pack from observed workbook changes. It is not an authenticated historical email or agreed legal term sheet. The February term sheet and both models are provided business artifacts. The February document describes fund-level distribution terms; it does not establish this April club-level preferred arrangement. Use it as background only.
PROPOSED GT The existing completed preferred-in-club workbook is the proposed target. It changes the anchor contribution from $250m to $150m, replaces pro rata operating participation with $15m annual preferred payments, deducts those payments before distributions to remaining club investors, and removes the $222m terminal lookback. Anchor capital is repaid at exit and residual proceeds go to the remaining club. Property underwriting and the existing JV-to-club allocation are retained. This is a proposed reference output, not independently verified GT. It has not received a native Excel recalculation or SME sign-off for this pack. Basic independent checks against stored outputs support the core scenario; they do not certify every workbook formula or alternate scenario.
SME PROMPT IDEAS Use Request.txt with the starting model, synthetic proposal and optional historical background. Ask for a native revised workbook plus a short investor comparison. Emphasize the relationship between property cash flow, the Ardian/Kering split and the investor-level allocation inside the club. Withhold Proposed GT and this guide from the model. The SME owns final scope, task, grading and any supplementary terms.
LEAN GRADING / VERIFIER HINTS
- Capital and priority: preserve total club capital while reallocating $100m from the anchor to the remainder; compute the 10% preferred cash payments at the club level with no duplicate pro rata entitlement or terminal catch-up.
- Reconciliation: annual preferred plus remainder distributions reconcile to the club cash available; anchor capital plus remaining exit proceeds reconcile to the club’s allocated exit proceeds. Keep property debt service and the JV split in the correct sequence.
- Returns and explanation: calculate investor IRRs/cash yields from the revised contributions and distributions and explain the trade-off with the original structure. Use a few numeric comparisons, formula review and the explanatory note. Do not require identical formatting or every cell address. No final scored rubric or executable verifier is included.
CHECKPOINTS FOR THE SME The proposed target carries $150m preferred capital at 10%, giving $15m annual cash pay for seven years and $150m capital repayment at the end. This stream produces a 10% annual-period IRR without an extra terminal payment. Remaining-club capital rises by $100m as total club capital stays fixed. These are SME checkpoints, not material to supply to the model alongside a reconstruction task. The source target’s lookback-rate field is 10%, but its terminal lookback cash payment is explicitly zero. A rate label alone does not create a separate terminal entitlement. The existing exit waterfall includes later tiers beyond those active in this source case. The current workbook’s Total Club Proceeds formula sums the first two club tiers; do not assume it supports higher-value scenarios without reviewing the later tiers. Preferred shortfall mechanics are not established by this case.
OTHER TASK IDEAS A. Lower operating cash flow Add a leasing/rent update that makes one year’s club cash insufficient for the preferred payment. Specify funding priority, who covers a deficit and whether unpaid amounts accrue or defer. Judge cash reconciliation and treatment of the unpaid amount. Requires adapted GT.
B. Preferred coupon versus common upside Offer two indicative structures with different coupons, capital amounts or residual participation. Specify all payment and exit rights. Judge total funding, priority and investor-level comparison. Requires adapted GT.
C. Earlier exit Supply a disposition instruction after year four or five and specify coupon timing and capital repayment. Judge the shortened cash-flow series and IRRs. Requires adapted GT.
D. Exit-value sensitivity Supply exit cap/sale-price scenarios and ask how proceeds distribute across the JV and then the club. Check all activated waterfall tiers and distributions before using the existing model as a reference. Requires expanded or reviewed GT.
WHY THIS IS A GOOD CANDIDATE The earlier and later workbooks contain a focused, observable change in investor structure. The task requires separating property debt service, joint-venture economics and internal club distributions, while preserving cash and capital across investors. It is distinct from a property-level assumption update.
STATUS Local review pack. Original files remain unchanged. No de-identification, model runs, native Excel recalculation or Prime upload. Synthetic correspondence is clearly segregated. Confirm economics and approve the proposed target before authoritative grading.