Finance with Excel - CB9060

Looking for a different module?

Module delivery information

Location Term Level1 Credits (ECTS)2 Current Convenor3 2020 to 2021
Canterbury
(version 2)
Spring 7 15 (7.5) DR N Voukelatos checkmark-circle

Overview

This module provides a general introduction to the use of Microsoft Excel in financial applications.
Subjects are:
Excel Essentials
Basic Financial Calculations with Excel (PV and FV, with applications to stock valuation; building loan tables)
Essential Probability and Statistics with Excel
Bond & Stock Analysis (bond pricing, duration and convexity, the yield curve, stock valuation using the DDM)
Portfolio Optimization (building efficient frontiers; constrained optimization)
Derivatives Modelling in Excel
Advanced Modelling: VBA for Financial Applications

Details

This module appears in the following module collections.

Contact hours

Total contact hours: 36
Private study hours: 114
Total study hours: 150

Method of assessment

Main assessment methods
Individual Coursework (2000 words) (30%)
Excel Based Project (70%)

Reassessment method:
100% coursework

Indicative reading

Benninga, S. (2008) Financial Modelling, third edition, MIT Press.

Alexander, C. (2008) Market Risk Analysis, Vol 1: Quantitative Methods in Finance, Wiley.

Holden, C.W. (2012) Excel Modelling in Investments, fourth edition, Pearson.

Jackson, M. and M. Staunton (2001) Advanced Modelling in Finance using Excel and VBA, Wiley.

See the library reading list for this module (Canterbury)

Learning outcomes

The intended subject specific learning outcomes.
On successfully completing the module students will be able to:
- perform essential financial calculations using Microsoft Excel;
- use Excel statistical and probabilistic functions and features for financial applications;
- carry out bond-related calculations using Excel;
- use Excel for stock analysis;
- use Excel for portfolio optimization;
- implement well-known derivatives models into Excel.

The intended generic learning outcomes.
On successfully completing the module students will be able to:
- set-up a professional Microsoft Excel spreadsheet;
- translate theoretical problems or models into spreadsheet applications;
- present and analyse real market data;
- understand and correctly interpret financial results obtained using Excel;
- use Microsoft Excel functions as well as other important features for financial applications.

Notes

  1. Credit level 7. Undergraduate or postgraduate masters level module.
  2. ECTS credits are recognised throughout the EU and allow you to transfer credit easily from one university to another.
  3. The named convenor is the convenor for the current academic session.
Back to top

University of Kent makes every effort to ensure that module information is accurate for the relevant academic session and to provide educational services as described. However, courses, services and other matters may be subject to change. Please read our full disclaimer.