In: Accounting
Compute and Interpret Z-score
Balance sheets and income statements for Lockheed Martin
Corporation follow. Refer to these financial statements to answer
the requirements.
Income Statement | |||
---|---|---|---|
Year Ended December 31 (In millions) | 2005 | 2004 | 2003 |
Net sales | |||
Products | $ 31,518 | $ 30,202 | $ 27,290 |
Service | 5,695 | 5,324 | 4,534 |
37,213 | 35,526 | 31,824 | |
Cost of sales | |||
Products | 27,932 | 27,637 | 25,306 |
Service | 5,073 | 4,765 | 4,099 |
Unallocated coporate costs | 803 | 914 | 443 |
33,808 | 33,316 | 29,848 | |
3,405 | 2,210 | 1,976 | |
Other income (expenses), net | (449) | (121) | 43 |
Operating profit | 2,956 | 2,089 | 2,019 |
Interest expense | 370 | 425 | 487 |
Earnings before taxes | 2,586 | 1,664 | 1,532 |
Income tax expense | 761 | 368 | 479 |
Net earnings | $ 1,825 | $ 1,296 | $ 1,053 |
Balance Sheet | ||
---|---|---|
December 31 (In millions) | 2005 | 2004 |
Assets | ||
Cash and cash equivalents | $ 2,144 | $ 1,080 |
Short-term investments | 429 | 396 |
Receivables | 4,579 | 4,094 |
Inventories | 1,921 | 1,864 |
Deferred income taxes | 861 | 982 |
Other current assets | 495 | 557 |
Total current assets | 10,409 | 8,973 |
Property, plant and equipment, net | 3,924 | 3,599 |
Investments in equity securities | 196 | 812 |
Goodwill | 8,447 | 7,892 |
Purchased intangibles, net | 560 | 672 |
Prepaid pension asset | 1,360 | 1,030 |
Other assets | 2,728 | 2,596 |
Total assets | $ 27,624 | $ 25,574 |
Liabilities and stockholders' equity | ||
Accounts payable | $ 1,998 | $ 1,726 |
Customer advances and amounts in excess of costs incurred | 4,331 | 4,028 |
Salaries, benefits and payroll taxes | 1,475 | 1,346 |
Current maturities of long-term debt | 202 | 15 |
Other current liabilities | 1,422 | 1,451 |
Total current liabilities | 9,428 | 8,566 |
Long-term debt | 4,944 | 5,184 |
Accrued pension liabilities | 1,617 | 1,760 |
Other postretirement benefit liabilities | 1,277 | 1,236 |
Other liabilities | 2,491 | 1,807 |
Stockholders' equity | ||
Common stock, $1 par value per share | 432 | 438 |
Additional paid-in capital | 1,724 | 2,223 |
Retained earnings | 7,278 | 5,915 |
Accumulated other comprehensive loss | (1,553) | (1,532) |
Other | (14) | (23) |
Total stockholders' equity | 7,867 | 7,021 |
Total liabilities and stockholders' equity | $ 27,624 | $ 25,574 |
Consolidated Statement of Cash Flows | |||
---|---|---|---|
Year Ended December 31 (In millions) | 2005 | 2004 | 2003 |
Operating Activities | |||
Net earnings | $ 1,825 | $ 1,266 | $ 1,053 |
Adjustments to reconcile net earnings to net cash provided by operating activities | |||
Depreciation and amortization | 555 | 511 | 480 |
Amortization of purchased intangibles | 150 | 145 | 129 |
Deferred federal income taxes | 24 | (58) | 467 |
Changes in operating assets and liabilities: | |||
Receivables | (390) | (87) | (258) |
Inventories | (39) | 519 | (94) |
Accounts payable | 239 | 288 | 330 |
Customer advances and amounts in excess of costs incurred | 296 | (228) | (285) |
Other | 534 | 568 | (13) |
Net cash provided by operating activities | 3,194 | 2,924 | 1,809 |
Investing Activities | |||
Expenditures for property, plant and equipment | (865) | (769) | (687) |
Acquisition of business/investments in affiliated companies | (784) | (91) | (821) |
Proceeds from divestiture of businesses/Investments in affiliated companies | 935 | 279 | 234 |
Purchase of short-term investments, net | (33) | (156) | (240) |
Other | 28 | 29 | 53 |
Net cash used for investing activities | (719) | (708) | (1,461) |
Financing Activities | |||
repayment of long-term debt | (53) | (1,069) | (2,202) |
Issuances of long-term debt | -- | -- | 1,000 |
Long-term debt repayment and issuance costs | (12) | (163) | (175) |
Issuances of common stock | 406 | 164 | 44 |
Repurchases of common stock | (1,310) | (673) | (482) |
Common stock dividends | (462) | (405) | (261) |
Net cash used for financing activities | (1,431) | (2,146) | (2,076) |
Net increase (decrease) in cash and cash equivalents | 1,044 | 70 | (1,728) |
Cash and cash equivalents at beginning of year | 1,080 | 1,010 | 2,738 |
Cash and cash equivalents at end of year | $ 2,124 | $ 1,080 | $ 1,010 |
As of December 31, there were the approximate shares
outstanding:
2005 - 434,264,432
2004 - 440,445,630
As of December 31, the company's stock closed at the following
values:
2005 - $63.63
2004 - $55.55
(a) Compute and compare the Altman Z-scores for both years. (Do not
round until your final answer; then round your answers to two
decimal places.)
2005 z-score = Answer
2004 z-score = Answer
z-score formula = 1.2A + 1.4B + 3.3C + 0.6D + 0.99E
where, A = working capital / total assets
B = retained earnings / total assets
C = EBIT / total assets
D = market value of equity / book value of liabilities
E = sales / total assest
In millions | ||
2005 | 2004 | |
Total assets | $27,624 | $25,574 |
Current assets | $10,409 | $8,973 |
current liabilities | $9,428 | $8,566 |
retained earnings | $7,278 | $5,915 |
EBIT | $2,956 | $2,089 |
Number of shares | 434.26 | 440.44 |
Share price | $63.63 | $55.55 |
total liabilities | $19,757 | $18,553 |
sales | $37,213 | $35,526 |
Working capital | $981 | $407 |
Market value of equity | $27,632 | $24,466 |
A | 0.036 | 0.016 |
B | 0.263 | 0.231 |
C | 0.107 | 0.082 |
D | 1.399 | 1.319 |
E | 1.347 | 1.389 |
2005 z-score = 1.2*0.036 + 1.4*0.263 + 3.3*0.107 + 0.6*1.399 + 0.99*1.347
= 2.94
2004 z- score = 1.2*0.016 + 1.4*0.231 + 3.3*0.082 + 0.6*1.319 + 0.99*1.389
= 2.77
The company is in grey zone in both the years as the z score is less than 2.9 and more than 1.23. This means it is a reg flag for the company for the potential problems it might face in the near future. The z score has imprived in 2005 on account of all the components of the z score.