Lease Analysis

You have an office building with a $25,000$ sf vacancy. You have two proposals:

Assume there is no parking revenue or moving allowances and that first year opex is $$16\mathrm{.}00$ psf$.$ Also pls assume

commissions are $$\frac{1}{s}\frac{f}{y}r$ for outside broker and $$\frac{0\mathrm{.}50}{?}$ sf for inside broker.

Using the lease analysis tool, please calculate the NPV for each.

If the owner was considering selling the building in $3$ years, please calculate the Capitalized Lease Value psf;

assume a $7\%$ cap rate

If the owner is a long term holder, which lease would they prefer? If they prefer to sell after $3$ years, which would

they prefer? Why?

please show the steps on excel