1 / 11

Course information

Course information. Real estate finance (RE410). Erwan Quintin equintin@bus.wisc.edu https://mywebspace.wisc.edu/quintin/web/ 5257 Grainger Hall Office Hours: T 2-4pm and by appointment. Grading. HW (25%), midterm (35%), final (40%)

kalin
Download Presentation

Course information

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Course information Real estate finance (RE410)

  2. ErwanQuintin equintin@bus.wisc.edu https://mywebspace.wisc.edu/quintin/web/ 5257 Grainger Hall Office Hours: T 2-4pm and by appointment

  3. Grading • HW (25%), midterm (35%), final (40%) • HW assignments are due at the beginning of lecture on the due date • “The mean grade should be no higher than 3.3 and the maximum percentage of A's is 30%” • Midterm: • Final: 12/17, 12:25pm

  4. Course plan • Preliminaries • Foundations of Asset Pricing • Real Estate Investment Analysis • Mortgages • Topics

  5. Course Material • Lecture notes • Power Point slides • Recommended textbook: “Commercial Real Estate Analysis and Investments,” Geltner, Miller et. al. (GM)

  6. Tools • Excel • Basics • Financial functions (NPV, IRR, PMT…) • Math and statistical functions (SUM, AVERAGE, …) • Logical functions (IF…) • Goal seek • Scenario analysis macro • Data analysis toolpak (regressions, RAND…) • Math • Basic algebra • Geometric sums • Notions of probability • Financial calculator

  7. How to turn in computer tasks • Include print-outs of the key Excel sheets you used to derive answers • Print only essential material

  8. Excel etiquette Inputs Model Outputs Outputs

  9. Good spreadsheets • Correct, clean and clear • As simple as possible • Use multiple sheets when and only when necessary

  10. Bloomberg • A gold mine and a must for capital market analysts • A good line on one’s CV • If you become certified by class’ end, your lowest HW grade will become a 100

  11. Questions?

More Related