Financial Model & Capital Planning Consultant

Posted last month

Worldwide

Summary

Build Investor-Grade Financial Model for Hospitality / Cafe / Event Venue Startup (Real Estate + SBA Financing) Project Overview We are launching Gattos, a hospitality concept in Pasadena, California that combines: Premium cafe and coffee program Sandwich-focused food menu Beer and wine garden Private events and community programming Owner-occupied commercial real estate We are currently evaluating a property acquisition and need an experienced financial modeling consultant to build a fully integrated, investor-grade financial model that can support: SBA financing discussions Investor fundraising Internal decision making Long-term business planning This is not a generic startup model. We are seeking someone with experience in: Restaurant finance Hospitality finance Commercial real estate underwriting SBA lending Investor capital structures Scope of Work Build a fully integrated financial model that includes: Real Estate Acquisition Property purchase Closing costs Construction and tenant improvements Furniture, fixtures and equipment (FF&E) Contingency reserves Working capital reserves Capital Structure SBA 7(a) and/or SBA 504 financing scenarios Investor equity Owner equity Construction financing assumptions Interest-only periods Permanent financing scenarios Revenue Modeling Cafe Operations Guest counts Average ticket size Coffee sales Food sales Seasonal assumptions Ramp-up assumptions Events Program Event frequency Event attendance Event revenue Food and beverage revenue Rental income Beer & Wine Program Average spend per guest Frequency assumptions Revenue forecasting Expense Modeling Include all major operating expense categories: Labor Payroll taxes Employee benefits Food COGS Beverage COGS Utilities Insurance Marketing Software subscriptions Maintenance Property taxes Professional services Miscellaneous operating expenses Financial Statements Build integrated: Profit & Loss Cash Flow Statement Balance Sheet Model should be fully linked and formula-driven. No hard-coded assumptions outside of the assumptions tab. Analysis Required Include: Monthly forecasts for first 36 months Annual forecasts through Year 10 Break-even analysis Debt service coverage ratio (DSCR) Cash flow analysis Sensitivity analysis Examples: Revenue down 10%, 20%, 30% Labor cost increases Construction cost overruns Interest rate increases Investor Analysis Include: Preferred return modeling Investor distribution scenarios Equity waterfall (if appropriate) IRR calculations Equity multiple calculations Deliverables Fully functional Excel model Assumptions dashboard Sources & Uses schedule Monthly operating forecast 10-year forecast Sensitivity analysis section Documentation explaining model structure One or two review sessions via Zoom Required Experience Please apply only if you have experience with at least one of the following: Restaurant financial modeling Hospitality financial modeling Hotel underwriting Event venue financial modeling Commercial real estate underwriting SBA loan financial projections Fractional CFO services for hospitality businesses When Applying Please provide: Examples of previous financial models you have built Hospitality or restaurant experience SBA financing experience Commercial real estate underwriting experience Estimated project cost Estimated timeline Budget Open to fixed-fee proposals. Preference will be given to candidates who have built financial models for hospitality businesses seeking SBA financing and outside investment. Additional Note to Candidates This project is already partially scoped. We have substantial assumptions, operating plans, staffing models, revenue projections, buildout estimates, and capital planning work completed. We are looking for a professional who can organize, challenge, refine, and convert those assumptions into a lender-ready and investor-ready model. The ideal candidate will act as a strategic financial partner rather than simply an Excel builder.

  • $2,000.00

    Fixed-price
  • Intermediate
    Experience Level
  • Remote Job
  • Ongoing project
    Project Type
Skills and Expertise
Mandatory skills
Financial Modeling
Financial Analysis
Nice-to-have skills
Financial Projection
Financial Accounting
Activity on this job
  • Proposals:20 to 50
  • Last viewed by client:3 weeks ago
  • Hires:
    1
  • Interviewing:
    6
  • Invites sent:
    7
  • Unanswered invites:
    0
About the client
Member since Jun 6, 2026
  • USA
    Altadena8:32 AM
  • 1 hire, 1 active

Explore similar jobs on Upwork

Microsoft Excel
Financial Modeling
Visual Basic for Applications
Financial Analysis
Data Entry
Spreadsheet Software
Data Visualization
Founding Revenue AssociateHourly‐ Posted 1 month ago
Business Development
Sales Development
Lead Generation

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