Skip to main content

Real Estate Investment Analysis Excel Skills (C)

  1. Course Number

    BuildAcademy_RE107
  2. Classes Start

    Self-Paced

Syllabus

7.1. Using Excel to Support Investment Decision-Making

Video 7.1

Brookside Square Excel Solution

Brookside Square Excel DCF Worksheet

Quiz 7.1

7.2. Sensitivity Analysis: Single Variable

Video 7.2

Brookside Square Excel DCF Worksheet, 1-Way Sensitivity Analysis

Quiz 7.2

7.3. Sensitivity Analysis: Two Variables

Video 7.3

Brookside Square Excel DCF Worksheet, 2-Way Sensitivity Analysis

Quiz 7.3

7.4. Break-Even Analylsis

Video 7.4

Brookside Square Excel DCF Worksheet, Break-Even Analysis

Quiz 7.4

7.5. Goal Seek

Video 7.5.

Brookside Square Excel DCF Worksheet, Goal Seek

Quiz 7.5

7.6. Scenario Management

Video 7.6.

Brookside Square Excel DCF Worksheet, Scenario Management

Quiz 7.6

7.7. Benefits of Stress Testing an Investment Analysis

Video 7.7.

Quiz 7.7

7.8. Conclusion

Video 7.8

7.9. Final Course Assignment

Course Assignment

7.10. Discussion

Excel Skills (C)

About This Course

This course completes the three course sequence on Excel Skills for analyzing income property. In previous course you have learned how to set up the spreadsheet and to compute all of the key return measures for evaluating the property using Brookside Square as a case illustration. This course teaches you how to use your Excel analysis for decision-making. You learn how to do sensitivity analysis and conditional formatting; break-even analysis; how to use the Goal Seek tool; how to build alternative scenarios; how to do stress testing on your assumptions; and what the benefits of stress testing are for investment analysis.

Learning Objectives

• To understand how to make the most of your Excel setup

• To learn how to do sensitivity analysis

• To learn how to do break-even analyses and to use the Goal Seek tool

• To understand how to develop alternative scenarios

• To understand the benefits of Stress testing

Workload

The course will require 3-4 hours of work to be completed.

Course Format

The course will feature video tutorials, excel training, virtual meetings, etc.

Assessments

The course will includes quizzes after each video, excel tutorials, and a written essay.

Certification

Build Academy will issue course certificates with credits to anyone who successfully completes 80% of the course assessments. Course participants will receive a diploma for completing the eight courses in the Real Estate Finance and Investment program.

Accreditation

We are in the process of accrediting the course with the State of New York for CEUs (Continuing Education Units). At the moment, the course awards international CPDs (Credits for Professional Development).

Prerequisites

The course is for real estate professionals who would like to further advance into their career and also for the general public who want to learn the basics of real estate. Successful completion of the previous courses in the program is required.

Readings

Kristen Hunter, The Brookside Square Case Study, 2016

Recommended readings:

Richard B. Peiser and David Hamilton, Professional Real Estate Development: The ULI Guide to the Business, 3rd Edition (The Urban Land Institute: Washington, D.C., 2012)

William Brueggeman and Jeffrey Fisher, Real Estate Finance & Investments, 15th edition (McGraw-Hill, 2015)

William J. Poorvu with Jeffrey L. Cruikshank, The Real Estate Game (Free Press, 1999).

Professors

Course Staff Image #1

Richard Peiser PhD, Michael D. Spear Professor at Harvard GSD

Richard Peiser has been the Michael D. Spear Professor of Real Estate Development at the Graduate School of Design since 1998. He is also Director of the university-wide Real Estate Academic Initiative created in 2003. He was previously on the faculty at the University of Southern California (1986-1998) as associate professor of urban planning and development, director of the Lusk Center for Real Estate Development, and Academic Director of the Master of Real Estate Development Program that he founded in 1986. His courses: Real Estate Finance and Development, Field Studies in Real Estate, Planning and Urban Design, and Advanced Real Estate Development and Finance offer basic and advanced-level study of real estate at the GSD. He also taught the studios: Alternative Urban Pattern Prototypes: Looking at Pomona/Los Angeles, Newry, Northern Ireland—Revealing History in Urban Reconstruction, and Alternative Futures for the West Lake, Hangzhou, People’s Republic of China, as well as field studies in Texas, California, New Hampshire, Idaho, and Shanghai. He is directing the school’s activities in advanced education for senior real estate executives, notably the six-week Advanced Management Development Program in Real Estate.

Course Staff Image #2

Kristen Hunter, DDes Candidate at Harvard GSD

Kristen Hunter is a doctoral candidate in Real Estate Finance and Urban Development at the Harvard University Graduate School of Design (GSD), where she has taught Real Estate Finance, as well as Public and Private Development, since 2010. She received a Master in Design Studies with distinction in Real Estate and Project Management from the GSD, earning the Gerald M. McCue Medal for highest overall academic record and the Ferdinand Colleredo Mansfeld Prize for superior achievement in real estate studies. She also holds an M.A. in Medieval Chinese History from Cornell University and an A.B. cum laude in East Asian Languages and Civilizations from Harvard University. An experienced real estate development manager and LEED AP, Kristen has delivered a variety of infill projects in Boston’s inner city neighborhoods, and currently provides strategic advisory for complex urban redevelopment projects in domestic and overseas markets.

Frequently Asked Questions

What web browser should I use?

The Build Academy platform works best with current versions of Chrome, Firefox or Safari, or with Internet Explorer version 9 and above.

See our list of supported browsers for the most up-to-date information.

Enroll