Gross Profit Percentage - Accounts Receivable Turnover - Report Writing - Accounting Assignment Help

Assignment Task:

Assignment brief
You have been hired by an investment firm, Happy Returns as a financial analyst and your manager has asked you to analyse the financial statements of the top seven U.S. technology companies. Your support person has downloaded the financial statements of the companies and extracted and summarised the data in a spreadsheet. In the spreadsheet there are the following sheets:

1. 2018 financial data (all seven companies)
2. 2019 financial data (all seven companies)
3. Apple (detailed income statements and balance sheets)
4. Alphabet (detailed income statements and balance sheets)
5. IBM (detailed income statements and balance sheets)
6. Intel (detailed income statements and balance sheets)
7. Microsoft (detailed income statements and balance sheets)
8. Texas Instruments (detailed income statements and balance sheets)
9. Amazon (detailed income statements and balance sheets)

In the 2018 and 2019 financial data sheets, there are columns for the relevant Income Statement and Balance Sheet items required for calculating the ratios.

Required:
Power BI:
(i) Load the ‘2018 financial data’ sheet and ‘2019 financial data’ sheet into Power BI. Use the information in the data sheets in Power BI to calculate the following ratios for the seven companies for 2019 (See Appendix A for the formulas):
1. Profit Margin
2. Gross Profit Percentage
3. Return on Total Assets
4. Return on Equity
5. Inventory Turnover
6. Number of Days in Selling Period
7. Accounts Receivable Turnover
8. Number of Days in Collection Period
9. Current Ratio
10. Quick Ratio

This Accounting Assignment has been solved by our Accounting Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.