Project-Based Financial Model
4 hours ago

Job description
Project OverviewWe are looking for a financial modeling specialist to build a thorough, responsive business model for Harpoon Media ), a social creator agency.
Harpoon is a streamlined, asset-light business with relatively few moving parts. However, we need to move beyond static projections and create a sophisticated, dynamic tool for real-time scenario planning.
Key Deliverables
Integrated Financial Core:
A clean P&L and Cash Flow engine capturing:
Fixed Costs:
Overhead, SaaS/tools, and office expenses.
Variable Costs:
Creator payouts, production costs, and platform-specific fees.
Headcount Planner:
A scalable section for current and future hiring (Salary + ERE).
Product-Specific Assumption Engine:
A "Control Panel" tab to input monthly variables across our core product tiers.
Cascading Scenario Planning:
The model must be architected so that changing a single monthly assumption (e.g., Campaign Count) automatically cascades through the entire sheet to show the impact on EBITDA and runway.
Technical RequirementsDynamic Architecture:
Expert use of Data Validation (toggles) and INDEX/MATCH or OFFSET functions—zero "hard-coding" within formulas.
Clarity:
A "Dashboard" tab that visualizes key metrics (CAC, LTV, Burn) for executive review.
Speed & Precision:
Ability to deliver a working V1 within 3-4 days for review.
Contract duration of less than 1 month.
Mandatory skills:
Financial Modeling, Microsoft Excel
Similar jobs
Nuestro equipo busca modelos financieros expertos en francés para apoyar proyectos de asesoramiento financiero y capital destinados a clientes francófonos. · Se requiere experiencia en análisis financiero, modelización financiera y valoración empresarial. · Fabricación robusta e ...
1 month ago
We are merging a group of un integrated business units together.The role will require someone who can source financial information from the business & format it into a consolidated group model. · ...
1 month ago
Design and delivery of a robust fully integrated financial model to support strategic decision making fundraising or investment evaluation. · The model will incorporate clear assumptions detailed revenue and cost drivers integrated profit and loss cash flow balance sheet projecti ...
1 month ago
Necesita un modelo financiero construido para una acería. Se proporcionan suposiciones básicas. · Contrato duración entre 1 y 3 meses con · 30 horas por semana. · ...
1 month ago
A financial modelling task needs to be completed by Wednesday at 12:00 p.m. · ...
2 days ago
I'm an early-stage founder building a UK-based women's wellness / supplement brand and I'm looking for support creating a realistic 12-month financial model and lean business plan to guide launch decisions. · ...
2 weeks ago
I need help with financial modelling to get the existing excel up to scratch. · get the existing excel up to scratch · ...
5 days ago
I need a financial model for a company using Excel and providing a written report. The contract duration is 1-3 months. · ...
4 weeks ago
Seeking an experienced financial modeler and business plan specialist to create investor-ready financial models business plans and pitch decks for startups and SMEs. · ...
1 month ago
We are looking to hire an experienced financial analyst. · ...
1 month ago
+We are looking for support in building and reviewing standalone financial models of publicly listed companies in Southeast Asia and China. · +Review filings and current transactions · Prepare a standalone financial model · +Chartered Financial Analyst · Equity Research · ...
1 month ago
We are building a real estate platform comprising of multiple warehousing assets.Need to build a model showing entry and exit yield, IRR based on sale at a certain cap rate and assumed rental, and also a DCF. · ...
1 month ago
We are a pre-revenue SaaS startup looking for an expert to build a professional 5-year Financial Model (Projection) to present to investors and Venture Capitalists. · You can use a standard SaaS model template or build a custom one, as long as it meets industry standards for earl ...
1 month ago
Financial Model & Investor Pitch Support – Automated Car Wash Platform (Saudi Arabia) · 1. Project Overview · We are building a scalable automated car wash platform in Saudi Arabia and are currently raising equity capital for our pilot phase and broader expansion plan. · We requi ...
1 day ago
Build and enhance advanced valuation models including DCF (WACC-based), trading comps, and precedent transaction analysis. · Develop integrated 3-statement financial models, operating models, and 13-week cash flow forecasts. · Create deal models such as LBO, merger models (base v ...
6 days ago
Update Excel financial models to make them easily reusable with different assumptions and inputs that change the entire output but deliver the same financial analysis results. · ...
1 month ago
I'm looking for a skilled financial modeler with a past history of working in investment banking for a mining acquisition. · ...
1 month ago
This role involves creating a comprehensive financial model in Excel for a startup company. · ...
2 weeks ago
I am looking for an experienced financial modeling and reporting specialist to help me design and build a durable Excel-first financial operating system. · Review existing spreadsheets and deliverables · , · , · Audit and Architecture Phase ...
1 month ago
I am a daycare owner looking for an Excel/Google Sheets expert to build a comprehensive enrollment management system. I am expanding my facility and need a tool that handles both my current daily operations and my future growth planning. · ...
3 weeks ago
We are seeking a Financial Analyst to support dynamic banking portfolios. This role involves financial modeling and data analysis for the Canadian retail banking line of business. · ...
2 weeks ago