NSTAR ELECTRIC CO (NSARP)

Import this data to Google Sheets with:

=jivedata("NSARP","financials")

Full statements spill as a table. For one cell: =jivedata("NSARP","Revenue") or =jivedata("NSARP","Revenue","TTM"). Install the Jive Data add-on, then paste into a cell.

NSTAR ELECTRIC CO

NSARP • CIK 0000013372

(in thousands, except per share data)	FY 2011	TTM
Electric Revenue (Deprecated 2018-01-31)	$2,487,288	$2,469,698
Operating Income (Loss)	$486,662	$423,217
Income (Loss) from Continuing Operations before Income Taxes, Noncontrolling Interest	$418,180	$353,187
Income Tax Expense (Benefit)	$165,686	$139,646
Net Income (Loss) Attributable to Parent	$252,494	$213,541
Utilities Operating Expense, Maintenance and Operations	$366,013	$418,565
Depreciation, Depletion and Amortization, Nonproduction	$272,122	$273,576
Taxes, Miscellaneous	$111,530	$113,325
Operating Expenses	$2,000,626	$2,046,481
Interest Expense, Long-term Debt	$90,225	$89,964
Interest Expense, Other	$7,678	$6,694
Interest Expense	$69,237	$70,448
Other Nonoperating Income	$2,147	$2,512
Other Nonoperating Expense	$1,392	$2,094
Other Nonoperating Income (Expense)	$755	$418

(in thousands, except per share data)	FY 2011	TTM
Cash and Cash Equivalents, at Carrying Value	$9,373	$9,143
Restricted Cash and Cash Equivalents, Current	$17,007	$17,007
Accounts Receivable, after Allowance for Credit Loss, Current	$232,827	$222,231
Costs in Excess of Billings, Current	$40,380	$33,875
Regulatory Assets, Current	$312,133	$305,142
Assets	$6,791,350	$6,753,407
Inventory, Net	$31,222	$37,907
Income Taxes Receivable, Current	$128,340	$128,340
Other Assets, Current	$247	$411
Assets, Current	$626,182	$608,709
Redeemable Noncontrolling Interest, Equity, Preferred, Carrying Amount	$43,000	$43,000
Capitalization, Long-term Debt and Equity	$3,517,955	$3,420,900
Public Utilities, Property, Plant and Equipment, Plant in Service	$5,720,718	$5,778,320
Public Utilities, Property, Plant and Equipment, Accumulated Depreciation	$1,436,021	$1,467,561
Public Utilities, Property, Plant and Equipment, Construction Work in Progress	$162,050	$189,879
Public Utilities, Property, Plant and Equipment, Net	$4,446,747	$4,500,638
Equity Method Investments	$4,211	$3,848
Restricted Cash and Cash Equivalents, Noncurrent	$3,373	$3,373
Long-term Investments	$7,584	$7,221
Regulatory Assets, Noncurrent	$1,680,596	$1,595,569
Regulated Entity, Other Assets, Noncurrent	$1,710,837	$1,636,839
Other Long-term Debt, Current	$400,687	$400,275
Long-term Transition Bond, Current	$48,680	$73,448
Short-term Debt	$141,500	$212,500
Accounts Payable, Current	$182,035	$162,891
Due to Related Parties, Current	$124,432	$80,706
Accrued Income Taxes, Current	$96,155	$98,204
Interest Payable, Current	$18,956	$26,214
Other Liabilities, Current	$57,854	$87,457
Liabilities, Current	$1,102,016	$1,172,813
Deferred Tax Liabilities, Net, Noncurrent	$1,310,180	$1,302,891
Liability, Defined Benefit Pension Plan, Noncurrent	$357,685	$363,751
Due to Related Parties, Noncurrent	$75,905	$70,550
Other Liabilities, Noncurrent	$79,837	$78,006
Liabilities, Noncurrent	$2,171,379	$2,159,694
Other Long-term Debt, Noncurrent	$1,199,714	$1,199,802
Long-term Transition Bond, Noncurrent	$43,493	$43,493
Long-term Debt, Excluding Current Maturities	$1,243,207	$1,199,802
Additional Paid in Capital, Common Stock	$992,613	$992,613
Retained Earnings (Accumulated Deficit)	$1,239,135	$1,185,485
Stockholders' Equity Attributable to Parent	$2,231,748	$2,178,098
Accounts Receivable, Allowance for Credit Loss, Current	$27,118	$41,684
Common Stock, Shares, Issued	100	100

(in thousands, except per share data)	FY 2011	TTM
Net Income (Loss) Attributable to Parent	$252,494	$213,541
Net Cash Provided by (Used in) Operating Activities	$721,168	$777,054
Cash and Cash Equivalents, Period Increase (Decrease)	$409	$1,317
Cash and Cash Equivalents, at Carrying Value	$9,373	$10,690
Depreciation, Depletion and Amortization, Nonproduction	$272,122	$273,576
Payments to Acquire Property, Plant, and Equipment	$381,245	$407,102
Amortization of Debt Discount (Premium)	$4,792	$4,680
Proceeds from Sale of Property, Plant, and Equipment	$188	$188
Deferred Income Tax Expense (Benefit)	$70,621	$45,039
Increase (Decrease) in Restricted Cash	$-17,007	$-17,007
Payments for (Proceeds from) Other Investing Activities	$-443	$-443
Net Cash Provided by (Used in) Investing Activities	$-363,607	$-406,096
Increase (Decrease) in Income Taxes Receivable	$-128,340	$-128,340
Proceeds from Issuance of Long-term Debt	$295,194	$295,194
Increase (Decrease) in Accounts Receivable	$3,564	$3,564
Payments of Debt Issuance Costs	$3,048	$3,048
Increase (Decrease) in Inventories	$12,968	$12,968
Repayments of Long-term Debt	$82,642	$80,031
Increase (Decrease) in Accounts Payable, Trade	$-38,542	$-38,542
Repayments of Other Long-term Debt	$16,650	$16,650
Increase (Decrease) in Other Current Assets and Liabilities, Net	$-68,918	$-149,784
Proceeds from (Repayments of) Short-term Debt	$-86,000	$-94,000
Increase (Decrease) in Regulatory Assets and Liabilities	$-14,764	$-61,968
Payments of Ordinary Dividends	$171,860	$178,960
Net Cash Provided by (Used in) Financing Activities	$-357,152	$-369,641
Increase (Decrease) in Other Noncurrent Assets and Liabilities, Net	$-37,217	$-14,391
Interest Paid, Excluding Capitalized Interest, Operating Activities	$96,073	$94,575
Income Taxes Paid, Net	$-62,190	$-68,114
Capital Expenditures Incurred but Not yet Paid	$34,336	$50,308

Loading financial statements…

Import this data to Google Sheets with:

=jivedata("NSARP","financials")

Full statements spill as a table. For one cell: =jivedata("NSARP","Revenue") or =jivedata("NSARP","Revenue","TTM"). Install the Jive Data add-on, then paste into a cell.