Treatment Categories
Pharmaceutical / Device
Tools
Unlisted J-Code Calculator
Unlisted J-Code Outcomes Calculator
Worksheet #1 with multi-instillation schedule & cash flow
Date of the first patient instillation.
How many instillations are planned in the series.
Days between each instillation (calendar days, not business days).
Business days from order date to drug delivery. US bank holidays excluded.
Business days between delivery and instillation.
Business days from instillation to claim submission.
Calendar days payers take to adjudicate and pay the claim.
Calendar days until your vendor invoice is due (up to 120 days in some cases; check with your distributor).
$
What you pay to purchase the drug (per instillation). Check with your GPO or distributor for any off-invoice discounts.
$
The ASP or WAC amount billed per instillation.
%
Expected reimbursement percentage (e.g., 103% of ASP/WAC).
$
Auto-calculated: ASP/WAC Ă— Payer % (per instillation).
Note: US bank holidays are excluded (with observed dates). Weeks start on Sunday and end on Saturday. Week #1 is the week of the earliest Order Date.
Columns 2–9 include one entry per instillation; Column 10 shows a running total.
Maximum Cash Needed (Based on Inputs)
—
Drug Income (Loss)
—
Net Income (Loss)
—
