An investor has approached you about whether purchasing stock in the company would be a wise investment.
Question:
An investor has approached you about whether purchasing stock in the company would be a wise investment. Using your financial analysis of the company, you will send a letter to the investor summarizing your findings and explaining whether you recommend a stock purchase at this time. Refer to the ?Annual Reports for Approved Companies? located in the course materials. You will use information in the Form 10-K to complete this assignment. Using the correct formulas and a separate tab for each analysis, calculate the following ratios using Excel
You will use information in the Form 10-K for the company you selected in the Topic 1 to complete this assignment. Using the correct formulas and a separate tab for each analysis, calculate the following ratios using Excel:
- Three liquidity ratios for the past 2 years
- Three solvency ratios for the past 2 years
- Three profitability ratios for the past 2 years
In addition, conduct research about a competitor company within the same sector using IBIS World and other topic resources. Complete a competitor analysis that includes a minimum of three ratios and compares your company to a competitor company using these ratios to determine financial performance as well as how the company compares to overall industry averages. Justify your analysis by explaining your findings.
Using your research findings and analysis of company performance in relation to industry competitors, construct a 500-750 word letter making stock purchase recommendations for a potential investor. In the letter, address the following, referencing specific ratios and comparative numbers as appropriate.
- Discuss the overall financial performance of your company in relation to industry averages and a specific competitor. Explain whether the company performed better or worse than the competition using specific numbers and providing an explanation of what the numbers illustrate.
- Recommend whether the potential investor should purchase stock in your company and justify your recommendation based upon your research and analysis of the company ratios and industry competition.
Lowe's Companies, Inc. Consolidated Statements of Earnings (In millions, except per share and percentage data) Current Earnings Net sales Cost of sales Gross margin Expenses: Selling, general and administrative Depreciation and amortization Operating income Interest - net Loss on extinguishment of debt Pre-tax earnings Income tax provision Net earnings Basic earnings per common share Diluted earnings per common share Cash dividends per share $ $ $ $ $ January 31, 2020 Amount % Sales 72,148 100.00% $ 68.20 49,205 22,943 31.80 15,367 1,262 6,314 691 5,623 1,342 4,281 5.49 5.49 2.13 21.30 1.75 8.75 0.96 7.79 1.86 5.93% $ $ $ $ Fiscal Years Ended February 1, 2019 Amount % Sales 71,309 100.00% $ 48,401 67.88 22,908 32.12 17,413 24.41 1,477 2.07 4,018 5.64 624 0.88 - 3,394 1,080 2,314 2.84 2.84 1.85 4.76 1.52 3.24% $ $ $ February 2, 2018 Amount 68,619 46,185 22,434 14,444 1,404 6,586 633 464 5,489 2,042 3,447 4.09 4.09 1.58 % Sales 100.00% 67.31 32.69 21.04 2.05 9.60 0.92 0.68 8.00 2.98 5.02% Lowe's Companies, Inc. Consolidated Statements of Comprehensive Income (In millions, except percentage data) Net earnings Foreign currency translation adjustments - net of tax January 31, 2020 Amount 4,281 94 (21) 73 4,354 Other Other comprehensive income/(loss) Comprehensive income $ See accompanying notes to consolidated financial statements. % Sales 5.93% $ 0.13 (0.03) 0.10 6.03% $ Fiscal Years Ended February 1, 2019 Amount 2,314 (221) 1 (220) 2,094 % Sales 3.24% $ (0.30) (0.30) 2.94% $ February 2, 2018 Amount 3,447 251 251 3,698 % Sales 5.02% 0.37 0.37 5.39% Lowe's Companies, Inc. Consolidated Balance Sheets (In millions, except par value) Assets Current assets: Cash and cash equivalents Short-term investments Merchandise inventory - net Other current assets Total current assets Property, less accumulated depreciation Operating lease right-of-use assets Long-term investments Deferred income taxes - net Goodwill Other assets Total assets Liabilities and shareholders' equity Current liabilities: Short-term borrowings Current maturities of long-term debt Current operating lease liabilities Accounts payable Accrued compensation and employee benefits Deferred revenue Other current liabilities Total current liabilities Long-term debt, excluding current maturities Noncurrent operating lease liabilities Deferred revenue - extended protection plans Other liabilities Total liabilities S $ January 31, 2020 716 $ 160 13,179 1,263 15,318 18,669 3,891 372 216 303 702 39,471 $ 1,941 $ 597 501 7,659 684 1,219 2,581 15,182 16,768 3,943 894 712 37,499 February 1, 2019 511 218 12,561 938 14,228 18,432 256 294 303 995 34,508 722 1,110 8,279 662 1,299 2,425 14,497 14,391 827 1,149 30,864 Commitments and contingencies Shareholders' equity: Preferred stock - $5 par value, none issued Common stock - $0.50 par value; Shares issued and outstanding January 31, 2020 February 1, 2019 Capital in excess of par value Retained earnings Accumulated other comprehensive loss Total shareholders' equity Total liabilities and shareholders' equity See accompanying notes to consolidated financial statements. 42 763 801 S 381 1,727 (136) 1,972 39,471 $ 401 3,452 (209) 3,644 34,508 Lowe's Companies, Inc. Consolidated Statements of Shareholders' Equity (In millions, except per share data) Balance February 3, 2017 Net earnings Other comprehensive income Cash dividends declared, $1.58 per share Share-based payment expense Repurchase of common stock Issuance of common stock under share- based payment plans Balance February 2, 2018 Cumulative effect of accounting change Net earnings Other comprehensive loss Cash dividends declared, $1.85 per share Share-based payment expense Repurchase of common stock Issuance of common stock under share- based payment plans Balance February 1, 2019 Cumulative effect of accounting change Net earnings Other comprehensive income Cash dividends declared, $2.13 per share Share-based payment expense Repurchase of common stock Common Stock Shares 866 S (40) 4 830 S (32) 3 801 S (41) Amount 433 S (20) 2 415 S (16) 2 401 $ (21) Issuance of common stock under share- based payment plans Balance January 31, 2020 See accompanying notes to consolidated financial statements. Capital in Excess of Par Value 3 763 S 381 $ 99 (215) 138 22 S 74 (209) 113 $ - S 98 (214) 116 $ Retained Earnings 6,241 3,447 (1,324) (2,939) 5,425 S 33 2,314 (1,500) (2,820) 3,452 S (263) 4,281 $ (1,653) (4,090) Accumulated Other Comprehensive Income/(Loss) 1,727 S (240) S 251 Total Shareholders' Equity 11 S (220) (209) S 73 (136) S 6,434 3,447 251 (1,324) 99 (3,174) 140 5,873 33 2,314 (220) (1,500) 74 (3,045) 115 3,644 (263) 4,281 73 (1,653) 98 (4,325) 117 1,972 Lowe's Companies, Inc. Consolidated Statements of Cash Flows (In millions) Cash flows from operating activities: Net earnings Adjustments to reconcile net earnings to net cash provided by operating activities: Depreciation and amortization Noncash lease expense Deferred income taxes Loss on property and other assets - net Impairment of goodwill Loss on extinguishment of debt Loss/(gain) on cost method and equity method investments Share-based payment expense Changes in operating assets and liabilities: Merchandise inventory - net Other operating assets Accounts payable Other operating liabilities Net cash provided by operating activities Cash flows from investing activities: Purchases of investments Proceeds from sale/maturity of investments Capital expenditures Proceeds from sale of property and other long-term assets Acquisition of business - net Other - net Net cash used in investing activities Cash flows from financing activities: Net change in commercial paper Net proceeds from issuance of debt. Repayment of long-term debt Fiscal Years Ended January 31, February 1, February 2, 2020 2019 2018 4,281 $ 1,410 468 177 117 12 98 (600) (376) (637) (654) 4,296 (743) 695 (1,484) 163 (1,369) 220 3,972 (1,113) 2,314 S 1,607 (151) 630 952 9 74 (1,289) (110) 1,720 437 6,193 (1,373) 1,393 (1,174) 76 (2) (1,080) (415) (326) 3,447 1,540 53 40 464 (82) 99 (791) 250 (92) 137 5,065 (981) 1,114 (1,123) 45 (509) 13 (1,441) 625 2,968 (2,849) Net cash used in investing activities Cash flows from financing activities: Net change in commercial paper Net proceeds from issuance of debt Repayment of long-term debt Proceeds from issuance of common stock under share-based payment plans Cash dividend payments Repurchase of common stock Other - net Net cash used in financing activities Effect of exchange rate changes on cash Net increase/(decrease) in cash and cash equivalents, including cash classified within current assets held for sale Less: Net increase/(decrease) in cash classified within current assets held for sale Net increase/(decrease) in cash and cash equivalents Cash and cash equivalents, beginning of year Cash and cash equivalents, end of year See accompanying notes to consolidated financial statements. 44 $ (1,369) 220 3,972 (1,113) 118 (1,618) (4,313) (1) (2,735) 1 193 12 205 511 716 $ (1,080) (415) (326) 114 (1,455) (3,037) (5) (5,124) (12) (23) (54) (77) 588 511 S (1,441) 625 2,968 (2,849) 139 (1,288) (3,192) (10) (3,607) 13 30 30 558 588 Lowe's Companies, Inc. Consolidated Statements of Earnings (In millions, except per share and percentage data) Current Earnings Net sales Cost of sales Gross margin Expenses: Selling, general and administrative Depreciation and amortization Operating income Interest - net Loss on extinguishment of debt Pre-tax earnings Income tax provision Net earnings Basic earnings per common share Diluted earnings per common share Cash dividends per share $ $ $ $ $ January 31, 2020 Amount % Sales 72,148 100.00% $ 68.20 49,205 22,943 31.80 15,367 1,262 6,314 691 5,623 1,342 4,281 5.49 5.49 2.13 21.30 1.75 8.75 0.96 7.79 1.86 5.93% $ $ $ $ Fiscal Years Ended February 1, 2019 Amount % Sales 71,309 100.00% $ 48,401 67.88 22,908 32.12 17,413 24.41 1,477 2.07 4,018 5.64 624 0.88 - 3,394 1,080 2,314 2.84 2.84 1.85 4.76 1.52 3.24% $ $ $ February 2, 2018 Amount 68,619 46,185 22,434 14,444 1,404 6,586 633 464 5,489 2,042 3,447 4.09 4.09 1.58 % Sales 100.00% 67.31 32.69 21.04 2.05 9.60 0.92 0.68 8.00 2.98 5.02% Lowe's Companies, Inc. Consolidated Statements of Comprehensive Income (In millions, except percentage data) Net earnings Foreign currency translation adjustments - net of tax January 31, 2020 Amount 4,281 94 (21) 73 4,354 Other Other comprehensive income/(loss) Comprehensive income $ See accompanying notes to consolidated financial statements. % Sales 5.93% $ 0.13 (0.03) 0.10 6.03% $ Fiscal Years Ended February 1, 2019 Amount 2,314 (221) 1 (220) 2,094 % Sales 3.24% $ (0.30) (0.30) 2.94% $ February 2, 2018 Amount 3,447 251 251 3,698 % Sales 5.02% 0.37 0.37 5.39% Lowe's Companies, Inc. Consolidated Balance Sheets (In millions, except par value) Assets Current assets: Cash and cash equivalents Short-term investments Merchandise inventory - net Other current assets Total current assets Property, less accumulated depreciation Operating lease right-of-use assets Long-term investments Deferred income taxes - net Goodwill Other assets Total assets Liabilities and shareholders' equity Current liabilities: Short-term borrowings Current maturities of long-term debt Current operating lease liabilities Accounts payable Accrued compensation and employee benefits Deferred revenue Other current liabilities Total current liabilities Long-term debt, excluding current maturities Noncurrent operating lease liabilities Deferred revenue - extended protection plans Other liabilities Total liabilities S $ January 31, 2020 716 $ 160 13,179 1,263 15,318 18,669 3,891 372 216 303 702 39,471 $ 1,941 $ 597 501 7,659 684 1,219 2,581 15,182 16,768 3,943 894 712 37,499 February 1, 2019 511 218 12,561 938 14,228 18,432 256 294 303 995 34,508 722 1,110 8,279 662 1,299 2,425 14,497 14,391 827 1,149 30,864 Commitments and contingencies Shareholders' equity: Preferred stock - $5 par value, none issued Common stock - $0.50 par value; Shares issued and outstanding January 31, 2020 February 1, 2019 Capital in excess of par value Retained earnings Accumulated other comprehensive loss Total shareholders' equity Total liabilities and shareholders' equity See accompanying notes to consolidated financial statements. 42 763 801 S 381 1,727 (136) 1,972 39,471 $ 401 3,452 (209) 3,644 34,508 Lowe's Companies, Inc. Consolidated Statements of Shareholders' Equity (In millions, except per share data) Balance February 3, 2017 Net earnings Other comprehensive income Cash dividends declared, $1.58 per share Share-based payment expense Repurchase of common stock Issuance of common stock under share- based payment plans Balance February 2, 2018 Cumulative effect of accounting change Net earnings Other comprehensive loss Cash dividends declared, $1.85 per share Share-based payment expense Repurchase of common stock Issuance of common stock under share- based payment plans Balance February 1, 2019 Cumulative effect of accounting change Net earnings Other comprehensive income Cash dividends declared, $2.13 per share Share-based payment expense Repurchase of common stock Common Stock Shares 866 S (40) 4 830 S (32) 3 801 S (41) Amount 433 S (20) 2 415 S (16) 2 401 $ (21) Issuance of common stock under share- based payment plans Balance January 31, 2020 See accompanying notes to consolidated financial statements. Capital in Excess of Par Value 3 763 S 381 $ 99 (215) 138 22 S 74 (209) 113 $ - S 98 (214) 116 $ Retained Earnings 6,241 3,447 (1,324) (2,939) 5,425 S 33 2,314 (1,500) (2,820) 3,452 S (263) 4,281 $ (1,653) (4,090) Accumulated Other Comprehensive Income/(Loss) 1,727 S (240) S 251 Total Shareholders' Equity 11 S (220) (209) S 73 (136) S 6,434 3,447 251 (1,324) 99 (3,174) 140 5,873 33 2,314 (220) (1,500) 74 (3,045) 115 3,644 (263) 4,281 73 (1,653) 98 (4,325) 117 1,972 Lowe's Companies, Inc. Consolidated Statements of Cash Flows (In millions) Cash flows from operating activities: Net earnings Adjustments to reconcile net earnings to net cash provided by operating activities: Depreciation and amortization Noncash lease expense Deferred income taxes Loss on property and other assets - net Impairment of goodwill Loss on extinguishment of debt Loss/(gain) on cost method and equity method investments Share-based payment expense Changes in operating assets and liabilities: Merchandise inventory - net Other operating assets Accounts payable Other operating liabilities Net cash provided by operating activities Cash flows from investing activities: Purchases of investments Proceeds from sale/maturity of investments Capital expenditures Proceeds from sale of property and other long-term assets Acquisition of business - net Other - net Net cash used in investing activities Cash flows from financing activities: Net change in commercial paper Net proceeds from issuance of debt. Repayment of long-term debt Fiscal Years Ended January 31, February 1, February 2, 2020 2019 2018 4,281 $ 1,410 468 177 117 12 98 (600) (376) (637) (654) 4,296 (743) 695 (1,484) 163 (1,369) 220 3,972 (1,113) 2,314 S 1,607 (151) 630 952 9 74 (1,289) (110) 1,720 437 6,193 (1,373) 1,393 (1,174) 76 (2) (1,080) (415) (326) 3,447 1,540 53 40 464 (82) 99 (791) 250 (92) 137 5,065 (981) 1,114 (1,123) 45 (509) 13 (1,441) 625 2,968 (2,849) Net cash used in investing activities Cash flows from financing activities: Net change in commercial paper Net proceeds from issuance of debt Repayment of long-term debt Proceeds from issuance of common stock under share-based payment plans Cash dividend payments Repurchase of common stock Other - net Net cash used in financing activities Effect of exchange rate changes on cash Net increase/(decrease) in cash and cash equivalents, including cash classified within current assets held for sale Less: Net increase/(decrease) in cash classified within current assets held for sale Net increase/(decrease) in cash and cash equivalents Cash and cash equivalents, beginning of year Cash and cash equivalents, end of year See accompanying notes to consolidated financial statements. 44 $ (1,369) 220 3,972 (1,113) 118 (1,618) (4,313) (1) (2,735) 1 193 12 205 511 716 $ (1,080) (415) (326) 114 (1,455) (3,037) (5) (5,124) (12) (23) (54) (77) 588 511 S (1,441) 625 2,968 (2,849) 139 (1,288) (3,192) (10) (3,607) 13 30 30 558 588
Expert Answer:
Figin mlns 31Dec16 30Dec17 Dec 292018 Analysis 1Current assets 35508 29500 28787 2Current liabilities 20302 17421 16626 Liquidity ratios 3Current asse... View the full answer
Cornerstones of Managerial Accounting
ISBN: 978-1305103962
6th edition
Authors: Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Students also viewed these accounting questions
-
You are a lender. A company has approached you about a loan. The company has offered to maintain a minimum current ratio and a maximum debt-to-equity ratio as well as to not pay dividends over the...
-
One of your corporate clients has approached you about whether or not its employees are required to include certain benefits provided by the corporation in their income. In particular, the...
-
Analyse of the financial ratios of Apple Inc. Each team will be required to examine Apples most recently published financial statements and calculate the ratios identified at the back of this...
-
4. In cells B4:B15, type a yearly salary for each staff member. Format these values as Currency with no decimal places. 5. Calculate the new salary with a 10% increase in column C. 6. Calculate the...
-
For what reason might an exporter use standard international trade documentation (letter of credit, draft, order bill of lading) on an intrafirm export to its parent or sister subsidiary?
-
Find the volume of the region bounded above by the sphere x 2 + y 2 + z 2 = 2 and below by the paraboloid z = x 2 + y 2 .
-
2. ETHICS Nineteen-year-old David Lee Nagel viciously murdered his grandparents, stabbing them repeatedly and slitting their throats, all because they denied him use of the family car. He was tried...
-
(Entry for Retirement of Bond; Bond Issue Costs) On January 2, 2005, Prebish Corporation issued $1,500,000 of 10% bonds at 97 due December 31, 2014. Legal and other costs of $24,000 were incurred in...
-
I need help 2,3. The following data relates to Patterson Company's budgeted amounts for next year. Budgeted Data: Department 1 Department 2 Overhead costs $ 124,000 $ 65.000 Direct labor hours...
-
Company A is a global company based in the United States that operates in the financial industry. Company A serves its customers with financial products, such as checking accounts, bank cards, and...
-
HPC3O1- Parenting Child Growth and Development Assignment Do a plan of two full days with a 3 year old. You must do: 1. A schedule with timings for two full days 2. A description of everything that...
-
Consider a simple financial market for a closed economy with government, such as might be crudely representative of the world as a whole. a) Construct a diagram to represent this market and note and...
-
You have an account with annual interest rate 6% compounded monthly. You will deposit $120 at the end of each month for 10 years into this account, leave the account untouched for 5 years, and then...
-
Assume that you have just started business as an actuarial consultant and are faced with two choices in terms of long term, full-time contracts. (If you take one, you cannot take the other). a. The...
-
A company issues zero coupon bonds which mature in 30 years. These bonds can be bought for $99.38 and then pay no annual interest payments, only $1000 at maturity. What is the annual percentage cost...
-
A group of thirty-nine people is selected at random. What is the probability that at least two of them will have the same birthday? (Round your answer to four decimal places.)
-
1) Scrap frequently has a zero sales value. a. TRUE b. FALSE 2) Distinguish among different types of saleable products, scrap and toxic waste. 3) Joint costs are incurred beyond the split off point...
-
Identify the Critical Infrastructure Physical Protection System Plan.
-
Blaylock Company provided the following partial comparative balance sheets and the income statement for 2016. Blaylock Company Income Statement For the Year Ended December 31, 2016 Revenues...
-
Aldovar Company produces a variety of chemicals. One division makes reagents for laboratories. The division's projected income statement for the coming year is: Sales (203,000 units @ $70)...
-
Gorman Nurseries Inc. grows poinsettias and fruit trees in a green house/nursery operation. The following information was provided for the coming year. A sales commission of 4% of sales is paid for...
-
Complete the truth table to determine the truth value of the proposition in the last column. 14 (b~d) (bvd) b~ Ad b- byd b d
-
\(\sim p ightarrow q \leftrightarrow r\) For each of the following compound logical statement, apply the proper dominance of connectives by adding parentheses to indicate the order in which the...
-
\(\sim(p \wedge q) \leftrightarrow \sim p \vee \sim q\) For each of the following compound logical statement, apply the proper dominance of connectives by adding parentheses to indicate the order in...
Study smarter with the SolutionInn App