Principles of
Finance with Excel, 2^{nd} edition Note (January 2012): In my teaching this year, I’m trying something new. At the beginning of most of the classes, I give a short quiz. I let the students grade their own quizzes in class. The scores count for very little in the final grade, but serve to reinforce the material and give me a starting point for my lectures. I will post these quizzes as I give them; each one roughly covers a chapter of PFE. The course I’m teaching does Chapters 113, so not all chapters will be covered by a quiz. 


Introduction
to accounting—a chapter from PFE1 (I left this out of the second
edition, but am making the typescript available) 

Chapter 1 
8 principles of finance 

Chapter 2 
Future value and present value Excel functions: NPV, IRR, FV, PMT,
NPER, Goal Seek 

Chapter 3 
Don’t trust quoted interest rates Computing the effective annual
interest rate (EAIR) Excel functions: IRR, PMT, IPMT, PPMT,
Rate, NPV, PV, Exp, Ln,
Sum, Max, Goal Seek 
Case:
Confusion between APR and actual EAIR ·
Case ·
Answer Social security problem ·
Problem ·
Answer Car lease: Volt example ·
Problem ·
Answer 
Chapter 4 
NPV rule for choosing investments Excel functions: NPV, IRR, Data Table 
Case:
Extension of the real estate case of Chapter 4 ·
Case ·
Solution 
Chapter 5 
Problems with IRR Excel functions: IRR, NPV, Sum, PMT,
If, XNPV, XIRR 
TIPS case: ·
Case
(PDF) ·
Case
template (Excel) ·
Case
solution (PDF) ·
Case
solution (Excel) 
Chapter 6 
Funding cost as discount rate Excel functions: NPV, IRR, PMT 
Excel
spreadsheet for chapter 6 PPT.
This is a large (~13MB ) file containing many
Yahoo screen clips. 
Chapter 7 
Building a financial planning model Excel functions: NPV, Sum, If, Data
Tables, circular references 
For more advanced valuation models, PowerPoints, and issues, see Chapter 16 materials. 