Excel Revenue Share Calculator for Consulting Partnership

We need someone to build a Revenue Share Calculator for Consulting Partnership (One-Time Excel Model). We are a B2B consulting firm entering a commercial partnership with another firm. We need a custom financial model built to project revenue scenarios, calculate commissions, and support our contract negotiation. Project Scope We need a single-use calculator (Excel or Google Sheets) that models: - Joint revenue share by deal - Bidirectional commission structures (each partner can refer and/or deliver) - Multiple deal types and service categories (PR, Analyst Relations, HubSpot, Paid Media, etc.) - Revenue over time, margin analysis, and profit split - Adjustable scenario planning (conservative / base / aggressive) - Option to add customer tenure or churn assumptions Key Features Needed Inputs tab: - Deal size and margin - Who sourced the lead - Who delivers the work - Type of service sold - Commission rates (editable) - Duration or cap on referral commissions Outputs tab: - Revenue and commission by partner - Net profit - Graphs or visual summaries - Scenario toggles or dropdowns Optional: - Alerts if margins fall below a threshold - Executive summary tab for legal/contract use You Are… - Experienced in Excel financial modeling - Familiar with revenue sharing, commission splits, or agency pricing - Detail-oriented and able to create clear, client-friendly documentation - Bonus: experience with SaaS or consulting services Timeline We’d like delivery within 7–10 days from project start. Budget Open to proposals. Estimate: $800–$1,500, depending on complexity and turnaround time. How to Apply | Please include: - A few lines about relevant experience - A link to a previous model or mockup (if possible) - Your availability and expected turnaround Apply tot his job