Nstar Electric reported total liabilities of $12.36B for the quarter ended Dec 2016. This balance sheet covers 19 quarters of results from Mar 2009 through Dec 2016, standardized by Business Quant from the company’s SEC filings.
| Balance SheetBalance Sheet | Mar2009 | Jun2009 | Sep2009 | Dec2009 | Mar2010 | Jun2010 | Sep2010 | Dec2010 | Mar2011 | Jun2011 | Sep2011 | Dec2011 | Mar2012 | Jun2012 | Sep2012 | Dec2012 | Mar2013 | Dec2015 | Dec2016 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Assets | |||||||||||||||||||
| Current Assets | |||||||||||||||||||
| Cash & EquivalentsCash & Equiv. | 10.47M | 9.25M | 9.74M | 7.46M | 9.29M | 9.12M | 9.18M | 8.96M | 7.83M | 9.52M | 10.04M | 9.37M | 9.14M | 28.48M | 73.45M | 45.75M | 60.82M | 23.95M | 30.25M |
| Receivables - NetNet Receivables | 254.54M | 215.36M | 222.69M | 229.56M | 265.65M | 227.12M | 236.13M | 241.36M | 277.22M | 232.83M | 222.23M | 661.91M | 773.42M | 792.82M | 832.99M | 775.48M | 847.30M | ||
| Receivables - OtherOther Receivables | 35.85M | 45.93M | 50.29M | 46.42M | 35.29M | 52.83M | 50.46M | 42.53M | 36.68M | 52.94M | 48.33M | 40.38M | 33.88M | 202.26M | 182.64M | 216.04M | 195.87M | 202.65M | 168.49M |
| Inventory | 24.50M | 26.47M | 23.14M | 21.33M | 22.47M | 21.84M | 21.51M | 18.25M | 21.48M | 22.93M | 22.92M | 31.22M | 37.91M | 262.56M | 267.28M | 267.71M | 239.23M | 336.48M | 328.72M |
| Regulatory Assets (Current) | 331.77M | 313.04M | 274.77M | 312.13M | 305.14M | 326.63M | 337.58M | 347.08M | 309.56M | 348.41M | 335.53M | ||||||||
| Prepaid Assets | 112.63M | 95.16M | 112.97M | 107.97M | 104.45M | 129.03M | 134.81M | ||||||||||||
| Current Assets | 871.80M | 835.56M | 801.13M | 763.38M | 763.67M | 809.48M | 823.86M | 807.72M | 778.63M | 640.53M | 633.67M | 626.18M | 608.71M | 1,954.01M | 2,138.99M | 2,227.30M | 2,158.01M | 2,618.79M | 2,477.67M |
| Non-Current Assets | |||||||||||||||||||
| Utility Plant, Gross | 5,007.94M | 5,095.20M | 5,183.95M | 5,260.92M | 5,288.75M | 5,341.09M | 5,378.87M | 5,468.56M | 5,506.59M | 5,563.46M | 5,616.38M | 5,720.72M | 5,778.32M | ||||||
| Accumulated Depreciation | 1,189.58M | 1,213.62M | 1,241.90M | 1,268.42M | 1,292.92M | 1,321.07M | 1,347.14M | 1,351.54M | 1,380.19M | 1,406.87M | 1,433.13M | 1,436.02M | 1,467.56M | ||||||
| Construction in Progress | 118.47M | 95.45M | 56.48M | 59.45M | 73.54M | 81.27M | 104.57M | 87.68M | 107.30M | 131.75M | 157.98M | 162.05M | 189.88M | ||||||
| Property, Plant & Equipment (Net) | 3,936.82M | 3,977.02M | 3,998.54M | 4,051.96M | 4,069.36M | 4,101.29M | 4,136.29M | 4,204.70M | 4,233.70M | 4,288.35M | 4,341.23M | 4,446.75M | 4,500.64M | 16,054.91M | 16,303.81M | 16,605.01M | 16,737.55M | 19,892.44M | 21,350.51M |
| Regulatory Assets | 370.04M | 339.75M | 311.32M | 319.51M | 321.22M | 335.14M | 303.50M | 1,676.69M | 314.76M | 1,595.59M | 1,561.91M | 1,680.60M | 1,595.57M | 8,835.37M | 8,959.35M | 9,142.09M | 9,201.88M | 845.84M | 887.63M |
| Long-Term Investments | 6.54M | 5.85M | 5.64M | 5.28M | 5.12M | 4.97M | 4.67M | 8.13M | 4.65M | 7.96M | 7.84M | 7.58M | 7.22M | 9,874.69M | |||||
| Goodwill | 287.59M | 3,518.45M | 3,518.45M | 3,519.40M | 3,519.40M | 3,519.40M | 3,519.40M | ||||||||||||
| Other Non-Current Assets | 6.99M | 6.99M | 6.99M | 6.99M | 6.99M | 3.36M | 12.40M | 3.37M | 3.37M | 1,630.66M | 1,595.79M | 3.37M | 3.37M | 311.86M | 300.82M | 327.77M | 311.62M | 295.24M | 522.26M |
| Non-Current Assets | 5,989.91M | 6,000.32M | 5,974.57M | 5,974.27M | 5,954.13M | 5,926.25M | 5,906.83M | 5,929.22M | 5,923.23M | 5,923.59M | 5,941.48M | 6,165.17M | 6,144.70M | 25,552.30M | 25,618.58M | 26,075.53M | 26,170.65M | 27,961.52M | 29,575.50M |
| Total Assets | 6,861.70M | 6,835.88M | 6,775.70M | 6,737.65M | 6,717.80M | 6,735.72M | 6,730.70M | 6,736.94M | 6,701.87M | 6,564.13M | 6,575.14M | 6,791.35M | 6,753.41M | 27,506.30M | 27,757.56M | 28,302.82M | 28,328.66M | 30,580.31M | 32,053.17M |
| Liabilities | |||||||||||||||||||
| Current Liabilities | |||||||||||||||||||
| Accounts Payables | 199.27M | 141.06M | 156.51M | 163.88M | 131.38M | 154.90M | 185.12M | 205.47M | 139.74M | 153.89M | 169.53M | 182.04M | 162.89M | 193.58M | 229.85M | 262.86M | 353.04M | 813.65M | 884.52M |
| Short-Term Borrowings | 232.00M | 330.50M | 235.50M | 341.00M | 160.00M | 343.00M | 257.50M | 227.50M | 306.50M | 163.00M | 82.50M | 141.50M | 212.50M | 1,248.50M | 1,359.25M | 1,120.20M | 1,287.00M | 1,160.95M | 1,148.50M |
| Current Portion of Long-Term Debt | 1,448.62M | 1,322.04M | 1,322.09M | 125.69M | 125.28M | 1.51M | 1.10M | 0.69M | 0.28M | 16.51M | 1.10M | 400.69M | 400.28M | 6,936.47M | 6,732.54M | 7,200.16M | 7,011.56M | 8,805.57M | 8,829.35M |
| Current Taxes | 98.11M | 75.23M | 98.28M | 65.99M | 87.09M | 55.66M | 52.88M | 63.62M | 73.97M | 102.99M | 131.07M | 96.16M | 98.20M | 91.30M | 72.67M | 60.11M | 53.38M | 91.82M | 77.77M |
| Regulatory Liabilities (Current) | 108.29M | 88.37M | 90.21M | 47.54M | 67.28M | 61.16M | 63.65M | ||||||||||||
| Accumulated Expenses | 28.63M | 14.81M | 28.39M | 14.44M | 27.79M | 18.52M | 25.52M | 18.59M | 25.50M | 18.85M | 26.11M | 18.96M | 26.21M | 9.52M | 14.21M | 9.32M | 13.84M | 271.06M | 300.21M |
| Total Current Liabilities | 986.30M | 1,078.24M | 1,041.38M | 1,060.53M | 864.36M | 861.41M | 825.24M | 804.15M | 815.70M | 688.64M | 660.46M | 1,102.02M | 1,172.81M | 3,490.47M | 3,800.72M | 3,643.69M | 3,839.64M | 2,989.79M | 3,638.61M |
| Non-Current Liabilities | |||||||||||||||||||
| Long-Term Debt | 1,701.55M | 1,574.97M | 1,534.29M | 1,534.35M | 1,786.02M | 1,784.46M | 1,743.78M | 1,743.87M | 1,700.41M | 1,683.85M | 1,643.12M | 1,243.21M | 1,199.80M | 228.88M | 773.88M | ||||
| Non-Current Deferred Tax Liability | 1,114.97M | 1,121.84M | 1,116.43M | 1,166.50M | 1,184.34M | 1,181.07M | 1,201.05M | 1,219.81M | 1,224.35M | 1,236.73M | 1,250.58M | 1,310.18M | 1,302.89M | 3,249.32M | 3,429.54M | 3,463.35M | 3,614.28M | 5,147.68M | 5,607.21M |
| Regulatory Liabilities | 219.00M | 221.09M | 223.68M | 219.62M | 222.78M | 225.29M | 227.46M | 226.74M | 229.30M | 231.75M | 234.47M | 2,767.36M | 237.62M | 2,734.56M | 2,794.62M | 2,828.13M | 2,835.49M | 107.76M | 146.79M |
| Pension | 312.24M | 318.12M | 324.34M | 229.62M | 235.46M | 240.91M | 246.55M | 254.01M | 258.73M | 261.81M | 265.71M | 357.69M | 363.75M | 2,064.07M | 2,015.65M | 2,130.50M | 2,097.55M | 1,407.29M | 1,141.51M |
| Operating Leases | 1,322.14M | ||||||||||||||||||
| Other Non-Current Liabilities | 116.87M | 39.89M | 108.14M | 37.29M | 44.21M | 40.40M | 39.88M | 151.02M | 38.10M | 152.01M | 147.88M | 155.74M | 148.56M | 884.32M | 871.43M | 967.56M | 873.64M | 871.50M | 853.26M |
| Total Non-Current Liabilities | 0.28M | 126.51M | 126.10M | 2,007.08M | 1,992.81M | 1,981.32M | 1,979.58M | 1,994.81M | 1,999.24M | 2,008.26M | 2,017.15M | 2,171.38M | 2,159.69M | 7,696.02M | 7,790.52M | 7,984.22M | 7,957.05M | 8,277.16M | 8,717.91M |
| Total Liabilities | 4,867.68M | 4,811.19M | 4,697.31M | 3,067.61M | 2,857.16M | 2,842.73M | 2,804.83M | 4,585.82M | 2,814.94M | 4,423.74M | 4,363.73M | 4,559.60M | 4,575.31M | 11,346.62M | 11,692.59M | 11,710.05M | 11,816.30M | 11,266.95M | 12,356.52M |
| Shareholder's Equity | |||||||||||||||||||
| Common Stock | 980.26M | 1,662.25M | 1,662.36M | 1,662.55M | 1,664.76M | 1,669.31M | 1,669.39M | ||||||||||||
| Additional Paid-In CapitalAPIC | 992.61M | 992.61M | 992.61M | 992.61M | 992.61M | 992.61M | 992.61M | 992.61M | 992.61M | 992.61M | 992.61M | 992.61M | 992.61M | 6,178.70M | 6,183.72M | 6,183.27M | 6,173.80M | 6,262.37M | 6,250.22M |
| Retained Earnings | 1,001.41M | 1,032.08M | 1,085.78M | 1,100.09M | 1,039.01M | 1,072.92M | 1,146.48M | 1,158.50M | 1,150.90M | 1,147.77M | 1,218.80M | 1,239.14M | 1,185.49M | 1,635.71M | 1,735.69M | 1,802.71M | 1,914.37M | 2,797.36M | 3,175.17M |
| Accumulated Other Comprehensive IncomeAOCI | -4.60M | -11.84M | -70.69M | -66.39M | -64.21M | -72.85M | -70.90M | -66.84M | -65.28M | ||||||||||
| Treasury Stock | -346.67M | -342.63M | -340.69M | -338.62M | -336.80M | -309.98M | -317.77M | ||||||||||||
| Noncontrolling Interests | 43.00M | 43.00M | 43.00M | 43.00M | 43.00M | 43.00M | 43.00M | 43.00M | 43.00M | 43.00M | 43.00M | 43.00M | 43.00M | 155.57M | 155.57M | 155.57M | 155.57M | ||
| Common Equity | 1,994.03M | 2,024.69M | 2,078.39M | 3,670.05M | 3,860.64M | 3,892.99M | 3,925.87M | 2,151.11M | 3,886.93M | 2,140.38M | 2,211.41M | 2,231.75M | 2,178.10M | 16,159.68M | 16,064.97M | 16,592.77M | 16,512.36M | 19,313.36M | 19,696.66M |
| Liabilities and Shareholders Equity | 6,861.70M | 6,835.88M | 6,775.70M | 6,737.65M | 6,717.80M | 6,735.72M | 6,730.70M | 6,736.94M | 6,701.87M | 6,564.13M | 6,575.14M | 6,791.35M | 6,753.41M | 27,506.30M | 27,757.56M | 28,302.82M | 28,328.66M | 30,580.31M | 32,053.17M |
| Additional items | |||||||||||||||||||
| Total Debt | 3,382.17M | 3,227.51M | 3,091.88M | 3,101.12M | 2,071.29M | 2,128.97M | 2,002.38M | 3,130.56M | 2,007.19M | 1,863.36M | 1,726.72M | 3,024.53M | 1,812.58M | 8,184.97M | 8,091.79M | 8,320.35M | 8,298.56M | 10,195.41M | 10,751.74M |
Pull Nstar Electric's standardized financial statements into your own models, spreadsheets and apps with the Business Quant Financial Statements API. The request below follows the statement, frequency and period selected above. Swap YOUR_API_KEY for your own key.
https://data.businessquant.com/statements?ticker=NSARO&statement=BS&frequency=Quarter&period=all&api_key=YOUR_API_KEYimport requests
url = "https://data.businessquant.com/statements"
params = {"ticker": "NSARO", "statement": "BS", "frequency": "Quarter", "period": "all", "api_key": "YOUR_API_KEY"}
data = requests.get(url, params=params).json()const res = await fetch("https://data.businessquant.com/statements?ticker=NSARO&statement=BS&frequency=Quarter&period=all&api_key=YOUR_API_KEY");
const data = await res.json();