Put operating and planned replacement costs on one horizon
An upfront price leaves out costs that occur while the lights are in use. A cheaper installation may require more electricity, maintenance or replacements over the years you intend to use it. This calculator adds those supplied costs over a whole-year planning horizon. The single-option mode gives an undiscounted budget; the comparison mode also puts two options’ costs on a present-value basis. Neither mode forecasts future prices or equipment failures.
Let N be the number of matching luminaires, P their individual input W, H annual equivalent operating hours and Y the chosen whole years. The power-times-time relationship gives:
Energy = N × P × H × Y ÷ 1,000 kWh.
Multiply this energy by the constant AUD/kWh usage rate. Annual maintenance is a whole-project amount multiplied by Y. Upfront cost is also a whole-project amount, whereas replacement cost is per luminaire event. Mixing these bases can multiply a project cost by the light count twice.
Define the replacement plan without predicting life
For a planned interval T in operating hours, each luminaire receives ceil(HY/T) − 1 replacements when HY is positive, with a minimum of zero. Zero operating hours means zero replacement events. This convention purchases a replacement only when another operating period remains; it excludes an event exactly at the horizon end and assigns no residual value to installed equipment.
A chosen interval is a planning assumption. A lumen-maintenance rating such as L70 is not automatically a failure time or a guaranteed replacement schedule. Use a maintenance plan appropriate to the actual system and avoid adding costs here that are already included in annual maintenance.
Reproduce the ten-year example
The artificial example has ten 10 W luminaires, 1,000 h/year, ten years and AUD0.30/kWh. Project upfront cost is AUD1,000, annual maintenance AUD20, planned interval 3,000 h and per-event replacement AUD5.
If the interval were 5,000 h, only the 5,000 h event would be included. A 10,000 h event falls exactly at the horizon end and is omitted. These are cost-plan conventions, not different predictions about the light’s reliability.
Compare service before comparing totals
Only compare budgets with consistent lighting service, operating schedules, included labour, tax, rebates and cost boundaries. This model assumes a 365-day year, limits equivalent annual hours to 8,760, and does not infer standby power. Exact decimal costs are accumulated before display rounding to cents; nonzero amounts below one cent remain labelled below AUD0.01.
Different luminaire counts or wattages can provide different lighting service. The comparison therefore requires a declared common service and cost basis; it does not infer equivalence from equal lumens, counts or power. For changing groups or operating periods, prepare the energy schedule before deciding whether a constant annual equivalent is suitable here.
Compare costs that fall in different years
An amount paid now and the same amount paid years later have different present values. The WA Life Cycle Cost Guidelines explain this common-time comparison and consider lighting system alternatives. Their historical example rates and facility-funding conditions are not defaults for your project.
The comparison uses the discounted cash-flow relationship explained by OpenStax:
Present cost = upfront cost + Σ[year-end costᵧ ÷ (1 + r)ʸ].
Here r is the annual rate expressed as a fraction: an entered 5% means r = 0.05. Each year-end cost comprises that year’s electricity, maintenance and planned replacements. Upfront cost is paid at time zero and is not discounted. A higher positive rate reduces the present value of later costs; it does not reduce the physical energy use or the amount in the undiscounted budget. At 0%, present cost equals the undiscounted total.
All costs stay in constant AUD, so the comparison needs a real rate, excluding general inflation. Supply the rate appropriate to your analysis; the artificial 5% example is not a recommendation. The supported 0–100% input range is a software boundary. Negative rates and nominal-rate forecasts with escalating prices need a different model. Costs are not escalated here, and financing, tax calculations, disposal costs and residual values are excluded.
Why the payment convention matters
Electricity and maintenance are treated as paid at each year end. Replacements are also grouped at the end of the planning year in which their operating-hour interval is reached. For example, 1,000 h/year and a 1,500 h interval put the first replacement in year 2; it is discounted as a year-2 payment. No uniform within-year operating schedule is inferred. An event exactly at an internal year end belongs to that year. An event exactly at the final horizon is omitted because no further operating period remains.
This year-end grouping is a planning approximation. Actual monthly bills or mid-year replacements occur sooner and, at a positive rate, have higher present costs than the same amounts deferred to year end. Use dated cash flows when that timing difference matters, especially if the two options’ costs are close.
A ten-year comparison with a higher initial cost
Keep the earlier artificial baseline and compare it with ten 6 W luminaires at the same 1,000 h/year and AUD0.30/kWh. Assume alternative upfront cost AUD1,100, annual maintenance AUD10, a 5,000 h planned interval and AUD5 per luminaire replacement. Comparable lighting service is assumed solely for this arithmetic example, not established by the wattages. Use a common ten-year horizon and an invented 5% real annual rate.
The ten-year present-value factor for AUD1 paid at each year end is 7.721734929… at 5%. Baseline present cost is therefore 1,000 + 50 × 7.721734929… + 50/1.05³ + 50/1.05⁶ + 50/1.05⁹. The alternative is 1,100 + 28 × 7.721734929… + 50/1.05⁵. Components and totals are calculated before display rounding, so displayed rows may not sum exactly to the displayed total.
The reported baseline minus alternative difference is AUD143.43: the alternative has the lower modelled present cost. A negative difference would mean the alternative costs more; zero means equal specified present costs. The difference includes only the costs entered, not lighting performance, project income or every investment consequence. It is therefore not a complete investment NPV or an unconditional purchase recommendation. Check uncertain costs and the chosen rate with additional scenarios before relying on a small difference.
Simple payback answers a different question: how long a constant full-year net saving takes to recover extra initial investment. As OpenStax’s payback discussion explains, that measure ignores the time value of money and cash flows after recovery. A short payback does not, by itself, identify the lower cost over your chosen horizon.