Real Estate, finance & Data Case Studies

20181008_164317.jpg

M.S. in Real Estate Candidate at Baruch College

Graam Liu 

"Hello and welcome! I believe that responsible real estate development can improve our communities and bring quality jobs to everyone. With that passion I am honored to add value to people's lives and to businesses with my background in creativity and quantitative analysis."

Sustainable Renovation Proposal for 235 Park Ave S

Using NYC data, I found that 235 Park Ave had an Energy Star score of only an 8. So it was due for a sustainable renovation to meet city law and address rapid climate change. 

 

Written by: Graam Liu 

Class: Sustainable Development taught by Professor Daniel Egan

 

 

 

 

 

 

 

 

Feasibility Analysis for Sears Redevelopment 

Pre-Covid 19 feasibility analysis for the redevelopment of a Sears in Prescott, AZ.

 

Written by: Thea Leitman, Jennifer Lewis, Graam Liu

 

 

Executive Summary, Design Concept, Market Study, Marketability Study, Operating Pro Forma, Hurdle Rate, Leasing/Sales Plan, Marketing Plan and Exhibit C Financial Sections by: Graam Liu 

Class: Real Estate Development taught by Professor Stephen Peca

 

 

 

 

 

 

 

 

Creating a Retention 

Strategy Using R

What is the best way to avoid customer churn in a telecommunications company? Utilizing R and data mining techniques, correlations were uncovered and an efficient retention solution was presented.

 

Proposal and website presentation designed, analyzed and led by: Graam Liu 

Class: Data Mining for Business Analytics taught by Professor Shuting Wang 

Tools: R, Excel, Kaggle

 

 

 

 

 

 

 

 

ANGUS CARTWRIGHT III

A Harvard University real estate case study about four income producing properties in Maryland and Virginia. I led the team in performing the financial model and risk analysis in excel. 

 

Case analysis written by: Graam Liu, Sandra Santana, Vincenzo Ferrara and Natalia Zybtseva

Financial modeling led by: Graam Liu

Class: Real Estate Finance taught by Professor Stephen Pearlman

 

 

 

 

CAPM REGRESSIONS

Our team looked at the market (SPY) and five individual stocks over a five year period in order to perform a CAPM regression and analysis. I was the lead for the analysis in excel.  

Case analysis written by: Graam Liu, Frank Bradley, Hannah Godlove and Marcy Pritchard

Class: Corporate Finance taught by Professor Alessandro Castaldo

 

Three-Statement Financial Model - Training The Street

In a one day workshop hosted by Training the Street, I created a three-statement financial model using Kellogg's as a case study. The model forecasts up to five years using data from three prior years including working capital, supporting schedules, equity, debt, amortization and depreciation. In addition, the course went over controlling circularity errors and troubleshooting.

 

Workshop & Resource from: Training the Street

 

Model and Analysis by: Graam Liu