Cash Flow Analysis & Argus Software

I used the Argus software to model out cash flows for four different multi-family properties. I developed an investment thesis on which properties would best suit two distinct investors. 

Feasibility Analysis (Equity Waterfall)

I performed a financial feasibility analysis of the Metropolitan at Lakeview apartment building in Durham, North Carolina. In this preview, I use an equity waterfall to calculate the returns to the general partner and the limited partner. The purpose of this project was to compare this project's book value and market value, and as a result, I created two different waterfall scenarios. 

Feasibility Analysis (Qualitative)

Durham, North Carolina is currently experiencing a construction boom of multi-family units. In addition to my financial feasibility analysis, I do a supply analysis to see if the Metropolitan at Lakeview apartment building should be built given Durham's construction boom. 

Loan Underwriting

I underwrote a residential mortgage for a property in Ithaca, NY. Here, I created different loan schedules and structures to qualify a potential home buyer.  

Back of the Envelope

I used back-of-the-envelope calculations to analyze the feasibility of a new shopping mall in Orlando, Florida. In this preview I demonstrate the cap rate front-door approach.

Market Analysis

This report is my in-depth macro-economic analysis of the Miami commercial real estate market. I concluded by identifying the key economic drivers of this market.

Location Analysis

I conducted a location analysis for JC Penney. I used regression analysis to see which future locations would be the most profitable and feasible for the franchise. 

Quick and Dirty Analysis

I performed a "quick and dirty analysis" on a prospective residential subdivision in Meridian, Idaho. I evaluated the developer's profit as a percentage of total expenditures, profit as a percentage of total revenue and return on equity to see if this project was profitable enough for the local developer. 

Tax Incremental Financing (Public Private Partnership)

In this report, I analyze the development of the Brunswick Crossing residential subdivision in Maryland. This project was a partnership between the Brunswick Crossing LLC and the local Brunswick government. Tax incremental financing is included in this project's capital structure, and I calculate if this project is feasible for both the government and the developer. 

Adaptive Reuse

In this report I look at an apartment building located in the South Shore community of Chicago. I analyze whether it's more profitable to invest in the apartment building as is or to convert the apartment units into condominiums.   

Commercial Leasing (GM Building)

For this project I used the Compstak database to analyze all the leases in the GM Building. In this preview, I modeled out the rents per floor group and the relationship between lease terms and rent concessions.