MMP221 Property Management Paper

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]

ONLY REQUIRE QUESTION 2 AND 3 DONE. QUESTION 1 SOLUTION INCLUDED FOR REFERENCE

Requirements: 600 | .doc file

QUALITY: 100% ORIGINAL - NO PLAGIARISM

(USA, AUS, UK & CA PhD. Writers)

CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS

The Best Custom Essay Writing Service

About Our Service

We are an online academic writing company that connects talented freelance writers with students in need of their services. Unlike other writing companies, our team is made up of native English speakers from countries such as the USA, UK, Canada, Australia, Ireland, and New Zealand.

Qualified Writers

Our Guarantees:

CLICK TO SUBMIT YOUR ORDER