Make income statement and balance sheet

ammar7599
Lowes.xlsx

Balance sheet

NOTE: 2015 BALANCE SHEET INFORMATION SHOULD BE USED ONLY FOR RATIOS
Report Date 2018 2017 2016 2015
$ in Thousands
Cash & cash equivalents $511,000 $588,000 $558,000 $405,000
Short-term investments $218,000 $102,000 $100,000 $307,000
Merchandise inventory, net $12,561,000 $11,393,000 $10,458,000 $9,458,000
Other current assets $938,000 $689,000 $884,000 $391,000
Total current assets $14,228,000 $12,772,000 $12,000,000 $10,561,000
Property, less accumulated depreciation $18,432,000 $19,721,000 $19,949,000 $19,577,000
Long-term investments $256,000 $408,000 $366,000 $222,000
Deferred income taxes - net $294,000 $168,000 $222,000 $241,000
Goodwill $303,000 $1,307,000 $1,082,000 $0
Other assets $995,000 $915,000 $789,000 $665,000
Total assets $34,508,000 $35,291,000 $34,408,000 $31,266,000
Liabilities
Short-term borrowings $722,000 $1,137,000 $510,000 $43,000
Current maturities of long-term debt $1,110,000 $294,000 $795,000 $1,061,000
Accounts payable $8,279,000 $6,590,000 $6,651,000 $5,633,000
Accrued compensation & employee benefits $662,000 $747,000 $790,000 $820,000
Deferred revenue $1,299,000 $1,378,000 $1,253,000 $1,078,000
Other current liabilities $2,425,000 $1,950,000 $1,975,000 $1,857,000
Total current liabilities $14,497,000 $12,096,000 $11,974,000 $10,492,000
Long-term debt, excluding current maturities $14,391,000 $15,564,000 $14,394,000 $11,545,000
Deferred revenue - extended protection plans $827,000 $803,000 $763,000 $729,000
Other liabilities $1,149,000 $955,000 $843,000 $846,000
Total liabilities $30,864,000 $29,418,000 $27,974,000 $23,612,000
Stockholders' Equity
Common stock $401,000 $415,000 $433,000 $455,000
Capital in excess of par value $0 $22,000 $0 $0
Retained earnings $3,452,000 $5,425,000 $6,241,000 $7,593,000
Accumulated other comprehensive income (loss) -$209,000 $11,000 -$240,000 -$394,000
Total shareholders' equity $3,644,000 $5,873,000 $6,434,000 $7,654,000
Total liabilities and stockholders’ equity $34,508,000 $35,291,000 $34,408,000 $31,266,000
Additional Information
**Property and Equipment, at cost:
Land $7,196,000 $7,414,000 $7,329,000 $7,086,000
Buildings & building improvements $18,052,000 $18,521,000 $18,147,000 $17,451,000
Equipment $10,090,000 $10,475,000 $10,978,000 $10,863,000
Construction in progress $525,000 $530,000 $464,000 $513,000
Total cost $35,863,000 $36,940,000 $36,918,000 $35,913,000
Less: accumulated depreciation $17,431,000 $17,219,000 $16,969,000 $16,336,000

Income Statement

As Reported Annual Income Statement
Report Date 2018 2017 2016
Scale Thousands Thousands Thousands
Net sales $ 71,309,000 $ 68,619,000 $ 65,017,000
Cost of sales $ 48,401,000 $ 45,210,000 $ 42,553,000
Gross margin $ 22,908,000 $ 23,409,000 $ 22,464,000
Selling, general & administrative expense $ 17,413,000 $ 15,376,000 $ 15,129,000
Depreciation & amortization $ 1,477,000 $ 1,447,000 $ 1,489,000
Operating income (loss) $ 4,018,000 $ 6,586,000 $ 5,846,000
Interest income (expense), net $ (624,000) $ (633,000) $ (645,000)
Loss on extinguishment of debt $ - 0 $ (464,000) $ - 0
Pre-tax earnings (losses) $ 3,394,000 $ 5,489,000 $ 5,201,000
Income tax provision $ 1,080,000 $ 2,042,000 $ 2,108,000
Net earnings $ 2,314,000 $ 3,447,000 $ 3,093,000
Additional Information
Weighted average shares outstanding - basic 811,000 839,000 880,000
Cash dividends per share 1.85 1.58 1.33
Net cash flows from operating activities $ 6,193,000 $ 5,065,000 $ 5,617,000