When collating the tenancy schedules for an office building in Brisbane QLD, on 7 th September 2021, ABC Company noticed that some vital information was missing and some leases havent been updated correctly The company has commissioned you to address these issues by completing and answering the questions listed after that Occupied Tenancies NLA Lease Term Option Gross Rent Other income (Car Parking) Rent Review Outgoings Tenants Level Use sq m Start Term Expiry Term $pa bays $pa Type Review $psm 1 Just Cafe Ltd Ground Retail 255 4 Mar 13 10 3 Mar 23 5 $136,221 5 $0 Turnover 2 $210 2 Ministry of Education Ground Mezz Office 3,024 10 Apr 15 15 9 Apr 30 5 7 $1,340,963 60 $162,981 Combi CPI 1 5 $210 3 Shipping Pty Ltd Level 1 Office 2,715 10 May 17 10 9 May 27 5 $1,115,865 40 $110,400 increase 2 00 $210 4 Stocktake Holdings Level 2 Office 768 7 Jan 20 10 6 Jan 30 5 $431,616 10 $32,400 Fixed $ $10,000 p a $210 5 Mobile Apps Pty Ltd Level 2 Office 1,385 20 Nov 20 8 19 Nov 28 5 5 $639,208 30 $87,480 0 increase 2 0 $210 6 EnviroClean Org Level 2 Office 462 11 Apr 17 5 10 Apr 22 3 3 $269,500 5 $16,200 increase 3 50 $210 7 Lawyers Ltd Level 3 Office 1,936 5 Sep 11 10 4 Sep 21 $831,800 50 $145,800 increase 2 $210 Your updated tenancy schedule must include the following What is the percentage of the total area ( of NLA) occupied by each tenant (6 marks) What are the expiry dates after all options for each tenant have been considered Add an option expiry column (6 marks) What is the total income ($ pa) from NLA and car parking (4 marks) What is the total outgoings ($ pa) for each tenant and the building (8 marks) What is the rental rate for NLA ($psm) and car parking per month ($pcpm) for each tenant (6 marks) What is the gross operating income ($ pa) for this property (3 marks) What is net operating income ($ pa) for this property (3 marks) Given the date of valuation is 07 September 2021 and there are 365 days in a year, Calculate the remaining days on the initial lease (3 marks) What is WALE (Income) Show all workings for each tenant and the building (7 marks) What is WALE (Area) Show all workings for each tenant and the building (7 marks) Briefly discuss their implications on future investment decision making (max 50 words) (3 marks) You have determined that the capitalization rate is 6 5 What would be the market value of the property on the date valuation (4 marks)

Question: When collating the tenancy schedules for an office building in Brisbane QLD, on 7 th September 2021, ABC Company noticed that some vital information was

When collating the tenancy schedules for an office building in Brisbane QLD, on 7^th September 2021, ABC Company noticed that some vital information was missing and some leases haven’t been updated correctly. The company has commissioned you to address these issues by completing and answering the questions listed after that.

Occupied Tenancies				NLA	Lease Term			Option	Gross Rent	Other income (Car Parking)		Rent Review		Outgoings
#	Tenants	Level	Use	sq m	Start	Term	Expiry	Term	$pa	# bays	$pa	Type	Review	$psm
1	Just Cafe Ltd	Ground	Retail	255	4-Mar-13	10	3-Mar-23	5	$136,221	5	$0	Turnover	2%	$210
2	Ministry of Education	Ground & Mezz.	Office	3,024	10-Apr-15	15	9-Apr-30	5 + 7	$1,340,963	60	$162,981	Combi	CPI + 1.5%	$210
3	Shipping Pty Ltd	Level 1	Office	2,715	10-May-17	10	9-May-27	5	$1,115,865	40	$110,400	% increase	2.00%	$210
4	Stocktake Holdings	Level 2	Office	768	7-Jan-20	10	6-Jan-30	5	$431,616	10	$32,400	Fixed $	$10,000 p.a.	$210
5	Mobile Apps Pty Ltd	Level 2	Office	1,385	20-Nov-20	8	19-Nov-28	5 + 5	$639,208	30	$87,480.0	% increase	2.0%	$210
6	EnviroClean Org.	Level 2	Office	462	11-Apr-17	5	10-Apr-22	3 + 3	$269,500	5	$16,200	% increase	3.50%	$210
7	Lawyers Ltd	Level 3	Office	1,936	5-Sep-11	10	4-Sep-21		$831,800	50	$145,800	% increase	2%	$210

Your updated tenancy schedule must include the following.

What is the percentage of the total area (% of NLA) occupied by each tenant? (6 marks)
What are the expiry dates after all options for each tenant have been considered? Add an option expiry column. (6 marks)
What is the total income ($/pa) from NLA and car parking? (4 marks)
What is the total outgoings ($/pa) for each tenant and the building? (8 marks)
What is the rental rate for NLA ($psm) and car parking per month ($pcpm) for each tenant? (6 marks)
What is the gross operating income ($/pa) for this property? (3 marks)
What is net operating income ($/pa) for this property? (3 marks)
Given the date of valuation is 07 September 2021 and there are 365 days in a year,
1. Calculate the remaining days on the initial lease. (3 marks)
2. What is WALE (Income)? Show all workings for each tenant and the building. (7 marks)
3. What is WALE (Area)? Show all workings for each tenant and the building. (7 marks)
4. Briefly discuss their implications on future investment decision-making (max 50 words). (3 marks)
You have determined that the capitalization rate is 6.5%. What would be the market value of the property on the date valuation? (4 marks)

Step by Step Solution

★★★★★

3.34 Rating (145 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

What is the percentage of the total area of NLA occupied by each tenant The percentage of the total area occupied by each tenant is as follows Just Cafe Ltd 255 Ministry of Education 100 Shipping Pty ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Water flows from the reservoir through a pipe and then discharges from a nozzle as shown. The head loss in the pipe itself is given as h L = 0.025(L/D)(V 2 /2g), where L and D are the length and...

In January 2011, Tammy acquired an office building in downtown Syracuse, New York for $400,000. The building was originally constructed in 1932. Of the $400,000 cost, $40,000 was allocated to the...

You own an office building in downtown Los Angeles. Your tenants have not been using the space during the COVID-19 recession. Even when the pandemic is over, they expect that the space will not be as...

Twenty years ago Sigurdsen Corp. purchased an office building in Oslo for 12 million Norwegian kroner (Kr), 4 million of which was attributable to land. Sigurdsen has fully paid off the mortgage. The...

1. What is the percentage of the total area (% of NLA) occupied by each tenant? 2. What are the expiry dates after all options for each tenant have been considered? Add an option expiry column. 3....

Paul Hambel is a financial consultant to Tecau Properties Inc., a real estate syndicate. Tecau Properties Inc. finances and develops commercial real estate (office buildings). The completed projects...

A car is approaching a hill at 30.0 m/s when its engine suddenly fails just at the bottom of the hill. The car moves with a constant acceleration of -2.00 m/s2 while coasting up the hill. (a) Write...

A piston/cylinder contains 2 lbm of liquid water at 70 F, and 30 lbf/in.2. There is a linear spring mounted on the piston such that when the water is heated the pressure reaches 300 lbf/in.2 with a...

When a block of mass M, connected to the end of a spring of mass ms = 7.40 g and force constant k, is set into simple harmonic motion, the period of its motion is T = 2π √M + (ms/3)/k A...

A 2.00-kg block hangs from a rubber cord, being supported so that the cord is not stretched. The unstretched length of the cord is 0.500 m, and its mass is 5.00 g. The spring constant for the cord is...

When a microorganism moves in a viscous fluid, inertia (fluid density) has a negligible influence on the organisms drag force. These are called creeping flows. The only important parameters are...

Speaker Shop sells and installs audio equipment. During a recent fire that occurred at its warehouse, Speaker Shops entire inventory was destroyed. Speaker Shops accounting records reflect the...

Recalculate the value of the option in problem 7, successively substituting one of the changes below while keeping the other parameters: a. Time to maturity = 3 months b. Standard deviation =25...

Question 6 Find the derivative of g . You do not need to simplify your answer. g ( x ) = ( - 2 x 4 ) l n ( x ) g ' ( x ) =

Why should one Choose Computer science? and what are the attribute that an institution should provide to him?

Using your knowledge of Felkin-Anh control, rationalize why compound (4) has a syn stereochemical relationship between the stereogenic centres labelled 3 and 4. Using 3D representations, invoke a...

Following is the Questionnaire; you need to answer the following questions: 1-Trent confessed that the expansion would probably force him to give some additional responsibilities to Max. But that...

Helping or Hurting? Exit interviews were usually handled by junior managers on the HR team, but Amrita felt that given the high rate of attrition among doctors at Krisna Hospital over the past year,...

5. Determine whether the series converges or diverges. 00 (a) 3+ sin n 3+ sin n (b) E (c) +)" en +n

During a two-hour period, the temperature in a city dropped from a high of 51F to a low of 19F. What was the range of the temperatures during this period? F

A memorandum by Labor Secretary Robert Reich to President Bill Clinton suggested that the government penalize U.S. companies that invest overseas rather than at home. According to Reich, this kind of...

1. Why does Porsche face more operating exposure than Mercedes or BMW? 2. Is Porsche really fully hedged through July 31, 2007? Suppose that gains on all its outstanding options were included in...

Over the past year, China has experienced an inflation rate of about 22%, in contrast to U.S. inflation of about 3%. At the same time, the exchange rate has gone from Y8.7/U.S.$1 to Y8.3/U.S.$1. a....

Marcus is the CEO of publicly traded ABC Corporation and earns a salary of $1,500,000. Assume ABC has a 35 percent marginal tax rate. a. What is ABC's after-tax cost of paying Marcus's salary? b. Now...

Harry and Rita formed Alpha Corporation as an S corporation, with each shareholder contributing $10,000 in exchange for stock. In addition, Rita loaned the corporation $7,000, and the corporation...

Alice, a single taxpayer, will form Morning Corporation in the current year. Alice plans to acquire all of Mornings common stock for a $100,000 contribution to the corporation. Morning will obtain...