MMP221 Property Management Paper
Check your essay before you submit. See exactly what your professor sees.
See your AI and plagiarism results before your instructor does.Get the exact same report your professor uses. Trusted by 50,000+ students worldwide.
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
Essay writing help – MMP221 Property Management Paper Online Essay Writing Agency – EssayGuru Pro.
DO MY HOMEWORK NOW!Write my Essay. Premium essay writing services is the ideal place for homework help or essay writing service. if you are looking for affordable, high quality & non-plagiarized papers, click on the button below to place your order. Provide us with the instructions and one of our writers will deliver a unique, no plagiarism, and professional paper.
Get help with your toughest assignments and get them solved by a Reliable Custom Papers Writing Company. Save time, money and get quality papers. Buying an excellent plagiarism-free paper is a piece of cake!
All our papers are written from scratch. We can cover any assignment/essay in your field of study.
