2.13 faculty of Business and Law
follow the requirement
3 years ago
40
ACFI3310-90Assignment1FAQ2023-241.docx
ACFI3310-90BankruptcyAssignment1.pdf
- example2.pdf
- example1.pdf
ACFI3310-90Assignment1FAQ2023-241.docx
ACFI3310 Assignment 1 (Bankruptcy) Frequently Asked Questions
Beaver/Altman
Should I calculate a cut-off point for Beaver?
It would take a large piece of analysis to do this and it’s certainly not required. Whilst it would impress, it might not be the best use of your time.
Do I need to include industry averages for Beaver?
It’s up to you but it’s not required. You can simply make comparisons using a competitor company. You would have to find or calculate the industry averages yourself if this is approach you take.
Can I use X as a comparison company?
You would not be penalised for any sensible choice of comparison company. You can critically comment on any limitations with your choice of company as part of your analysis.
How can I access financial and market data for other companies?
You can access the FAME database for UK companies through the Library website: https://library.dmu.ac.uk/business/financialdata.
Which of share prices should I use to calculate the MV of equity?
The data we provided contains 4 daily prices: Open, High, Low and Close. High and Low refer to the maximum and minimum prices for the given day. Open and Close are the prices at which a stock began and ended trading for the given day. From these figures you’ll need to determine which are the most appropriate to use in your calculations.
How should I calculate total debt?
For your assignment you should use total liabilities to represent total debt. This is the approach we followed in the seminars (Beaver also followed a similar approach).
For the Beaver analysis, how many ratios should I use?
We have provided guidance on this in the lectures.
Which figure do I use for cash flow?
Cash inflow from operating activities would be most appropriate here, as this indicates the amount of money a company brings in from its ongoing, regular business activities.
Should I net off the other operating income from the expenses when doing the Cash Interval calculation?
No.
Should I net off the Overdraft from the Cash balance?
No.
Should I use Administration expenses as the Operating expenses
Yes, you should use administration expenses to represent operating expenses. You should not include the exceptional items in your calculations.
Any other questions about which numbers to use from the spreadsheet (e.g. EBIT, retained earnings, cash flow, expenditure to fund operations etc.)
No further guidance will be provided here, and you’ll need to determine which figures to use. If in doubt, you should clearly state your assumption(s) and proceed with your analysis. We appreciate it was easier to identify the numbers in the seminar, however, for your assignment are required to apply your understanding to a scenario with real-world data.
How many years should I calculate for?
All three years.
I have found more recent data. Can I include this?
You should only use the provided data when calculating financial ratios for the provided company for the Beaver/Altman analysis. The provided data was up to date when the assignment was released.
What do I do about the negative figures on the spreadsheet?
The expenses on the income statement are shown as negatives and so are the liabilities on the statement on financial position. The figures have been taken from the FAME database and this is the nature of working real-world data. Where you want these items to show as positive in Excel, all you need to do is include a minus sign immediately before referencing it.
Should my ratio be positive of negative?
You should follow the approach covered in the learning materials. No further guidance will be here are required to apply your understanding to real-world data.
Do I need to show workings for my calculations?
Yes, this is stipulated on the brief. Look at the answers for the week 9 seminar or the example submissions provided on Blackboard.
Argenti
Which years do I need to consider for the Argenti analysis?
You can consider any information available before the date on your memorandum. You date your memorandum as you choose between Nov 23 and Feb 24 (inclusive). You only need to perform the Argenti analysis once, and you do not need to repeat the analysis for multiple years.
Do I need to provide evidence for my scoring for the Argenti analysis?
Absolutely - this is one of the most important parts of the analysis. The marker needs to be able to see exactly why you have scored it the way you have.
How do I present the Argenti analysis?
The assignment document states "The Argenti analysis should be in the appendix with the main points summarised in the memorandum." The approach we are suggesting is to use a three-column table with the item, the score and the support in the three columns. You can also look at the example submissions provided on Blackboard.
Other queries
How do I present a memorandum?
Other than the guidance in the lecture, it's up to you but using headings for Subject, Date etc. is a good start. There are 10 marks available for "structure, style and overall professionalism". As you are being assessed on presentation we are not stipulating how it must be done.
What is included in the word-count?
The appendix doesn’t count. You can also exclude the in-text citations when in brackets and also the Memo format “To/From etc...”.
What about rounding?
Sensible rounding will make the figures easy to read without a significant loss of information or accuracy. There is no single rule about rounding that would be appropriate for every circumstance, but presenting financial ratios to say 2 or 3 significant figures or decimal places is often sufficient. No further guidance will be provided on rounding.
ACFI3310-90BankruptcyAssignment1.pdf
This document is for De Montfort University use and should not be passed to third parties or posted on any website.
Assignment Brief Template Page 1 of 5
Faculty of Business and Law
Assignment Brief
Module Title Advanced Corporate Finance Assignment Number
1
Module Code ACFI3310/ACFI3390 Assignment Title
Individual Coursework: Bankruptcy
Module Leader Louis Ellam (ACFI3310) Wansu Hu (ACFI3390)
Assignment Weighting
30%
Assignment Release Date:
16/11/23
Submission Date/Time:
15/02/24 12:00pm (noon)
Assessment Information – What you need to do
This assignment must be completed individually. The assignment aims to increase your understanding of the different techniques used in the evaluation of business sustainability and corporate bankruptcy. You are required to apply theoretical knowledge to actual company data.
Your task for this assignment is to evaluate the bankruptcy risk for Vodafone Plc based on the provided data, and your own research. Your memorandum should include the following:
1. A critical analysis of bankruptcy risk for the company using Beaver’s, Altman’s and Argenti’s approaches to support your assessment.
2. A critical evaluation of the likelihood of the company going into bankruptcy in the upcoming years.
Other requirements:
• The submission should be in the format of a memorandum addressed to an analyst who has asked you to make the evaluation.
• When calculating financial ratios for Beaver’s and Altman’s approaches: o You must follow the same approach as the one that was covered in the
learning materials. o You must only use the provided data and you should calculate financial ratios
for all three years. Workings must be shown.
This document is for De Montfort University use and should not be passed to third parties or posted on any website.
Assignment Brief Template Page 2 of 5
Criteria for Assessment - How you will be marked
The mark allocation is shown below:
Marks
Memorandum
Good marks are available for students who not only bring the evidence together convincingly and logically to arrive at an overall conclusion, but also discuss the credibility of the conclusion they arrive at. Higher marks will be available for a critical discussion of the theory and evidence presented. The memorandum should include:
• Critical analysis using Beaver’s approach (20 marks)
• Critical analysis using Altman’s approach (20 marks)
• Critical analysis using Argenti’s approach (20 marks)
• Critical discussion and overall conclusion (20 marks) Calculations for Beaver’s and Altman’s approach should be in the appendix, and the main figures referred to in the memorandum where needed. Workings must be shown. The scorecard for Argenti’s approach should be in the appendix with the main points summarised in the memorandum.
80
Referencing Full marks are available for students correctly applying the Harvard referencing system, and displaying appropriate reading around the subject area.
10
Structure, style and overall professionalism Full marks are available for students who produce a professional memorandum, which is well-structured and of an appropriate tone.
10
Total 100
Further information on University mark descriptors can be found here. This assignment is designed to assess the following subject-specific learning outcomes: • Systematic understanding of the theoretical and practical basis of financial modelling. • Assess organisations’ reporting needs and deploy accurately a suitable financial model. • Critically evaluate different financial scenarios and apply scenario management to
facilitate informed decision-making. • Apply presentation and visualisation methods for efficient and dynamic reporting.
Assessment Details The word count is 500. The word limit includes tables, figures, quotations and citations, but excludes the references list and appendices. You can also exclude the in-text citations and the memo header from the word limit. There will be a penalty of a deduction of 10% of the mark for work exceeding the word limit by 10% or more.
This document is for De Montfort University use and should not be passed to third parties or posted on any website.
Assignment Brief Template Page 3 of 5
How to Submit your Assessment The assessment must be submitted by 12:00pm noon (GMT/BST) on 15/02/24 using the link provided on LearningZone.
• Your coursework will be given a zero mark if you do not submit a copy through Turnitin. Please take care to ensure that you have fully submitted your work.
• Please ensure that you have submitted your work using the correct file format, unreadable files will receive a mark of zero. The Faculty accepts Microsoft Office and PDF documents, unless otherwise advised by the module leader.
• All work submitted after the submission deadline without a valid and approved reason will be subject to the University regulations on late submissions.
o If an assessment is submitted up to 24 hours late the mark for the work will be capped at the pass mark of 40 per cent for undergraduate modules or 50 per cent for postgraduate modules
o If an assessment is submitted beyond 24 hours late the work will receive a mark of zero per cent
o The above applies to a student’s first attempt at the assessment. If work submitted as a reassessment of a previously failed assessment task is submitted later than the deadline the work will immediately be given a mark of zero per cent
o If an assessment which is marked as pass/fail rather than given a percentage mark is submitted later than the deadline, the work will immediately be marked as a fail
• The University wants you to do your best. However, we know that sometimes events happen which mean that you can’t submit your coursework by the deadline – these events should be beyond your control and not easy to predict. If this happens, you can apply for an extension to your deadline for up to five working days, or if you need longer, you can apply for a deferral, which takes you to the next assessment period (for example, to the re-sit period following the main Assessment Boards). You must apply before the deadline for your assessment. You will find information about applying for extensions and deferrals here.
• Students MUST keep a copy and/or an electronic file of their assignment.
• Checks will be made on your work using anti-plagiarism software and approved plagiarism checking websites.
Return of Marked Work You can expect to have feedback returned to you by 12:00pm (noon) on 07/03/24 (within 15 working days). If for any reason there is a delay you will be kept informed. Marks and feedback will be provided online. It is important that you access the feedback you receive as this will help to make improvements to your later work, you can request a meeting with your Module Leader or Personal Tutor to discuss your feedback in more detail.
This document is for De Montfort University use and should not be passed to third parties or posted on any website.
Assignment Brief Template Page 4 of 5
Marks will have been internally moderated only, and will therefore be provisional; your mark will be formally agreed later in the year once the external examiner has completed their review. More information on assessment and feedback can be found here.
Academic Integrity and Generative AI Use In submitting a piece of work for assessment it is essential that you understand the University's requirements for maintaining academic integrity and ensure that the work does not contravene University regulations. Some examples of behaviour that would not be considered acceptable include plagiarism, re-use of previously assessed work, collusion with others and purchasing your assignment from a third party. For more information on academic offences, bad academic practice, and academic penalties, please read chapter four of our academic regulations. Generative AI tools cannot be used for this assessment. You must not use generative artificial intelligence (AI) to generate any materials or content in relation to your assessment. For further information on Generative AI tools, please refer to the library guide here - https://library.dmu.ac.uk/genai.
This document is for De Montfort University use and should not be passed to third parties or posted on any website.
Assignment Brief Template Page 5 of 5
Academic Support and Your Well-being Referencing is the process of acknowledging other people’s work when you have used it in your assignment or research. It allows the reader to locate your source material as quickly and easily as possible so that they can read these sources themselves and verify the validity of your arguments. Referencing provides the link between what you write and the evidence on which it is based.
You identify the sources that you have used by citing them in the text of your assignment (called citations or in-text citations) and referencing them at the end of your assignment (called the reference list or end-text citations). The reference list only includes the sources cited in your text. The main referencing guide can be found here and includes information on the basics of referencing and achieving good academic practice. It also has tabs for the specific referencing styles depending on whether you require Harvard style used in business or OSCOLA style used by the Law school.
The University has a wealth of support services available to students; further information can be obtained from Student Gateway, the Student Advice Centre, Library and Learning Services and, most importantly, your Personal Tutor. If you are struggling with your assessments and/or deadlines please do seek help as soon as possible so that appropriate support and guidance can be identified and put in place for you. More information can be found on the Healthy DMU pages.
- Self Regulation case - Professor EX
- Audit Exercise Paper Four
- Social Psychology Literature Review..
- Certblaster Test
- Jezreel
- Blanton - 5- 7 Paragraphs
- I need a 3pages paper before 10pm tonight about the article called: Our Time by John Edgar whidman
- Freedom of Speech 2Paragraph
- BUS 660 Week 1 Assignment Leadership Competency Models
- 7 help