About Yash
REAL ESTATE | INSTITUTIONAL INVESTMENT ANALYSIS | FINANCIAL MODELLING & POWER BI
I provide institutional-grade Financial Modelling, Investment Analysis, and Underwriting for Commercial, Residential, Development, and Hospitality assets. With 10+ years of experience and an MSc (Distinction) from the University of Manchester, I have engineered models for acquisitions and developments exceeding £500M+ AUM.
Core Expertise
- Investment Underwriting: Audit-friendly, logic-based models (DCF, IRR, NPV) with zero hardcoding.
- Development & Construction Finance: Phased CAPEX (S-Curve), construction loan drawdowns, and refinancing/stabilization strategies.
- Operational Asset Management: Long-term hold models, NOI optimization, and revenue-from-operations analysis.
- Deal Structuring: Complex capital stacks, LP/GP waterfalls, and debt covenant testing (LTV/DSCR).
- Risk Analysis: Probabilistic modeling using Monte Carlo simulations for quantified risk assessment.
- Strategic Reporting: High-impact Investment Memoranda (IM), Board-level decks, and Lender Reporting packages.
Asset Class Experience
- Commercial: Office, Retail, Logistics.
- Residential & Living: Build-to-Rent (BTR), Student Accommodation, Co-Living, Multifamily
- Hospitality: Hotels, Resorts, Serviced Apartments, and STR/Airbnb portfolios.
Technical Toolkit
- Advanced Excel: VBA/Macros, fully dynamic dashboards, institutional-grade architecture.
- Data Visualization: Power BI for executive reporting and portfolio analytics.
- Market Intelligence: CoStar, STR benchmarking, AirDNA, MSCI.
Qualifications & Global Reach
- MSc Real Estate Asset Management (Distinction) – University of Manchester (RICS Accredited).
- 10+ Years Experience across UK, Europe, US, Middle East, and Asia.
- Award-Winning Strategist: Recognized for board-level business plans and market-entry strategies.
English
Native or bilingual
Can work on-site
Manchester (up to 50km)
Experience
- IndependentReal Estate Investment Advisory (Buy/ Sell-Side Underwriting Support)January 2025 - Today (1 year and 7 months)• • Built excel financial models for acquisitions and developments, including multi-layer debt structures, equity waterfalls, and scenario analyses.• • Conducted underwriting, feasibility, and franchise/managed deal analyses using DCF, IRR, NPV, DSCR, and ROI, incorporating interest rates, cap rates, income growth rate, and operating costs to project cash flows.• • Prepared investment memoranda, board reports, and IC presentations summarising key risks, sensitivities, value creation, franchise implications, and market insights for senior stakeholders.
- Mahindra Holidays and Resorts (Hotels and Resorts)Real Estate (Investment and Acquisitions)July 2019 - September 2023 (4 years and 2 months)• • Led the formulation of a 5-year destination-specific investment strategy, creating the strategic roadmap for long-term capital allocation and portfolio expansion into untapped geographies.• • Formulated strategic market entry assessments and engineered unique deal formats (JV, Lease, Management) to facilitate rapid expansion while mitigating commercial and regulatory risk.• • Developed high-impact board-level presentations, utilizing advanced data storytelling to distill complex underwriting into clear, actionable investment recommendations for the C-suite and Board of Directors• • Served as the primary strategic liaison for Investment Committee (IC) approvals, coordinating cross-functional teams (Legal, Revenue, Architects) to ensure site suitability and strategic alignment for all development opportunities.• • Engineered advanced DCF models for acquisitions and developments valued at $82.5M+, incorporating multi-scenario sensitivity analyses (IRR, NPV, DSCR) to validate financial viability.• • Managed the full transaction lifecycle from sourcing to execution, including the negotiation of commercial term sheets and the oversight of final deal documentation.• • Standardized institutional-grade model templates, lease abstracts, and automated rent-roll maintenance systems, increasing departmental efficiency in investment evaluation by 30%.• • Governed the alignment of all transactional documentation with legal and functional requirements, ensuring seamless transition from "Deal-Close" to "Asset Management."
- Juniper Hotels (Hyatt Hotels) (Hotel, Office, Retail)Real Estate (Acquisitions andApril 2012 - August 2016 (4 years and 4 months)Asset Management)• • Prepared cash flows, underwriting models, and sensitivity analyses for mixed-use developments, guiding investment and development decisions.• • Supported ongoing asset management by monitoring NOI, DSCR, covenant compliance, and business plan performanc and recommended strategies to optimise returns and operational efficiency.• • Evaluated and structured PPP bids, assessing concession terms, risk allocation, and investment viability for long-term projects.• • Conducted detailed market research and competitor benchmarking to inform development planning, launch strategies, and portfolio positioning.• • Collaborated with Finance and asset management teams to align financial models with operational targets and performance initiatives.
Recommendations
Be the first to recommend Yash
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- MSc Real Estate Asset Management (RICS Accredited)University of Manchester2024MSc Real Estate Asset Management (RICS Accredited)
- MBA and PGPM –Amity University, Amity Global Business School2012MBA and PGPM –