You are considering an investment in a 250,000 sqft office building. Market rent in this area is currently $25/sqft and is expected to increase at a rate of 5% annually into the foreseeable future. Comparable buildings in this area have a 6% vacancy rate. Expenses are currently $13/sqft and have been increasing by $1/sqft annually. Typically half of the operating expenses are recovered from tenants. When getting into a project of this type you generally consider a 5-year holding period and look for a 12% rate of return.
Create the pro forma cash flow statement for this investment.