Assignment Task

Assignment Details: As a property analyst, you are required to carry out a ratio analysis report for your client who has an opportunity to purchase an income-producing commercial property in Sydney or any major city of Australia. You must identify an income-producing commercial property that is still in the market or recently sold (as recent as June 2023 to date) and obtain the information for the property as follows:

1. Property Data - asking price of the property, acquisition costs including legal fees, etc.
2. Income Data - vacancy rate, current rent, operating expenses (outgoings), etc.

There are 5 major parts of this report:

Part 1: Introduction

You should provide the identification of the property. It includes descriptive information of the subject property.

Part 2: Property Market

Provide a review of market fundamentals and the property market. The review should be done at two levels covering the period 2018 -2023.

1. The first level is a review of key market fundamentals of Australia such as cash rate, GDP, inflation/consumer price index, unemployment rate, and population growth.
2. The second level is a review of key property parameters of the local market of the subject property such as Sydney, Melbourne etc., focusing on vacancy rate, demand, supply, price, rent, incentives, investment activity, and yield.

Part 3: Mortgage Requirements

1. You are also required to obtain mortgage information for your client. Identify the amount of loan that is required, term and repayment frequency and interest rate. Based on the information, calculate the loan/mortgage repayment.
2. You should compare mortgage payment from at least 3 lending institutions from which you will recommend one to your client.

Part 4: Ratio Analysis

By utilizing the collected data, conduct a detailed ratio analysis. A table consisting of all essential information is also expected.