Browse Tag: Excel

Video: Excel How-To: Lease Pro-Forma

Would-be Excel jockeys, take a peek at this. It’s a 40-minute clip detailing the analysis of leases from the tenant and the landlord perspectives. Veterans and rookies alike can learn a thing or two about detailing a lease deal for either side of the table.

Learn about the major variables, learn about how tenants and landlords see these variables differently, and how the math differs between the two. When costs are shared through various means, the numbers jiggle around, and this clip shows how to stay on top of exactly that.

Continue Reading

Corporate Real Estate Veteran To Younger Brokers: Ditch The Spreadsheets

Picture of a legal padIt’s not possible to patrol the commercial RE beat online without finding Coy Davidson. A Senior VP at Colliers with twenty years in the business, Coy writes The Tenant Advisor, one of the better blogs dedicated to commercial property markets with a focus on corporate real estate and tenant representation and office solutions.

His recent post is titled Know Your Numbers.  And when he says “know”, he’s not kidding.  His advice to agents is to embrace the math in the financial analysis spreadsheets by learning it away from spreadsheets — old-school — to the benefit of everybody at the table. He writes:

Continue Reading