I just need the balance sheets for both companies. none of the writing. i only have until midnight to turn this portion in.

what information are you missing

umerem On What requnean we current projects. ThereTore, you CANNOT directly follow the samples. Some modification is needed. The specific purposes of the projects are: 1. Apply to actual companies the knowledge and analytical techniques learned from our course. 2. Perform vertical and horizontal analysis and various ratios on the financial statements. 3. Compare the calculated results with competitor and across different years. 4. Summarize the analyses and make investment recommendations. You will be analyzing the following firms: a. Home Depot (HD) b. Lowes (LOW). Please check the blackboard for the financial statements. 5(1).xlsx Lowes.xlsx 2. Y lie 100% A Home Layout Tables Charts SmartArt Formulas Data Review Edit Font 10 Alignment abc Fill Arial A A Wrap Text C Clear B U aste Merge 4 E 2015 A52 x B D NOTE: 2015 BALANCE SHEET INFORMATION SHOULD BE USED ONLY FOR RATIOS Report Date 2018 2017 2016 $ In Thousands Cash & cash equivalents $511,000 $588,000 $558,000 Short-term investments $218,000 $102,000 $100,000 Merchandise inventory.net $12,561,000 $11,393,000 $10,458,000 Other current assets $938,000 $689,000 $884,000 Total current assets $14,228,000 $12,772,000 $12,000,000 Property, less accumulated depreciation $18,432,000 $19,721,000 $19.949,000 Long-term investments $256,000 $408,000 $366,000 Deferred Income taxes - net $294,000 $168,000 $222.000 Goodwill $303,000 $1,307.000 $1,082,000 Other assets $995,000 $915,000 $789,000 4 Total assets $34,508,000 $35,291,000 $34,408,000 $405,000 $307,000 $9,458,000 $391,000 $10,561,000 $19,577,000 $222,000 $241,000 $0 $665,000 $31,266,000 7 Liabilities 3 Short-term borrowings 9 Current maturities of long-term debt 0 Accounts payable 1 Accrued compensation & employee benefits 2 Deferred revenue 3 Other current liabilities 4 Total current liabilities 5 Long-term debl, excluding current maturities 6 Deferred revenue - extended protection plans 27 Other liabilities 28 Total liabilities $722.000 $1,110,000 $8,279,000 $662,000 $1.299,000 $2.425,000 $14,497,000 $14,301,000 5827,000 $1,149,000 $30,864,000 $1,137,000 $204,000 $6,590,000 $747,000 $1,378,000 $1,950,000 $12,096,000 $15,564,000 $803,000 $955,000 $29,418,000 $510,000 $795,000 $6,851.000 $790,000 $1,253,000 $1,975,000 $11,974,000 $14,394.000 $763,000 $843,000 $27,974,000 $43.000 $1,061,000 $5,633,000 $820,000 $1,078,000 $1,857,000 $10,492,000 $11,545,000 $729.000 $846,000 $23,612,000 S401,000 SO $3,452.000 $209,000 $3,644,000 534,508,000 $415,000 $22,000 $5,425,000 $11,000 $5,873,000 $35,291,000 $433.000 SO $6,241,000 -S240,000 $6,434,000 $34,408,000 $455,000 SO $7.593.000 $394.000 $7,654,000 $31,266,000 30 Stockholders' Equity 31 Common stock 32 Capital in excess of par value 33 Retained earnings 34 Accumulated other comprehensive income foss) 35 Total shareholders' equity 36 Total liabilities and stockholders' equity 37 38 Additional Information 39 **Property and Equipment, al cost 40 Land 41 Buildings & building improvements 42 Equipment 43 Construction in progress 44 Total cos! 45 Less: accumulated depreciation 46 $7.190.000 S18.052.000 $10,000,000 $525.000 $35,863,000 $17.431.000 $7,414,000 $18,621,000 $10.475,000 $530,000 $36.940.000 $17.219.000 $7,329.000 $18,147.000 $10.978,000 $484,000 $35.918,000 $16.989.000 $7,086,000 $17.451,000 $10.863,000 $513.000 $35.913,000 $18,336,000 50 5. 55 2.1. Y 100% Home Layout Tables Charts SmartArt Formulas Data Review Edit Font Alignment Fill Arial 10 . . abc- Wrap Text General ste Clear B 1 U Merge - % Al X fx NOTE: 2015 BALANCE SHEET INFORMATION SHOULD BE USED ONLY FOR RA A B D NOTERISTALTARLARINFORMATION SHUDHUDIONYFORRATO Report Date 2018 2017 2016 2015 . $2,216 $1,890 $11 809 $569 $2,538 $2,029 $12,549 $608 $17,724 $21.914 $2,093 $1.235 $42,966 $16,484 $22.191 $2.102 $1,196 $41,973 Sin Millions Current assets: Cash and cash equivalents $1,778 $3,595 Receivables, net $1,936 $1,952 Merchandise inventories $13,925 $12.748 Other current assets $890 $638 Total current assets $18,529 $18,933 Net property and equipment $22,375 $22.075 Goodwil $2,252 $2,275 Other assets $847 $1.246 Total assets $44,003 $44,529 Current Liabilities: Short-term debt $1,339 $1,550 Accounts payable $7.755 $7,244 Accrued salaries and related expenses $1,506 $1,640 Sales taxes payable $656 $520 Deferred revenue $1,782 $1,805 Income taxes payable $11 $54 Current installments of long-term debt $1,058 $1.202 Other accrued expenses $2,611 $2.170 Total current liabilities $16,716 $16,194 Long-term debl, excluding current installments $26.807 $24.267 Deferred Income taxes $491 $440 Other long-term liabilities $1,867 $2.174 8 Total liabilities $45.881 $43,075 Common stock, par value $0.06; authorized: 10.000 shares, issued: 1.78: $89 $80 Paid-in capital $10.678 $10,192 Retained earnings $48,423 $30,935 2 Accumulated other comprehensive loss $772 -$566 3 Treasury stock, at cost, 677 shares of February 3, 2019 and 622 shares $58,198 -$48,198 4 Total stockholders' (deficit) equity -$1,878 $1,454 5 Total liabilities and stockholders' equity $44,003 $44,529 6 7 B 9 Additional Information 0 No a lowance account is created for receivables, Not receivables sequarto gross recevables 1 Z Property and Equipment at cost 33 Land $8,363 8352 14 Buildings 18190 $18.073 5 Fumitur, Futures and Equipment 12450 11506 6 Leasehold Improvements 1705 1637 87 Construction in Progress 820 538 18 Capital Leases 1308 49 Less Accumulated Doprecation and Amortization 20564 19330 SO Net Property and Equpment 22375 22075 $710 $7.000 $1,484 $500 $1,669 $25 $542 $2.195 $14,133 522349 $296 $1,855 $38,633 $88 $9,787 $35,519 $567 $40.194 $4,333 $42.956 $350 $6,565 $1,515 $478 $1,566 $34 $77 $1,941 $12,524 $20,789 $379 $1,965 $35,657 588 59,347 $30.973 -5898 -$33,194 $6,316 $41,973 $8.207 $17.772 11.020 1,519 730 1.169 18,512 21.914 B.149 17.567 10,270 1,481 670 1.020 17.075 22.191 Balance She umerem On What requnean we current projects. ThereTore, you CANNOT directly follow the samples. Some modification is needed. The specific purposes of the projects are: 1. Apply to actual companies the knowledge and analytical techniques learned from our course. 2. Perform vertical and horizontal analysis and various ratios on the financial statements. 3. Compare the calculated results with competitor and across different years. 4. Summarize the analyses and make investment recommendations. You will be analyzing the following firms: a. Home Depot (HD) b. Lowes (LOW). Please check the blackboard for the financial statements. 5(1).xlsx Lowes.xlsx 2. Y lie 100% A Home Layout Tables Charts SmartArt Formulas Data Review Edit Font 10 Alignment abc Fill Arial A A Wrap Text C Clear B U aste Merge 4 E 2015 A52 x B D NOTE: 2015 BALANCE SHEET INFORMATION SHOULD BE USED ONLY FOR RATIOS Report Date 2018 2017 2016 $ In Thousands Cash & cash equivalents $511,000 $588,000 $558,000 Short-term investments $218,000 $102,000 $100,000 Merchandise inventory.net $12,561,000 $11,393,000 $10,458,000 Other current assets $938,000 $689,000 $884,000 Total current assets $14,228,000 $12,772,000 $12,000,000 Property, less accumulated depreciation $18,432,000 $19,721,000 $19.949,000 Long-term investments $256,000 $408,000 $366,000 Deferred Income taxes - net $294,000 $168,000 $222.000 Goodwill $303,000 $1,307.000 $1,082,000 Other assets $995,000 $915,000 $789,000 4 Total assets $34,508,000 $35,291,000 $34,408,000 $405,000 $307,000 $9,458,000 $391,000 $10,561,000 $19,577,000 $222,000 $241,000 $0 $665,000 $31,266,000 7 Liabilities 3 Short-term borrowings 9 Current maturities of long-term debt 0 Accounts payable 1 Accrued compensation & employee benefits 2 Deferred revenue 3 Other current liabilities 4 Total current liabilities 5 Long-term debl, excluding current maturities 6 Deferred revenue - extended protection plans 27 Other liabilities 28 Total liabilities $722.000 $1,110,000 $8,279,000 $662,000 $1.299,000 $2.425,000 $14,497,000 $14,301,000 5827,000 $1,149,000 $30,864,000 $1,137,000 $204,000 $6,590,000 $747,000 $1,378,000 $1,950,000 $12,096,000 $15,564,000 $803,000 $955,000 $29,418,000 $510,000 $795,000 $6,851.000 $790,000 $1,253,000 $1,975,000 $11,974,000 $14,394.000 $763,000 $843,000 $27,974,000 $43.000 $1,061,000 $5,633,000 $820,000 $1,078,000 $1,857,000 $10,492,000 $11,545,000 $729.000 $846,000 $23,612,000 S401,000 SO $3,452.000 $209,000 $3,644,000 534,508,000 $415,000 $22,000 $5,425,000 $11,000 $5,873,000 $35,291,000 $433.000 SO $6,241,000 -S240,000 $6,434,000 $34,408,000 $455,000 SO $7.593.000 $394.000 $7,654,000 $31,266,000 30 Stockholders' Equity 31 Common stock 32 Capital in excess of par value 33 Retained earnings 34 Accumulated other comprehensive income foss) 35 Total shareholders' equity 36 Total liabilities and stockholders' equity 37 38 Additional Information 39 **Property and Equipment, al cost 40 Land 41 Buildings & building improvements 42 Equipment 43 Construction in progress 44 Total cos! 45 Less: accumulated depreciation 46 $7.190.000 S18.052.000 $10,000,000 $525.000 $35,863,000 $17.431.000 $7,414,000 $18,621,000 $10.475,000 $530,000 $36.940.000 $17.219.000 $7,329.000 $18,147.000 $10.978,000 $484,000 $35.918,000 $16.989.000 $7,086,000 $17.451,000 $10.863,000 $513.000 $35.913,000 $18,336,000 50 5. 55 2.1. Y 100% Home Layout Tables Charts SmartArt Formulas Data Review Edit Font Alignment Fill Arial 10 . . abc- Wrap Text General ste Clear B 1 U Merge - % Al X fx NOTE: 2015 BALANCE SHEET INFORMATION SHOULD BE USED ONLY FOR RA A B D NOTERISTALTARLARINFORMATION SHUDHUDIONYFORRATO Report Date 2018 2017 2016 2015 . $2,216 $1,890 $11 809 $569 $2,538 $2,029 $12,549 $608 $17,724 $21.914 $2,093 $1.235 $42,966 $16,484 $22.191 $2.102 $1,196 $41,973 Sin Millions Current assets: Cash and cash equivalents $1,778 $3,595 Receivables, net $1,936 $1,952 Merchandise inventories $13,925 $12.748 Other current assets $890 $638 Total current assets $18,529 $18,933 Net property and equipment $22,375 $22.075 Goodwil $2,252 $2,275 Other assets $847 $1.246 Total assets $44,003 $44,529 Current Liabilities: Short-term debt $1,339 $1,550 Accounts payable $7.755 $7,244 Accrued salaries and related expenses $1,506 $1,640 Sales taxes payable $656 $520 Deferred revenue $1,782 $1,805 Income taxes payable $11 $54 Current installments of long-term debt $1,058 $1.202 Other accrued expenses $2,611 $2.170 Total current liabilities $16,716 $16,194 Long-term debl, excluding current installments $26.807 $24.267 Deferred Income taxes $491 $440 Other long-term liabilities $1,867 $2.174 8 Total liabilities $45.881 $43,075 Common stock, par value $0.06; authorized: 10.000 shares, issued: 1.78: $89 $80 Paid-in capital $10.678 $10,192 Retained earnings $48,423 $30,935 2 Accumulated other comprehensive loss $772 -$566 3 Treasury stock, at cost, 677 shares of February 3, 2019 and 622 shares $58,198 -$48,198 4 Total stockholders' (deficit) equity -$1,878 $1,454 5 Total liabilities and stockholders' equity $44,003 $44,529 6 7 B 9 Additional Information 0 No a lowance account is created for receivables, Not receivables sequarto gross recevables 1 Z Property and Equipment at cost 33 Land $8,363 8352 14 Buildings 18190 $18.073 5 Fumitur, Futures and Equipment 12450 11506 6 Leasehold Improvements 1705 1637 87 Construction in Progress 820 538 18 Capital Leases 1308 49 Less Accumulated Doprecation and Amortization 20564 19330 SO Net Property and Equpment 22375 22075 $710 $7.000 $1,484 $500 $1,669 $25 $542 $2.195 $14,133 522349 $296 $1,855 $38,633 $88 $9,787 $35,519 $567 $40.194 $4,333 $42.956 $350 $6,565 $1,515 $478 $1,566 $34 $77 $1,941 $12,524 $20,789 $379 $1,965 $35,657 588 59,347 $30.973 -5898 -$33,194 $6,316 $41,973 $8.207 $17.772 11.020 1,519 730 1.169 18,512 21.914 B.149 17.567 10,270 1,481 670 1.020 17.075 22.191 Balance She