INTRODUCTION TO FINANCE WITH EXCEL

Instructor:  Simon Benninga, Tel Aviv University

 

Buy the book on Amazon

This is the website for an introductory finance course given by Simon Benninga at Tel Aviv University, December 2012 - January 2013. The course is based on my book Principles of Finance with Excel.

The materials on this website are available to my students in the Sofaer International MBA program (http://imba.tau.ac.il ) and to individuals who have requested logins. If you are not a Sofaer IMBA student and want access, click here to get a login.

Course syllabus

A word to Mac users

 

Session

Contents

Video

18dec2012

Class 1 overview

PFE, Chapter 1 Powerpoint:  what is finance?

PFE, Chapter 2 Powerpoint:  time value of money

PFE, Chapter 27 Powerpoint:  data tables

Class spreadsheet

Class1 homework:

·      Word file

·      Excel template

·      Answers

Video

20dec2012

Class 2 overview

Class spreadsheet

Class1 homework:

·      Word file

·      Excel template

·      Answers

PFE, Chapter 3 Powerpoint

Partial video

25dec2012

Class 3 overview

Social security case

·      Case

·      Solution

PFE, Chapter 4 Powerpoint

Video

27dec2012

Class 4 overview

PFE, Chapter 5 Powerpoint

Video

1jan2012

Class participates in Wharton

3jan2012

Continuation of Chapter 5

Video

8jan2012

Class cancelled [weather]

 

10jan2012

Class cancelled [snow]

 

15jan2012

Building pro forma models
PFE Chapter 7

Template with answers

Video

17jan2012

Class1

Models of fixed assets

PPG case

Personal notebook in Excel

 

17jan2012

Class2

Introduction to portfolio

PFE Chapter 8

PFE Chapter 9

Video

24jan2012

PFE Chapter 10

PFE Chapter 11

Class file

Video

 

Last year’s final exam with answers

·      Exam

·      Answers

Note that this year’s final exam is cumulative


 
 

 

 

 

TO GET A LOGIN

For students not in this class:  You can write me at benninga@tau.ac.il to get a personal login to the materials.  When you write, tell me:

·      Your full name

·      Email address

·      Current occupation or place of study (or both)

·      Something about your background (for example:  have you had a finance class?  Do you use Excel or finance in your current occupation?)

The support given to electronic logins is limited to the materials on this website.


 

 

 

 

 

 

 

View My Stats