# Course information

Language English
Course ECTS 7.5 ECTS
Type Elective
Level Bachelor
Duration Summer
Start time of the course Summer
Timetable Course schedule will be posted at calendar.cbs.dk
Max. participants 120
Study board
Course coordinator
• Course instructor - Dr Hassan Tanha, Victoria University, ht.acc@cbs.dk
Sven Bislev - Department of Management, Society and Communication (MSC)
• Finance
Last updated on 25/04/2018

Learning objectives
To achieve the grade 12, students should meet the following learning objectives with no or only minor mistakes or errors:
• Calculate time value of money, and use capital budgeting
• Produce a portfolio analysis, capital asset pricing model (CAPM) and the security market line (SML)
• Work with valuation: Bonds and Stocks
• Analyse options: Strategies and pricing (Black-Scholes and Binomial)
Course prerequisites
At least one Introductory course in finance (It is essential to be familiar with time value of money, NPV,IRR and also the basics of the capital asset pricing model- CAPM,SML,beta) plus an introductory course in financial accounting and a basic knowledge of Excel.
Examination
Course content and structure

In this class you will learn to implement in Excel using Data Tables and many Excel financial functions the financial concepts. These concepts include:
-Capital budgeting and time value of money
-Corporate, bonds and stock valuation models:
-Portfolio analysis, capital asset pricing model (CAPM) and the security market line (SML)
-Measuring investment performance
-Options: strategies and pricing
The combination of Excel and finance is a necessity for students wishing to enter the finance job market! This course combines the basic theory of finance with intensive implementation of all concepts in Excel. The result is that you will better understand the financial theory and (of course) will come out equipped with Excel skills.

Preliminary assignment

Class 1: Class 1: Background to Excel: In-class discussion of Data Tables, very basic VBA, and Excel’s personal notebook (PFE, Chapters24- 29). Time value of money (PFE, Chapter 2)

Class 2: Time value of money (PFE, Chapters 2, 3)

Class 3: Capital budgeting (PFE, Chapters 4, 5 and 6)

Class 4: Free cash flows, simplified valuation model, financial modelling - valuing a company with Yahoo data (PFE, Chapter 7)

Class 5: Introduction to risk, portfolio mathematics, and portfolio returns and the efficient frontier (PFE, Chapters 8, 9, 10)

Class 6: Capital asset pricing model (CAPM), measuring investment performance (SML), and SML and the cost of capital (PFE, Chapters 11, 12 and 13)

Feedback activity

Class 7: Bond Valuation: Treasury Bills, Treasury Bonds, yield curve, YTM, callable bonds and preferred stocks (PFE, Chapter 15).

Class 8: Valuing Stocks: Discounted cash flows, free cash flows (FCF)• Cost of capital, cost of equity, cost of debt, weighted average cost of capital (WACC) • Equity premium • Beta, equity beta, asset beta • Two-stage growth models (PFE, Chapter 16).

Class 9: Options:  concepts (cash flows of options; option strategies); Option pricing restrictions:  No early exercise of calls; Put-call parity; Early exercise of American puts; Option price convexity (PFE, Chapters 20, 21).

Class 10: Black-Scholes formula Stock price volatility; Implied volatility (Chapter 22)

Class 11: Binomial model and replicating portfolio (chapter 23)
Comprehensive Review

Teaching methods
I teach interactively—a combination of lecture, theory of finance, Excel. I expect students to follow along with my lectures, implementing in Excel the models that are explained in class.
Feedback during the teaching period
TBA
 Preliminary assignment 20 hours Classroom attendance 33 hours Preparation 126 hours Feedback activity 7 hours Examination 20 hours
Further Information

Preliminary Assignment: To help students get maximum value from ISUP courses, instructors provide a reading or a small number of readings or video clips to be read or viewed before the start of classes with a related task scheduled for class 1 in order to 'jump-start' the learning process.

Course timetable is available on https://www.cbs.dk/uddannelse/international-summer-university-programme-isup/courses-and-exams.

We reserve the right to cancel the course if we do not get enough applications. This will be communicated on https://www.cbs.dk/uddannelse/international-summer-university-programme-isup/courses-and-exams end February 2018 at the latest.

Expected literature