Question

In: Accounting

Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin...

Compute and Interpret Liquidity, Solvency and Coverage Ratios
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,882 27,637 25,306
Service 5,073 4,765 4,099
Unallocated coporate costs 803 914 443
33,758 33,316 29,848
3,455 2,210 1,976
Other income (expenses), net (449) (121) 43
Operating profit 3,006 2,089 2,019
Interest expense 370 425 487
Earnings before taxes 2,636 1,664 1,532
Income tax expense 811 398 479
Net earnings $ 1,825 $ 1,266 $ 1,053
Balance Sheet
December 31 (In millions) 2005 2004
Assets
Cash and cash equivalents $ 2,164 $ 780
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,449 8,673
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,664 $ 25,274
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,664 5,264
Accrued pension liabilities 2,097 1,300
Other postretirement benefit liabilities 1,277 1,236
Other liabilities 2,331 1,887
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,664 $ 25,274
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 (84) (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 (19) (708) (1,461)
Financing Activities
repayment of long-term debt (413) (1,369) (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,791) (2,446) (2,076)
Net increase (decrease) in cash and cash equivalents 1,384 (230) (1,728)
Cash and cash equivalents at beginning of year 780 1,010 2,738
Cash and cash equivalents at end of year $ 2,164 $ 780 $ 1,010

(a) Compute Lockheed Martin's current ratio and quick ratio for 2005 and 2004. (Round your answers to two decimal places.)
2005 current ratio = Answer


2004 current ratio = Answer



2005 quick ratio = Answer


2004 quick ratio = Answer






(b) Compute total liabilities-to-equity ratios and total debt-to-equity ratios for 2005 and 2004. (Round your answers to two decimal places.)
2005 total liabilities-to-stockholders' equity = Answer


2004 total liabilities-to-stockholders' equity = Answer



2005 total debt-to-equity = Answer


2004 total debt-to-equity = Answer





(c) Compute times interest earned ratio, cash from operations to total debt ratio, and free operating cash flow to total debt ratios. (Round your answers to two decimal places.)
2005 times interest earned = Answer


2004 times interest earned = Answer



2005 cash from operations to total debt = Answer


2004 cash from operations to total debt = Answer



2005 free operating cash flow to total debt = Answer


2004 free operating cash flow to total debt = Answer

Solutions

Expert Solution

A. Computation of Current Ratio and quick ratio for 2005 and 2004

Current Ratio = Current Assets / Current Liabilities

2005

2004

Total current assets

10,449

8.673

Total Current Liabilities

9,428

8,566

Current Ratio

=10449/9428

=8673/8566

=1.11 : 1

=1.01 : 1

               

Quick Ratio = Quick Assets / Current Liabilities

Quick Assets = Current Assets – Inventory – Deffered Tax Assets

               

2005

2004

Total current assets

10,449

8.673

Total Current Liabilities

9,428

8,566

Inventory

1,961

1,824

Deferred income taxes

861

982

(i) Quick Assets

=10,449-1961-861

=8673-1824-982

=7627

=5867

(ii) Quick Ratio

=7627/9428

=5867/8566

=0.81 : 1

=0.68:1

B. Computation of Total Liabilities to Stock holders’ equity ratio and Total debt to Stockholers’ equity ratio

Total liabilities to Stockholders’ equity ratio = Total Liabilities / Stock holders’ equity

Total liabilities = Total liabilities and stock holders’ equity – stock holders’ equity

               

2005

2004

Total liabilities and Stockholders’ equity

27,664

25,274

Stock holders’ equity

7,867

7,021

Total liabilities

=27,664-7,867

=25274-7021

=19,797

=18,253

Total liabilities to stockholders’ equity ratio

=19797/7867

=18253/7021

=2.52 : 1

=2.60:1

Total Debt to stockholders’ equity ratio = Total Debt / Stockholders equity

Total Debt = Long Term Debt

               

2005

2004

Long Term Debt

4,664

5,264

Stock holders’ equity

7,867

7,021

Total Debt to Stockholders’ equity

=4664/7867

=5264/7021

=0.59 : 1

=0.75 : 1

C. Computation of Interest Earned Ratio

Interest Earned Ratio= Net Profit Before Interest, Taxes and Dividend / Total Interest Expense

(this ratio tells how many times interest expense is covered by Net Profit )

               

2005

2004

Net profit before interest, taxes and dividend (operating profit)

3,006

2,089

Interest expense

370

425

Interest earned ratio

=3006/370

=2089/425

8.12 times

4.92 times


Related Solutions

Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin Corporation follow. Refer to these financial statements to answer the requirements. Consolidated Statements of Earnings Year Ended December 31 (In millions) 2016 2015 Net sales Products $ 40,365 $ 34,868 Services 6,883 5,668 Total net sales 47,248 40,536 Cost of sales Products (36,616) (31,091) Services (6,040) (4,824) Severance and other charges (80) (82) Other unallocated costs 550 (47) Total cost of sales (42,186) (36,044)...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin...
Compute and Interpret Liquidity, Solvency and Coverage Ratios 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,882 27,637 25,306 Service 5,073 4,765 4,099 Unallocated coporate costs 803 914 443 33,758 33,316 29,848 3,455 2,210 1,976 Other income (expenses),...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin...
Compute and Interpret Liquidity, Solvency and Coverage Ratios 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 28,800 27,879 25,306 Service 5,073 4,765 4,099 Unallocated coporate costs 803 914 443 34,676 33,558 29,848 2,537 1,968 1,976 Other income (expenses),...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin...
Compute and Interpret Liquidity, Solvency and Coverage Ratios 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,882 27,637 25,306 Service 5,073 4,765 4,099 Unallocated coporate costs 803 914 443 33,758 33,316 29,848 3,455 2,210 1,976 Other income (expenses),...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin Corporation follow. Refer to these financial statements to answer the requirements. Consolidated Statements of Earnings Year Ended December 31 (In millions) 2016 2015 Net sales Products $ 40,365 $ 34,868 Services 6,883 5,668 Total net sales 47,248 40,536 Cost of sales Products (36,616) (31,091) Services (6,040) (4,824) Severance and other charges (80) (82) Other unallocated costs 550 (47) Total cost of sales (42,186) (36,044)...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin Corporation follow. Refer to these financial statements to answer the requirements. Consolidated Statements of Earnings Year Ended December 31 (In millions) 2012 2011 2010 Net sales Products $ 37,817 $ 36,925 $ 36,380 Services 9,365 9,574 9,291 Total net sales 47,182 46,499 45,671 Cost of sales Products (33,495) (32,968) (32,539) Services (8,383) (8,514) (8,382) Severance and other charges (48) (136) (220) Other unallocated costs...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Information from the balance sheet, income statement, and...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Information from the balance sheet, income statement, and statement of cash flows for Nike follows. Refer to these financial statements to answer the requirements. NIKE, INC. Consolidated Statements of Income Year Ended December 31 (In millions) 2019 2018 Revenues $39,117 $36,397 Cost of sales 21,643 20,441 Gross profit 17,474 15,956 Demand creation expense 3,753 3,577 Operating overhead expense 8,949 7,934 Total selling and administrative expense 12,702 11,511 Interest expense (income), net 49...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information for...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information for Calpine Corporation for 2004 and 2006 follows. ($ millions) 2004 2006 Cash $ 1,376.73 $ 1,503.36 Accounts receivable 1,097.16 735.30 Current assets 3,563.56 3,168.33 Current liabilities 3,285.39 6,057.95 Long-term debt 16,940.81 3,351.63 Short-term debt 1,033.96 4,568.83 Total liabilities 22,628.42 25,743.17 Interest expense 1,516.90 1,288.29 Capital expenditures 1,545.48 211.50 Equity 4,587.67 (7,152.90) Cash from operations 9.89 155.98 Earnings before interest and taxes 1,589.84 1,877.84 (a)...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information for...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information for Nordstrom, Inc. for 2016 and 2015 follows. ($ millions) 2016 2015 Cash $ 595 $ 827 Accounts receivable 196 2,306 Current assets 3,014 5,224 Current liabilities 2,911 2,800 Long-term debt 2,795 3,123 Short-term debt 10 8 Total liabilities 6,827 6,805 Interest expense 153 156 Capital expenditures 1,082 861 Equity 871 2,440 Cash from operations 2,451 1,220 Earnings before interest and taxes 1,101 1,323 (a)...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information for...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information for Nordstrom, Inc. for 2014 and 2013 follows. ($ millions) 2014 2013 Cash $ 1,194 $ 1,285 Accounts receivable 2,177 2,129 Current assets 5,228 5,081 Current liabilities 2,541 2,226 Long-term debt 3,113 3,131 Short-term debt 0 0 Total liabilities 6,494 6,176 Interest expense 161 160 Capital expenditures 803 513 Equity 2,080 1,913 Cash from operations 1,320 1,110 Earnings before interest and taxes 1,350 1,345 (a)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT