Financial Derivation Table




NEW ZEALAND GAZETTE

No. 71

Derivation Table

Symbol in formula Input Column Calculations
Earnings before interest and tax (EBIT)
Net profit after tax (NPAT)
a Amortised Goodwill Numerator (as adjusted)
b Subordinated Debt Fixed Assets at year beginning (FA₀)
c Depreciation of SFA at BV Net Working Capital at year beginning (NWC₀)
d ODV Depreciation tax adjustment Average Total Funds Employed (ATFE)
e Subvention Payment Tax Shield Total Equity at year beginning (TE₀)
f Revaluations Total Debt at year beginning (TD₀)
g Income Tax Average total capital (T₁)
h Average total equity (TE)
i WUC at year beginning (WUC₀)
j WUC of Average Total Works Under Construction (WUCₜ)
k Goodwill asset at year beginning (GW₀)
l Revaluations
m Goodwill payment asset (GWₜ)
n Subvention payment at year end (S₁)
o Subvention payment tax adjustment at year end (Sₜ)
p Subvention payment tax adjustment related tax-value (SFAᵀ)
q Average Fixed Assets at year end at ODV value (SFA₁)
r System Fixed Assets at year end at book value (SFAᴮᴺᵒᵐ)
s System Fixed Assets at year beginning at ODV value (SFA₀)
t System Fixed Assets at year beginning (SFA₀)
u Average value of System Fixed Assets at ODV value (SFA)
v System Fixed Assets adjusted (SFAₐᵈⱼ)
Denominator (as adjusted)
ODV = optimised deprival valuation
bv = book value

Key:

  • SFA = System Fixed Assets
  • ODV = Optimised Deprival Valuation
ROI ROE ROF

Calculations:

= (FA₀ + FA₁ + NWC₀ + NWC₁)/2 = s + t
= (TE₀ + TE₁)/2
= (TD₀ + TD₁ + s)/2
= (WUC₀ + WUC₁)/2
= (GW₀ + GW₁)/2
sₜ = s
= (S₀ + S₁ + s + d)/2
= (SFA₀ + SFA₁)/2

| | 14,172 | N/A |
| a | 2,658 | 4,638 |
| b | 0 | add |
| c | 2,000 | add |
| d | 2,260 | deduct |
| e | 6,260 | add |
| f | 3,094 | deduct |
| g | 1,045 | N/A |
| h | 680 | N/A |
| i | 2,636 | add |
| j | N/A | N/A |
| k | N/A | N/A |
| l | N/A | = a + g + s - p + t - b |
| m | 7,105 | 8,119 |
| n | 1,525 | 19,238 |
| o | No entry | 191,158 (3.833) |
| p | (3,770) | 198,653 (3.833) |
| q | No entry | add |
| r | No entry | add by 2 |
| s | 81,476 | divide by 2 |
| t | 81,233 | 71,470 |
| u | No entry | N/A |
| v | 1,768 | N/A |
| | 3,967 | 1,768 (979) |

| | | 191,104 |
| | | N/A |
| | | N/A |
| | | divide by 2 |
| | | N/A |
| | | 71,223 |

| | | 196,882 |
| | | 193,975 |
| | | 141,151 |
| | | 150,280 |
| | | 147,216 |
| | | 39,863 | EBIT³ᵒᵖ / ATFE³ᵒᵖ × (100)¹ = 14.71% end of the financial year

| | | 27,689% subscrip. t¹ = beginning of the financial year



Next Page →



Online Sources for this page:

VUW Te Waharoa PDF NZ Gazette 2000, No 71


Gazette.govt.nz PDF NZ Gazette 2000, No 71





✨ LLM interpretation of page content

💰 Performance Measures for Dunedin Electricity (continued from previous page)

💰 Finance & Revenue
Electricity, Performance Measures, Financial, Efficiency, Statistics