Complete pro forma for NOI and BTCF

Commercial Complex 4 tenants Property will be held for 5 years

Tenant	Lease Type	Size	Current Lease Rate	Rent Growth	CAM
Bank	NNN	Outparcel	$75,000/yr	1.75%
Retailer	Percentage	4,200	$4.25 sq ft Plus 5% revenue	Tenant revenue is expected to grow at 3.35% per year Year 1 Revenues are $350,000	Limited to $3.35 per sq foot Pro rata on sq feet
Office		3,000	$18 sq ft	CPI	None
Office		3,800	$16	CPI	Limited to $3.65 per sq foot Pro rata on sq feet

OP EX Category	Cost	Growth Rate
Utilities	$1.20 per sq ft	2.4% per year
Taxes	$9,500 per year	2.5% per year
Insurance	$0.50 per sq ft	1.5% per year
Maintenance	$0.85 per sq ft	3.0% per year

CPI	Rate
Years 1-3	2.1%
Years 4-7	2.8%
Years 8-10	3.1%

Can you show me in excel?