P
Profit Calculator
โจ
Guide
๐ฑ
Copy
โณ Reset
? Help
๐จ๏ธ Print
1) Prices (Optional)
PTR (Retailer Price)
Rs.
Includes GST
PTS (Stockist Price)
Rs.
Includes GST
NRV (Factory Price)
Rs.
Always Ex-GST
Custom Price
Rs.
Includes GST
2) Base & Offer
Use Price:
PTR
PTS
NRV
Custom
GST %
%
Buy (X)
Free (Y)
3) Extra Discount
Extra Discount %
%
Apply Ex-GST
4) MRP
MRP per Unit
Rs.
Includes GST
5) Refund/Cash Activity
Refund/Activity %
%
Apply Ex-GST
The Bottom Line
Net Invoice Amount With GST
i
Formula
Taxable + GST - Refund
Ex: 900 + 45 - 0 = 945
โ
To Pay
Net Invoice Amount Without GST
i
Formula
Taxable - 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
Formula
Rate Ex-GST ร Buy Qty
Ex: 90 ร 10 = 900
โ
Base Amount
Gross Ex-GST After Discount
i
Formula
Gross Ex-GST - Total Discount
Ex: 900 - 45 = 855
โ
Taxable Value
Total Discount
i
Formula
Gross ร Disc %
Ex: 900 ร 5% = 45
โ
โ
GST Value
i
Formula
Taxable Value ร GST %
Ex: 855 ร 12% = 102.6
โ
%
Net Without Refund/Activity
i
Formula
Taxable + GST
Before subtracting refund
โ
Before Refund
Refund Amount
i
Formula
Refund % on Base Amount
Deducted from final bill
โ
โ
Unit Economics
Effective Price Per Unit
i
Formula
Net Invoice / Total Units
Ex: 945 / 11 = 85.90
โ
(Net รท Buy+Free)
Cash Profit Per Unit
i
Formula
MRP - 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
Info
Maximum Retail Price
Incl. GST
โ
Inc GST
Verification (No Free Goods)
Paid Unit Cost Without Free Units
i
Formula
Net Invoice / Buy Quantity
Ex: 945 / 10 = 94.50
โ
Net รท Buy
Paid Margin % Without Free Units
i
Formula
Margin calculated excluding free goods
Ex: ((100 - 94.5) / 100) = 5.5%
โ
Ignore free goods
5) Comparison
PTR
PTS
NRV
Cust
Source
GrossEx
Disc
Taxable
GST
Net Inv
Eff/Unit
MRP
Profit
Margin %
Enter prices to see details
ร
๐
Welcome
Pharmacy Profit Calculator
โจ
Guided Mode
Step-by-step
โจ๏ธ
Manual Entry
Dashboard
ร
Instructions
Commas:
You can type 304,40 or 304.40. Both work.
Logic:
GST is calculated on (Gross - Extra Discount).
Refund/Activity:
Financial credit note deducted from final Net Pay.
Empty Fields:
Fields left empty are treated as zero.
Close
Profit Calculation
Inputs
PTR
โ
GST %
โ
Scheme
Buy/Free
โ
Disc %
โ
Net Invoice
โ
Total Profit
โ
Final Margin
โ
ROI %
โ
Gross Ex-GST
โ
Taxable
โ
GST Value
โ
Effective/Unit
โ
Cash Profit
โ
Trade Margin
โ
Paid Unit Cost
โ
Paid Margin %
โ
Details
Src
Gross
Taxable
GST
Net
Eff
Profit
%