1. Prepare vertical common-size income statements and balance sheets for both companies 2. Prepare horizontal analysis on...
Fantastic news! We've Found the answer you've been seeking!
Question:
1. Prepare vertical common-size income statements and balance sheets for both companies 2. Prepare horizontal analysis on income statements and balance sheets for both companies 3. Ratio analyses 4. Comment on the analytical results of the two companies based on your work in excel5. Conclusive summary on the firms
HOME DEPOT
LOWE
Transcribed Image Text:
1 2 Report Date 3 4 Sin Millions 5 ASSETS 6 Current assets: 7 Cash and cash equivalents 8 Receivables, net. 9 Merchandise inventories 10 Other current assets 11 Total current assets 12 13 Net property and equipment 14 Goodwill 15 Other assets 16 Total assets 17 18 rent Liabilities: 19 Short-term debt A B C D NOTE: 2015 BALANCE SHEET INFORMATION SHOULD BE USED ONLY FOR RATIOS 20 Accounts payable 21 Accrued salaries and related expenses 22 Sales taxes payable 23 Deferred revenue 24 Income taxes payable 25 Current installments of long-term debt 26 Other accrued expenses 27 Total current liabilities 28 Long-term debt, excluding current installments 29 Deferred income taxes 30 Other long-term liabilities 31 Total liabilities 32 Common stock, par value $0.05; authorized: 10,000 shares; issue 33 Paid-in capital 34 Retained earnings 35 Accumulated other comprehensive loss 36 Treasury stock, at cost, 677 shares at February 3, 2019 and 622 37 Total stockholders' (deficit) equity 38 Total liabilities and stockholders' equity 39 40 41 45 **Property and Equipment, at cost: 46 Land 47 Buildings Ready 2018 Balance Sheet Income Statement $1,778 $1,936 $13,925 $890 $18,529 $22,375 $2,252 $847 $44,003 $1,339 $7,755 $1,506 $656 $1,782 $11 $1,056 $2,611 $16,716 $26,807 $491 $1,867 $45,881 $89 $10,578 $46,423 -$772 -$58,196 -$1,878 $44,003 2017 $8,363 18199 10100 $3,595 $1,952 $12,748 $638 $18,933 $22,075 $2,275 $1,246 $44,529 $1,559 $7,244 $1,640 $520 42 Additional Information 43 * No allowance account is created for receivables, i.e. Net receivables is equal to gross receivables 44 $1,805 $54 $1,202 $2,170 $16,194 $24,267 $440 $2,174 $43,075 $89 $10,192 $39,935 -$566 -$48,196 $1,454 $44,529 8352 $18,073 Ascoc 2016 $2,538 $2,029 $12,549 $608 $17,724 $21,914 $2,093 $1,235 $42,966 $710 $7,000 $1,484 $508 $1,669 $25 $542 $2,195 $14,133 $22,349 $296 $1,855 $38,633 $88 $9,787 $35,519 -$867 -$40,194 $4,333 $42,966 $8,207 $17,772 E 2015 $2,216 $1,890 $11,809 $569 $16,484 $22,191 $2,102 $1,196 $41,973 $350 $6,565 $1,515 $476 $1,566 $34 $77 $1,941 $12,524 $20,789 $379 $1,965 $35,657 $88 $9,347 $30,973 -$898 -$33,194 $6,316 $41,973 8,149 17,667 10.070 F Avg. $2,532 $1,952 $12,758 $676 $17,918 $22,139 $2,181 $1,131 $43,368 G 1 2 Report Date 3 4 Sin Millions 5 ASSETS 6 Current assets: 7 Cash and cash equivalents 8 Receivables, net. 9 Merchandise inventories 10 Other current assets 11 Total current assets 12 13 Net property and equipment 14 Goodwill 15 Other assets 16 Total assets 17 18 rent Liabilities: 19 Short-term debt A B C D NOTE: 2015 BALANCE SHEET INFORMATION SHOULD BE USED ONLY FOR RATIOS 20 Accounts payable 21 Accrued salaries and related expenses 22 Sales taxes payable 23 Deferred revenue 24 Income taxes payable 25 Current installments of long-term debt 26 Other accrued expenses 27 Total current liabilities 28 Long-term debt, excluding current installments 29 Deferred income taxes 30 Other long-term liabilities 31 Total liabilities 32 Common stock, par value $0.05; authorized: 10,000 shares; issue 33 Paid-in capital 34 Retained earnings 35 Accumulated other comprehensive loss 36 Treasury stock, at cost, 677 shares at February 3, 2019 and 622 37 Total stockholders' (deficit) equity 38 Total liabilities and stockholders' equity 39 40 41 45 **Property and Equipment, at cost: 46 Land 47 Buildings Ready 2018 Balance Sheet Income Statement $1,778 $1,936 $13,925 $890 $18,529 $22,375 $2,252 $847 $44,003 $1,339 $7,755 $1,506 $656 $1,782 $11 $1,056 $2,611 $16,716 $26,807 $491 $1,867 $45,881 $89 $10,578 $46,423 -$772 -$58,196 -$1,878 $44,003 2017 $8,363 18199 10100 $3,595 $1,952 $12,748 $638 $18,933 $22,075 $2,275 $1,246 $44,529 $1,559 $7,244 $1,640 $520 42 Additional Information 43 * No allowance account is created for receivables, i.e. Net receivables is equal to gross receivables 44 $1,805 $54 $1,202 $2,170 $16,194 $24,267 $440 $2,174 $43,075 $89 $10,192 $39,935 -$566 -$48,196 $1,454 $44,529 8352 $18,073 Ascoc 2016 $2,538 $2,029 $12,549 $608 $17,724 $21,914 $2,093 $1,235 $42,966 $710 $7,000 $1,484 $508 $1,669 $25 $542 $2,195 $14,133 $22,349 $296 $1,855 $38,633 $88 $9,787 $35,519 -$867 -$40,194 $4,333 $42,966 $8,207 $17,772 E 2015 $2,216 $1,890 $11,809 $569 $16,484 $22,191 $2,102 $1,196 $41,973 $350 $6,565 $1,515 $476 $1,566 $34 $77 $1,941 $12,524 $20,789 $379 $1,965 $35,657 $88 $9,347 $30,973 -$898 -$33,194 $6,316 $41,973 8,149 17,667 10.070 F Avg. $2,532 $1,952 $12,758 $676 $17,918 $22,139 $2,181 $1,131 $43,368 G
Expert Answer:
Related Book For
Basic Technical Mathematics
ISBN: 9780137529896
12th Edition
Authors: Allyn J. Washington, Richard Evans
Posted Date:
Students also viewed these finance questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
A. What is Alpha One's NOPAT? Why does NOPAT differ from the earnings after taxes? B. Estimate the effective before-tax cost of the long-term debt. c. Estimate the effective after-tax cost of the...
-
What is the relationship between the NPV of reinvesting cash flows and the change in the price of the stock?
-
If f F(S) is strictly positive definite, quasiconcave, and homogeneous of degree one, then f is superadditive, that is, f (x1 + x2) f (x1) + f(x2) for every x1, x2 S
-
Plaintiffs James and Betty Tonkovich own approximately 850 acres of in Belmont County, Ohio. Plaintiffs belong to a group of landowners known as Belmont Leasing Group, which leases land for oil and...
-
If Professor Laurie Macdonald takes 15 minutes to grade the first exam and follows an 80% learning curve, how long will it take her. a) To grade the 25th exam? b) To grade the first 10 exams?
-
Your company has decided to adopt a NoSQL database management system for storage and processing of big data. You have been asked to investigate alternative NoSQL technologies. (a) Explain the...
-
1. (35 points) Write a program to declare the following array of elements and using one of the sorting methods (Selection or Exchange) sort the elements in descending order. {47, 67, 85, 92, 24, 35,...
-
A pharmacist received a prescription for a brand name drug and substituted a generic drug pursuant to state law. The pharmacist labeled the dispensed generic drug using the brand name drug name....
-
A pharmacist counted cephalosporin capsules on a counting tray that contained powder from penicillin tablets that had been counted previously and dispensed the capsules to a patient who is allergic...
-
Dunkin Brands Group, Inc. operates under the Dunkin Donuts and Baskin-Robbins brands worldwide and has over 13,000 Dunkin Donuts and over 8,100 Baskin-Robbins restaurants. Using financial websites...
-
A hospital pharmacy received ampules of a commonly stocked drug contained in a pink solution. Previously the drug had always been in a clear solution. The pharmacist dispensed the drug for IV...
-
A pharmacist received a bottle of cephalosporin capsules. Unknown to the pharmacist, the capsules also contained small amounts of penicillin. The pharmacist dispensed the capsules to a patient who is...
-
A. Penzema Corporation acquired a property, plant, and equipment through governmental grant. Explain the different ways which Penzema Corporation can apply in valuing such assets. B. The plant asset...
-
What is master production scheduling and how is it done?
-
Find the equation of the hyperbola with foci (1, 2) and (11, 2), and a transverse axis of 8, by use of the definition. Sketch the curve.
-
Show that the given points are vertices of the given geometric figures. (5,4), (7, 1), (10, 5), and (2, 0) are the vertices of a parallelogram.
-
Calculate the indicated areas. All data are accurate to at least two significant digits. The widths of the baseball playing area in Bostons Fenway Park at 45-ft intervals are shown in Fig. 2.110....
-
(a) The longitudinal data set "v4c" is in the vertical format; transform it into the horizontal format. (b) Transform the data set you obtained in part (a) back into the vertical format.
-
Perform some exploratory analysis on the DTS study described above. (a) Compute the mean and standard deviation of the HamD scores for the two treatment groups at each time point. (b) Treat repeated...
-
Plot the mean/SD of HIV knowledge of adolescent girls at baseline and three months post treatment stratified by treatment for the Sexual Health study.
Study smarter with the SolutionInn App