NLC Calculator — Mahavir Mobile Shop

NLC Sheet — Live

Type MOP and all values calculate instantly. Data syncs live across all devices in real time.

#	Series Name	Model Name	MOP (₹)	MOP W/O GST MOP ÷ 1.18	DP MOP − 3.5%	DP W/O GST DP ÷ 1.18	Adv Payment × 6.5%	Billing Price DP − Adv	Bill Less MOP − DP	CN × 9.5%	1% Pmt × 1%	Quarterly 1 × 0.5%	Quarterly 2 × 0.5%	Total CN ↓ Final	CN % of MOP W/O GST	Payment Level A / B / C / D
	TOTALS

Total MOP

₹0.00

sum of all products

Total CN

₹0.00

credit notes earned

Avg CN %

0.00%

average of MOP W/O GST

Products

active rows

Formula Reference — from your Excel Sheet1

DP = MOP × 96.5%

DP W/O GST = DP ÷ 1.18

Adv Payment = DP W/O GST × 6.5%

Billing Price = DP − Adv Payment

Bill Less = MOP − DP

CN = DP W/O GST × 9.5%

1% Pmt = DP W/O GST × 1%

Quarterly 1 = DP W/O GST × 0.5%

Quarterly 2 = DP W/O GST × 0.5%

Total CN = Bill Less + CN + 1% Pmt + Qtr1 + Qtr2

CN % = Total CN ÷ MOP W/O GST × 100