ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
LLM MODEL POPULATION GUIDE
2
Use this tab to populate the workbook without breaking the template. Blue inputs may be edited; formulas and structure must be preserved.
3
Section / TabPurpose / LogicLLM MAY ChangeLLM MUST NOT Change
4
WORKBOOK STRUCTURE
5
Instructions & SummaryDisplay-only summary and navigation sheet. Key outputs flow here from downstream tabs. Property name display is driven from A1/C16.Update A1 only if the user explicitly changes the property name. Leave address/type alone unless the user gives a specific destination for them.Do not overwrite formulas in C6:C12, C19, or C26:C32. Ignore legacy references to deleted tabs in rows 44:46.
6
AssumptionsPrimary global input sheet. Drives growth, rollover, loan terms, discount rate, exit cap, and other core assumptions. Note: C8 is formula-driven.Populate only C5:C7, C9:C10, C14:C27, C31:C38, and C42 with sourced inputs.Do not overwrite C8 or any labels/headers. Do not insert rows or columns.
7
Rent RollTenant input engine for up to 20 tenants. Rows 5:24 are the only tenant input rows. Forecast rent and rollover logic are formula-driven.Populate B5:M24 for active tenants and leave unused rows blank.Do not edit N:X on input rows or formula blocks in rows 25:132. Do not insert extra tenant rows; if more than 20 tenants are needed, stop and ask.
8
Revenue ProjectionAggregates gross rent and rent adjustments from Rent Roll. Also includes hardcoded reimbursements and other-income lines.Populate only hardcoded blue lines B13:M15 and B19:M20 when source data exists.Do not overwrite linked rows C5:M10 or total lines. Do not force forecast outputs by hardcoding formula cells.
9
Expense ProjectionForecasts OpEx from base-year hardcodes and management fee as a percent of EGI. Forecast years are formula-driven.Populate only B5:B17 and B23:B26 when source data exists.Do not overwrite forecast columns C:M or the management fee formula in row 22.
10
Operating Pro FormaCombines revenue and expenses into EGI, OpEx, NOI, and per-SF metrics.No manual edits unless the user specifically asks for a formula repair.Do not edit formulas or presentation rows. Treat this tab as output-only.
11
Capital ExpendituresCalculates TI, LC, reserves, building improvements, and net cash flow from rollover assumptions and lease expirations.No manual edits unless the user specifically asks for a formula repair.Do not hardcode TI/LC totals or edit the formula blocks in B6:M18 or B26:M26.
12
Debt ScheduleCalculates annual debt service and ending balances from Assumptions loan terms.No manual edits beyond source inputs on Assumptions.Do not overwrite formulas in B13:M24 or change debt math to force ratios.
13
Levered Cash FlowOutputs debt service coverage, cash flow after debt service, and debt yield.No manual edits.Do not edit formulas or replace '-' outputs with hardcodes.
14
Unlevered DCF ValuationDiscounts unlevered cash flow and terminal value. Driven by Assumptions discount rate / exit cap and upstream NOI / CapEx.No manual edits beyond source inputs on Assumptions.Do not edit formulas, residual value logic, or total valuation cells.
15
INPUTS REQUIRED
16
Property-level assumptionsAnalysis date, projection period, discount rate, exit cap rate, market rent growth, renewal assumptions, TI/LC, free rent, credit loss, reserves, management fee, building improvements, and loan terms.Enter only sourced values in the designated Assumptions input cells.Do not guess missing inputs. Leave them blank or flag them explicitly.
17
Tenant-level inputsFor each tenant provide name, suite, leased SF, lease start/end, Exp Year, current rent per SF, escalation, market rent, renewal probability, downtime, and lease type.Populate one tenant per row within Rent Roll rows 5:24.Do not use placeholders like TBD or N/A in numeric/date cells.
18
Revenue hardcodesExpense reimbursements and other income may be hardcoded if they come from source materials or user instructions.Use Revenue Projection B13:M15 and B19:M20 only.Do not create new revenue lines or overwrite lines linked from Rent Roll.
19
Expense hardcodesBase-year taxes, insurance, CAM, other expenses, vacancy utilities, and professional/admin fees can be populated from source materials.Use Expense Projection B5:B17 and B23:B26 only.Do not edit forecast columns C:M or add new categories without approval.
20
MODEL CONVENTIONS
21
Color legendBlue font = editable hardcodes / inputs. Green font = cross-sheet links. Black font = local formulas / calculations. White on navy = title bars.Use color as a permission system when deciding what to touch.Do not recolor the workbook unless the user explicitly asks.
22
Exp Year conventionExp Year is a relative rollover bucket used by formulas, not a raw calendar year.Use the current model convention: 0 = expires during Year 1; 1 = survives Year 1 but expires before Year 2; etc.Do not change formulas to fit a different convention. Adjust the input value instead.
23
Units / formatsCurrency cells are whole dollars, rent inputs are annual $/SF, SF is whole square feet, percentages should respect the cell percent format, and dates must be true Excel dates.Enter values in existing formatted cells and let Excel handle display.Do not paste text into numeric or date cells.
24
Calculation flowAssumptions + Rent Roll -> Revenue Projection / Expense Projection -> Operating Pro Forma -> Capital Expenditures + Debt Schedule -> Levered Cash Flow / Unlevered DCF.Use downstream tabs only to validate that inputs flow correctly.Do not bypass this flow by writing directly to output tabs.
25
Guardrails / placeholdersThe workbook now returns '-' or 0 in guarded cells when required inputs are missing.Populate missing source inputs to resolve placeholders naturally.Do not replace guarded formulas with hardcoded numbers just to remove '-'.
26
WHAT THE LLM CAN CHANGE
27
Allowed edits1) Blue-font input / hardcode cells. 2) Instructions & Summary A1 if the user explicitly changes the property name. 3) Unused tenant rows within Rent Roll 5:24. 4) Cell comments/notes if needed to document sources.Stay within the designated input areas and preserve the existing structure.If a requested change requires structural edits, stop and ask first.
28
WHAT THE LLM CANNOT CHANGE
29
Forbidden structural changesSheet names, sheet order, row order, formulas, headers, number formats, and model color coding are part of the template.None.Do not add, delete, or rename sheets, rows, or columns. Do not recreate deleted tabs such as Refinance Analysis or OSAR unless explicitly asked.
30
Forbidden formula changesAll green and black formula cells are calculation logic or outputs.None.Do not overwrite formulas to force a target output. Do not convert formula regions to hardcodes.
31
Forbidden output editsSummary, pro forma, debt, levered cash flow, and DCF outputs must update from inputs only.None.Do not enter manual values on output tabs even if a number is missing; fix the source input instead.
32
FINAL QA BEFORE HANDOFF
33
Validation checklistAfter populating inputs, confirm: no Excel errors, totals populate, debt service calculates, DCF updates, and unused tenant rows remain blank.Use downstream output tabs only for validation.Do not finish with broken links, mixed units, or unexplained blanks.
34
If something is missingIf source data is incomplete or more than 20 tenants are needed, stop and list the missing information and exact target cells/ranges.Flag the exact gap clearly for the user.Do not invent data or restructure the workbook without permission.
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100