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.

  • Unit Title

    Financial Modelling
  • Unit Code

    ECF3120
  • Year

    2019
  • Enrolment Period

    1
  • Version

    2
  • Credit Points

    15
  • Full Year Unit

    N
  • Mode of Delivery

    On Campus
    Online
  • Unit Coordinator

    Dr Jaime Li YONG

Description

The unit is designed to introduce the conceptual and practical aspects of financial modelling using Microsoft Excel. Students learn to design spreadsheet solutions for specialist individual users and spreadsheet models for non-specialist end-users. Spreadsheet models are more complex than spreadsheet solutions and require a much more disciplined approach where consideration is given to architecture, user interface, error handling and flexibility. Students are expected to use and apply financial knowledge from pre-requisite unit(s) to build financial models and solutions. In this unit, students will develop a framework for systematic and justified approaches to problem solving.

Prerequisite Rule

Students must have passed ECF2226.

Learning Outcomes

On completion of this unit students should be able to:

  1. Analyse possible financial risk in project and share investment.
  2. Conduct various kinds of data analysis including charting, estimation and forecasting, optimisation, what-if analysis and simulation.
  3. Demonstrate proficiency in Excel spreadsheet manipulation andcontrol.
  4. Model financial statements models for the purpose of forecasting, valuation and what-if analysis.
  5. Plan, develop and debug a financial model.
  6. Value investment projects, shares, bonds, and companies.

Unit Content

  1. Spreadsheet modelling and model design.
  2. Excel basics: Statistical, mathematical, conditional, time, logical, search, and array functions, conditional formatting, data validation, charting and debugging error values.
  3. What-if analysis: Sensitivity and scenario analysis.
  4. Valuation of annuities, bonds and shares.
  5. Estimation and forecasting with regression analysis.
  6. Simulation.
  7. Optimisation: Linear, nonlinear and integer programming.
  8. Financial statements modelling and valuation of companies.
  9. Risk analysis.

Learning Experience

Students will attend on campus classes as well as engage in learning activities through ECU Blackboard.

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

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 Board of Examiners.

ON CAMPUS
TypeDescriptionValue
TestIn-class tests20%
ProjectMajor group project50%
AssignmentIndividual assignment30%

Core Reading(s)

  • Winston. (2016). Microsoft Excel 2016 data analysis and business modeling. Redmond: Microsoft Press. Retrieved from https://ecu.on.worldcat.org/oclc/952370664

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 Misconduct

Edith Cowan University has firm rules governing academic misconduct and there are substantial penalties that can be applied to students who are found in breach of these rules. Academic misconduct includes, but is not limited to:

  • plagiarism;
  • unauthorised collaboration;
  • cheating in examinations;
  • theft of other students' work;

Additionally, any material submitted for assessment purposes must be work that has not been submitted previously, by any person, for any other unit at ECU or elsewhere.

The ECU rules and policies governing all academic activities, including misconduct, can be accessed through the ECU website.

ECF3120|2|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.

  • Unit Title

    Financial Modelling
  • Unit Code

    ECF3120
  • Year

    2019
  • Enrolment Period

    2
  • Version

    2
  • Credit Points

    15
  • Full Year Unit

    N
  • Mode of Delivery

    On Campus
    Online
  • Unit Coordinator

    Dr Jaime Li YONG

Description

The unit is designed to introduce the conceptual and practical aspects of financial modelling using Microsoft Excel. Students learn to design spreadsheet solutions for specialist individual users and spreadsheet models for non-specialist end-users. Spreadsheet models are more complex than spreadsheet solutions and require a much more disciplined approach where consideration is given to architecture, user interface, error handling and flexibility. Students are expected to use and apply financial knowledge from pre-requisite unit(s) to build financial models and solutions. In this unit, students will develop a framework for systematic and justified approaches to problem solving.

Prerequisite Rule

Students must have passed ECF2226.

Learning Outcomes

On completion of this unit students should be able to:

  1. Analyse possible financial risk in project and share investment.
  2. Conduct various kinds of data analysis including charting, estimation and forecasting, optimisation, what-if analysis and simulation.
  3. Demonstrate proficiency in Excel spreadsheet manipulation andcontrol.
  4. Model financial statements models for the purpose of forecasting, valuation and what-if analysis.
  5. Plan, develop and debug a financial model.
  6. Value investment projects, shares, bonds, and companies.

Unit Content

  1. Spreadsheet modelling and model design.
  2. Excel basics: Statistical, mathematical, conditional, time, logical, search, and array functions, conditional formatting, data validation, charting and debugging error values.
  3. What-if analysis: Sensitivity and scenario analysis.
  4. Valuation of annuities, bonds and shares.
  5. Estimation and forecasting with regression analysis.
  6. Simulation.
  7. Optimisation: Linear, nonlinear and integer programming.
  8. Financial statements modelling and valuation of companies.
  9. Risk analysis.

Learning Experience

Students will attend on campus classes as well as engage in learning activities through ECU Blackboard.

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

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 Board of Examiners.

ON CAMPUS
TypeDescriptionValue
TestIn-class tests20%
ProjectMajor group project50%
AssignmentIndividual assignment30%

Core Reading(s)

  • Winston. (2016). Microsoft Excel 2016 data analysis and business modeling. Redmond: Microsoft Press. Retrieved from https://ecu.on.worldcat.org/oclc/952370664

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 Misconduct

Edith Cowan University has firm rules governing academic misconduct and there are substantial penalties that can be applied to students who are found in breach of these rules. Academic misconduct includes, but is not limited to:

  • plagiarism;
  • unauthorised collaboration;
  • cheating in examinations;
  • theft of other students' work;

Additionally, any material submitted for assessment purposes must be work that has not been submitted previously, by any person, for any other unit at ECU or elsewhere.

The ECU rules and policies governing all academic activities, including misconduct, can be accessed through the ECU website.

ECF3120|2|2