You are a financial analyst. Based on your analysis of Macys financial statements, provide a report to
Question:
You are a financial analyst. Based on your analysis of Macy’s financial statements, provide a report to guide investors whether Macy’s is a buy (keep) or sell stock. Your report should include the following
a. An interpretation of trends illustrated by supportive ratios, horizontal and vertical analysis and focus on the main ratios that “tell the story”. (a minimum of one page-not to exceed two pages, single space, 12 font size).
i. horizontal and vertical analysis
ii. Liquidity analysis
iii. Profitability analysis
iv. Solvency analysis
b. Your informed recommendation (buy or sell) about Macy’s with justifications. What is your general impression about Macy’s ? Support your conclusion (1- paragraph)
Macy's Inc (NYS: M) As Reported Annual Balance Sheet Report Date Cash & cash equivalents Receivables Merchandise inventories Prepaid expenses & other current asset Total current accet Land Buildings on owned land Buildings on leased land & leasehold improve Fixtures & equipment Leased properties under capitalized leases Property & equipment, at cost Less accumulated depreciation & amortization Property & equipment, not Goodw Other intangible assets, not other assets Total accets Senior debentures Senior notes Capital lease & current portion of other long-term obligat Short-tem debt Merchandise accounts payable Accounts payable Gift cards & customer award certificates Accrued wages & vacation Cument portion of post employment & postretirement be Taxes other than income taxes Severance & relocation Lease related liabilities Cument portion of workers' compensation & general labi Restructuring accruals, Induding severance Allowance for future sales returns Accrued interest Deferred real estate gains Other accounts payable & accrued liablites Accounts payable & accrued labiles Income taxes Deferred Income taxes Total current lab Senior notes Senior debentures Amortizing debentures Un amortized debt issue cost Un amortized debt discount Promlum on acquired debt Capital lease & other long-term obligations Long-term debt Deferred Income taxes Other Tables Total Liabilities Common stock Additional paidin capital Accumulated equity (det) Treasury stock Accumulated other comprehensive Income (los) Total Macy's, Inc. shareholders equity (deficit) Noncontrolling interest Total shareholdere equity Y3 1,455,000 363,000 5,178,000 22.000 22,000 1.590,000 735,000 967,000 229,000 194,000 157,000 189,000 108.000 448,000 7,444,000 1,494,000 4.106.000 1,444.000 1,545,000 1,672,000 4,204,000 4,541,000 4,910,000 34,000 34,000 34,000 11,282,000 11,873,000 12,935.000 4.610.000 4,856.000 5,319,000 6,672.000 7,017.000 7.616.000 3,897,000 3,897,000 3,897,000 488.000 880,000 514.000 897,000 498.000 813.000 18,861,000 20,678,000 300.000 18,381,000 93,000 90,000 70,000 65,000 270,000 3,167,000 296.000 Y2 1,297,000 522.000 5,861,000 1,122,000 1,662.000 1,109,000 558,000 5,399,000 5,506,000 408,000 479,000 7,828,000 7,862,000 1,541,000 1,629,000 4.212,000 4,690,000 3.000 676,000 7.174.000 1.456.000 9,000 309.000 1,423,000 754,000 970,000 215,000 208.000 166,000 166,000 174,000 119,000 - 96,000 74.000 340,000 281.000 3,563,000 352,000 Y1 59.000 577.000 6,000 642,000 1.526.000 814,000 920.000 (896,000) 4,323,000 (724,000) 5,673,000 (12.000) (1,000) 6,881,000 4,322,000 153,000 257,000 184,000 123,000 165.000 127,000 6,076,000 6,847,000 6,728,000 2,021,000 4,000,000 4,000,000 3,769,000 2,437,000 2,845,000 16.000 22.000 26,000 (25.000) (29,000) (32.000) (13,000) (16,000) (16,000) 67,000 121,000 143,000 26,000 27.000 29,000 88.000 112,000 6,562,000 6,995.000 1.443.000 1,477,000 1,877,000 2.123.000 13,720,000 16,620,000 16,323,000 390,000 3,333,000 227,000 .. 3,000 3,000 617,000 6,088,000 6.334,000 621,000 1,489,000 1,665,000 (1.043,000) 4,250,000 3,000 4,263,000 Horizontal Ana y cic (Y3/Y2) 12.2% -30.5% 4.1% 9.8% -2.4% 3.0% -2.5% 6.5% -7.4% 0.0% 5.0% 4.1% 4.9% 0.0% -2.0% 8.2% -2.4% #VALUE! #VALUE! 144.4% -92.9% 11.7% -2.5% -0.3% 6.5% 6.7% -5.4% #VALUE! 8.6% -9.2% #VALUE! 4.3% -5.4% 80.9% -3.9% -11.1% -15.9% #VALUE! -10.1% 49.5% 54.7% -27.3% -13.8% -18.8% 44.6% 3.7% -10.7% -22.2% -11.5% -11.6% 0.0% 9.6% 17.8% -2.2% -19.2% 31.2% 1100.0% 31.0% 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 Vertical Analysis YS 7.5% 1.9% 26.7% 2.3% 38.4% 7.7% 21.2% 7.5% 21.7% 0.2% 58.2% 23.8% 34.4% 20.1% 2.5% 4.5% 100.0% 0.1% 0.1% 8.2% 3.8% 5.0% 1.2% 1.0% 0.8% #VALUE! 1.0% 0.6% 0.5% 0.5% 0.4% 0.3% 1.4% 16.3% 1.5% #VALUE! 26.2% 10.4% 19.4% 0.1% -0.1% -0.1% 0.3% 0.1% 30.2% 5.8% 8.6% 70.8% 0.0% 3.5% 37.0% 7.5% -3.7% 29.3% -0.1% 29.2% 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 55 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 텦 Vertical Analysis Y2 6.5% 2.6% 27.2% 2.1% 38,4% 7.8% 21.2% 7.8% 22.9% 0.2% 50.8% 24.5% 35.3% 19.6% 2.5% 4.1% 100.0% 1.5% #VALUE! 0.0% 1.6% 7.2% 3.8% 4.9% 1.1% 1.0% 0.8% 0.8% 0.9% 0.6% #VALUE! 0.5% 0.4% 1.7% 1.4% 17.9% 1.8% #VALUE! 28.4% 20.2% 12.3% 0.1% -0.1% -0.1% 0.6% 0.1% 33,1% 7.3% 9.5% 78.2% 0.0% 3.1% 30.7% 7.5% 4.5% 21.8% 0.0% 21.8% 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 5 6 ને તે છે કે કોઈ તેને 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 6.6 6.6 Macy's Inc (NYS: M) As Reported Annual Balance Sheet Report Date Cash & cash equivalents Receivables Merchandise inventories Prepaid expenses & other current asset Total current accet Land Buildings on owned land Buildings on leased land & leasehold improve Fixtures & equipment Leased properties under capitalized leases Property & equipment, at cost Less accumulated depreciation & amortization Property & equipment, not Goodw Other intangible assets, not other assets Total accets Senior debentures Senior notes Capital lease & current portion of other long-term obligat Short-tem debt Merchandise accounts payable Accounts payable Gift cards & customer award certificates Accrued wages & vacation Cument portion of post employment & postretirement be Taxes other than income taxes Severance & relocation Lease related liabilities Cument portion of workers' compensation & general labi Restructuring accruals, Induding severance Allowance for future sales returns Accrued interest Deferred real estate gains Other accounts payable & accrued liablites Accounts payable & accrued labiles Income taxes Deferred Income taxes Total current lab Senior notes Senior debentures Amortizing debentures Un amortized debt issue cost Un amortized debt discount Promlum on acquired debt Capital lease & other long-term obligations Long-term debt Deferred Income taxes Other Tables Total Liabilities Common stock Additional paidin capital Accumulated equity (det) Treasury stock Accumulated other comprehensive Income (los) Total Macy's, Inc. shareholders equity (deficit) Noncontrolling interest Total shareholdere equity Y3 1,455,000 363,000 5,178,000 22.000 22,000 1.590,000 735,000 967,000 229,000 194,000 157,000 189,000 108.000 448,000 7,444,000 1,494,000 4.106.000 1,444.000 1,545,000 1,672,000 4,204,000 4,541,000 4,910,000 34,000 34,000 34,000 11,282,000 11,873,000 12,935.000 4.610.000 4,856.000 5,319,000 6,672.000 7,017.000 7.616.000 3,897,000 3,897,000 3,897,000 488.000 880,000 514.000 897,000 498.000 813.000 18,861,000 20,678,000 300.000 18,381,000 93,000 90,000 70,000 65,000 270,000 3,167,000 296.000 Y2 1,297,000 522.000 5,861,000 1,122,000 1,662.000 1,109,000 558,000 5,399,000 5,506,000 408,000 479,000 7,828,000 7,862,000 1,541,000 1,629,000 4.212,000 4,690,000 3.000 676,000 7.174.000 1.456.000 9,000 309.000 1,423,000 754,000 970,000 215,000 208.000 166,000 166,000 174,000 119,000 - 96,000 74.000 340,000 281.000 3,563,000 352,000 Y1 59.000 577.000 6,000 642,000 1.526.000 814,000 920.000 (896,000) 4,323,000 (724,000) 5,673,000 (12.000) (1,000) 6,881,000 4,322,000 153,000 257,000 184,000 123,000 165.000 127,000 6,076,000 6,847,000 6,728,000 2,021,000 4,000,000 4,000,000 3,769,000 2,437,000 2,845,000 16.000 22.000 26,000 (25.000) (29,000) (32.000) (13,000) (16,000) (16,000) 67,000 121,000 143,000 26,000 27.000 29,000 88.000 112,000 6,562,000 6,995.000 1.443.000 1,477,000 1,877,000 2.123.000 13,720,000 16,620,000 16,323,000 390,000 3,333,000 227,000 .. 3,000 3,000 617,000 6,088,000 6.334,000 621,000 1,489,000 1,665,000 (1.043,000) 4,250,000 3,000 4,263,000 Horizontal Ana y cic (Y3/Y2) 12.2% -30.5% 4.1% 9.8% -2.4% 3.0% -2.5% 6.5% -7.4% 0.0% 5.0% 4.1% 4.9% 0.0% -2.0% 8.2% -2.4% #VALUE! #VALUE! 144.4% -92.9% 11.7% -2.5% -0.3% 6.5% 6.7% -5.4% #VALUE! 8.6% -9.2% #VALUE! 4.3% -5.4% 80.9% -3.9% -11.1% -15.9% #VALUE! -10.1% 49.5% 54.7% -27.3% -13.8% -18.8% 44.6% 3.7% -10.7% -22.2% -11.5% -11.6% 0.0% 9.6% 17.8% -2.2% -19.2% 31.2% 1100.0% 31.0% 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 Vertical Analysis YS 7.5% 1.9% 26.7% 2.3% 38.4% 7.7% 21.2% 7.5% 21.7% 0.2% 58.2% 23.8% 34.4% 20.1% 2.5% 4.5% 100.0% 0.1% 0.1% 8.2% 3.8% 5.0% 1.2% 1.0% 0.8% #VALUE! 1.0% 0.6% 0.5% 0.5% 0.4% 0.3% 1.4% 16.3% 1.5% #VALUE! 26.2% 10.4% 19.4% 0.1% -0.1% -0.1% 0.3% 0.1% 30.2% 5.8% 8.6% 70.8% 0.0% 3.5% 37.0% 7.5% -3.7% 29.3% -0.1% 29.2% 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 55 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 텦 Vertical Analysis Y2 6.5% 2.6% 27.2% 2.1% 38,4% 7.8% 21.2% 7.8% 22.9% 0.2% 50.8% 24.5% 35.3% 19.6% 2.5% 4.1% 100.0% 1.5% #VALUE! 0.0% 1.6% 7.2% 3.8% 4.9% 1.1% 1.0% 0.8% 0.8% 0.9% 0.6% #VALUE! 0.5% 0.4% 1.7% 1.4% 17.9% 1.8% #VALUE! 28.4% 20.2% 12.3% 0.1% -0.1% -0.1% 0.6% 0.1% 33,1% 7.3% 9.5% 78.2% 0.0% 3.1% 30.7% 7.5% 4.5% 21.8% 0.0% 21.8% 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 5 6 ને તે છે કે કોઈ તેને 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 6.6 6.6
Expert Answer:
Based on my analysis of Macys financial statements over the past two years I recommend selling Macys ... View the full answer
Students also viewed these finance questions
-
Prepare a simplified balance sheet and income statement projecting the growth of Walgreens-Boots Alliance, Inc. for the fiscal year ending 8/31/2022. Assume no new issues of equity. Projections can...
-
Produce the following calculations: Gross & Net Margin, EBIT & AT Inventory Turnover ROA, EBIT & AT ROE, AT Current Ratio Debt/Equity Receivables turnover Fixed asset turnover Total asset...
-
Presented below are excerpts from Note 1 to Starbucks' September 30, 2012, consolidated financial statements in which Starbucks describes accounting policy for long-lived assets. a. Leasehold...
-
Figure 11-31 shows a cooling curve for a Pb-Sn alloy. Determine (a) The pouring temperature; (b) The superheat; (c) The liquidus temperature; (d) The eutectic temperature; (e) The freezing range; (f)...
-
Find the centroid of the region bounded by the given curves. 27. y = V. y = x 28. y = x + 2. y = x? 29. y = sin x, y = cos x, x= 0. x= 7/4 30. y = x, y= 0, y 1/x, x 2 31. x = 5 - y. x= 0
-
In designing the communication message to be used in external recruiting, what kinds of information should be included?
-
The characteristics of services affect the development of marketing mixes for services. Choose a specific service and explain how each marketing mix element could be affected by these service...
-
Satu Company, a merchandiser, recently completed its 2015 operations. For the year, (1) all sales are credit sales, (2) all credits to Accounts Receivable reflect cash receipts from customers, (3)...
-
Book Hint Print Exercise 10-4 (Algo) Straight-Line: Amortization of bond discount LO P2 Tano Company issues bonds with a par value of $90,000 on January 1, 2021. The bonds' annual contract rate is...
-
Ellipses Corp is a small business that operates in Herndon, VA. The company is located at10 Period Lane, Herndon, VA 20170. Its federal Employer Identification Number is 77-7777777, and its...
-
2 00:39:50 Kramer Corp. began the period with 4,400 units in process that were 100% complete for materials and 70% complete for conversion, and ended the period with 21,300 units completed and 6,600...
-
Why should each page in a batch report have a page heading and a page number? What is the purpose of printing an end-of-job marker on the last page of a batch report?
-
Why is there often a need for continuous monitoring of advanced information systems? How do concurrent auditing techniques facilitate continuous monitoring of advanced information systems?
-
Why has the disappearance of paper-based audit trails motivated the implementation and use of concurrent auditing techniques?
-
Why are concurrent auditing techniques useful in monitoring the authenticity, accuracy, and completeness of transaction processing in distributed application systems?
-
How can auditors use concurrent auditing techniques to monitor application systems that are developed, implemented, operated, and maintained on behalf of an organization by an outsourcing vendor?
-
ASSESSMENT 2 - Part 1 - DRAFT This part of the assessment requires you to use the Gibbs Reflective Cycle (available in the learning modules) as it's an excellent model to help you work your way...
-
Evaluate how many lines there are in a true rotational spectrum of CO molecules whose natural vibration frequency is w = 4.09 1014 s1 and moment of inertia I = 1.44 1039 g cm2.
-
The Budwell & Son Oil Company is looking at two drilling proposals. One project lasts for three years, costs $20 million to start, pays back quickly, and has an NPV of $15 million. The other project...
-
Watson Waterbed Works Inc. has an EBIT of $2.75 million, can borrow at 15% interest, and pays combined state and federal income taxes of 40%. It currently has no debt and is capitalized by equity of...
-
Inflation is expected to be 5% next year and a steady 7% each year thereafter. Maturity risk premiums are zero for one-year debt but have an increasing value for longer debt. One-year government debt...
-
Swissie Triangular Arbitrage. The following exchange rates are available to you. (You can buy or sell at the stated rates.) Assume you have an initial SF12,000,000. Can you make a profit via...
-
Aussie Dollar Forward. Use the following spot and forward bid-ask rates for the U.S. dollar/Australian dollar (US$ = A$1.00) exchange rate from December 10, 2010, to answer the following questions:...
-
Transatlantic Arbitrage. A corporate treasury working out of Vienna with operations in New York simultaneously calls Citibank in New York City and Barclays in London. The banks give the following...
Study smarter with the SolutionInn App