300956 (v.3) Finance (Analysis) 206
| Area: | School of Economics and Finance |
| Credits: | 25.0 |
| Contact Hours: | 4.0 |
| Laboratory: | 1 x 2 Hours Weekly |
| Seminar: | 1 x 2 Hours Weekly |
| Prerequisite(s): | 2806 (v.5) Finance (Introductory) 201 or any previous version
OR
12607 (v.3) Finance (Principles) 215 or any previous version
|
| Syllabus: | Integration of finance theory and spreadsheet techniques. Financial ratios, leverage analysis, cost of capital, financial mathematics, capital budgeting, risk and statistical analysis, portfolio theory,macros and visual basic. Quantifying and programming financial problems. |
| |
| Unit Outcomes: | On successful completion of this unit students will have- Been Introduced to Microsoft Excel. Will have begun to develop good financial modelling habits and advanced financial modelling skills. Have an understanding of financial modelling techniques as they are typically applied in commerce. Discovered the analytical power available through financial modelling. |
| Text and references listed above are for your information only and current as of September 30, 2003. Please check with the unit coordinator for up-to-date information. |
| Unit References: | Benninga, S., (1997), Financial Modeling,The MIT Press. Benninga, S., and Sarig, 0. H., (1977), Corporate Finance; A Valuation Approach, McGraw Hill. Hallberg, B., Kinkoph, S., et al., (1997), Using Microsoft Excel 97, QUE. Webb, J., (1996), Using Excel Visual Basic for Applications, QUE. |
| Unit Texts: | Beaman, I.R., Ratnatunga, J.A., Krueger, P. and Mudalige, N.(2001) Financial Modelling, 3rd ed, Quill Press. |
| |
| Unit Assessment Breakdown: | Final Examination 30%. Major Group Assignment 40%. Minor Group Assignment 20%. Weekly Lab Participation 10%. This is by grade/mark assessment. |
| Year | Location | Period | Internal | Area External | Central External | | 2004 | Bentley Campus | Semester 1 | Y | | Y | | 2004 | Bentley Campus | Semester 2 | Y | | Y | | 2004 | Joondalup Campus | Semester 1 | Y | | | | 2004 | Joondalup Campus | Semester 2 | Y | | | | 2004 | Mktg Inst of S'pore | Trimester 1A | Y | | | | 2004 | UHK SPACE Main Campus | Trimester 2A | Y | | | |
Current as of: February 2, 2004
CRICOS provider code 00301J
