Category: Real Estate

To complete this assignment:
Purchase and read the case study The Green Duplex by John J. Lawrence, University of Idaho.
You can access the case study through our Coursepack here: https://hbsp.harvard.edu/import/1107828Links to an external site.
Read Unlocking Value in Class B-C Office Buildings
Complete Assignment #1 and upload to Canvas no later than the beginning of class on Nov. 6, 2023
Based on the case The Green Duplex, please answer the following questions:
1) What are Sean’s goals for this project? How will he know if he has achieved these goals?
2) What makes this project green? Why is there uncertainty about this? How much additional cost does building green add to the project?
3) Evaluate Sean’s approach to decision-making. What has he done well? What has he done less well?
4) How could Sean provide more structure to the decision on which wall technology to use?
5) How should Sean determine the appropriate rent for the duplex? Given the information in this case, is $800 a reasonable rent to expect from this unit?
6) What is the return (IRR) that Sean will achieve on the Lunsford Street duplex if his assumption are correct? Assume he sells the duplex after 20 years and that the capital gains tax is 15 percent at that time. How sensitive is this return to deviations in the assumptions that Sean has made? Are Sean’s actual results consistent with these assumptions?
7) What is your estimate of the IRR of Sean’s proposed green duplex on Tamarack St? What are the most significant uncertainties associated with these estimates?
8) What would you recommend Sean do with respect to building green? Why?
For your essay be sure to:
Follow the APA Guide for formatting; however, you do not need to include an abstract.
Submit in Times New Roman, 12-point font, single-spaced.
Do not exceed a maximum length of 3 pages.
PLEASE USE YOUR OWN WORD
No plagiarism and no AI generated response
I will send case study after matching the tutor

To complete this assignment:
Purchase and read the case study The Green Duplex by John J. Lawrence, University of Idaho.
You can access the case study through our Coursepack here: https://hbsp.harvard.edu/import/1107828Links to an external site.
Read Unlocking Value in Class B-C Office Buildings
Complete Assignment #1 and upload to Canvas no later than the beginning of class on Nov. 6, 2023
Based on the case The Green Duplex, please answer the following questions:
1) What are Sean’s goals for this project? How will he know if he has achieved these goals?
2) What makes this project green? Why is there uncertainty about this? How much additional cost does building green add to the project?
3) Evaluate Sean’s approach to decision-making. What has he done well? What has he done less well?
4) How could Sean provide more structure to the decision on which wall technology to use?
5) How should Sean determine the appropriate rent for the duplex? Given the information in this case, is $800 a reasonable rent to expect from this unit?
6) What is the return (IRR) that Sean will achieve on the Lunsford Street duplex if his assumption are correct? Assume he sells the duplex after 20 years and that the capital gains tax is 15 percent at that time. How sensitive is this return to deviations in the assumptions that Sean has made? Are Sean’s actual results consistent with these assumptions?
7) What is your estimate of the IRR of Sean’s proposed green duplex on Tamarack St? What are the most significant uncertainties associated with these estimates?
8) What would you recommend Sean do with respect to building green? Why?
For your essay be sure to:
Follow the APA Guide for formatting; however, you do not need to include an abstract.
Submit in Times New Roman, 12-point font, single-spaced.
Do not exceed a maximum length of 3 pages.
PLEASE USE YOUR OWN WORD

To complete this assignment:
Purchase and read the case study The Green Duplex by John J. Lawrence, University of Idaho.
You can access the case study through our Coursepack here: https://hbsp.harvard.edu/import/1107828Links to an external site.
Read Unlocking Value in Class B-C Office Buildings
Complete Assignment #1 and upload to Canvas no later than the beginning of class on Nov. 6, 2023
Based on the case The Green Duplex, please answer the following questions:
1) What are Sean’s goals for this project? How will he know if he has achieved these goals?
2) What makes this project green? Why is there uncertainty about this? How much additional cost does building green add to the project?
3) Evaluate Sean’s approach to decision-making. What has he done well? What has he done less well?
4) How could Sean provide more structure to the decision on which wall technology to use?
5) How should Sean determine the appropriate rent for the duplex? Given the information in this case, is $800 a reasonable rent to expect from this unit?
6) What is the return (IRR) that Sean will achieve on the Lunsford Street duplex if his assumption are correct? Assume he sells the duplex after 20 years and that the capital gains tax is 15 percent at that time. How sensitive is this return to deviations in the assumptions that Sean has made? Are Sean’s actual results consistent with these assumptions?
7) What is your estimate of the IRR of Sean’s proposed green duplex on Tamarack St? What are the most significant uncertainties associated with these estimates?
8) What would you recommend Sean do with respect to building green? Why?
For your essay be sure to:
Follow the APA Guide for formatting; however, you do not need to include an abstract.
Submit in Times New Roman, 12-point font, single-spaced.
Do not exceed a maximum length of 3 pages.
PLEASE USE YOUR OWN WORD

CHAPTER 10 – REAL ESTATE APPRAISAL
1. Please define what an appraisal is. How is value determined? What are the four essential elements of value?
2. What are the four forces that influence value? Which one do you believe is the most important? Explain why.
3. Name and describe the six principles of valuation, be specific.
4. What is depreciation? Name and describe the three categories of depreciation and include if each is curable or incurable, be specific.
5. Name and describe the three different methods (approaches to value) of appraisal, be specific. What type of property would the appraiser use for each approach? Please read the question carefully, you are being asked for the three different approaches to appraisal, not the different types of reports.

Question#1
What is the present worth of an income producing property which receives a net operating income of $30,000 during year 1, $32,000 in year 2, $40,000 in year 3, and $43,000 in year 4? Assume the property is sold at the end of year 4 for $50,000 net of selling expenses and the discount rate is 15%.
Question#2
How many months does it take to amortize a loan with an outstanding balance of $200,000, monthly payments of $1,245, and an interest rate of 3%?
Question#3
A retail shopping center was purchased in 2016 for $2.1 million in cash. During the next four years the property appreciated at 4 percent per year. Annual depreciation allowance is $16,000 per year. At the end of year 4, the property is sold; selling expenses are 8 percent. What is the after-tax equity reversion for an investor with an income tax rate of 28 percent, a capital gains tax rate of 20 percent and a deprecation recapture of tax rate of 25 percent?
Question#4
An office building situated on a 1-acre parcel of land has an expected gross income of $106,000 per year with a vacancy rate of 7.5 percent. What is the value of the property and improvements assuming a gross income multiplier of 6.5? If the land area is worth $45,000 what is the value of the building?
Question#5
The owner of a financially distressed property in Texas can dispose of it at a $2 million loss today. If the period of recovery for the project is expected to be three years, with annual before tax carrying costs of $1,000,000, $800,000 and $600,000 respectively, should the property be sold? Assume that the market value of the property immediately before the downturn in the Texas market was $10,000,000. Today the market value of the property is estimated to be $8,000,000. In three years, the market value of the property is expected to again be $10,000,000. The appropriate discount rate is 15%. Selling expenses are assumed to be zero. Should the property be sold if the discount rate is now 20%?

The Title Grid assignment is as follows:
Find or research the various ways of holding title (IN CALIFORNIA.) Many Title companies publish “grids” as hand outs for clients to help them determine what method of holding title is best for them. As a licensed real estate agent is not a lawyer and should refrain from advising clients how to hold title, create a grid that shows the pros/cons, benefits, complexities of the different ways of holding title. 5 extra credit points are available for a well done project that BOTH includes holding title in trust as a grid item as well as looks like a professional marketing piece for a real estate business (Handout/flyer.)
30 points (+5 extra credit possible)

Do you have a family member or friend who is currently working as a real estate salesperson (or broker)? If so, have you consulted them for advice regarding a possible career in real estate? If you do not personally know any real estate agents, please consider dropping by an ‘open house’ in your neighborhood and mention to the salesperson on duty that you are a real estate student and you’d like to know some of their thoughts on a possible career in real estate. If you do attend an open house, please do not stay too long as the salesperson needs to spend time with a potential buyer or future client.
If you do not know any real estate professionals at all nor have the time to stop by an open house, please post some of your own thoughts about going into the real estate business. Or as a last resort, post a meaningful response to any of your classmates posting.

Scenario:
Congratulations! You are now appointed as an Asset Manager of an Australian property asset management company operating its business across Australia. Your first task as an Asset Manager is to prepare a report containing detailed analysis of a shopping centre in SA, linking its strategic aspects of the centre with local socio-economic data and other relevant material introduced in the course. Furthermore, you are required to carry out some simple financial analysis.
Available options to choose:
Sefton Plaza Shopping Centre, Sefton Park
Please do not try to contact centre management or tenants to obtain information to complete this assessment. Instead, you can utilise their website, news articles, publications, and other resources accessible through the Internet.
Format/Assessment Criteria:
This report needs to be prepared using the below headings. You may include photos, tables, graphs and floor plans as long as they are relevant, properly captioned (e.g. Table 1. XXX) and discussed in the main text. Referencing in accordance with the APA referencing system is required. You are to provide a word count for the report.
1. The Centre Descriptions (5 Marks)
This section requires descriptions about your chosen shopping centre including its location, centre category and the current shopping centre management (e.g. Westfield, Mirvac, Stockland, etc.). A breakdown of the tenancy type (based on Supermarket, Menswear, Women’s fashion, etc. See Table 1 under the “Financial Analysis” section for further details) as well as discussions on the “magnet” of the centre should be also included (there may be more than one magnet!). Any other introductory information such as a number of car parking and GLAR can be also included.
2. The Centre Operations (20 Marks)
This section requires discussing the operational side of the centre. This typically involves the ease of finding tenants and the natural traffic flows within the centre. Further, you need to identify the “magnet” of the centre and why, followed by discussions on how they might impact on overall centre operations. By inspecting the centre, you may be also able to identify and discuss current vacancies (if any) and “dead spots”. Besides, any unique features or strategies currently adopted by the centre to gain competitive advantages in the market should be also discussed. For example, your centre may be one of the “green” certified shopping centres.
3. Catchment Area Analysis (20 marks)
This section requires defining the “catchment” areas of the chosen centre (there may be more than one catchment areas). This should be followed by discussing demographics of the identified catchment area and what those demographics tell us about the shoppers and the centre operations. If you expect any changes of the catchment area in the near future, it can be also discussed here. Some useful resources to complete this section include the Australian Bureau of Statistics (ABS) and profile.id. Keep in mind that simply copying and pasting demographic information without discussing their implications specific to your centre may lead to 0 mark in this section.
4. Competitor Analysis (20 marks)
This section requires discussing at least two current or potential competitors of the centre. This should include providing descriptions on identified competitors as well as their advantages and disadvantages compared to your centre. You should also highlight if any of these competitors at least partially share the catchment area of your chosen centre. Lastly, suggest and discuss at least one interstate or overseas shopping centre suitable for benchmarking. Similar to the above, simply copying and pasting generic information without acknowledge their sources may lead to 0 mark in this section.
5. Financial Analysis (10 Marks)
This section requires using very simple maths and an understanding of the term “Net Income Multiplier” (NIM) which was discussed in Discovering Opportunities in Property (BUSS 1055) course. You are now required to assume that you are asked by your boss to establish the viability of upgrading the shopping centre. Rents as follows (before and after upgrade):
Table 1 The centre tenancy and rental profile
Tenancy type
Number of stores in this category*
Size
(square metres)
Current net rent
(Per square metre per year)
Proposed net rent
(Per square metre per year)
Supermarket
2,500
210
380
Menswear
290
450
460
Women’s fashion
400
400
420
Café/restaurants
100
530
540
Banks and services
70
650
600
Fresh food
80
450
460
Other
190
600
600
*below columns should be completed based on the actual numbers of tenants you identified from your chosen centre
After consultation with the centre management, their architects and builders have proposed to upgrade the centre in various ways, including upgrading the external appearance of the centre with greater signage and visual display of tenancies, extending the landscaping area to provide more pleasurable experience for shoppers, to upgrade the air-conditioning of the centre and to provide further and more modern lighting internally. Total cost will be as follows:
$21,000,00
The current NIM for a centre of this nature has been determined to be 19.2. After consultation with a valuer, it has also been determined that the NIM appropriate for the centre AFTER the proposed upgrade will be changed to 19.5.
You are to establish the followings using an excel sheet. Using the given Excel spreadsheet, you will first have to insert appropriate formulas, then you can simply copy and paste the excel into the word document. Eventually, this section must present the followings:
The “current” and “proposed” market net rent for the whole centre
The percentage increase in rent from “current to proposed” for the whole centre
The “current” and “proposed” market value of the centre (based on the NIM as provided)
The “actual” dollar and “percentage” increase in value of the centre
“Percentage” of return on capital expenditure (i.e. return on expenditure)
And most importantly, “discussions” on whether the return on capital expenditure is good or poor
6. Conclusions and Recommendations (20 Marks)
This section hardly requires any explanations. But keep in mind that you need to present at least three recommended practices to raise the competitive advantage of your centre after presenting conclusions of your report. Similar to your discussions in other sections, these recommendations must be supported by proper justifications.
7. Referencing and presentation (5 Marks)
This report should be referenced appropriately, both “in text” and “end of text” using the APA referencing guideline. See below for further guidance on how this will be addressed from a marking perspective. Your mark for this section will be dictated by not only how appropriately you have referenced but also for the extent to which you have researched and referenced appropriately.
Additional information on assessment criteria:
In addition to the general assessment criteria discussed within this report, the following specific criteria will apply to the grading of your assignment:
How well your statements and arguments are supported by data from trustful sources (i.e do NOT use Wikipedia)
How well you provided a link between each section. So, in expressing an idea about the centre you should provide evidence (“justification”) of confirming views arising from a reading or other study material including lectures.
PLEASE NOTE: The assumption is that your report is prepared in a professional, business-like manner; if it is, your mark for the section REPORT STANDARD will be zero. It is zero because this is the standard expected.
You will be penalised if the report is grossly substandard (for instance not adopting the headings as required, numerous spelling and grammatical errors, inadequate referencing and or significant deviation from the required words required). Significant deviation would amount to 10-15% above or below the stated wordcount range.
Students submitting their report after the due date will attract a penalty of 10% (of the total available mark) every day. You can upload a draft, which you can then revisit and update if you need, however, whatever is in the system at the due date is the assignment that will be marked. Again, extensions can be given only when it is allowed by the University’s Academic Policy. Staff will aim to mark assignments within 10 working days of receiving them but no longer than 15 working days. i will send class materials

Please Note: Once your assignment is submitted and graded, the grade will be final, no re-submissions will be allowed.
CHAPTER 6 (Part 1) – Legal Descriptions, Title & Deeds:
1. List and DEFINE the 3 major methods used to legally describe and locate land.
2. Under what Baseline and Meridian is San Diego County located? What is a section? How many acres are there in a section? How many sections are there in a township?
3. Name and DEFINE the 5 legal methods of acquiring title to property.
4. DESCRIBE in detail the difference between a Grant Deed and a Quitclaim Deed.
5. Name the six essential elements required for a valid deed (not to be confused with what the county recorder will accept).

Scenario:
Congratulations! You are now appointed as an Asset Manager of an Australian property asset management company operating its business across Australia. Your first task as an Asset Manager is to prepare a report containing detailed analysis of a shopping centre in SA, linking its strategic aspects of the centre with local socio-economic data and other relevant material introduced in the course. Furthermore, you are required to carry out some simple financial analysis.
Available options to choose:
Sefton Plaza Shopping Centre, Sefton Park
Please do not try to contact centre management or tenants to obtain information to complete this assessment. Instead, you can utilise their website, news articles, publications, and other resources accessible through the Internet.
Format/Assessment Criteria:
This report needs to be prepared using the below headings. You may include photos, tables, graphs and floor plans as long as they are relevant, properly captioned (e.g. Table 1. XXX) and discussed in the main text. Referencing in accordance with the APA referencing system is required. You are to provide a word count for the report.
1. The Centre Descriptions (5 Marks)
This section requires descriptions about your chosen shopping centre including its location, centre category and the current shopping centre management (e.g. Westfield, Mirvac, Stockland, etc.). A breakdown of the tenancy type (based on Supermarket, Menswear, Women’s fashion, etc. See Table 1 under the “Financial Analysis” section for further details) as well as discussions on the “magnet” of the centre should be also included (there may be more than one magnet!). Any other introductory information such as a number of car parking and GLAR can be also included.
2. The Centre Operations (20 Marks)
This section requires discussing the operational side of the centre. This typically involves the ease of finding tenants and the natural traffic flows within the centre. Further, you need to identify the “magnet” of the centre and why, followed by discussions on how they might impact on overall centre operations. By inspecting the centre, you may be also able to identify and discuss current vacancies (if any) and “dead spots”. Besides, any unique features or strategies currently adopted by the centre to gain competitive advantages in the market should be also discussed. For example, your centre may be one of the “green” certified shopping centres.
3. Catchment Area Analysis (20 marks)
This section requires defining the “catchment” areas of the chosen centre (there may be more than one catchment areas). This should be followed by discussing demographics of the identified catchment area and what those demographics tell us about the shoppers and the centre operations. If you expect any changes of the catchment area in the near future, it can be also discussed here. Some useful resources to complete this section include the Australian Bureau of Statistics (ABS) and profile.id. Keep in mind that simply copying and pasting demographic information without discussing their implications specific to your centre may lead to 0 mark in this section.
4. Competitor Analysis (20 marks)
This section requires discussing at least two current or potential competitors of the centre. This should include providing descriptions on identified competitors as well as their advantages and disadvantages compared to your centre. You should also highlight if any of these competitors at least partially share the catchment area of your chosen centre. Lastly, suggest and discuss at least one interstate or overseas shopping centre suitable for benchmarking. Similar to the above, simply copying and pasting generic information without acknowledge their sources may lead to 0 mark in this section.
5. Financial Analysis (10 Marks)
This section requires using very simple maths and an understanding of the term “Net Income Multiplier” (NIM) which was discussed in Discovering Opportunities in Property (BUSS 1055) course. You are now required to assume that you are asked by your boss to establish the viability of upgrading the shopping centre. Rents as follows (before and after upgrade):
Table 1 The centre tenancy and rental profile
Tenancy type
Number of stores in this category*
Size
(square metres)
Current net rent
(Per square metre per year)
Proposed net rent
(Per square metre per year)
Supermarket
2,500
210
380
Menswear
290
450
460
Women’s fashion
400
400
420
Café/restaurants
100
530
540
Banks and services
70
650
600
Fresh food
80
450
460
Other
190
600
600
*below columns should be completed based on the actual numbers of tenants you identified from your chosen centre
After consultation with the centre management, their architects and builders have proposed to upgrade the centre in various ways, including upgrading the external appearance of the centre with greater signage and visual display of tenancies, extending the landscaping area to provide more pleasurable experience for shoppers, to upgrade the air-conditioning of the centre and to provide further and more modern lighting internally. Total cost will be as follows:
$21,000,00
The current NIM for a centre of this nature has been determined to be 19.2. After consultation with a valuer, it has also been determined that the NIM appropriate for the centre AFTER the proposed upgrade will be changed to 19.5.
You are to establish the followings using an excel sheet. Using the given Excel spreadsheet, you will first have to insert appropriate formulas, then you can simply copy and paste the excel into the word document. Eventually, this section must present the followings:
The “current” and “proposed” market net rent for the whole centre
The percentage increase in rent from “current to proposed” for the whole centre
The “current” and “proposed” market value of the centre (based on the NIM as provided)
The “actual” dollar and “percentage” increase in value of the centre
“Percentage” of return on capital expenditure (i.e. return on expenditure)
And most importantly, “discussions” on whether the return on capital expenditure is good or poor
6. Conclusions and Recommendations (20 Marks)
This section hardly requires any explanations. But keep in mind that you need to present at least three recommended practices to raise the competitive advantage of your centre after presenting conclusions of your report. Similar to your discussions in other sections, these recommendations must be supported by proper justifications.
7. Referencing and presentation (5 Marks)
This report should be referenced appropriately, both “in text” and “end of text” using the APA referencing guideline. See below for further guidance on how this will be addressed from a marking perspective. Your mark for this section will be dictated by not only how appropriately you have referenced but also for the extent to which you have researched and referenced appropriately.
Additional information on assessment criteria:
In addition to the general assessment criteria discussed within this report, the following specific criteria will apply to the grading of your assignment:
How well your statements and arguments are supported by data from trustful sources (i.e do NOT use Wikipedia)
How well you provided a link between each section. So, in expressing an idea about the centre you should provide evidence (“justification”) of confirming views arising from a reading or other study material including lectures.
PLEASE NOTE: The assumption is that your report is prepared in a professional, business-like manner; if it is, your mark for the section REPORT STANDARD will be zero. It is zero because this is the standard expected.
You will be penalised if the report is grossly substandard (for instance not adopting the headings as required, numerous spelling and grammatical errors, inadequate referencing and or significant deviation from the required words required). Significant deviation would amount to 10-15% above or below the stated wordcount range.
Students submitting their report after the due date will attract a penalty of 10% (of the total available mark) every day. You can upload a draft, which you can then revisit and update if you need, however, whatever is in the system at the due date is the assignment that will be marked. Again, extensions can be given only when it is allowed by the University’s Academic Policy. Staff will aim to mark assignments within 10 working days of receiving them but no longer than 15 working days.