Consider a 100,000 square foot office building with one tenant and an additional "lease in hand". the current tenant leases 50,000 square feet at market rent, which is $12/ft./yr. fixed, and the lease has a remaining term of 4 years. the lease in hand is a binding commitment to lease 35,000 square feet at $14/ft./yr. fixed for 5 years with the lease starting in exactly 2 years (first rent payment at the end of year 3). average (market) rent is currently 13/ft./yr., and historically has increased at 2% per year. a) ignoring operating and capital costs and assuming that rent is paid at the end of the year, use dcf over a 5 year investment window to find the value of the property. assume that the property currently under lease is re-let at the same rent at the end of the current lease, the discount rate is 9% and the expected cap rate for the property at the end of 5 years is the current stabilized cap rate of 7%. using the price you derive from dcf, what is the property’s current cap rate? why isn’t it the current market cap rate of 7%? b) now suppose that the leases in part a) are "triple nets" under which operating costs (cam, insurance, and property taxes) are reimbursed by the tenant on a pro rata basis. (each tenant’s share of the expenses is the % of the total leasable space that it leases.) cam, real estate taxes, and insurance are estimated to be $1.50/ft./yr., $2.50/ft./yr., and $.15/ft./yr., respectively. as the owner you pay all capital costs, which are estimated as a reserve of $.25/ft./yr. you also pay $5/ft. in tenant improvement at the start of the second lease (end of year 2), $2/ft. in ti when the first lease rolls over, and you pay lease commissions of 6% of all base rent revenue over the life of the second lease at the end of year 2. find the value of the property using dcf. discount at 9% as above. (best to do this in a spreadsheet.)