Mahavir NLC

Checking your signed-in account...

Mahavir NLC

Sign in with an approved Google account to open the calculator.

Checking access...
Mahavir Logo
Mahavir Mobile Shop
Net Landing Cost Calculator
0 Products
⟳ Connecting…
logo

NLC Sheet — Live

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

# Series Model Name Total Quantity MOP (₹) MOP W/O GST
MOP ÷ GST
DP
MOP − DP Less%
DP W/O GST
DP ÷ GST
Adv Payment
× Adv%
Billing Price
DP − Adv / DP
Bill Less
MOP − DP
CN
× CN%
1% Pmt
× Pmt%
Quarterly 1
× Qtr1%
Quarterly 2
× Qtr2%
Total CN ↓
Per piece
Grand Total CN
Qty + boosters
CN %
of MOP W/O GST
Payment Level
A / B / C / D
Booster 1
₹ or %
Quantity Booster 2
₹ or %
Quantity Booster 3
₹ or %
Quantity
TOTALS
Total MOP
₹0.00
sum of all products
Grand Total CN
₹0.00
quantity plus boosters
Avg CN %
0.00%
average of MOP W/O GST
Products
0
active rows
Formula Reference — from your Excel Sheet1
DP = MOP − DP Less%
DP W/O GST = DP ÷ GST
Adv Payment = DP W/O GST × Adv%
Billing Price = DP − Adv Payment
Bill Less = MOP − DP
CN = DP W/O GST × CN%
1% Pmt = DP W/O GST × Pmt%
Quarterly 1 = DP W/O GST × Qtr1%
Quarterly 2 = DP W/O GST × Qtr2%
Total CN = Adv Payment + Bill Less + CN + 1% Pmt + Qtr1 + Qtr2
Grand Total CN = Total CN × Total Qty + enabled booster extras
Booster % = Total CN per piece × booster %
CN % = Grand Total CN ÷ total MOP W/O GST × 100

Series Formula Values