Electricity Bill Estimator

Estimated Bill

💰

₱7,791.12

593 kWh usage

Energy Used

⚡

593kWh

26,393 − 25,800

Daily Usage

📈

28.24kWh/day

₱371.01/day (21 days)

Rate / kWh

📊

₱13.14/ kWh

Exact: ₱13.1385

Cycle Forecast

📅

₱11,130.17

9 days left in cycle

📟 Meter Readings & Cycle

Present Reading Latest meter value

kWh

Previous Reading Last statement value

kWh

Net Power Used

26393 − 25800

593 kWh

Billing Cutoff Day Day of month

Days In Cycle: 20 days elapsed

Days Remaining: 10 days left

Average Daily Cost: ₱389.56 / day

Est. Extra Charge: ₱3,895.56

Quick Scenarios:

⚙️ Tools & Actions

Cost Distribution by Category

Proportionate unbundled bill share

₱7,791.12

Generation ₱4,705.51 (60.4%)

Transmission ₱705.43 (9.1%)

Distribution ₱787.40 (10.1%)

System Loss ₱587.60 (7.5%)

Universal / Subsidies ₱524.98 (6.7%)

Government Taxes (VAT) ₱478.64 (6.1%)

Component Description	Calculation Rule	Total Amount (₱)
VATABLE SALES	Gen + Ancillary + Trans + SysLoss + Dist + Supply + Metering + Senior Citizen	₱6,787.50
Zero Rated Sales	Non-taxable zero rated energy sales	₱0.00
VAT Exempt Sales	MCC/RFSC + Missionary + Environmental + Stranded Debt + FIT-ALL + Lifeline	₱524.98
Value Added Tax (VAT)	Gen Tax + Trans Tax + Ancillary Tax + 12% Distribution VAT + Other VAT	₱478.64
TOTAL ESTIMATED CURRENT BILL	SUM(Vatable + Zero + Exempt + VAT)	₱7,791.12
Effective Cost per kWh	Total Bill ÷ kWh Used	₱13.1385 / kWh
Average Daily Cost	Bill ÷ 20 elapsed days	₱389.56 / day
Projected Full Month Total	Current Bill + (Daily Cost × Remaining Days)	₱11,686.68

Charge Category & Item	Multiplier / kWh	Rate (₱)	Total Amount (₱)
Generation Charges
Generation Charge	593	7.9351	₱4,705.51
DAA: GRAM & ICERA	0	0.0000	₱0.00
RPPD Adjustment	0	0.0000	₱0.00
Transmission Charges
Ancillary Service	593	0.6602	₱391.50
Transmission System Charge	593	0.5294	₱313.93
System Loss Charge
System Loss Charge	593	0.9909	₱587.60
Distribution Charges
Distribution System Charge	593	0.4613	₱273.55
Supply System Charge	593	0.5376	₱318.80
Metering System Charge	593	0.3205	₱190.06
Metering Customer Charge (Fixed)	1 cust	5.0000	₱5.00
Subtotal Distribution Charges	₱787.40

Component Item	Multiplier / kWh	Rate (₱)	Total Amount (₱)
MCC / RFSC
MCC / RFSC (Member-Consumer Fund)	593	0.2178	₱129.16
Subsidy / Discount Charges
Lifeline Subsidy Charge	593	0.0100	₱5.93
Senior Citizen Subsidy Charge	593	0.0026	₱1.54
Universal Charges
Missionary Electrification (SPUG)	593	0.2662	₱157.86
Missionary Electrification (RED)	593	0.0101	₱5.99
Environmental Charge	593	0.0025	₱1.48
FIT-ALL (Feed-In Tariff Renewable)	593	0.3359	₱199.19
NPC Stranded Debt	593	0.0428	₱25.38
Subtotal Universal & Subsidies (VAT Exempt)	₱524.98

Tax Component	Base / Multiplier	Tax Rate	Total Tax (₱)
Value Added Tax (VAT)
Generation VAT	593 kWh	0.5110 ₱/kWh	₱303.02
Transmission VAT	593 kWh	0.0666 ₱/kWh	₱39.49
Ancillary VAT	593 kWh	0.0699 ₱/kWh	₱41.45
Distribution VAT	₱787.40 (Dist Total)	12.0%	₱94.49
Other VAT (Senior Subsidy)	₱1.54 (Senior Sub)	12.0%	₱0.19
Total Value Added Tax (VAT Amount)	₱478.64

⚙️ ISELCO 1 Reference Rates Manager (Click to edit all 22 spreadsheet rates) ▼

These rates are pulled directly from column B and E in ElectricityEstimator.xlsx. You can customize them if your electric cooperative releases updated monthly rate schedules. Changes are automatically saved in your browser.

Accurate Monthly Power Estimator

Cost Distribution by Category