Ratio Analysis Project 2 – savvyessaywriters.net | Savvy Essay Writers
Ratio Analysis Project 2 – savvyessaywriters.net | Savvy Essay Writers
Savvy Essay Writers Business & Finance Assignment Help
The project is an exercise of fundamental analysis of a firm using ratios. You are expected to calculate a number of ratios for a firm and analyze its financial condition. As the main outcomes of the project, upload 2 files on Canvas:Project Report (word/pdf)andCalculation (excel).Pick a prominent non-financial public firm (EXCEPT WALMART) from any industry. Calculate the following ratios for your chosen firm for 2019 and 2020 (if data for 2021 is available, use 2020 and 2021data)Liquidity Ratios:Current RatioQuick RatioCash RatioSolvency Ratios:Total Debt RatioDebt-equity RatioTimes Interest Earned RatioTurnover Ratios:Inventory TurnoverReceivables TurnoverTotal Asset TurnoverProfitability Ratios:Profit MarginReturn on Assets (ROA)Return on Equity (ROE)Market values Ratios:Price-earnings RatioPrice-sales RatioMarket-to-book RatioInvestigate the firm’s financial condition in 2020 (by comparing with 2019) in terms of itsLiquidity,Solvency,Turnover,Profitability,andMarket Valuesbyanalyzingthe calculated ratios. How the firm’s performancechangedthrough time? Based on your analysis, comment on the future prospect of the firm from aninvestor’sviewpoint.Instructions:Consistent with the university academic integrity policy, your submission MUST be your original work.Show all your works/calculation in an excel file (Question 1). The required financial statements (Income Statement and Balance Sheet) must be presented in excel; calculate all the ratios from those datausing excel formula.Use a word/pdf file for the analysis part (Question 2). There is no page limit for the Project Report. The length of the report depends on the work needed in completing each of the components of the project.For both calculation and analysis, use extensively the content of Chapter 3: Working with Financial Statements.Use reliable web sources for financial statements such as Bloomberg, Yahoo Finance, Edgar etc.The grade for the project depends on the quality of work in terms of accuracy, analyses, completeness, organization, writing, and relevance.