Question

In: Accounting

Risk Assesment Project 2.Fill in industry comparisons for Macy in the Excel Spreadsheet. Compute missing financial...

Risk Assesment Project 2.Fill in industry comparisons for Macy in the Excel Spreadsheet. Compute missing financial

statement ratios for Macy and describe Macy’s profitability, efficiency, liquidity.

Solutions

Expert Solution

Profitability.
In case of profitability Macy's Inc had outperformed the industrial standards. When the industrial average ROE is just 10.10%, the ROE of Macy's is 18.30%, which indicates that investors are getting high return compared to industry.
Efficiency.
The company is less efficient with regards to asset turnover and receivable turnover. It is highly disappointing that Macy's efficiency is almost half the industrial standard.
Liquidity.
Though Current ratio seems to be lower when compared with industry, the quick ratio and cash ratio are higher, which depicts that the company is maintain sufficient liquidity with them.

ekkarill92 answered 3 years ago
Next > < Previous

Related Solutions

1. Understand how to use EXCEL Spreadsheet (a)  Develop proforma Income Statement Using Excel Spreadsheet (b)  Compute  Net Project...
1. Understand how to use EXCEL Spreadsheet (a)  Develop proforma Income Statement Using Excel Spreadsheet (b)  Compute  Net Project Cashflows, NPV,  and IRR (c) Develop problem-solving and  critical thinking skills and make long-term investment decisions 1) Life Period of the Equipment = 4 years 8) Sales for first year (1) $200,000 2) New equipment cost $(200,000) 9) Sales increase per year 5% 3) Equipment ship & install cost $(35,000) 10) Operating cost (60% of Sales) $(120,000) 4) Related start up cost $(5,000)     (as a percent...
1. Learning Objectives (a) Develop proforma Project Income Statement Using Excel Spreadsheet (b) Compute Net Project...
1. Learning Objectives (a) Develop proforma Project Income Statement Using Excel Spreadsheet (b) Compute Net Project Cash flows, NPV, IRR and PayBack Period (c) Develop Problem-Solving and Critical Thinking Skills 1) Life Period of the Equipment = 4 years 8) Sales for first year (1) 200000 2) New equipment cost -200000 9) Sales increase per year 0.05 3) Equipment ship & install cost -35000 10) Operating cost: -120000 4) Related start up cost -5000 (60 Percent of Sales) -0.6 5)...
(a) Develop proforma Project Income Statement Using Excel Spreadsheet (b) Compute Net Project Cash flows, NPV,...
(a) Develop proforma Project Income Statement Using Excel Spreadsheet (b) Compute Net Project Cash flows, NPV, IRR and PayBack Period (c) Develop Problem-Solving and Critical Thinking Skills 1) Life Period of the Equipment = 4 years 8) Sales for first year (1) $   200,000 2) New equipment cost $ (200,000) 9) Sales increase per year 5% 3) Equipment ship & install cost $     (35,000) 10) Operating cost: $ (120,000) 4) Related start up cost $       (5,000)     (60 Percent of...
Project Household Budget Document should be a Completed Excel spreadsheet. Instructions: Utilizing an excel spreadsheet create...
Project Household Budget Document should be a Completed Excel spreadsheet. Instructions: Utilizing an excel spreadsheet create a household budget showing 2 columns: 1) Monthly Budget and an 2)Annualized Budget. To help you with this endeavor, there are numerous personal financial planning or budgeting tools available on the internet, many of them are free. You may either create a fictitious profile or use your own personal information. If you choose to use your personal data on one of the website budget...
(a) Develop proforma Income Statement Using Excel Spreadsheet (b) Compute Net Project Cashflows, NPV, and IRR...
(a) Develop proforma Income Statement Using Excel Spreadsheet (b) Compute Net Project Cashflows, NPV, and IRR 1) Life Period of the Equipment = 4 years 8) Sales for first year (1) $200,000 2) New equipment cost $(200,000) 9) Sales increase per year 5% 3) Equipment ship & install cost $(35,000) 10) Operating cost (60% of Sales) $(120,000) 4) Related start up cost $(5,000)     (as a percent of sales in Year 1) -60% 5) Inventory increase $25,000 11) Depreciation Use...
Process Cost Excel Project Create a new Excel spreadsheet and name it “Last name_PC”. You project...
Process Cost Excel Project Create a new Excel spreadsheet and name it “Last name_PC”. You project is to create a model for a production cost report using the weighted average method for the month of May.   Following good Excel design techniques, you should have an input area in which you put the department information for the month, and an output area that calculates the production cost report. As always, you should have only formulas or references in your output area....
Process Cost Excel Project Create a new Excel spreadsheet and name it “Last name_PC”. You project...
Process Cost Excel Project Create a new Excel spreadsheet and name it “Last name_PC”. You project is to create a model for a production cost report using the weighted average method for the month of May.   Following good Excel design techniques, you should have an input area in which you put the department information for the month, and an output area that calculates the production cost report. As always, you should have only formulas or references in your output area....
Process Cost Excel Project Create a new Excel spreadsheet and name it “Last name_PC”. You project...
Process Cost Excel Project Create a new Excel spreadsheet and name it “Last name_PC”. You project is to create a model for a production cost report using the weighted average method for the month of May.   Following good Excel design techniques, you should have an input area in which you put the department information for the month, and an output area that calculates the production cost report. As always, you should have only formulas or references in your output area....
Use a financial calculator or an Excel spreadsheet to estimate the IRR for each of the...
Use a financial calculator or an Excel spreadsheet to estimate the IRR for each of the following investments. Investment A B Initial Investment $                8,500.00 $      9,500.00 End of Year Income 1 $                2,500.00 $      2,000.00 2 $                2,500.00 $      2,500.00 3 $                2,500.00 $      3,000.00 4 $                2,500.00 $      3,500.00 5 $                2,500.00 $      4,000.00
Use a financial calculator or an Excel spreadsheet to estimate the IRR for each of the...
Use a financial calculator or an Excel spreadsheet to estimate the IRR for each of the following​ investments: The Yield for Investment A: The Yield for Investment B: A B Initial Investment 6,400 9,535 Year 1 $1,822.65 $2,200 Year 2 $1,822.65 $2,500 Year 3 $1,822.65 $3,100 Year 4 $1,822.65 $3,600 Year 5 $1,822.65 $4,100
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT