Skip to content
BackNov 7
Ruchik C.

Ruchik C.

Real Estate Underwriter, Asset Valuation Report, Waterfall Modeling

Detail-oriented real estate analyst and underwriter. Extensive experience in sourcing deals, underwriting, and analyzing properties across the US. I have also worked in hospitality, preparing exhaustive US hotel appraisal reports using STAR and CoStar reports, analyzing ADR/Occupancy/other market metrics, and studying demographic trends. I hold an Engineering degree from Purdue University and an MBA from Babson College. I have lived and worked in the US, China, and India, and bring with me an international perspective. I have analyzed over 500 real estate deals in various sub-segments across the US and my experience includes: - Multifamily real estate underwriting - Commercial (NNN/FSG/MG leases) real estate underwriting - Self storage real estate underwriting - Analyzing economic vacancies - Performing detailed comps analysis - Analyzing expense line items - Creating business plans for value-adds - Analyzing Other Income opportunities - Waterfall, Promote Interest, Preferred Returns - Financial Modeling - Debt (agency vs private, fixed vs variable rates, using forward curves) - Evaluating demographics and macro data for specific locations - Making appraisal reports I can not only analyze rent rolls, offering memorandums, and T12s, but also interpret what the data is telling. I link the trends and paint a picture of what the property's performance is like. I have also extensively used redIQ (including valuationIQ and model generation), YardiMatrix, CoStar, Stortrack, and MS Excel including advanced functions for dynamic financial modeling. I am well-versed with data sources like Neighborhood Scout, FRED, BLS, FEMA, etc. used in evaluating a sub-market/location. I have also worked with multiple underwriting excel models and understand the nuances of various models as well as how the numbers flow through the various calculations. Working as a real estate analyst, I have developed a solid understanding of real estate partnership structures including promoted interest, catch-up, clawbacks, and various waterfall models. I can also model waterfall structures in Excel based on the Partnership/Operating agreement conditions. As an analyst, I can create investor memos, investor presentations, and content for offering memorandums. I can also write content and blogs for investors.

🇮🇳Mumbai, India$18/hr100% JSS4.78 (58)Since Jul 2015

Earnings and projects

MRR
$0

Last 6 months ÷ 6

World#55,848 / 412k
🇮🇳Country#8,700 / 45.9k
Revenue, last 30 days
$0
Total earnings
$71k

Billed in all: $72k

World#55,848 / 412k
🇮🇳Country#8,700 / 45.9k
Per project
$826

$0 in the last 6 months

Projects, last 6 months
1

Across 2 contracts

0% fixed100% hourly
World#128,092 / 412k
🇮🇳Country#14,379 / 45.9k
Projects in all
86

Across 93 contracts

53% fixed47% hourly
World#33,682 / 412k
🇮🇳Country#5,972 / 45.9k

Earnings, last 30 days

$72.5kNothing earned in the last 30 daysBilled in all, before Upwork's fee · drag across the chart to see what was earned in any stretch
$71k$72k$73k$74kOct 8Oct 23Nov 7

Skills