Real Estate PE Financial Model for Extended Stay Brand — HoldCo / OpCo / PropCo

Posted last month

Worldwide

Summary

We are building a 10-sheet Excel financial model for a premium co-living / extended-stay residential concept based in Dubai. The model covers three entities: HoldCo (platform), OpCo (operations), and property-level SPVs acquired one per year from 2027. It must model two investment stories simultaneously: (1) investing in the HoldCo platform, and (2) investing in individual property SPVs as an LP. Key requirements: 10 sheets: Assumptions, HoldCo P&L, SPV models, OpCo P&L, Consolidated Cash Flow, Investor Summary Single scenario toggle: Best / Base / Worst Case across the entire model LP return waterfall: 7.5% preferred return, 80/20 carry split Fees: 2% arrangement, 2% AUM, 0.75% disposal, 20% carry Debt modelling: 40% LTV, monthly DSCR covenant tracking 7 revenue streams per property Cash flow must determine when HoldCo needs to raise (Series A trigger) and when each SPV needs additional debt 15 charts including IRR sensitivity heat map, LP waterfall, and fundraising timeline Output: raise amounts are model outputs, not pre-set inputs A detailed brief will be shared upon shortlisting. Please include examples of comparable multi-entity real estate PE models in your proposal. First draft needed within 7 days. Fixed price only.

  • $1,750.00

    Fixed-price
  • Intermediate
    Experience Level
  • Remote Job
  • Ongoing project
    Project Type
Skills and Expertise
Mandatory skills
Financial Modeling
Financial Analysis
Activity on this job
  • Proposals:20 to 50
  • Last viewed by client:4 weeks ago
  • Hires:
    1
  • Interviewing:
    8
  • Invites sent:
    17
  • Unanswered invites:
    4
About the client
Member since Mar 7, 2019
  • United Arab Emirates
    Dubai2:53 AM
  • $22K total spent
    36 hires, 9 active
  • 116 hours
  • Retail & Consumer Goods
    Large company (100-1,000 people)

Explore similar jobs on Upwork

Business Plan
Market Research
Business Modeling
Data Analysis
Financial Analysis
Forecasting
Financial Analysis
Business Valuation
Real Estate Financial Modeling
Pitchbook
Financial Modeling
Business Presentation
Pitch Deck
Microsoft PowerPoint
Microsoft Excel
Business Plan
Graphic Design
Presentations
Market Research
Financial Analysis & Valuation

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo