Summer 2009
General Information
- The class blog is located at http://rea5311.blogspot.com
- If you are pursuing the blog research paper option then you will post your paper to the REAE program blog at http://realestateprogram.blogspot.com
Class Note Downloads
Introductory Appraisal Video/Audio Clips (to accompany chapters 6-9)
To download and view the class notes, you must use Explorer (version 5.0 or higher) or Netscape. Please note that Firefox will not work.
Optional Valuation/Appraisal clips (notes from another textbook but very useful):
Ch 12 PP | Chapter 12 pdf | Chapter 12 Video/Audio Clip (23 min) | |
Ch 13 PP | Chapter 13 pdf | Chapter 13 Word | Chapter 13 Video/Audio Clip (40 min) (wmv file right click and save to desktop to download) |
Ch 14 PP | Chapter 14 pdf | Chapter 14 Video/Audio Clip (38 min) | |
Ch 15 PP | Chapter 15 pdf | Chapter 15 Word | Chapter 15 Video/Audio Clip (29 min) |
Ch 17 PP | Chapter 17 pdf | Chapter 17 Video/Audio Clip (43 min) | |
Ch 18 PP | Chapter 18 pdf | Chapter 18 Word | Chapter 18 Video/Audio Clip (66 min) |
Ch 20 PP | Chapter 20 pdf | Chapter 20 Word | Ch 20 Part 1 Audio/Video Clip (wmv file right click and save to desktop to download) Ch 20 Part 2 Audio/Video Clip (wmv file right click and save to desktop to download) |
Ch 21 PP | Chapter 21 pdf | Chapter 21 Word | Chapter 21 Audio/Video Clip (wmv file right click and save to desktop to download) |
Ch 22 PP | Chapter 22 pdf | Chapter 22 Word | Chapter 22 Audio/Video Clip (wmv file right click and save to desktop to download) |
Ch 23 PP | Chapter 23 pdf | Chapter 23 Audio/Video Clip (wmv file right click and save to desktop to download) |
Other valuation appraisal materials (time permitting):
- Appraisal Crossword Puzzle (.pdf)
- Appraisal Crossword Puzzle Solution (.pdf)
- Other Materials for Appraisal (.pdf)
- Video/Audio Clip for SC and Cost Approach Solutions (20 minutes)
- Sales Comparison Approach Problem Solution (.pdf)
- Cost Approach Problems Solutions (.pdf)
- Video/Audio Clip for the Case of the Botched Appraisal Instructions (15 minutes)
- Case of the Botched Appraisal Instructions
- Video/Audio Clip for the Case of the Botched Appraisal Solution
Review Materials (TVM Review) for Real Estate (pdf and WMV audio/video clips)
- Review Materials for Real Estate Audio/Video Clips:*
*Note: These links are to .WMV files. You can try to click directly on this link to start your media player, however, you will likely need to download this clip on to your desktop, then double-click on the downloaded file. To download this file, “right click” on the link above. In the menu that appears, select “Save target as…” and save this file to your desktop. Go to your desktop and double-click on the file to start.- HP calculator overview
- Introduction
- Time-value-of-money (TVM) Part I
- TVM Part II
- Problem Set 1
- NPV/IRR
- Problem Set 2
- Mortgage Calculations
- Problem Set 3
- Duration and Variance of Cash Flows (Time Pending)
- Problem Set 4 (Time Pending. Answers are posted on website.)
Time Value of Money Review Problem Set Answers
TVM Review: Problem set 1 Answers:
- 24,464.43
- 25,093.31
- 1,738.91
- 4,755.19
- 675,764.89
- 14,381.74
TVM Review: Problem set 2 Answers:
- 10% compounded semi-annually (1.05^2 = 1.1025; 1.0238^4 = 1.0984)
- 19,236.15
- 98,111.31
- 5,575.46
- 22,601.66
- 15.94%
- 6,357.56
TVM Review: Problem set 3 Answers:
- ANN: 15 – 25,288.30 25-20,519.45 MO: 15-2,067.95 30-1614.72
- 14,043.41
- Yes, NPV = 10,850.30
- 13.22%
- PMT = 103,873.36
- Balance end of year 5 equals 961,283.21
- Balance end of year 15 equals 801,472.49
- PV = 854,972.16
- 79,612.63 + 220,436.31 = 300,048.94
- PMT = 638.58 (724.26 – 638.58 = 85.68)
- IRR = 16.2%; NPV = 1,306.20
- 68,640.81
Problem Set 4:
- a) 19,876.60 b) 1,903,479.15
- 8,076.30 + 159,263.83 = 207,340.13
- Investment 1 IRR = 9.57% Investment 2 IRR = 10.18% or 9.94% assuming annual compounding
- N=60, I = 12%, Pmt = 657.56, FV= 88,000 then 657.56 (pmt) + 120.00 (taxes, insurance, maintenance) = $777.56 rent
- $1,365.86
- 8.5%
- 12.14%
- NPV = $209.94 IRR = 12.27%
- a) 10.36% b) 4,378.29
- 163,028.46
- 1,294.88
- 137,243.36
Investment Problem Downloads
- Investment Problem Instructions (1, 2, and Homework)
- Investment Problem 1 Steps 1-7
- Amortization Table
- Investment Problem Spreadsheet
- Investment Problem Print Out with Notes (pdf file)
- Investment Problem Video/Audio Clips
GIS Related Links
The link to the two GIS site selection practice files (pizza restaurant and campaign headquarters) is: http://magellan.uta.edu/website/download/
UTA GIS Projects for REAE: http://libraries.uta.edu/gis/imsspecial.htm
UTA GIS Project Data and GIS Viewer: http://magellan.uta.edu/website/reaemls/reaemls/viewer.htm (password required)
ArcGIS website (ESRI): http://www.esri.com/ (free trial version)
MapInfo website: http://extranet.mapinfo.com/products/products_index.cfm?productcategoryid=1
MapPoint website: http://www.microsoft.com/mappoint
Maptitude GIS software website: http://www.caliper.com/maptovu.htm
Relevant Articles
Arlington Star Telegram
AST 1/25/03 C1 Foreclosure postings most in 8 years (.PDF)
AST 1/24/03 C1 Arlington survey has some seeing positives (.PDF)
AST Avoiding (Costly) Closing-Table Surprises (.PDF)
Tierra Grande (Journal of the Real Estate Center at Texas A&M University)
TG 1/03 p. 2-5 Why Texans won’t kill robin hood (.PDF)
TG 1/03 p. 13-19 Texas two-step: Looking back, moving forward (.PDF)
Interested in more real estate related articles? CLICK HERE THEN SCROLL DOWN
Relevant Links
Anyone interested in a free report on the real estate industry? Checkout the Lend Lease Real Estate Investment (http://www.lendleaserei.com/) Emerging Trends in Real Estate 2003(http://www.lendleaserei.com/LLREI/freeform.nsf/Content/571774E730BBBEE685256C4C006A7235?OpenDocument).
Anyone interested in receiving weekly e-mail updates on the Texas real estate market? To subscribe go to http://recenter.tamu.edu
Home-Buyers Guide: (http://recenter.tamu.edu/pdf/1044.pdf)
Homeowner’s Guide: (http://recenter.tamu.edu/pdf/1415.pdf)
Landlords and Tenants Guide: (http://recenter.tamu.edu/pdf/866.pdf)
Texas Real Estate Sales and Broker Information: http://www.trec.state.tx.us/