the writer that did this for me of my order #556844674
did it wrong because i got message from my teacher which is
down below
When you complete the Excel Spreadsheet, you do not need to add the zeros to provide the numbers in millions. This can lead to confusion within the numbers. We can assume the numbers provided are in the millions. (Copy the data as it appears within the provided statements.)
This will cause an issue for your final as I will not be presenting the numbers with the additional zeros within the submission links. Note this as you continue to complete the ratio analysis for next week and for the final.
You will want to review the document preview of the Excel Spreadsheet. I have indicated some of the numbers that you did not transpose from the statements correctly. This resulted in an incorrect ratio.
If you would like to update these numbers and resubmit your spreadsheet, please do so. You will also want to update your paper to reflect the correct ratios.
Amy Perry , Feb 20 at 12:22pm
Because most students are in the habit of placing figures from the statements as they appear in the statement, I adjusted the equation in the excel spreadsheet to add the negative numbers so that you would return the correct number. Because you inserted the number as a positive capital expenditure, the equation returned the wrong Free Cash Flow. If you would like to return to your document and spreadsheet and update the Free Cash Flow, please feel free to do so.
Amy Perry , Feb 20 at 12:23pm
therefore i need the writer to fix it for me and do it correctly
the instructions of the assignment is down below
Analyzing the Ratios
You will be working with the Income Statement, Balance Sheet, and Cash Flow Statement of Dell Technologies, Inc.
Working with the attached Excel spreadsheet, you are to determine the profitability, solvency, and liquidity ratios for Dell Technologies, Inc for the years 2022 and 2021.
All the data, as well as a template, are provided to you within the spreadsheet.
NOTE:
The spreadsheet is “color-coded” to help you find the necessary line items within the Financial Statements.
Once you have calculated the ratios, you will submit an APA formatted paper and include the following:
Excel Worksheet: M7 – Ratios for Dell-Profitability-Solvency-Liquidity 2022.xlsxDownload M7 – Ratios for Dell-Profitability-Solvency-Liquidity 2022.xlsx
Introduction
Should include a description of the company you are analyzing and a description of the data you are using.
➖ You are working with data/financial statements supplied by the Securities and Exchange Commission for Dell Technologies for the years 2021 and 2022.
Profitability Ratios
➖ Define the term “Profitability Ratios” and discuss what these ratios tell you about a company.
Gross Profit Percentage
➖Define the term Gross Profit %. (The description of the equation is not a definition.)
Net Profit Percentage
➖Define the term Net Profit %. (The description of the equation is not a definition.)
➖ What makes these two percentages different?
Dell Ratio Data
➖ ➖ ➖ Present the profitability ratios for Dell Technologies, Inc.
Do you think these ratios are good or bad? Why?
Has the ratios improved from 2021 to 2022?
Solvency Ratios
➖ Define the term “Solvency Ratios” and discuss what these ratios tell you about a company.
Debt to Asset Ratio
➖Define the term Debt to Asset Ratio. (The description of the equation is not a definition.)
Dell Ratio Data
➖ ➖ ➖ Present the Solvency ratios for Dell Technologies, Inc.
Do you think these ratios are good or bad? Why?
Has the ratios improved from 2021 to 2022?
Liquidity Ratios
➖ Define the term “Liquidity Ratios” and discuss what these ratios tell you about a company.
Current Ratio
➖Define the term Current Ratio. (The description of the equation is not a definition.)
Quick Ratio
➖Define the term Quick Ratio. (The description of the equation is not a definition.)
➖ What makes these two percentages different?
Dell Ratio Data
➖ ➖ ➖ Present the liquidity ratios for Dell Technologies, Inc.
Do you think these ratios are good or bad? Why?
Has the ratios improved from 2021 to 2022?
Free Cash Flow
➖ Define the term “Free Cash Flow” and discuss what this tell you about a company.
Dell Ratio Data
➖ ➖ ➖ Present the Free Cash Flow data for Dell Technologies, Inc.
Do you think these numbers are good or bad? Why?
Has Free Cash Flow improved from 2021 to 2022?
Conclusion
Overall, do you think the company is in a healthy financial situation? If so, why? If not, why?
M7 – Printable Directions Profitability-Solvency-Liquidity.docx
The paper should be in APA 7.0 Professional format and include at least two references (these DO NOT have to be scholarly, peer-reviewed). There is a template of an APA 7.0 Professional paper in the Introductory Module. The 2 – 5 pages DOES NOT include the title page and reference page.
Report Template: APA 7.0 Professional Template.docx
SUBMIT
M7-Ratio for Dell-Profitability-Solvency-Liquidity Excel File
Report- Written Paper
