Financial Model & Capital Planning Consultant
Worldwide
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- IntermediateExperience Level
- Remote Job
- Ongoing projectProject Type
Skills and Expertise
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
- USAAltadena8:32 AM
- 1 hire, 1 active
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers 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