Question: roject 1 . 2 . 3 . 4 . 5 . 6 . Project 1 . 2 . 3 . Timing Analysis Start: 1 2
roject
Project
Timing
Analysis Start:
Predevelopment: months
Construction: months
Lease : Commencing months after delivery Lease : Commencing months after delivery Sale Date: Month or
Size:
Project GSF: To be determined by applying efficiency below to NRSF Project NRSF: SF
Project Efficiency:
Development Assumptions
Land Purchase Price: $ GSF to be spent at time zero
Soft Costs: $ GSF to be spent during the predevelopment period
Hard Costs: $ GSF
to be spent during the first year of construction
to be spent during the second year of construction
Leasing Assumptions
Tenant i
ii iii. iv v vi
vii.
Tenant i
ii iii. iv v vi
vii.
Premises: NRSF Rent: $ SF NNN Free Rent: months Escalations:
Term: years
Tenant Improvement Allowance: $ NRSF
Paid in lease commencement year Leasing Commissions
Paid in lease commencement year
Premises: NRSF Rent: $ SF NNN Free Rent: months Escalations: Term: years
Tenant Improvement Allowance: $ NRSF Paid in lease commencement year
Leasing Commissions
Paid in lease commencement year
Operating Assumptions: The numbers below should be reflected at delivery and escalate thereafter
Opex: $ SF
Real Estate Taxes: $ SF
Escalation: Sale Assumptions
Residual Cap Rate: to be applied to year NOI
Sales Costs:
Please display the following on a gross dollar and $ GSF basis:
a Gross Sales Proceeds
b Selling Costs
c Net Sale Proceeds
d Gross Sales Proceeds deescalated to the commencement date at growth rate
Financing Assumptions: Please assume a traditional bank construction loan for this project. That means equity upfront.
Loan to Cost:
Interest Rate:
Recordation Tax:
Financing Fees:
Please include the following as part of your model:
Sources and Uses Table
Returns
Unlevered IRR
Levered IRR
Equity Multiple
Stabilized Yield
Stabilized Cash on Cash
Data Tables Measuring IRR at the following:
a b c
Please a b c
d e
Tenant rents $SF increments vs cap rates
Land purchase price $ SF increments vs debt interest rate increments Tenant rents $ SF increments vs TIs $ SF increments
build a waterfall reflecting the following:
GP Investment LP Investment
Pari Passu until a return
to the GP and to the LP until a return to the GP and to the LP until a return to the GP and to the LP thereafter
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
