301337 (v.3) Finance (Analysis) 506


 

Area:School of Economics and Finance
Credits:25.0
Contact Hours:3.0
Lecture:1 x 2 Hours Weekly
Laboratory:1 x 1 Hours Weekly
Prerequisite(s):13317 (v.2) Finance (Introductory) 501 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 exam 30%, Major group assignment 40%, Minor group assignment 20%, Weekly lab participation 10%. This is by grade/mark assessment.
YearLocationPeriodInternalArea ExternalCentral External
2004Bentley CampusSemester 1Y  
2004Bentley CampusSemester 2Y  

 

Copyright and Disclaimer
Current as of: February 2, 2004
CRICOS provider code 00301J