The Data Center Project Finance Model is a 180-month Excel underwriting model designed for data center developers, financial advisors, infrastructure investors and lenders.
The workbook combines customer contracts, operating costs, construction expenditure, development financing, permanent debt and exit value into one integrated cash-flow model.
The model is delivered in a standalone configuration. A dedicated Standalone Input Adapter lets you enter externally prepared assumptions, including the power capacity ceiling, the energy-cost series, the CapEx series, project timing and capacity blocks. The adapter then builds internally the structured inputs the model expects, so no upstream workbook is required to run a complete case.
REVENUE
Customer contracts can define contracted kW, start dates, terms, starting rent per kW per month and escalation.
Billable capacity is checked against the physical power ceiling supplied to the model, preventing commercial assumptions from monetizing capacity the site cannot support.
OPERATING COSTS
The model incorporates utilities, maintenance, staffing and security, insurance, property tax, G&A, management fee, vacancy and recoveries.
Trended and untrended NOI are calculated separately to distinguish operating performance from inflation.
FINANCING
The model supports senior and mezzanine construction financing, loan-to-cost limits, rates, fees, current-pay or capitalized interest and a permanent takeout.
Permanent debt is sized by the binding minimum of three constraints: loan-to-value, debt service coverage ratio and debt yield. The binding test is reported explicitly, so it is always clear which constraint is setting the loan amount.
Construction-interest circularity is handled through a visible frozen-interest mechanism instead of opaque iterative calculation.
RETURNS AND EXIT
Outputs include levered and unlevered IRR, equity multiples, net profit, yield-on-cost, development spread, DSCR, debt yield, loan sizing and exit proceeds.
The dashboard is organized around the Sponsor, Equity and Lender perspectives, so the same case can be presented to a development committee, an equity partner and a credit team without rebuilding the analysis.
Sensitivity analysis covers contract price, exit cap rate, vacancy, energy cost, construction duration and CapEx.
Metrics are pre-corporate-tax by design.
WHAT YOU RECEIVE
The primary download is the standalone T4 underwriting model. The secondary file is a ZIP bundle containing the Standalone Input Adapter, the T4 User Manual, a Standalone Quick Start, an Input Map showing exactly which values the adapter needs and where they come from, and the licence, scope and disclaimer documentation.
WHO IT IS FOR
Data center developers, colocation and hyperscale operators, digital-infrastructure funds, project finance analysts, banks and credit teams, transaction advisors, financial modelers and investors underwriting data center opportunities.
WHAT IT IS NOT
This is an underwriting model, not a complete tax model, legal model, final lender model or substitute for technical due diligence.
It does not produce the power and energy study or the detailed construction estimate itself: externally prepared capacity, energy-cost and CapEx inputs must be provided.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Data Center, Integrated Financial Model Excel: Data Center Project Finance Model: Sponsor, Equity & Lender Excel (XLSX) Spreadsheet, ExpertPro Consulting
|
Download our FREE Digital Transformation Templates
Download our free compilation of 50+ Digital Transformation slides and templates. DX concepts covered include Digital Leadership, Digital Maturity, Digital Value Chain, Customer Experience, Customer Journey, RPA, etc. |