UTS – 25705 Financial Modelling and Analysis

25705 – Financial Modelling and Analysis

University of Technology Sydney | UTS Business School

 

🎯 Course Overview

This subject focuses on applied statistical and financial modelling using Excel. Students learn forecasting, regression, and model evaluation techniques within real-world financial contexts.

🎓 Learning Outcomes

  • Apply statistical methods to financial analysis
  • Build and evaluate forecasting and regression models
  • Use Excel for spreadsheet-based modelling

📅 Key Topics by Week

  • W1: Descriptive statistics
  • W2–3: Confidence intervals & hypothesis testing
  • W4–5: Forecasting & model accuracy
  • W6–9: Linear regression & model issues
  • W10–11: Excel modelling applications
  • W12: Final review

📝 Assessment

  • 2 Quizzes (20%)
  • 1 Individual Case Study (20%)
  • Final Exam (60%)

📚 Textbook

Hanke & Wichern, Business Forecasting, 9th Edition, Pearson