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 Analysis and Modelling
  • Unit Code

    ECF6130
  • Year

    2016
  • Enrolment Period

    1
  • Version

    1
  • Credit Points

    20
  • Full Year Unit

    N
  • Mode of Delivery

    On Campus

Description

This unit provides students with the skills required to undertake financial analysis and modelling using Microsoft Excel. With the intensive use of Excel in businesses, these skills are highly desired by employers. The unit covers both the conceptual and practical aspects of financial analysis and modelling. Besides providing students with a powerful Excel toolkit, this unit also teaches students the construction of financial models, giving consideration to architecture, user interface, error handling, and flexibility.

Prerequisite Rule

Students must pass ECF6110

Learning Outcomes

On completion of this unit students should be able to:

  1. Analyse financial data in a variety of financial scenarios.
  2. Appraise and analyse financial risk in project and share investments.
  3. Design, plan, develop, construct and debug single-workbook financial models.
  4. Model and forecast financial statements and cash flows.
  5. Select and apply appropriate Excel functions and controls in the analysis and modelling of financial data.
  6. Value a select range of financial assets.

Unit Content

  1. Single-workbook model design.
  2. Financial risk analysis.
  3. Excel toolkit.
  4. What-if analysis.
  5. Valuation of annuities and bonds; financial planning and amortisation.
  6. Valuation of shares; leverage analysis
  7. Estimation and forecasting using regression.
  8. Simulation.
  9. Optimisation: Linear, nonlinear and integer programming
  10. Financial statements modelling, leverage analysis, and cash flow forecasting.

Additional Learning Experience Information

Students attend weekly three-hour seminars. Unit delivery is aimed at developing students' capabilities in Excel skills, which are crucial for building complex financial models. The learning process will involve students working in teams to generate ideas in order to solve financial modelling problems, in a computer laboratory setting.

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
ProjectProject 120%
ProjectProject 220%
Examination ^Final examination60%

^ Mandatory to Pass

Text References

  • ^ Winston, W. L. (2014). Microsoft Office Excel 2013: Data analysis and business modelling. Redmond, Washington: Microsoft Press.
  • ^ Dodge, M., & Stinson, C. (2014). Microsoft Office Excel 2013 inside out. Redmond, Washington: Microsoft Press (optional).
  • Benninga, S. (2014). Financial modelling. (4th ed.). Cambridge: MIT Press.
  • Day, A. L. (2001). Mastering financial modelling: A practitioner's guide to applied corporate finance. London: Prentice Hall.
  • Sengupta, C. (2004). Financial modelling: Using Excel and VBA. Hoboken, New Jersey: John Wiley & Sons.

Journal References

  • Interfaces

^ Mandatory reference


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.

ECF6130|1|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 Analysis and Modelling
  • Unit Code

    ECF6130
  • Year

    2016
  • Enrolment Period

    2
  • Version

    1
  • Credit Points

    20
  • Full Year Unit

    N
  • Mode of Delivery

    On Campus

Description

This unit provides students with the skills required to undertake financial analysis and modelling using Microsoft Excel. With the intensive use of Excel in businesses, these skills are highly desired by employers. The unit covers both the conceptual and practical aspects of financial analysis and modelling. Besides providing students with a powerful Excel toolkit, this unit also teaches students the construction of financial models, giving consideration to architecture, user interface, error handling, and flexibility.

Prerequisite Rule

Students must pass ECF6110

Learning Outcomes

On completion of this unit students should be able to:

  1. Analyse financial data in a variety of financial scenarios.
  2. Appraise and analyse financial risk in project and share investments.
  3. Design, plan, develop, construct and debug single-workbook financial models.
  4. Model and forecast financial statements and cash flows.
  5. Select and apply appropriate Excel functions and controls in the analysis and modelling of financial data.
  6. Value a select range of financial assets.

Unit Content

  1. Single-workbook model design.
  2. Financial risk analysis.
  3. Excel toolkit.
  4. What-if analysis.
  5. Valuation of annuities and bonds; financial planning and amortisation.
  6. Valuation of shares; leverage analysis
  7. Estimation and forecasting using regression.
  8. Simulation.
  9. Optimisation: Linear, nonlinear and integer programming
  10. Financial statements modelling, leverage analysis, and cash flow forecasting.

Additional Learning Experience Information

Students attend weekly three-hour seminars. Unit delivery is aimed at developing students' capabilities in Excel skills, which are crucial for building complex financial models. The learning process will involve students working in teams to generate ideas in order to solve financial modelling problems, in a computer laboratory setting.

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
ProjectProject 120%
ProjectProject 220%
Examination ^Final examination60%

^ Mandatory to Pass

Text References

  • ^ Winston, W. L. (2014). Microsoft Office Excel 2013: Data analysis and business modelling. Redmond, Washington: Microsoft Press.
  • ^ Dodge, M., & Stinson, C. (2014). Microsoft Office Excel 2013 inside out. Redmond, Washington: Microsoft Press (optional).
  • Benninga, S. (2014). Financial modelling. (4th ed.). Cambridge: MIT Press.
  • Day, A. L. (2001). Mastering financial modelling: A practitioner's guide to applied corporate finance. London: Prentice Hall.
  • Sengupta, C. (2004). Financial modelling: Using Excel and VBA. Hoboken, New Jersey: John Wiley & Sons.

Journal References

  • Interfaces

^ Mandatory reference


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.

ECF6130|1|2