Students
AFIN6013 – Financial Statement Analysis and Modelling
2022 – Session 1, Online-scheduled-In person assessment, North Ryde
General Information
Download as PDF
| Unit convenor and teaching staff | Unit convenor and teaching staff |
|---|---|
| Credit points |
Credit points
10
|
| Prerequisites |
Prerequisites
Admission to GradCertFin or GradDipAppFin or MAppFin or MAppFin(Adv) or MBkgFin
|
| Corequisites |
Corequisites
|
| Co-badged status |
Co-badged status
|
| Unit description |
Unit description
This unit equips students with financial analysis skills to support advanced study in corporate finance and investment analysis. Emphasis is placed on being able to interpret financial statements in the context of a company's operational performance and strategy, to assess historical financial performance and to prepare a spreadsheet based financial model capable of forecasting integrated financial statements for a company. |
Important Academic Dates
Information about important academic dates including deadlines for withdrawing from units are available at https://www.mq.edu.au/study/calendar-of-dates
Learning Outcomes
On successful completion of this unit, you will be able to:
- ULO1: Explain the main components of and the linkages between the three major financial statements.
- ULO2: Critically assess a company’s historical financial performance using financial ratios and other analysis tools.
- ULO3: Apply financial analysis skills to develop financial projections for a project or business.
- ULO4: Construct spreadsheet based integrated financial models.
- ULO5: Demonstrate proficiency in using spreadsheet based financial modelling to solve a range of finance based problems
General Assessment Information
Late submissions of assessments
Unless a Special Consideration request has been submitted and approved, no extensions will be granted. There will be a deduction of 10% of the total available assessment-task marks made from the total awarded mark for each 24-hour period or part thereof that the submission is late. Late submissions will only be accepted up to 96 hours after the due date and time.
No late submissions will be accepted for timed assessments – e.g., quizzes, online tests.
Table 1: Penalty calculation based on submission time
|
Submission time after the due date (including weekends) |
Penalty (% of available assessment task mark) |
Example: for a non-timed assessment task marked out of 30 |
|
< 24 hours |
10% |
10% x 30 marks = 3-mark deduction |
|
24-48 hours |
20% |
20% x 30 marks = 6-mark deduction |
|
48-72 hours |
30% |
30% x 30 marks = 9-mark deduction |
|
72-96 hours |
40% |
40% x 30 marks = 12-mark deduction |
|
> 96 hours |
100% |
Assignment won't be accepted |
Other assessment criteria for assessment tasks will be provided on the unit iLearn site.
Assessment Tasks
| Name | Weighting | Hurdle | Due |
|---|---|---|---|
| Practice quizzes | 0% | No | Wed Apr 20, 2022 |
| Assignment | 30% | No | Fri May 6, 2022 |
| Quizzes and short questions exercise | 30% | No | Sun May 15, 2022 |
| Final Examination | 40% | No | Final exam period |
Practice quizzes
Assessment Type 1: Quiz/Test
Indicative Time on Task 2: 2 hours
Due: Wed Apr 20, 2022
Weighting: 0%
The practice quiz consists of multiple choice and/or short answer questions. Please use the practice quizzes as an indicator of whether you are progressing satisfactorily in the unit.
On successful completion you will be able to:
- Explain the main components of and the linkages between the three major financial statements.
- Critically assess a company’s historical financial performance using financial ratios and other analysis tools.
Assignment
Assessment Type 1: Modelling task
Indicative Time on Task 2: 20 hours
Due: Fri May 6, 2022
Weighting: 30%
Students will be required to conduct spreadsheet analysis and write a report based on the findings.
On successful completion you will be able to:
- Explain the main components of and the linkages between the three major financial statements.
- Critically assess a company’s historical financial performance using financial ratios and other analysis tools.
- Apply financial analysis skills to develop financial projections for a project or business.
- Construct spreadsheet based integrated financial models.
- Demonstrate proficiency in using spreadsheet based financial modelling to solve a range of finance based problems
Quizzes and short questions exercise
Assessment Type 1: Quiz/Test
Indicative Time on Task 2: 20 hours
Due: Sun May 15, 2022
Weighting: 30%
Two quizzes and one short questions exercise will be conducted. They are of various weightings and in total contribute 30% to the course final mark.
On successful completion you will be able to:
- Explain the main components of and the linkages between the three major financial statements.
- Critically assess a company’s historical financial performance using financial ratios and other analysis tools.
- Apply financial analysis skills to develop financial projections for a project or business.
- Construct spreadsheet based integrated financial models.
Final Examination
Assessment Type 1: Examination
Indicative Time on Task 2: 20 hours
Due: Final exam period
Weighting: 40%
A two hour exam will be held during the University Examination Period.
On successful completion you will be able to:
- Explain the main components of and the linkages between the three major financial statements.
- Critically assess a company’s historical financial performance using financial ratios and other analysis tools.
1 If you need help with your assignment, please contact:
- the academic teaching staff in your unit for guidance in understanding or completing this type of assessment
- the Writing Centre for academic skills support.
2 Indicative time-on-task is an estimate of the time required for completion of the assessment task and is subject to individual variation
Delivery and Resources
The lectures will cover the following things:
- Explanation of the lecture slides
- Demonstration of modelling techniques in Excel
- Work-through of the assessments, including quizes, exercises and assignment
- Important announcements
It is the best place for you to learn the course and ask questions. it may take you a lot more time to catch up if you miss a lecture.
No textbooks are required.
Unit Schedule
|
Week |
Lecture Topic |
|
1 |
Introduction to financial statement analysis |
|
2 |
Introduction to modelling |
|
3 |
Preparing financial statements |
|
4 |
A closer look at the Balance Sheet |
|
5 |
Preparing a financial model Part 1 |
|
6 |
Preparing a financial model Part 2 |
|
7 |
Review (no lecture) |
|
8 |
Analysis of financial statements |
|
9 |
Analysis of financial statements Part 2 |
|
10 |
Industry Guest Speaker |
|
11 |
Revisit the Plan and the Plug; Share evaluation |
|
12 |
Preparing a financial model Part 3 |
|
13 |
Final Exam Revision |
Policies and Procedures
Macquarie University policies and procedures are accessible from Policy Central (https://policies.mq.edu.au). Students should be aware of the following policies in particular with regard to Learning and Teaching:
- Academic Appeals Policy
- Academic Integrity Policy
- Academic Progression Policy
- Assessment Policy
- Fitness to Practice Procedure
- Assessment Procedure
- Complaints Resolution Procedure for Students and Members of the Public
- Special Consideration Policy
Students seeking more policy resources can visit Student Policies (https://students.mq.edu.au/support/study/policies). It is your one-stop-shop for the key policies you need to know about throughout your undergraduate student journey.
To find other policies relating to Teaching and Learning, visit Policy Central (https://policies.mq.edu.au) and use the search tool.
Student Code of Conduct
Macquarie University students have a responsibility to be familiar with the Student Code of Conduct: https://students.mq.edu.au/admin/other-resources/student-conduct
Results
Results published on platform other than eStudent, (eg. iLearn, Coursera etc.) or released directly by your Unit Convenor, are not confirmed as they are subject to final approval by the University. Once approved, final results will be sent to your student email address and will be made available in eStudent. For more information visit ask.mq.edu.au or if you are a Global MBA student contact globalmba.support@mq.edu.au
Academic Integrity
At Macquarie, we believe academic integrity – honesty, respect, trust, responsibility, fairness and courage – is at the core of learning, teaching and research. We recognise that meeting the expectations required to complete your assessments can be challenging. So, we offer you a range of resources and services to help you reach your potential, including free online writing and maths support, academic skills development and wellbeing consultations.
Student Support
Macquarie University provides a range of support services for students. For details, visit http://students.mq.edu.au/support/
The Writing Centre
The Writing Centre provides resources to develop your English language proficiency, academic writing, and communication skills.
- Workshops
- Chat with a WriteWISE peer writing leader
- Access StudyWISE
- Upload an assignment to Studiosity
- Complete the Academic Integrity Module
The Library provides online and face to face support to help you find and use relevant information resources.
Student Services and Support
Macquarie University offers a range of Student Support Services including:
- IT Support
- Accessibility and disability support with study
- Mental health support
- Safety support to respond to bullying, harassment, sexual harassment and sexual assault
- Social support including information about finances, tenancy and legal issues
Student Enquiries
Got a question? Ask us via AskMQ, or contact Service Connect.
IT Help
For help with University computer systems and technology, visit http://www.mq.edu.au/about_us/offices_and_units/information_technology/help/.
When using the University's IT, you must adhere to the Acceptable Use of IT Resources Policy. The policy applies to all who connect to the MQ network including students.
Unit information based on version 2022.02 of the Handbook