Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / Finance 1B AFIN102 Group Valuation Assignment Find a house or apartment that you would like to research

Finance 1B AFIN102 Group Valuation Assignment Find a house or apartment that you would like to research

Finance

Finance 1B AFIN102

Group Valuation Assignment

Find a house or apartment that you would like to research. From here on this will be referred to as a house or property or home regardless of whether it is a house or apartment. The house can be in any country (and we especially look forward to reading those assignments on overseas houses) so long as you can find enough details about the home and the other variables discussed in the below questions.

If you choose to research an overseas property, be consistent with using that country’s currency in your answer to all questions. There’s no need to convert the currency to Australian dollars, just state your answers in the appropriate currency.

Question 1 (1/2 Mark): State the house’s full address and important details such as the number of bedrooms and bathrooms, floor space and any other aspects that you think are important. Include a small picture.

Question 2 (1/2 Mark): Estimate the home’s value based on an average of similar properties that have sold recently. Using a table, set out the details of the other properties and why you think that they’re comparable. The table should have at least 5 columns including the addresses, number of bedrooms, floor space, last sale date and price. You can include other columns too if you think they’re important. The first row of the table should include the details of the property you’re valuing which was stated in Question 1, and the other rows (include a minimum of one other property to compare) should show the details of the other similar properties. Here is an unpopulated example table:

Details of Comparable House Prices

Address

Bed-rooms

Floor space (m^2)

Last sale date

Last sale price

<Replace this first row with the details of the property being valued>

 

 

 

 

<Replace with comparable property one>

 

 

 

 

<Replace with comparable property two>

 

 

 

 

<Replace with comparable property three>

 

 

 

 

 

 

 

<Calculate and report the average of the comparable properties’ prices only here>

 

 

State your value estimate and sources.

 

Question 3 (1 Mark): Estimate the gross annual rental revenue from leasing this home if you were the landlord and chose to rent it out to another person. You might find similar rental properties and take an average of their actual or advertised rents. A table similar to the one used above might be appropriate. The gross rental revenue ignores costs of renting. Ignore the intra-year time value of money effect. So for example, even though rent might actually be $3,000 paid monthly, assume that it is 36,000 (=12 * 3,000) paid annually at the end of the year. Reference your sources.

Question 4 (2 Marks): Estimate the annual rental costs of leasing your home if you were the landlord and chose to rent it out to another person. Similarly to the above, ignore the intra-year time value of money effect. Be sure to present your figures using a table. Reference your sources.

Question 5 (2 Marks): Estimate the annual growth rate of rents. Provide arguments as to what the annual growth rate of rents should be. Reference your sources which may include data from your country’s government statistics agency.

Question 6a (1 Mark): Assuming that your property lasts forever, use the ‘perpetuity with growth’ formula to find the implied total required return (r) based on the estimated house price, net rent and rental growth. Note that net rent equals gross rental revenue less rental costs.

Price = Net Rent / (r – g)

Question 6b (1 Mark): Is this perpetuity model suitable for valuing your house? Explain why or why not. If you think that the perpetuity model in the above form is unsuitable, make some adjustments or use some other model to estimate a more accurate implied total required return. When answering the below questions, use this implied total required return.

Question 7a (1 Mark): Find the current inflation rate in the country where your house is located. State the exact version of inflation that you found, as well as the source and the date that the inflation rate was observed.

Also present a table showing the weights (in %) of the different categories of items (usually goods and services if you’ve used the consumer price index or similar) that make up the weighted average inflation calculation. For example, the Australian CPI has weights in food, transport, housing, and so on. This table should have at least 2 columns for the name of the item and its weight.

Question 7b (1 Mark): Compare the inflation rate to the implied total required return on your home and comment on whether one should be higher than the other or if they should be equal.

Question 7c (1 Mark): Compare the inflation rate to the growth rate of rents on your home and comment on whether one should be higher than the other or if they should be equal.

Question 8a (1 Mark): Find the current yield of the longest-maturity government bond in the country where your house is located. State your source and the date that the yield was observed.

Question 8b (1 Mark): Compare the government bond yield to the implied total required return on your home and comment on whether one should be higher than the other or if they should be equal.

Question 9a (1 Mark): Find the most competitive home loan interest rate in the country where your house is located. State your source, the type of rate (fixed or variable or any other characteristics that are relevant) and the date that the rate was observed.

Question 9b (1 Mark): Compare the home loan rate to the implied total required return on your home and comment on whether one should be higher than the other or if they should be equal.

Question 10a (1 Mark): Find the ‘CAPM market’ required total return of the share market index in the country where your house is located. State your source.

Question 10b (1 Mark): Compare the required total return to the implied total required return on your home and comment on whether one should be higher than the other or if they should be equal.

Question 11a (1 Mark): What is the price-earnings (PE) ratio of the house? Use annual net rent as the annual earnings.

Question 11b (1 Mark): What is the price-earnings (PE) ratio of the share market in the country where your house is located? State your source.

Question 11c (1 Mark): Compare these PE ratios and comment on whether one should be higher than the other or if they should be equal.

Question 12a (2 Marks): Explain and show the benefits of ‘negative gearing’. The best answers will illustrate the concept using an example that applies to a person buying your house using the home loan rate and other details that you found above.

Question 12b (1 Mark): Can shares be negatively geared and if so, how?

Question 13a (1/2 Mark): Briefly describe three non-pecuniary benefits of home ownership over renting.

Question 13b (1/2 Mark): Briefly describe three non-pecuniary benefits of renting a home over home ownership.

Question 14 (1 Mark): Some commentators believe that many countries’ real estate markets are currently in a bubble, meaning that they’re over-priced. If you were certain that house prices in the country that you investigated were going to fall in the next 6 months, describe a strategy that would allow you to profit.

 

 

 

Administrative requirements

This report is worth 15% of the course's marks.

You should form a group of 2-4 members from any class. You may not make a group of more than 4 or less than 2. We recommend larger groups since this assignment requires much research and many decisions are best discussed as a group. Each group member must contribute substantially to the final submitted work. Groups can be amongst students from any class.

Your group must elect a leader. The team leader is expected to maintain a weekly journal, registering the contribution of each team member during the week. The journal must be submitted with the assignment. It need not be exhaustive, just a record of significant contributions. All group members are equally responsible for the entire submitted assignment.

You can choose your own group members. You can eject non-contributing members from your group, but this must be done at least 10 calendar days before submission and you must tell the group member, preferably by email using your MQ email accounts, that they’re ejected at this time so they can begin the work themselves. The ejected group members may not use the old group’s work that they did not contribute to.

The limit is 10 pages using 1.5 line spacing and default margins, just like this page. Supporting images, graphs, tables and so on should be placed in-text next to the paragraph where the figure is discussed. There's no need for an appendix and if you have one it's not likely to be marked. You may use any common referencing style you like. Bibliographies are not included in the page count. Items listed in the bibliography but not actually referred to in the report will have marks deducted.

The assignment should be submitted in electronic form to Turnitin which will be made available as a link online.

Assignments that are not proof-read will be marked down. Grammar and sentence structure is important. Business writing should be clear, succinct and front-focused, which means putting the most important points at the very start.

Answer the questions in the order that they are asked. Be sure to include sub-headings that contain the question number.

There's no need for an introduction or conclusion. This assignment is a collection of short answer questions.

There's no need to write the whole question in your assignment if you're struggling to fit everything into the page limit. You may write the question number as a subtitle to show where each question begins. For example:

Question 1: Write answer here.

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE