EDITH COWAN UNIVERSITY 
ECF3120 - Financial Modelling 
Final Examination Guide and Notes 2024 
 
Part 01. About This Guide 
Part 02. Sample Final Examination Paper 
Part 03. Suggested Solutions to Final Exam Paper 
Part 04. Final Examination - Hints and Tips 
 
The 24/7 Online Support You Deserve 
Need to reach out to us with questions or for help? You’ll connect with a private tutor who is extremely passionate about the unit to provide assistance and help ensure that you’re on the right track to graduating. 
 
Looking for more study resources? 
Find out about all the services and resources available for students at 
Edith Cowan University

Edith Cowan University - ECF3120: Financial Modelling (Solutions)

$35.00

ACADEMIC YEAR 2023 - 2024

University	Edith Cowan University
Study Level	Undergraduate
Unit Code	ECF3120
Unit Name	Financial Modelling
Notes Title	Final Examination Guide and Notes
Format	PDF
Page Length	35

This guide allows students to understand how the ECF3120: Financial Modelling, Edith Cowan University - Final Examination 2024 will be assessed, structured and the likely style and range of questions that would be asked. This self-study set has been thoroughly updated to cover all of the examinable topics covered in the latest edition of the final exam. You do not need to be an expert in the course, you just need a basic understanding and be able to quickly recall the information that you learn. You can use these notes as a reference, to understand the topics better and improve your grades in the final exam.

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.

✔ Key areas of study:

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

UNIT CODE	UNIT NAME
ACC1100	Accounting I
ACC2250	Accounting II
ACC2350	Cost Accounting
ACC2700	Financial Reporting Standards
ECF1110	Economics I
ECF1120	Finance I
ECF2210	Capital Markets
ECF2222	Corporate Finance
ECF2226	Investment Finance
ECF3120	Financial Modelling
ECF3312	Financial Institutions Management
LAW1100	Legal Framework I
LAW2410	Income Tax Framework II
MAN1100	Management
MKT1600	Marketing Principles and Practices
MKT2605	Promotional Marketing
SBL1300	Business Environments and Markets
SBL1400	Introduction to Business Analytics

Edith Cowan University - ECF3120: Financial Modelling (Solutions)

INFORMATION

UNIT DESCRIPTION

RELATED UNITS