Financial Ratios Business Performance Assignment

Assignment Task

PART A – Financial Statements Evaluation:

You have been hired by the consultancy firm, KDP Investments Ltd, as a financial analyst. Your manager, Andrew Jackson, asked you to analyse the financial statements of the top seven technology companies. You have asked your support person to download the financial statements of the companies and extract the data in a spreadsheet. In the spreadsheet there are the following sheets:

1. 2021 (all seven companies)
2. 2022 (all seven companies)

Required:

In Power BI:

Upload the data from the provided Excel file, ‘115.112 Data Assessment 3.xlsx’. Load the ‘2021’ and ‘2022’ sheets from this file. Use the information in the data sheets in Power BI to calculate the following ratios for the seven companies for 2022: (See Appendix A for the formulas, p. 8; Use the amounts as they are provided.):

(i)

1. Profit Margin
2. Gross Profit Percentage
3. Return on Total Assets
4. Return on Owners’ Equity
5. Inventory Turnover
6. Number of Days in Selling Period
7. Accounts Receivable Turnover (Assume all sales are on credit)
8. Number of Days in Collection Period
9. Current Ratio
10. Quick Ratio
11. Debt Ratio
12. Interest Coverage
13. Sales % Increase

Tip: Use the ‘New Column’ function in the ‘Data view’ in Power BI to create a new calculated column for each of the ratios.

In the 2021 and 2022 financial data sheets, there are columns for the relevant Income Statement and Balance Sheet items required for calculating the financial analysis ratios. All amounts, for all seven companies, are presented in NZ dollars.

• Present the 2022 ratios in relevant tables in your Power BI file to compare the seven companies, using the ‘Report view’. The tables have to express profitability, efficiency, liquidity and financial gearing appropriately. 

• Create appropriate graphs in your Power BI file for the 2022 ratios to compare the seven companies, using the ‘Report view’. The graphs have to express profitability, efficiency, liquidity and financial gearing 

In a Word document:

• Mr Jackson further requested you to evaluate company C (writing a simple discussion) in terms of profitability by comparing the company’s 2022 results with its results for 2021. Include a comparison of the company’s 2022 results with the results of the other six companies for 2022, in terms of profitability. To justify your explanations, use relevant ratios from requirement (i) and the 2021 ratios of company C, as provided below:

PART B – Accounting Information for Māori Business:

• Discuss and compare the investment performance (Assets and net worth, Return on Assets, and Net Assest per Member) of each of two iwi, Ngāti Awa and Ngāti Pāhauwera. Include a comparison between Ngāti Awa and Ngāti Pāhauwera. 
• References for requirement (v). 

This Accounting And Finance have been solved by our PhD Experts at My Uni Paper. Our Assignment Writing Experts are efficient in providing a fresh solution to this question. We are serving more than 10000+ Students in Australia, the UK, and the US by helping them to score HD in their academics. Our Experts are well-trained to follow all marking rubrics and referencing styles.

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 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.