Hi please help me with this case study from questions a to d

For b and d, can you put the calculation into a excel spreadsheet, please.

Thank you.

Correct information for the current 2020 financial year

-The Market price for shares on 30.06.2020 (not 30.06.2015) it is the same figure just change the year $2.65

Correct information for the current 2019 financial year

-The market price for shares on 30.06.2019 (not 30.06.2014) it is the same figure just change the year $2.20

Below are the case study and questions:

Under here is the appendix to refer for question b

requirements and discuss about the energy and resource conservation techniques that should be used in an organisation. During the demonstration, the assessor will also ask at least 4 (four) questions as you complete the task to help assess your knowledge and how you can apply it to work relevant situations. Part B: Case Study + Presentation Star Limited You have joined Star Limited's finance team as their finance manager. They have provided you with the following figures to perform a financial ratio analysis. The following are the Income Statement and Balance Sheet for 2019 (Current financial year). They have also provided financial ratios from 2019 (previous financial year for comparison purposes). Star Limited- Statement of Comprehensive Income For the year ended 30 June 2020 (Current financial year) FINAL APPROVED - STUDENT PRODUCT ASSESSMENT TASK TEMPLATE - June 2019_Version 20 Page 2 of 17 Star Limited-Balance Sheet Scenario: Ron (CEO) and the directors would now like a report on an analysis of the financial position they are in. They have also asked for a presentation on the company's performance and seeking recommendations on how they might improve areas of weaknesses identified in the analysis. When preparing the report (including any financial statements), Ron has strictly advised to abide by the financial reporting policies and organisational procedures, statutory requirements and standard financial reporting principles. Note: Star Limited's financial report policy complies with guidelines provided by the Victorian State Government, Treasure and Finance Department. The policy can be found here: https://www.dtf.vic.gov.au/financial-management-government/financial-reporting-policy Your tasks are as follows: Task 1 - Prepare a Report STUDENT RMIT Classification: Trusted UNIVERSITY the client's needs. When creating the spreadsheet report, you are to develop templates that are consistent in style, design and layout, clearly labelling all cell references as well as worksheets (you are required to refer to online help with Excel design and production. Identify and evaluate which tasks could be completed by developing and editing macros to increase efficiency. (in word or Excel) and automate tasks for efficiency. i. Input the above Income Statement and Balance Sheet data in EXCEL ii. Perform a ratio analysis for 2019 (current financial year) and compare it to ratio analysis from 2018 (previous financial year). Use various ratios to support your analysis and prepare a detailed analysis report commenting on increases or decreases for: - Liquidity - Activity - Profitability - Leverage - Market Performance iii. Use formulas/ functions to perform all mathematical calculations in the worksheet clearly showing all workings and linking (import and export) between worksheets. Please note your work will be cross checked against the input they have put in the cells. iv. Determine style of graph required to specified requirements and manipulate spreadsheet data if necessary, to suit graph requirement Present the analysis in a graph or chart and embed this in the written business report (to be created as a word document). pendix 1 - Financial Reports from Quad Accountants (External) Star Limited- Statement of Comprehensive Income by Quad Accountants For the vear ended 30 June 2020 (Current financial vear) Star Limited-Balance Sheet As at 30 June 2020 requirements and discuss about the energy and resource conservation techniques that should be used in an organisation. During the demonstration, the assessor will also ask at least 4 (four) questions as you complete the task to help assess your knowledge and how you can apply it to work relevant situations. Part B: Case Study + Presentation Star Limited You have joined Star Limited's finance team as their finance manager. They have provided you with the following figures to perform a financial ratio analysis. The following are the Income Statement and Balance Sheet for 2019 (Current financial year). They have also provided financial ratios from 2019 (previous financial year for comparison purposes). Star Limited- Statement of Comprehensive Income For the year ended 30 June 2020 (Current financial year) FINAL APPROVED - STUDENT PRODUCT ASSESSMENT TASK TEMPLATE - June 2019_Version 20 Page 2 of 17 Star Limited-Balance Sheet Scenario: Ron (CEO) and the directors would now like a report on an analysis of the financial position they are in. They have also asked for a presentation on the company's performance and seeking recommendations on how they might improve areas of weaknesses identified in the analysis. When preparing the report (including any financial statements), Ron has strictly advised to abide by the financial reporting policies and organisational procedures, statutory requirements and standard financial reporting principles. Note: Star Limited's financial report policy complies with guidelines provided by the Victorian State Government, Treasure and Finance Department. The policy can be found here: https://www.dtf.vic.gov.au/financial-management-government/financial-reporting-policy Your tasks are as follows: Task 1 - Prepare a Report STUDENT RMIT Classification: Trusted UNIVERSITY the client's needs. When creating the spreadsheet report, you are to develop templates that are consistent in style, design and layout, clearly labelling all cell references as well as worksheets (you are required to refer to online help with Excel design and production. Identify and evaluate which tasks could be completed by developing and editing macros to increase efficiency. (in word or Excel) and automate tasks for efficiency. i. Input the above Income Statement and Balance Sheet data in EXCEL ii. Perform a ratio analysis for 2019 (current financial year) and compare it to ratio analysis from 2018 (previous financial year). Use various ratios to support your analysis and prepare a detailed analysis report commenting on increases or decreases for: - Liquidity - Activity - Profitability - Leverage - Market Performance iii. Use formulas/ functions to perform all mathematical calculations in the worksheet clearly showing all workings and linking (import and export) between worksheets. Please note your work will be cross checked against the input they have put in the cells. iv. Determine style of graph required to specified requirements and manipulate spreadsheet data if necessary, to suit graph requirement Present the analysis in a graph or chart and embed this in the written business report (to be created as a word document). pendix 1 - Financial Reports from Quad Accountants (External) Star Limited- Statement of Comprehensive Income by Quad Accountants For the vear ended 30 June 2020 (Current financial vear) Star Limited-Balance Sheet As at 30 June 2020