On Balance Sheet Debt
On Balance Sheet Debt
Short and long-term
Introduction: Important issue in analysis of debt is to realize that not all items classified as debt are debt. Some items represent equity (raised from shareholders); others are equity by virtue of being unrecognized income (revenue).
At the same time, (certain) items classified as equity are perhaps better treated as debt.
Most importantly there exist numerous items not reported anywhere on the financial statements which should be reported as debt (off balance sheet debt).
Current liabilities: three classifications that should be treated differently:
1. Trade debt (A/P, accrued liabilities etc) – normal operating debt within firms operating cycle
2. Short-term debt (& current portion of Long-term debt) – loans , commercial paper – outside financing – care should be taken to ensure that firm is not shifting from trade to bank financing
3. Advance from customers – not a liability! (at least not in the amount listed). Unrecognized revenue – as advance from customer goes up, it is good sign---future income increases.
Long-term debt and equity
Nature of debt should be analyzed:
• Convertible bonds Debt or equity? – portion debt and portion equity; one should examine strike price to assess this question (option pricing models may be appropriate.
• Redeemable preferred shares: Equity or debt? Given its provisions, more than likely its debt and should be so treated. [SEC requires that it be reported above (but not as part of) equity.]
Market or Cost: (Carrying Value)
• Difference between two affected by a function of three factors:
1. Terms of debt – fixed or variable (swaps)
2. Horizon – long or short
3. “Imbedded” rate versus change in interest rates
• Debt denominated in foreign currency is adjusted for changes in exchange rates (not changes in interest rate)
Effect on Cash Flow Statement:
Per GAAP, coupon payments (“interest”) are treated as CFO; whereas Face Value (“principal”) is treated as CFF.
Distortion/Inconsistency
• When bonds issued at premium – coupon payments include principal payment but reported as CFO
• When bonds issued at discount – face value payments include interest but reported as CFF –
Consider Zero Coupon Bond: all payments are CFF, no CFO!
Bond Covenants
10-5
Selected Balance Sheet Data, December 31, 1987 to 1988 ($ in millions)
American Airlines Eastern Airlines
1987 1988 1987 1988
Cash and short-term investments $1,012.4 $1,286.6 $ 332.9 $ 402.3
Net receivables 729.2 833.6 463.1 396.5
Inventories 299.4 375.1 182.1 163.7
Other current assets 105.3 119.7 44.3 37.4
Current assets $2,146.3 $2,615.0 $1,022.4 $ 999.9
Accounts payable 560.4 710.4 267.2 242.7
Accrued liabilities 728.5 1,072.0 344.9 455.7
Air traffic liability* 577.0 800.0 390.5 302.4
Notes payable and current portion long-term debt 205.1 213.2 190.1 153.0
Current liabilities $2,071.0 $2,795.6 $1,192.7 $1,153.8
Net revenues $7,198.0 $8,824.3 $4,447.5 $3,806.1
*For Eastern Air Lines includes $7.8 million and 19.2 million in frequent flier miles for 1987 and 1988, respectively.
Source: American Airlines and Eastern Airlines, 1988 Annual Reports.
| | American Airlines | | Eastern Airlines | |
| | 1987 | 1988 | 1987 | 1988 |
|Current assets |$2,146.3 |$2,615.0 |$1,022.4 |$ 999.9 |
|Current Liabilities |2,071.0 |2,795.6 |1,192.7 |1,153.8 |
|Net working | | | | |
|Capital |$ 75.3 |$ (180.6) |$ (170.3) |$ (153.9) |
| | | | | |
| | | | | |
|Current ratio |1.03X |0.94X |0.86X |0.87X |
|Quick ratio |0.84 |0.76 |0.67 |0.69 |
|Cash ratio |0.49 |0.46 |0.28 |0.35 |
|Adjusted Computations: | | | | |
|Current | | | | |
|liabilities |$2,071.0 |$2,795.6 |$1,192.7 |$1,153.8 |
|Air traffic | | | | |
|liability |(577.0) |(800.0) |(390.5) |(302.4) |
|Current liabilities |$1,494.0 |$1,995.6 |$ 802.2 |$ 851.4 |
|Net working | | | | |
|capital |652.3 |619.4 |220.2 |148.5 |
| | | | | |
|Current ratio |1.44X |1.31X |1.27X |1.17X |
|Quick ratio |1.17 |1.06 |0.99 |0.94 |
|Cash ratio |0.68 |0.64 |0.41 |0.47 |
MICROSOFT
Balance Sheet (In millions)
June30 1998 1999
Assets
Current assets:
Cash and short-term investments $13,927 $17,236
Accounts receivable 1,460 2,245
Other 502 752
Total current assets 15,889 20,233
Property and equipment 1,505 1,611
Equity and other investments 4,703 14,372
Other assets 260 940
Total assets $22,357 $37,156
Liabilities and stockholders equity
Current liabilities:
Accounts payable $ 759 $ 874
Accrued compensation 359 396
Income taxes payable 915 1,607
Unearned revenue 2,888 4,239
Other 809 1,602
Total current liabilities 5,730 8,718
Commitments and contingencies
Stockholders’ equity:
Convertible preferred stock — shares authorized 100;
shares issued and outstanding 13 980 980
Common stock and paid-in capital — shares authorized 12,000;
shares issued and outstanding 4,940 and 5,109 8,025 13,844
Retained earnings, including other comprehensive income
of $666 and $1,787 7,622 13,614
Total stockholders’ equity 16,627 28,438
Total liabilities and stockholders’ equity $22,357 $37,156
Income Statement (In millions)
|Year Ended June30 |1997 |1998 |1999 |
|Revenue |$ 11,936 |$ 15,262 |$ 19,747 |
|Operating expenses: | | | |
|Cost of revenue |2,170 |2,460 |2,814 |
|Research and development |1,863 |2,601 |2,970 |
|Acquired in-process technology |— |296 |— |
|Sales and marketing |2,411 |2,828 |3,231 |
|General and administrative |362 |433 |689 |
|Other expenses |259 |230 |115 |
|Total operating expenses |7,065 |8,848 |9,819 |
|Operating income |4,871 |6,414 |9,928 |
|Investment income |443 |703 |1,803 |
|Gain on sale of Softimage, Inc. |— |— |160 |
|Income before income taxes |5,314 |7,117 |11,891 |
|Provision for income taxes |1,860 |2,627 |4,106 |
|Net income |$ 3,454 |$ 4,490 |$ 7,785 |
MICROSOFT
Notes To Financial Statements
UNEARNED REVENUE
A portion of Microsoft’s revenue is eamed ratably over the product life cycle or, in the case of subscriptions, over the period of the license agreement.
End users receive certain elements of the Company’s products over a period of time. These elements include browser technologies and technical support. Consequently, Microsoft’s earned revenue reflects the recognition of the fair value of these elements over the product’s life cycle. Upon adoption of SOP 98-9 during the fourth quarter of fiscal 1999, the Company was required to change the methodology of attributing the fair value to undelivered elements. The percentages of undelivered elements in relation to the total arrangement decreased, reducing the amount of Windows and Office revenue treated as uneamed, and increasing the amount of revenue recognized upon shipment. The percentage of revenue recognized ratably decreased from a range of 20% to 35% to a range of approximately 15% to 25% of Windows desktop operating systems. For desktop applications, the percentage decreased from approximately 20% to a range of approximately 10% to 20%. The ranges depend on the terms and conditions of the license and prices of the elements. The impact on fiscal 1999 was to increase reported revenue $170 million. In addition, the Company extended the life cycle of Windows from two to three years based upon management’s review of product shipment cycles. The impact on fiscal 1999 was to decrease reported revenue $90 million. Product life cycles are currently estimated at 18 months for desktop applications. The Company also sells subscriptions to certain products via maintenance and certain organizational license agreements. At June 30, 1999, Windows platforms products unearned revenue was $2.17 billion and unearned revenue associated with productivity applications and developer products totaled $1.96 billion. Uneamed revenue for other miscellaneous programs totaled $116 million at June 30, 1999.
Contingencies
The Securities and Exchange Commission is conducting a non-public investigation into the Company’s accounting reserve practices. Microsoft is also subject to various legal proceedings and claims that arise in the ordinary course of business.
|Face Value | | $100,000 |
|Coupon | |10% |
|Mkt rate | |10% |Issued at Par | |
| |
| |Opening |Interest | |Change in |Closing |
| |Balance |Expense |Payment |Principal |Balance |
|1 | $100,000 | $ 10,000 | $ 10,000 |$ - | $ 100,000 |
|2 | $100,000 | $ 10,000 | $ 10,000 |$ - | $ 100,000 |
|3 | $100,000 | $ 10,000 | $ 10,000 |$ - | $ 100,000 |
|4 | $100,000 | $ 10,000 | $ 10,000 |$ - | $ 100,000 |
| | | $ 40,000 | $ 40,000 |$ - | |
|Face Value | | $100,000 |
|Coupon | |10% |
|Mkt rate | |8% |Issued at Premium | |$106,624 |
| |
| |Opening |Interest | |Change in |Closing |
| |Balance |Expense |Payment |Principal |Balance |
|1 | $106,624 | $ 8,530 | $ 10,000 | $ (1,470) | $ 105,154 |
|2 | $105,154 | $ 8,412 | $ 10,000 | $ (1,588) | $ 103,567 |
|3 | $103,567 | $ 8,285 | $ 10,000 | $ (1,715) | $ 101,852 |
|4 | $101,852 | $ 8,148 | $ 10,000 | $ (1,852) | $ 100,000 |
| | | $ 33,376 | $ 40,000 | $ (6,624) | |
|Face Value | | $100,000 |
|Coupon | |10% |
|Mkt rate | |12% |Issued at Discount | |$93,925 |
| |
| |Opening |Interest | |Change in |Closing |
| |Balance |Expense |Payment |Principal |Balance |
|1 | $ 93,925 | $ 11,271 | $ 10,000 | $ 1,271 | $ 95,196 |
|2 | $ 95,196 | $ 11,424 | $ 10,000 | $ 1,424 | $ 96,620 |
|3 | $ 96,620 | $ 11,594 | $ 10,000 | $ 1,594 | $ 98,214 |
|4 | $ 98,214 | $ 11,786 | $ 10,000 | $ 1,786 | $ 100,000 |
| | | $ 46,075 | $ 40,000 | $ 6,075 | |
|Face Value | | $100,000 |
|Coupon | |0% |
|Mkt rate | |10% |Issued at discount | |$68,301 |
| |
| |Opening |Interest | |Change in |Closing |
| |Balance |Expense |Payment |Principal |Balance |
|1 | $ 68,301 | $ 6,830 |$ - | $ 6,830 | $ 75,131 |
|2 | $ 75,131 | $ 7,513 |$ - | $ 7,513 | $ 82,645 |
|3 | $ 82,645 | $ 8,264 |$ - | $ 8,264 | $ 90,909 |
|4 | $ 90,909 | $ 9,091 |$ - | $ 9,091 | $ 100,000 |
| | | $ 31,699 |$ - | $ 31,699 | |
EQK REALTY
Zero Coupon Financing, Financial Statement Excerpts
Balance Sheet
|Year Ended December 31 |1991 |1992 |
|Liabilities | | |
|Mortgage note payable, net of debt discount of $392 |------------ |$ 75,324 |
|Zero-coupon mortgage notes, net of unamortized discount of $9,574 | | |
| |$89,410 |--------- |
Statement of Cash Flows
Year Ended December 31 1992
Cash flows from operating activities
Net loss $ (8,850)
Adjustments to reconcile net loss to net cash provided by
operating activities
Amortization of discount on zero-coupon mortgage
notes 9,344
Other adjustments 7,574
Net cash provided by operating activities $ 8,068
Cash flows from financing activities
Prepayment of zero-coupon note $(23,038)
Other adjustments 1,572
Net cash provided by (used in) financing activities $(21,466)
Note 2: Debt Restructuring
In December 1992, the Company refinanced $75,689,000 representing the balance of its zero-coupon mortgage note that remained after reducing this indebtedness with the proceeds from the sale of properties. . . . The new financing, which is collateralized by first mortgage liens …. matures in December 1995.
Source: EQK Realty Investors, 1992 Annual Report.
EXHIBIT 10-13. NORAM ENERGY CORP.
Stockholders’ Equity and Debt Covenants
Condensed Shareholders’ Equity 1994 1993
Capital Stock
Preferred $ 130,000 $ 130,000
Common stock including paid-in capital 944,870 944,118
$1,074,870 $1,074,118
Retained Deficit
Balance at beginning of year (366,080) (360,121)
Net income (loss) 48,066 36,087
Cash dividends
Preferred stock, $3.00 per share (7,800) (7,800)
Common stock, $0.28 per share in 1994 and
$0.28 per share in 1993 (34,265) (34,246)
Balance at end of year $ (360,079) $ (366,080)
Unrealized gain on Itron investment, net of tax 2,586 ____
Total stockholders’ equity $ 717,377 $ 708,037
Note 5: Restrictions on Stockholders’ Equity and Debt
Under the provisions of the Company’s revolving credit facility as described in Note 3, and under similar provisions in certain of the Company’s other financial arrangements, the Company’s total debt capacity is limited and it is required to maintain a minimum level of stockholders’ equity. The required minimum level of stockholders’ equity was initially set at $650 million at December 31, 1993, increasing annually thereafter by (1) 50% of positive consolidated net income and (2) 50% of the proceeds (in excess of the first $50 million) of any incremental equity offering made after June 30, 1994. The Company’s total debt is limited to $2,055 million. Based on these restrictions, the Company had incremental debt issuance and dividend capacity of $321.2 million and $43.3 million, respectively, at December 31, 1994. The Company’s revolving credit facility also contains a provision which limits the Company’s ability to reacquire, retire or otherwise prepay its long-term debt prior to its maturity to a total of $100 million.
Source: NorAm Energy, 1994 Annual Report.
-----------------------
EQK Realty Investors
Adjustment of Operating Cash Flow (CFO),
Years Ending December 31, 1989 to 1994
($ in thousands)
1989 1990 1991 1992 1993 1994
Reported CFO $10,458 $9,795 $5,728 $8,068 $4,087 $2,184
Less: Zero-coupon interest 7,486 8,318 9,229 9,344 0 0
Adjusted CFO $2,972 $1,477 $(3,501) $(1,276) $4,087 $2,184
A.Current Income Level B. Required Level
1995 1996 1997 1997 1998
Estimated Stockholders' Equity
Opening $717.3 $723.3 $729.3 $729.3 $756.7
Income 48.0 48.0 48.0 69.4 84.0
Dividend (42.0) (42.0) (42.0) (42.0) (42.0)
Closing $723.3 $729.3 $735.3* $756.7 $798.7
Minimum Stockholders' Equity
Opening $674.0 $698.0 $722.0 $722.0 $756.7
Addition (50% of
income) 24.0 24.0 24.0 34.7 42.0
Closing $698.0 $722.0 $746.0 $756.7 $798.7
*Below minimum stockholders' equity required.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- income and balance sheet template
- amazon balance sheet 2018
- personal balance sheet template
- amazon balance sheet and income state
- balance sheet of a publicly traded company
- reading a balance sheet 101
- amazon balance sheet analysis
- amazon balance sheet and income statement
- amazon balance sheet 2017
- income and balance sheet examples
- disney balance sheet 2018
- current balance sheet for amazon