Statement items, Balance Sheet items and Population (members) required for calculating the ratios for eight iwi....

  

Transcribed Image Text:

Statement items, Balance Sheet items and Population (members) required for calculating the ratios for eight iwi. You will mainly be using data from 2020. Required: Power Bl: (i) "Get data" from the 115.112 Assignment 2 - Student Data.xlsx and load the 2020 financial data' sheet into Power BI. Use the information in the data sheets in Power BI to calculate the following ratios for the eight iwi for 2020: (See Appendix A for the formulas) 1. Debt ratio % 2. Interest bearing debt % 3. Assets per member $ 4. Net worth per member $ 5. Distribution per member $ 6. Distribution to Revenue % 7. Distribution to Total Comprehensive Income % (ii) Use the 'New Column' function in the 'Data view' in Power BI to create a new calculated column for each of the ratios. Remember that all numbers represent millions, except for the population column which is the actual number and the Return on Assets which is in percentages. (iii) (14 marks) Present the 2020 ratios in relevant tables in your Power BI file to compare the eight iwi using Financial Gearing, Population, Distribution and Return on Assets as your four groupings. (12 marks) Create appropriate visualisations (graphs) in your Power BI file for the 2020 ratios to compare the eight iwi using the groupings in (ii). (24 marks) Save your Power BI file (iv) (v) Word document: Discuss the following two points. 6 Discuss Maori Asset ownership objectives (20 marks) With reference to the TDB report and your ratios and graphs discuss the distribution policies of the different iwi. (25 marks) Statement items, Balance Sheet items and Population (members) required for calculating the ratios for eight iwi. You will mainly be using data from 2020. Required: Power Bl: (i) "Get data" from the 115.112 Assignment 2 - Student Data.xlsx and load the 2020 financial data' sheet into Power BI. Use the information in the data sheets in Power BI to calculate the following ratios for the eight iwi for 2020: (See Appendix A for the formulas) 1. Debt ratio % 2. Interest bearing debt % 3. Assets per member $ 4. Net worth per member $ 5. Distribution per member $ 6. Distribution to Revenue % 7. Distribution to Total Comprehensive Income % (ii) Use the 'New Column' function in the 'Data view' in Power BI to create a new calculated column for each of the ratios. Remember that all numbers represent millions, except for the population column which is the actual number and the Return on Assets which is in percentages. (iii) (14 marks) Present the 2020 ratios in relevant tables in your Power BI file to compare the eight iwi using Financial Gearing, Population, Distribution and Return on Assets as your four groupings. (12 marks) Create appropriate visualisations (graphs) in your Power BI file for the 2020 ratios to compare the eight iwi using the groupings in (ii). (24 marks) Save your Power BI file (iv) (v) Word document: Discuss the following two points. 6 Discuss Maori Asset ownership objectives (20 marks) With reference to the TDB report and your ratios and graphs discuss the distribution policies of the different iwi. (25 marks)

Answer rating: 100% (QA)

i Calculating Ratios in Power BI To calculate the ratios using Power BI follow these steps Load Data Open Power BI go to the Home tab click on Get Dat... View the full answer