Do you need this or any other assignment done for you from scratch?
We have qualified writers to help you.
We assure you a quality paper that is 100% free from plagiarism and AI.
You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)
NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.
NB: All your data is kept safe from the public.
Week #5: Part III. Comprehensive Case Analysis: Computation of Financial Ratios
Week #5: Part III. Comprehensive Case Analysis: Computation of Financial Ratios and Analysis of Financial Performance-Compute financial ratios on the data provided in the case. Conduct an analysis of the company’s financial performance and determine if the company’s strategy is producing satisfactory results. Compare company’s financial performance with their competitors-if possible.
Deliverable: Each student must compute financial ratios on the firm’s profitability, liquidity, leverage, rate of return, and its capital structure. In this week, pairs of students will work collaboratively with one another to work on the financial ratio calculations. Each student will be responsible for reviewing their peers’ financial ratio calculations for accuracy. Students must compute ratios for all of the years presented in the case.
Financial ratio calculations must be placed in an appendix to be added at the end of the report. Use Excel in Microsoft Office to create tables and charts to present your ratio analysis in the case report, along with graphs to track trends in the financial performance of the organization.
Compare the company’s financial performance with competitors in their industry.
Given the financial statement information is somewhat dated in the book, you will be required to retrieve the most current annual reports to analyze your financial ratios. You are required to calculate ratios for 4 consecutive years starting with the most current; therefore, 2022, 2021, 2020, 2019. You are NOT allowed to use Yahoo Finance. You must locate the 10k or annual reports for the company you are analyzing.
Ratio formulas can be found on pages 89-91.
Below are the ratios you should be computing for your respective cases:
Profitability Ratios
-Gross profit margin
-Operating profit margin
-Net profit margin
-Total Return on total Assets
-Return on stockholder’s equity
Liquidity Ratios
-Current ratio
-Working capital
Leverage Ratios
-Debt to assets
-Long-term debt to capital
Activity Ratios
Inventory turnover
Average collection period
An appendix must be completed to show the ratio calculations. After the appendix is completed, a discussion about the ratios and corresponding graphs must be included in the case analysis report. Therefore two items should be submitted in week #5: appendix with ratio calculations (show work) and financial analysis in the case report with graphs to track trends.
Note: Depending on the type of company you are analyzing, you may not be able to compute some ratios. Select other ratios if necessary, but make sure that you discuss the major financial indicators: profitability, liquidity, leverage, and activity.
See the case analysis example: Example Case Study – Final Paper.doc (https://peirce.instructure.com/courses/7405/files/1432391/download?verifier=kwxGi3Th1AX9u5WIGmONePx4z1IfcelXGDhoWA8T&wrap=1)
Note: Analysis and evaluation will be evaluated in week #5. Zeros will be placed in the case analysis categories that are not being graded; identification of issues, stakeholder perspectives, application of external sources, recomme
ndations, and implementation plans. Professional format, writing skills, and APA format will be evaluated in every submission.
Do you need this or any other assignment done for you from scratch?
We have qualified writers to help you.
We assure you a quality paper that is 100% free from plagiarism and AI.
You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)
NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.
NB: All your data is kept safe from the public.
Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount