P
Profit Calculator

1) Prices (Optional)

Rs.
Includes GST
Rs.
Includes GST
Rs.
Always Ex-GST
Rs.
Includes GST

2) Base & Offer

%

3) Extra Discount

%
Apply Ex-GST

4) MRP

Rs.
Includes GST

5) Refund/Cash Activity

%
Apply Ex-GST
The Bottom Line
Net Invoice Amount With GST
i
FormulaTaxable + GST - Refund
Ex: 900 + 45 - 0 = 945
โ€”
To Pay
Net Invoice Amount Without GST
i
FormulaTaxable - Refund
Ex: 900 - 0 = 900
โ€”
Excluding Tax
Final Margin % With Free Units, Discounts & Activity
i
Formula((MRP - EffectiveCost) / MRP) ร— 100
Ex: ((100 - 78) / 100) = 22%
โ€”
Ratios
Total Profit (ROI in cash)
i
Formula(MRP ร— Total Units) - Net Invoice
Ex: 1200 - 945 = 255
โ€”
Whole Deal
ROI %
i
Formula(Total Profit / Net Invoice) ร— 100
Ex: (255 / 945) = 27%
โ€”
Profit รท Invest
Invoice Breakdown
Gross Ex-GST Before Discount
i
FormulaRate Ex-GST ร— Buy Qty
Ex: 90 ร— 10 = 900
โ€”
Base Amount
Gross Ex-GST After Discount
i
FormulaGross Ex-GST - Total Discount
Ex: 900 - 45 = 855
โ€”
Taxable Value
Total Discount
i
FormulaGross ร— Disc %
Ex: 900 ร— 5% = 45
โ€”
โ€”
GST Value
i
FormulaTaxable Value ร— GST %
Ex: 855 ร— 12% = 102.6
โ€”
%
Net Without Refund/Activity
i
FormulaTaxable + GST
Before subtracting refund
โ€”
Before Refund
Refund Amount
i
FormulaRefund % on Base Amount
Deducted from final bill
โ€”
โ€”
Unit Economics
Effective Price Per Unit
i
FormulaNet Invoice / Total Units
Ex: 945 / 11 = 85.90
โ€”
(Net รท Buy+Free)
Cash Profit Per Unit
i
FormulaMRP - Effective Price
Ex: 100 - 85.90 = 14.10
โ€”
Earnings / Unit
Margin% Without Free Units, Discounts & Activity
i
Formula((MRP - RateWithTax) / MRP) * 100
Standard Trade Margin
โ€”
Trade Margin
MRP / Unit
i
InfoMaximum Retail Price
Incl. GST
โ€”
Inc GST
Verification (No Free Goods)
Paid Unit Cost Without Free Units
i
FormulaNet Invoice / Buy Quantity
Ex: 945 / 10 = 94.50
โ€”
Net รท Buy
Paid Margin % Without Free Units
i
FormulaMargin calculated excluding free goods
Ex: ((100 - 94.5) / 100) = 5.5%
โ€”
Ignore free goods

5) Comparison

PTR PTS NRV Cust
SourceGrossExDiscTaxableGSTNet InvEff/UnitMRPProfitMargin %
Enter prices to see details
ร—
๐Ÿ‘‹

Welcome

Pharmacy Profit Calculator

โœจ
Guided ModeStep-by-step
โŒจ๏ธ
Manual EntryDashboard
ร—