You are appointed by the owner of an office building, Monument Tower, as the property manager. You are currently negotiating a 5-year lease with an IT company, Extreme Vision, for 2,000 square metres of rentable space. After careful market/property analysis, you estimate that the base rent should be $250 per square metre per year. Monument Tower offers full service to all its tenants as a policy. Rent is due at the beginning of each year.

Extreme Vision indicates to you that they are willing to pay $220 per square metre with step-ups of $10 per square metre each year beginning one year from now. You think that a price of $220 is too low to degrade the reputation of Monument Tower. The owner will certainly reject this price. You come up with two alternative proposals.

Option A: Monument Tower offers Extreme Vision a move-in allowance of $50,000 plus tenant improvements (fitouts) worth $50,000 subject to Extreme Vision signing the lease at a flat rent of $250 for a term of 5 years.

Option B: Monument Tower offers Extreme Vision to buy out its existing lease in another building. The existing lease of Extreme Vision has 1 year remaining. Its space in the other building is 2,000 square metres and the price is $200 per square metre per year. The lease agreement between Extreme Vision and its existing landlord specifies that Extreme Vision should pay 50% of the remaining rent due in a buyout. Extreme Vision signs the new lease at $250 with step-ups of $5 per square metre each year starting one year from now.

(1)Using discounted cash flow method, calculate the present values and effective rents of the three options: the original proposed rent schedule from Extreme Vision, option A, and option B. The discount rate is 10%, which is the required return by the owner. Show your workings by copying the table here and state the formulas if necessary. Explain concisely.

Discount rate

10%

Total ft

2,000.00

Offer

Year

0

1

2

3

4

rent rate per ft

220

230

240

250

260

Effective rate

220

230

240

250

260

Sales

$440,000.00

$460,000.00

$480,000.00

$500,000.00

$520,000.00

Net profit / operating cashflow

$440,000.00

$460,000.00

$480,000.00

$500,000.00

$520,000.00

FCF

$440,000.00

$460,000.00

$480,000.00

$500,000.00

$520,000.00

Discounted Cash flow

$440,000.00

$418,181.82

$396,694.21

$375,657.40

$355,167.00

NPV

$1,985,700.43

Option A

Year

0

1

2

3

4

rent rate per ft

250

250

250

250

250

Move in allowances

$ 100,000.00

Effective rate

200

250

250

250

250

Sales

$400,000.00

$500,000.00

$500,000.00

$500,000.00

$500,000.00

Net profit / operating cashflow

$400,000.00

$500,000.00

$500,000.00

$500,000.00

$500,000.00

FCF

$400,000.00

$500,000.00

$500,000.00

$500,000.00

$500,000.00

Discounted Cash flow

$400,000.00

$454,545.45

$413,223.14

$375,657.40

$341,506.73

NPV

$1,984,932.72

Option B

Year

0

1

2

3

4

rent rate per ft

250

255

260

265

270

Buyout cost

$ 200,000.00

Effective rate

150

255

260

265

270

Sales

$300,000.00

$510,000.00

$520,000.00

$530,000.00

$540,000.00

Net profit / operating cashflow

$300,000.00

$510,000.00

$520,000.00

$530,000.00

$540,000.00

FCF

$300,000.00

$510,000.00

$520,000.00

$530,000.00

$540,000.00

Discounted Cash flow

$300,000.00

$463,636.36

$429,752.07

$398,196.84

$368,827.27

NPV

$1,960,412.54

[8 marks]

2) Should you recommend option A or option B to the owner? What are the benefits and costs of the three options?

[6 marks]

3)If you propose the selected option in part (2) to Extreme Vision, will it accept it? How could you convince them to accept the offer? Please propose another set of lease terms to make it attractive to the potential tenant while satisfying the requirement of the owner.

[6 marks]