Total area
Sq. ft.Carpet + Mezzanine + Utility + OthersSum the four entered area fields for each record. The preview includes Others even where a source Excel total excludes it.
UI previewLPLogipark
Warehouse analysis
Portfolio scale, rental income and asset value in one view.
Calculation reference
Rules used by this HTML preview, including reported values and calculation limits.
Base rent
₹ / monthΣ (Area × matching rent rate) + Extra rentCalculate carpet, mezzanine, utility and other rent separately, then add extra rent once. Rates and extra rent are treated as monthly inputs.
Base CAM
₹ / monthΣ (Area × matching CAM rate)Sum all four area × CAM-rate products. Extra rent is not included.
Annual base rent
₹ crore / yearΣ matching records’ base rent × 12 ÷ 1,00,00,000Uses the selected records. This excludes escalation and CAM; it is not the reported annual rental potential.
Filtered lease area
Million sq. ft.Σ matching records’ total area ÷ 10,00,000All active filters apply together. Search matches park, company, state, city, box or source column.
Stage area share
%Selected stage area ÷ total selected area × 100Calculated for detailed records. A zero total returns 0%. Overview shares come directly from the supplied report.
Implied stage value
₹ croreReported stage annual rent ÷ 0.0725Used only for a reported development-stage selection. The capitalisation rate is 7.25%; for example, ₹152 Cr ÷ 0.0725 = ₹2,096.55 Cr.
Counts
CountCount records; count distinct nonblank companies, cities or statesDetailed record counts are source columns, not verified box counts. The reported 49 boxes, 10 states and 18 locations are fixed overview values.
Custom calculated fields
Depends on chosen inputsFirst field +, −, × or ÷ second fieldCalculated per record from the two selected numeric fields. Blank / nonnumeric inputs are treated as 0. Division by 0 displays —.
Lease dates and escalation
Date / %Excel date serial → calendar date; decimal rate × 100Lock In Period and Lease Period are end dates. The rate is displayed as a percentage: 0.1248 → 12.48%. Dates and escalation are stored inputs; escalation is not applied to preview rent.
Reported financial values
Overview figures are saved values from logipark overview data.xlsx, not recalculated from data-entry edits.
Portfolio value
Annual lease rent ÷ capitalisation rateReported: ₹4,311.9 Cr at 7.25%. The overview displays the supplied figure; dividing its rounded ₹312.6 Cr rental figure may give a slightly different result.
Net asset value
Portfolio value − total debtReported: ₹4,311.9 Cr − ₹1,968.2 Cr = ₹2,343.7 Cr. This relationship explains the overview value; the card remains a supplied snapshot.
Debt / portfolio value
Total debt ÷ portfolio value × 100Reported: 45.6%. Equity / value is 54.4%. The overview ratios are supplied values, rounded to one decimal place.
Excel financials
Saved cell values, without recalculationDetailed Total Income, NOI, Valuation, NAV, Security and LRD outstanding come from rows 35, 41, 42, 52, 43 and 44 of the original workbook. The HTML does not execute those Excel formulas or external links.
Data and display rules
- Overview source: logipark overview data.xlsx. Development stages follow its management tables; the supporting calculation block combines construction and finalization.
- Detailed source: logipark dashabord .xlsx, Sheet1. The 53 imported source columns are not reconciled to the reported 49 boxes. Jaipur, KMRA and Varanasi aggregate columns are excluded.
- Analysis source: no filters, or only a reported development-stage filter, shows the overview figures. Search or company, park, state, city or box filters switch to detailed records. Other status selections also use detailed records.
- Missing mappings: company, box and development status remain unassigned until entered. City/state associations follow the overview location list and matching park names. Portfolio value, debt and NAV are not allocated to detailed selections.
- Blank values: area and rent calculations use 0 for blank numeric inputs. Missing saved financial values display —. Blank dates and escalation rate remain unset.
- Rounding: calculations keep full precision. Most tables show up to 2 decimals; summary area uses 2 decimals and crore amounts use 1. Rounded stage totals and shares may differ slightly from the reported total.
- Preview storage: changes last until refresh. Editing records updates detailed preview calculations, but not the reported overview or saved Excel financial snapshots.
Your custom field rules
Portfolio at a glance
Current position across the full portfolio
10.42Million sq. ft.
₹312.6Crore / year
₹4,311.9Crore · at 7.25%
₹1,968.2Crore
₹2,343.7Crore
45.6%Reported ratio
49Parks / boxes10States / UTs18Locations2022Year of commencement
Development status
Lease area · million sq. ft.
5.37
2.34
1.76
0.94
Park records
Area in sq. ft.