Advanced

Pharma inventory and rebate/chargeback accrual framework

Designs a framework to accrue for rebates, chargebacks, returns, and inventory reserves common in pharma. Useful for controllers and audit support.

Create an accrual framework for rebates/chargebacks/returns for {pharma_company}.

Inputs:
- Sales channels and terms: {sales_channels_terms}
- Rebate programs and rates: {rebate_programs}
- Chargeback/contract pricing terms: {chargeback_terms}
- Returns history and policy: {returns_history}
- Inventory on hand and expiry risk: {inventory_data}

Output:
1) Accrual model outline by program (inputs, calculations, timing).
2) Journal entry templates and rollforward schedules.
3) Controls and evidence requirements (data sources, approvals).
4) Key risks and sensitivities (utilization rates, lag, channel mix).

Be transparent about uncertainties and data needs.

Related Prompts

Industry-Specific
Beginner

Nonprofit: Functional Expense Allocation (990)

Allocates expenses between Program, Management, and Fundraising buckets.

GPT-4oGemini 1.5 Pro
0
0
54
Industry-Specific
Advanced

CECL allowance model governance: assumptions, controls, and doc

Designs a CECL model governance and documentation package including assumptions, controls, and validation. Useful for banks and auditors supporting allowance estimates.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
45
Industry-Specific
Intermediate

Retail gross margin bridge: markdowns, mix, shrink, freight

Builds a gross margin bridge explaining changes driven by markdowns, mix, shrink, and freight. Useful for merchandising and finance alignment.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
47