Financial Report Analysis and Decision to Lend to a Company - Report Writing Assignment Help

Download Solution Order New Solution
Assignment Task :

Aims of this assignment
This assignment aims to develop:
a)
a highly proficient digital literacy through digitising financial statements into an excel spreadsheet and use these digitised financial statements to calculate and compare ratios to do the analysis showing the comparison in a graph.
b) an ability to understand and analyse financial reports,
c) skills to compare financial information of two listed companies, and
d) capacity to evaluate financial information and synthesise financial and non-financial information to make business decisions.

 

This assignment is to be completed on an individual basis.
Your submitted assignment must be entirely your own work. You may seek guidance from the lecturer or fellow students to clarify concepts or the application of concepts to company financial statements in general. Any clarification you need to do the assignment you have to put your questions in the course Teams site, so all students will benefit from the questions and the answers. Advice that is clearly associated with the assignment tasks cannot be sought or provided.

 

1. Excel Worksheet  
 Allocation of marks for each part according to the rubric.

1.1 Digitise the 4-years comparative income statement, balance sheet and statement of cash flows in an excel worksheet. Use a different worksheet for the two companies, worksheet 1one for Michael Hill and worksheet 2 for Lovisa. The first column for each financial statement is the column of the accounts, sub-totals and totals of the statement. The second column is the year 2019, the third column the year 2018, then the year 2017 and finally the year 2016. Always use the year reported in the most current financial statement (e.g. the year 2018 that is reported in the comparative financial statements 2019) because sometimes companies make adjustments to the financial statements in the following Annual Report.

 

This Report Writing Assignment has been solved by our Report Writing 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.

Get It Done! Today

Country
Applicable Time Zone is AEST [Sydney, NSW] (GMT+11)
+

Every Assignment. Every Solution. Instantly. Deadline Ahead? Grab Your Sample Now.