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 ScopeWe 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 assumptionsKey Features NeededInputs 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 commissionsOutputs tab:- Revenue and commission by partner- Net profit- Graphs or visual summaries- Scenario toggles or dropdownsOptional:- Alerts if margins fall below a threshold- Executive summary tab for legal/contract useYou 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 servicesTimelineWe’d like delivery within 7–10 days from project start.BudgetOpen to proposals. Estimate: $800–$1,500, depending on complexity and turnaround time. | 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