Yash Agarwal

Yash Agarwal

Manchester, United Kingdom

Yash Agarwal

Real Estate Investment Analyst
Category : Finance
REAL ESTATE | INSTITUTIONAL GRADE INVESTMENT ANALYSIS | PROBABILISTIC FINANCIAL MODELLING & POWER BI

Real Estate Financial Modeling, Investment Analysis, and Property Underwriting for Commercial Real Estate, Residential & Living Sector, Development Projects, and Hospitality Investments (Hotels, Resorts, STR/Airbnb).
I help investors, developers, and acquisition teams evaluate property opportunities through institutional-grade DCF models, feasibility studies, underwriting, and deal structuring across residential, commercial, and hospitality assets globally.
With 10+ years of real estate experience and an MSc (Distinction) from a Top 10 University in Europe, I have built financial models and investment analysis used for acquisitions, developments, and portfolio investment decisions worth £500M+.
My work has also been recognised through award-winning strategic business plans and presentations at board-level, demonstrating strategic acumen amongst high level stakeholders.

Investment Underwriting
- Financial Modeling & Valuation – Logic-based, Audit-friendly models (DCF, IRR, NPV) built with zero hardcoding, verified using macros. Expert in bifurcated modeling for both:
- Development Modeling: Phased CAPEX (S-Curve), construction financing, and refinancing strategies upon commencement of operations.
- Operational Modeling: Long-term rental-based (hold) models and revenue-from-operations analysis for both unit-sale and income-generating assets.
- Investment Decks & Reporting – High-impact Investment Memoranda, Presentation, Professional Board Decks, and Lender Reporting Packages tailored for institutional stakeholders.
- Risk, Portfolio & Asset Performance Analysis – Monte Carlo simulations, portfolio benchmarking, asset-level performance
- Deal Structuring & Capital Stacks – LP/GP waterfalls, layered debt structures, LTV/DSCR covenants
- Market Research & Investment Strategy – macro/micro analysis, market entry, benchmarking, investment committee reporting
- Investor & Lender Reporting – investment memoranda, financial summaries, board-level presentations

Asset Types
- Commercial Real Estate – Office, Retail, Logistics
- Residential & Living Sector – Build-to-Rent (BTR), Student Accommodation, Co-Living
- Hospitality & Short-Term Rentals – Hotels, Resorts, Serviced Apartments, Aparthotels, Airbnb / VRBO / STR portfolios, RV Park

Technical Toolkit
- Advanced Excel Financial Modelling – institutional-grade models, VBA, Macros, Zero hardcoding, fully dynamic & intuitive dashboards
- Probabilistic Risk Modelling – Monte Carlo simulations - Quantified risk assessment
- Data - Power BI - Executive Reporting and Portfolio Visualization
- Market Intelligence – CoStar, STR benchmarking, AirDNA, IPC Reports
- Visual Communication – Professional Investment Decks, Strategy Presentations, and Structured IMs (Investment Memoranda)

Qualification & Experience
- MSc Real Estate Asset Management – Distinction
- University of Manchester (Top 10 in Europe / Top 30 Globally)
- 10+ Years Real Estate & Investment Experience
- Financial analysis supporting $500M+ real estate transactions

Global Market Experience
UK | Europe | United States | Middle East | Asia

Working hours

  • Monday:08h00 To 18h00
  • Tuesday:08h00 To 18h00
  • Wednesday:08h00 To 18h00
  • Thursday:08h00 To 18h00
  • Friday:08h00 To 18h00
  • Saturday:Not available
  • Sunday:Not available
  • 🇬🇧 English
0.0 (0)
0
0
0
0
0
⚠️
Please sign in as a customer to give your feedback

    Need a service ?

    Do you want to hire the services of this Professional ?

    Post your need and you will receive dozens of proposals from the Professionals of the community.