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.

1. What is the percentage of the total area (% of NLA) occupied by each tenant? (6 marks)
2. What are the expiry dates after all options for each tenant have been considered? Add an option expiry column. (6 marks)
3. What is the total income ($/pa) from NLA and car parking? (4 marks)
4. What is the total outgoings ($/pa) for each tenant and the building? (8 marks)
5. What is the rental rate for NLA ($psm) and car parking per month ($pcpm) for each tenant? (6 marks)
6. What is the gross operating income ($/pa) for this property? (3 marks)
7. What is net operating income ($/pa) for this property? (3 marks)
8. 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)
9. 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)