Reference no: EM133070803
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. (ANSWER TO QUESTION 1 LOCATED BELOW UNDER QUESTION 2,3, REQUIRE QUESTION 2 AND 3 COMPLETED.
2. Should you recommend option A or option B to the owner? What are the benefits and costs of the three options?
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.
QUESTION 1 SOLUTION , REQUIRE QUESTION 2 AND 3 COMPLETED, THANKS
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
|
|
|
|
|
Develop a capitalization table
: A company has 3,000,000 common shares outstanding and then issues 1,000,000 shares of Preferred stock in a Series A offering at a purchase price of $1.00 per sh
|
Calculate the balance of Investment in XYZ account
: Calculate the balance of 'Investment in XYZ' account on ABC's balance sheet on December 31, 20X1. Assume both companies have a December 31 fiscal year end
|
Firm after-tax cost of debt on the bond
: Tea-Time Travel wishes to offer a $1,000 bond that pays 8% annual interest and matures in 15 years. Using information provided, what will be the firm's after-ta
|
How much after-tax intercompany gain or loss was realized
: The tax rate for both companies is 32.67%. How much after-tax intercompany gain or loss was realized during Year 4 from Sub's sale of assets to Par in Year 4
|
What are the benefits and costs of the three options
: 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,
|
Explain the steps in making a recommendation
: When these leases (Type I) rollover near end of June 2022, a certain percentage are expected to be renewed at market rents for an additional 12 months. The rest
|
Prepare the income statement for the year ended
: Eagle Sporting goods Company Balance Sheet March 31, 2021 Assets Current Assets: Prepare the Income Statement for the year ended
|
What is the dirty price of a? bond
: 1) What is the dirty price of a? bond?
|
What the amount of goodwill on consolidated balance sheet
: On January 1, 20X1, Par Inc acquires 80.49% of Sub Corp for $165,931 in cash. What the amount of goodwill on consolidated balance sheet
|