Question

Following are the forecasted income statement and balance sheet for Lockheed Martin Corporation for the year...

Following are the forecasted income statement and balance sheet for Lockheed Martin Corporation for the year ended December 31, 2017. Prepare a forecasted statement of cash flows for the company for 2017.

LOCKHEED MARTIN CORPORATION

Consolidated Balance Sheet

At December 31,

(in millions)

2017

Forecasted

2016

Actual

Cash and equivalents

$ 6,715

$ 1,837

Receivables, net

9,526

8,202

Inventories, net

5,385

4,670

Other current assets

399

399

Total current assets

22,025

15,108

Property, plant and equipment, net

5,358

5,549

Goodwill

10,764

10,764

Intangible assets, net

3,892

4,093

Deferred income taxes

6,625

6,625

Other noncurrent assets

5,667

5,667

Total assets

$54,331

$47,806

Accounts payable

$ 1,916

$ 1,653

Customer advances and amounts in excess of costs

7,829

6,776

Salaries, benefits and payroll taxes

2,026

1,764

Current portion of long-term debt

0

0

Other current liabilities

2,349

2,349

Total current liabilities

14,120

12,542

Long-term debt, net

14,282

14,282

Accrued pension liabilities

16,041

13,855

Other postretirement benefit liabilities

985

862

Other noncurrent liabilities

4,659

4,659

Total liabilities

$50,087

$46,200

Common stock

$ 289

$ 289

Retained earnings

15,962

13,324

Accumulated other comprehensive (loss)

(12,102

)

(12,102

)
Total stockholders' equity

4,149

1,511

Noncontrolling interests in subsidiary

95

95

Total equity

4,244

1,606

Total liabilities and equity

$54,331

$47,806

LOCKHEED MARTIN CORPORATION

Consolidated Income Statement

For the year ended December 31,

(in millions)

2017

Forecasted

2016

Actual

Net sales
Products

$46,420

$40,365

Services

8,328

6,883

Total net sales

54,748

47,248

Cost of sales
Products

42,103

36,616

Services

7,304

6,040

Severance and other charges

0

80

Other unallocated corporate costs

0

(550

)
Total cost of sales

49,407

42,186

Gross profit

5,341

5,062

Other operating income

487

487

Operating profit

5,828

5,549

Interest expense

663

663

Earnings before income taxes

5,165

4,886

Income tax expense

1,198

1,133

Net earnings from continuing operations

$ 3,967

$ 3,753

Net earnings (loss) from discontinued operations

0

1,549

Net earnings

$ 3,967

$ 5,302


The following assumptions were used to develop the forecasted financial statements:

Depreciation expense to start of year PPE, net

21.2%

Amortization expense to start of year intangible assets, net

4.9%

CAPEX to total net sales

1.8%

Dividends to net earnings

33.5%

Homework Answers

Answer #1

Workings-

Calculation of Depreciation = $5,549 x 21.2% = $1177(Approx)
Calculation of Amortisation = $4,093 x 4.9% = $201

CAPEX to total net sales = 1.8%
Net sales = $54,748
CAPEX = $986 (approx) = (5,358 - 5,549) + (3,892 - 4,093) + Depreciation + $201
Or Depreciation = $986+191+201-201 = $1177

Dividend = 33.5% of $ 3,967 = $1329 (Approx)

Increase in Current Asset = (22,025 - $ 6,715) - (15,108 - $ 1,837) = $2039
Increase in Current Liability = (14,120 - 12,542) = $1578

Property, plant and equipment purchased during the year = $5,358 - (5,549 - 1177) = $986

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Refine Assumptions for Dividend and Retained Earnings Forecast Following are the income statement and balance sheet...
Refine Assumptions for Dividend and Retained Earnings Forecast Following are the income statement and balance sheet for Medtronic PLC. Consolidated Statement of Income ($ millions) For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expenses 2,330 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 198 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit (loss) 6,268 Other nonoperating income,...
Operating Section of Statement of Cash Flows (Indirect Method) Following are the income statement and balance...
Operating Section of Statement of Cash Flows (Indirect Method) Following are the income statement and balance sheet for Nike Inc. for the year ended May 31, 2016, and a forecasted income statement and balance sheet for 2017. Nike Inc. Income Statement For Year Ended May 31 $ millions 2016 actual 2017 Est. Revenues $ 32,376 $ 34,319 Cost of sales 17,405 18,464 Gross profit 14,971 15,855 Demand creation expense 3,278 3,466 Operating overhead expense 7,191 7,619 Total selling and administrative...
Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and...
Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and balance sheets of General Mills, Inc. Income Statement, Fiscal Years Ended ($ millions) May 29, 2011 May 30, 2010 Net Sales $ 14,880.2 $ 14,635.6 Cost of sales 8,926.7 8,835.4 Selling, general and administrative expenses 3,192.0 3,162.7 Divestitures (gain), net (17.4) -- Restructuring, impairment, and other exit costs 4.4 31.4 Operating income 2,774.5 2,606.1 Interest, net 346.3 401.6 Earnings before income tax expense and...
Refine Assumptions for PPE Forecast Following are the income statement and balance sheet for Medtronic PLC....
Refine Assumptions for PPE Forecast Following are the income statement and balance sheet for Medtronic PLC. Consolidated Statement of Income ($ millions) For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expenses 2,330 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 198 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit (loss) 6,268 Other nonoperating income, net (373) Interest...
The following table shows an abbreviated income statement and balance sheet for McDonald's Corporation for 2012....
The following table shows an abbreviated income statement and balance sheet for McDonald's Corporation for 2012. INCOME STATEMENT OF MCDONALD’S CORP., 2012 (Figures in $ millions)   Net sales 27,572   Costs 17,574   Depreciation 1,407   Earnings before interest and taxes (EBIT) 8,591   Interest expense 522   Pretax income 8,069   Taxes 2,624   Net income 5,445 BALANCE SHEET OF MCDONALD’S CORP., 2012 (Figures in $ millions)   Assets 2012 2011 Liabilities and Shareholders' equity 2012 2011 Current assets Current liabilities   Cash and marketable securities 2,341 2,341...
The Balance Sheet and the Income Statement for ABC Manufacturing Corporation are as follows: DATA (All...
The Balance Sheet and the Income Statement for ABC Manufacturing Corporation are as follows: DATA (All amounts in SAR unless otherwise indicated, all sales are on credit and no hard keys.) Balance Sheet: ABC Corporation Balance Sheet Other current assets Total current assets Gross fixed assets Accumulated depreciation Net fixed assets Total assets LIABILITIES (DEBT) AND EQUITY Accounts payable Short-term notes payable Total current liabilities Long-term debt Total liabilities Common stock (par & paid in capital) Retained earnings Total common...
Following is the balance sheet for Medtronic PLC for the year ended April 29, 2016. Medtronic...
Following is the balance sheet for Medtronic PLC for the year ended April 29, 2016. Medtronic plc Consolidated Balance Sheets ($ millions) Apr. 29, 2016 Apr. 24, 2015 Current assets Cash and cash equivalents $3,221 $4,843 Investments 9,758 14,637 Accounts receivable 5,562 5,112 Inventories 3,473 3,463 Tax assets 697 1,335 Prepaid expenses and other current assets 1,234 1,454 Total current assets 23,945 30,844 Property, plant, and equipment, net 4,841 4,699 Goodwill 41,500 40,530 Other intangible assets, net 26,899 28,101 Long-term...
Ivanhoe Corporation recently filed the following financial statements with the SEC. Ivanhoe Corporation Income Statement for...
Ivanhoe Corporation recently filed the following financial statements with the SEC. Ivanhoe Corporation Income Statement for the Fiscal Year Ended July 31, 2017 Net sales $58,589 Cost of products sold 41,674 Gross profit $16,915 Selling, general, and administrative expenses 7,466 Depreciation 848 Operating income (loss) $8,601 Interest expense 519 Earnings (loss) before income taxes $8,082 Income taxes 2,829 Net earnings (loss) $5,253 Ivanhoe Corporation Balance Sheet as of July 31, 2017 Assets Liabilities and Stockholders’ Equity Cash and marketable securities...
Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and...
Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and balance sheets of Amazon.com Inc. AMAZON.COM INC. Consolidated Statement of Operations $ millions Dec. 31, 2015 Dec. 31, 2014 Net product sales $79,268 $70,080 Net service sales 27,738 18,908 Total net sales 107,006 88,988 Operating expenses Cost of sales 71,651 62,752 Fulfillment 13,410 10,766 Marketing 5,254 4,332 Technology and content 12,540 9,275 General and administrative 1,747 1,552 Other operating expense (income), net 171 133...
Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and...
Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and balance sheets of Amazon.com Inc. AMAZON.COM INC. Consolidated Statement of Operations $ millions Dec. 31, 2015 Dec. 31, 2014 Net product sales $79,268 $70,080 Net service sales 27,738 18,908 Total net sales 107,006 88,988 Operating expenses Cost of sales 71,651 62,752 Fulfillment 13,410 10,766 Marketing 5,254 4,332 Technology and content 12,540 9,275 General and administrative 1,747 1,552 Other operating expense (income), net 171 133...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT