School: Business and Law

This unit information may be updated and amended immediately prior to semester. To ensure you have the correct outline, please check it again at the beginning of semester.

Your unit may be subject to government or third party COVID-19 vaccination requirements. Please consider this before enrolling in this unit, and speak with the unit coordinator if this raises any concerns.

  • Unit Title

    Financial Modelling
  • Unit Code

    ECF3120
  • Year

    2022
  • Enrolment Period

    1
  • Version

    4
  • Credit Points

    15
  • Full Year Unit

    N
  • Mode of Delivery

    On Campus
    Online
  • Unit Coordinator

    Dr Jaime Li YONG

Description

This is a capstone unit for the finance major where students apply financial principles and theories from related first and second year units, to build adaptive financial models that solve complex problems and make recommendations to investor clients. The unit will develop students’ Excel skills beyond an intermediate level. This is achieved as students conceptualise the architecture and design of financial models, provide consideration for user interface, and debug constructed models for error handling and flexibility. In this unit, students will demonstrate the ability to communicate financial knowledge, concepts and advice persuasively in written and oral formats. Students are also required to collaborate effectively in team settings to produce measurable outcomes for clients. Students will conduct in-depth research on companies and academic literature in finance, to model and test theories using real-time financial market and economic data.

Prerequisite Rule

Students must have passed ECF2222 and ECF2226.

Learning Outcomes

On completion of this unit students should be able to:

  1. Construct robust financial models to solve problems for clients.
  2. Collaborate effectively in a team to comprehensively evaluate companies and make investment recommendations.
  3. Plan a contemporary research study using current financial market data, drawing from financial theories and academic literature to produce meaningful research findings.
  4. Communicate findings of financial analyses, in both oral and written formats, to specialist and non-specialist audiences.

Unit Content

  1. Spreadsheet modelling and model design.
  2. Financial databases and data presentation.
  3. Math and statistical functions.
  4. Conditional, time, logical, search and array functions.
  5. Conditional formatting and data validation.
  6. Time Value of Money functions: valuing cash flows, annuities and dividend discount models.
  7. Approaches to determining cost of capital.
  8. Pro forma financial statements, forecasting company cash flows and equity valuation.
  9. Risk and What-if analysis: Sensitivity and Scenario modelling.
  10. Simulation models.
  11. Empirical finance research.
  12. Regression analysis, hypothesis testing and forecasting.

Learning Experience

ON-CAMPUS

Students will attend on campus classes as well as engage in learning activities through ECU's LMS

JoondalupMount LawleySouth West (Bunbury)
Semester 113 x 3 hour labNot OfferedNot Offered
Semester 213 x 3 hour labNot OfferedNot Offered

For more information see the Semester Timetable

ONLINE

Students will engage in learning experiences via ECU’s LMS as well as additional ECU learning technologies

Additional Learning Experience Information

Unit delivery is aimed at developing students’ intermediate to advanced capabilities to conceptualise, design, build and test financial models using Excel. The unit assumes students have a strong grasp of finance principles and theories learned from pre-requisite units, and will build on this prior learning. The learning process will require students to work effectively in teams to produce insightful investment recommendations. Students will also be required to access real-time financial market and economic data from sources such as Thomson Reuters Refinitiv Eikon, IbisWorld, the Reserve Bank of Australia (RBA) and the Australian Bureau of Statistics (ABS). On-campus students are expected to attend weekly lab sessions to collaborate on group projects, seek feedback from instructors, and participate actively in order to refine project and assessment deliverables. Off-campus students are expected to collaborate online on a weekly basis for the group project and communicate regularly with instructors to refine project and assessment deliverables. All students are encouraged to use formal collaboration tools such as MS Teams or LMS Collaborate to facilitate groupwork processes outside of class time.

Assessment

GS1 GRADING SCHEMA 1 Used for standard coursework units

Students please note: The marks and grades received by students on assessments may be subject to further moderation. All marks and grades are to be considered provisional until endorsed by the relevant School Progression Panel.

ON CAMPUS
TypeDescriptionValue
TestTimed Exercises20%
ProjectMajor group equity valuation project50%
AssignmentIndividual research paper and video presentation30%
ONLINE
TypeDescriptionValue
TestTimed Exercises20%
ProjectMajor group equity valuation project50%
AssignmentIndividual research paper and video presentation 30%

Disability Standards for Education (Commonwealth 2005)

For the purposes of considering a request for Reasonable Adjustments under the Disability Standards for Education (Commonwealth 2005), inherent requirements for this subject are articulated in the Unit Description, Learning Outcomes and Assessment Requirements of this entry. The University is dedicated to provide support to those with special requirements. Further details on the support for students with disabilities or medical conditions can be found at the Access and Inclusion website.

Academic Integrity

Integrity is a core value at Edith Cowan University, and it is expected that ECU students complete their assessment tasks honestly and with acknowledgement of other people's work. This means that assessment tasks must be completed individually (unless it is an authorised group assessment task) and any sources used must be referenced.

Breaches of academic integrity can include:

Plagiarism

Copying the words, ideas or creative works of other people, without referencing in accordance with stated University requirements. Students need to seek approval from the Unit Coordinator within the first week of study if they intend to use some of their previous work in an assessment task (self-plagiarism).

Unauthorised collaboration (collusion)

Working with other students and submitting the same or substantially similar work or portions of work when an individual submission was required. This includes students knowingly providing others with copies of their own work to use in the same or similar assessment task(s).

Contract cheating

Organising a friend, a family member, another student or an external person or organisation (e.g. through an online website) to complete or substantially edit or refine part or all of an assessment task(s) on their behalf.

Cheating in an exam

Using or having access to unauthorised materials in an exam or test.

Serious outcomes may be imposed if a student is found to have committed one of these breaches, up to and including expulsion from the University for repeated or serious acts.

ECU's policies and more information about academic integrity can be found on the student academic integrity website.

All commencing ECU students are required to complete the Academic Integrity Module.

Assessment Extension

In some circumstances, Students may apply to their Unit Coordinator to extend the due date of their Assessment Task(s) in accordance with ECU's Assessment, Examination and Moderation Procedures - for more information visit https://askus2.ecu.edu.au/s/article/000001386.

Special Consideration

Students may apply for Special Consideration in respect of a final unit grade, where their achievement was affected by Exceptional Circumstances as set out in the Assessment, Examination and Moderation Procedures - for more information visit https://askus2.ecu.edu.au/s/article/000003318.

ECF3120|4|1

School: Business and Law

This unit information may be updated and amended immediately prior to semester. To ensure you have the correct outline, please check it again at the beginning of semester.

Your unit may be subject to government or third party COVID-19 vaccination requirements. Please consider this before enrolling in this unit, and speak with the unit coordinator if this raises any concerns.

  • Unit Title

    Financial Modelling
  • Unit Code

    ECF3120
  • Year

    2022
  • Enrolment Period

    2
  • Version

    4
  • Credit Points

    15
  • Full Year Unit

    N
  • Mode of Delivery

    On Campus
    Online
  • Unit Coordinator

    Dr Jaime Li YONG

Description

This is a capstone unit for the finance major where students apply financial principles and theories from related first and second year units, to build adaptive financial models that solve complex problems and make recommendations to investor clients. The unit will develop students’ Excel skills beyond an intermediate level. This is achieved as students conceptualise the architecture and design of financial models, provide consideration for user interface, and debug constructed models for error handling and flexibility. In this unit, students will demonstrate the ability to communicate financial knowledge, concepts and advice persuasively in written and oral formats. Students are also required to collaborate effectively in team settings to produce measurable outcomes for clients. Students will conduct in-depth research on companies and academic literature in finance, to model and test theories using real-time financial market and economic data.

Prerequisite Rule

Students must have passed ECF2222 and ECF2226.

Learning Outcomes

On completion of this unit students should be able to:

  1. Construct robust financial models to solve problems for clients.
  2. Collaborate effectively in a team to comprehensively evaluate companies and make investment recommendations.
  3. Plan a contemporary research study using current financial market data, drawing from financial theories and academic literature to produce meaningful research findings.
  4. Communicate findings of financial analyses, in both oral and written formats, to specialist and non-specialist audiences.

Unit Content

  1. Spreadsheet modelling and model design.
  2. Financial databases and data presentation.
  3. Math and statistical functions.
  4. Conditional, time, logical, search and array functions.
  5. Conditional formatting and data validation.
  6. Time Value of Money functions: valuing cash flows, annuities and dividend discount models.
  7. Approaches to determining cost of capital.
  8. Pro forma financial statements, forecasting company cash flows and equity valuation.
  9. Risk and What-if analysis: Sensitivity and Scenario modelling.
  10. Simulation models.
  11. Empirical finance research.
  12. Regression analysis, hypothesis testing and forecasting.

Learning Experience

ON-CAMPUS

Students will attend on campus classes as well as engage in learning activities through ECU's LMS

JoondalupMount LawleySouth West (Bunbury)
Semester 113 x 3 hour labNot OfferedNot Offered
Semester 213 x 3 hour labNot OfferedNot Offered

For more information see the Semester Timetable

ONLINE

Students will engage in learning experiences via ECU’s LMS as well as additional ECU learning technologies

Additional Learning Experience Information

Unit delivery is aimed at developing students’ intermediate to advanced capabilities to conceptualise, design, build and test financial models using Excel. The unit assumes students have a strong grasp of finance principles and theories learned from pre-requisite units, and will build on this prior learning. The learning process will require students to work effectively in teams to produce insightful investment recommendations. Students will also be required to access real-time financial market and economic data from sources such as Thomson Reuters Refinitiv Eikon, IbisWorld, the Reserve Bank of Australia (RBA) and the Australian Bureau of Statistics (ABS). On-campus students are expected to attend weekly lab sessions to collaborate on group projects, seek feedback from instructors, and participate actively in order to refine project and assessment deliverables. Off-campus students are expected to collaborate online on a weekly basis for the group project and communicate regularly with instructors to refine project and assessment deliverables. All students are encouraged to use formal collaboration tools such as MS Teams or LMS Collaborate to facilitate groupwork processes outside of class time.

Assessment

GS1 GRADING SCHEMA 1 Used for standard coursework units

Students please note: The marks and grades received by students on assessments may be subject to further moderation. All marks and grades are to be considered provisional until endorsed by the relevant School Progression Panel.

ON CAMPUS
TypeDescriptionValue
TestTimed Exercises20%
ProjectMajor group equity valuation project50%
AssignmentIndividual research paper and video presentation30%
ONLINE
TypeDescriptionValue
TestTimed Exercises20%
ProjectMajor group equity valuation project50%
AssignmentIndividual research paper and video presentation 30%

Disability Standards for Education (Commonwealth 2005)

For the purposes of considering a request for Reasonable Adjustments under the Disability Standards for Education (Commonwealth 2005), inherent requirements for this subject are articulated in the Unit Description, Learning Outcomes and Assessment Requirements of this entry. The University is dedicated to provide support to those with special requirements. Further details on the support for students with disabilities or medical conditions can be found at the Access and Inclusion website.

Academic Integrity

Integrity is a core value at Edith Cowan University, and it is expected that ECU students complete their assessment tasks honestly and with acknowledgement of other people's work. This means that assessment tasks must be completed individually (unless it is an authorised group assessment task) and any sources used must be referenced.

Breaches of academic integrity can include:

Plagiarism

Copying the words, ideas or creative works of other people, without referencing in accordance with stated University requirements. Students need to seek approval from the Unit Coordinator within the first week of study if they intend to use some of their previous work in an assessment task (self-plagiarism).

Unauthorised collaboration (collusion)

Working with other students and submitting the same or substantially similar work or portions of work when an individual submission was required. This includes students knowingly providing others with copies of their own work to use in the same or similar assessment task(s).

Contract cheating

Organising a friend, a family member, another student or an external person or organisation (e.g. through an online website) to complete or substantially edit or refine part or all of an assessment task(s) on their behalf.

Cheating in an exam

Using or having access to unauthorised materials in an exam or test.

Serious outcomes may be imposed if a student is found to have committed one of these breaches, up to and including expulsion from the University for repeated or serious acts.

ECU's policies and more information about academic integrity can be found on the student academic integrity website.

All commencing ECU students are required to complete the Academic Integrity Module.

Assessment Extension

In some circumstances, Students may apply to their Unit Coordinator to extend the due date of their Assessment Task(s) in accordance with ECU's Assessment, Examination and Moderation Procedures - for more information visit https://askus2.ecu.edu.au/s/article/000001386.

Special Consideration

Students may apply for Special Consideration in respect of a final unit grade, where their achievement was affected by Exceptional Circumstances as set out in the Assessment, Examination and Moderation Procedures - for more information visit https://askus2.ecu.edu.au/s/article/000003318.

ECF3120|4|2