Home retail group plc (Finance)
Home retail group plc (Finance)
M004 (F01) Coursework One (CW1): Data Response
Groupwork prepared and submitted by self-chosen groups of three persons
from within the same seminar class. The minimum number in any group is 2
persons. Submissions of groups with more than three members will not be
accepted and marked as absent FAIL.
Use any permitted organisation of your choice for this assignment. The list of permitted
companies for this CW1 is
Name of Company Sector
1 Britvic plc International soft drinks company
2 Coats plc International industrial thread & textile craft business
3 Home Retail Group plc UK’s leading home and general merchandise retailer
4 Merlin Entertainments plc An international entertainments company
5 Restaurant Group plc Multi-branded restaurant chain.
6 Serco plc International outsourcing service provider.
These are companies you have studied in M002 Strategy in E10 Term. Knowing and
understanding the company strategy will speed your ability to answer M004 Assignments.
This is why we use the same companies.
Your seminar tutor will maintain a list of students names together with choice of
organisation. This Tutor held list is the definitive record; submitted work will not be assessed
if it does not agree with the list.
Using financial reports and accounts of your chosen organisation analyse the results of the
organisation highlighting trends in performance using appropriate and relevant ratios and
analysis techniques.
Your analysis should include a(n):
1.
comparison of Latest year results with Previous year results; 15
2.
ratio analysis of both Latest and Previous years (show all
workings and 20
provide detailed reference of data sources); This should include
a. Liquidity,
b. Solvency,
c. Working capital management,
d. Profitability,
e. Asset efficiency,
providing a minimum of two (2) and an average of three (3) ratios
under
each of the above headings for each of the two years covered;
3. comparison with industry average figures as available; 10
4. measurement against the organisation’s KPIs;; 10
5.
evaluation of the uses of KPIs in assessing organization
performance; 15
6. discussion and explanation of your results; 10
7.
discussion of the advantages and limitations of the analysis
techniques 10
you have used.
Professional format 10
Your approach to this task must reflect your ability to carry out research, understand key
principles in financial management and apply these to a case study.
The outcome of this task should be in the form of a detailed and structured report
addressed to the directors of your chosen organisation. You must also include evidence of
your research materials including full workings of your financial analysis in the appendix
sections of your assignment.
Submission instructions
Please use the NAME of your company + the name of your group leader
e.g.
Marks & Spencer plc Mohammad Al-Momani ID 1234567
On the cover page of the assignment please give all student names and ID
numbers. Without this your marks will not be recorded.
Use the CW1 submission link for Coursework 1 to upload your assignment
Report Format:
1. The maximum word count for the main text excluding tables is 2,000 words.
Exceeding the word count by more than 10% can result in a reduction of marks.
Only the main text excluding any tables and diagrams counts, excluding the
contents page, executive summary, list of references and appendix.
2. The assignment must have a front cover stating:
Module number and name and seminar group number
Title of the assignment
Student names and IDs for each group member
Submission date
Word count as defined above 3. All pages must be numbered
4. An executive summary is required (not included in the word count), but
this should not exceed ½ page.
5. A short introduction is required (and included in the word count), even if it is
not explicit in the assessment criteria.
6. A reasonable number of appendices may be used for relevant supporting
information and to demonstrate your calculations and analysis.
7. Only Word documents can be submitted through Turnitin, the University’s
plagiarism detection software, therefore you are advised to create tables in Word
and not to cut and paste Excel or other software into the document. The marker
will not be able to access your spreadsheets and see your workings.
The rubric by which your report will be assessed follows on pages 3-4. It is important
that prior to you submitting your work, you read this and objectively assess your response
against the rubric. This will ensure that you have done enough to attain the marks you
wish to achieve.
This assignment tests achievement of all our module learning outcomes:
1. Select and apply appropriate accounting techniques to critically analyse financial
data in a variety of business decision making scenarios
2. Make informed financial judgements based on the outcome of such accounting
analyses
3. Critically appraise the techniques used and the information to which they have
been applied
4. Demonstrate an critical understanding to the internal, external and legal
environments in which the judgements are being made
3
Assessment criteria
Task and category Score per category (max. 20×5=100)
0 1 2 3 4 5
1. Comparison of Latest year results with Previous year results
Criterion 1 no attempt The data choice is The data choice is The data choice is The choice of all data The choice of all data
?? Data choice unimaginative and sufficiently appropri- entirely meaningful is entirely meaningful is highly imaginative
not meaningful for ate for the purpose of for the purpose of for the purpose of and entirely meathe
purpose of this this task this comparison this comparison ningful for the purpotask
se of this comparison
Criterion 2 no attempt Data comparison is Data comparison is All or most provided All provided data are All data are fully
?? Full comparison incomplete and few incomplete (possibly data are fully fully compared, and compared wherever
Latest vs. Previous differences are restricted to tables or compared but not all any differences useful, and any difyear
highlighted diagram only) and differences highlighted where ferences highlighted
not all differences highlighted appropriate where appropriate
highlighted
Criterion 3 no attempt Some obvious differ- Some reasonable Most important All differences are Full and original ex-
?? Explanation for ences are explained differences are differences are well fully explained with planations are providifferences
Latest in general terms but explained but lack explained full reference to data ded for all differences
vs. Previous year lack originality or re- originality sources with full reference to
lation to organisation data sources
2. Ratio analysis of both Latest and Previous years
Criterion 4 no attempt The choice of ratios The choice of ratios Mostly meaningful The choice of all The choice of all
?? Meaningful choice appears to follow fulfils formal require- ratios are chosen ratios is entirely ratios is entirely meaof
ratios some textbook with ments but some are which reflects good meaningful for the ningful and justified
little consideration of redundant and do not understanding of purpose of this task for the purpose of
the ratios’ use for this reflect good under- their meaning. Few and reflects full this task and reflects
task. standing of the ratios’ ratios are redundant understanding of the full understanding of
meaning. or less useful ratios’ meaning the ratios’ meaning
Criterion 5 no attempt Many are not calcula- Most ratios are calcu- Most ratios are calcu- All ratios are calcula- All ratios are
?? Full, correct ted correctly and lated correctly but lated correctly using ted correctly using calculated correctly
calculation of all source figures are sometimes confusing almost always the almost always the using the right figures
ratios often confused source figures right figures right figures
Criterion 6 no attempt Workings in the ap- Workings are shown All workings are All workings are pro- All workings are pro-
?? Full workings in pendix are incom- in the appendix but shown in the fessionally and neatly fessionally and neatly
appendix plete or grossly lack lack clarity appendix but lack shown in the shown in the appenclarity
or are difficult some clarity appendix dix, fully numbered
to follow. for reference
Criterion 7 no attempt Data comparison is Data comparison is All or most provided All provided data are All ratios are compa-
?? Comparison and incomplete and few incomplete (possibly data are fully fully compared, and red, any differences
explanation of any differences are restricted to tables or compared and most any differences are highlighted and fully
movement Latest explained diagram only) and important differences fully explained with and originally exvs.
Previous year not all differences are well explained full reference to plained with full
explained sources reference to sources
3. Comparison with industry average figures as available;
Criterion 8 no attempt Reference data pro- Reference to an Clear evidence that Clear evidence that Clear evidence that
?? Evidence of vided in class were effort to finding useful an effort was made every effort was every effort beyond
attempt to finding used but no effort to data for comparison to find useful data for made to find useful expected was made
comparison data finding own data was made comparison data for comparison to find useful data for
shown comparison
Criterion 9 no attempt Data comparison is Data comparison is All or most provided All provided data are All ratios are compa-
?? Comparison and incomplete and few incomplete (possibly data are fully fully compared, and red, any useful differexplanation
of any differences are restricted to tables or compared and most any differences are ences highlighted
discrepancies explained diagram only) and important differences fully explained with and fully and
not all differences are well explained full reference to originally explained
