Prepare a financial report for the department about the financial condition of the LAs assigned to you.

You have been hired as a Graduate Trainee Accountant by the Treasury department. The central government is concerned about the economic situation in the country in the wake of COVID-19 and wants to assess the financial health of the Local Authorities (LAs) in England. You have been asked to prepare a financial report for the department about the financial condition of the LAs assigned to you.

*LocalAuthoritiesDataInput4IRR-1-1.xlsx*

The template be used to collect essential data that can be helpful/useful for analysis required for the research report assignment.

The Excel template also refers to IMD 2019 ranking. For that the following excel list provided by the government can be used.

*IMDranks2019.xlsx*

Rank 1 means most deprived area and higher the rank the lesser deprived the area is. e.g Rank 100 area is much better in terms of various deprivation factors compared to an area that is ranked 10.