Introduction

Chapter 1: Introduction to Excel 2007

Setup Spreadsheet for Chapter 1 is here

The setup for Day 2 is here

The setup for Day 3 is here

Word Example File

Amortization Table Model
Capital Budgeting Model

Formula sheet is here

Solutions to Chapter 1 problems are here

 Chapter 2: The Basic Financial Statements

Setup Spreadsheet for Chapter 2 is here

Day 2 Spreadsheet is here

The completed model is here.

Slides on the Statement of Cash Flows are here

Solutions for problems 1 and 2 are here

 Chapter 3: The Cash Budget

Setup Spreadsheet for Chapter 3 is here

Setup Spreadsheet for Day 2 is here

Timothy Mayes simulation add-in is here -- Download and save this file, double click to run it (nothing will seem to happen). Then open Excel and click on the Add-Ins tab. ExcelSim should appear as an add-in. Run it and follow the wizard to define the cells to change and to watch, and to specify the distribution and parameters for the changing cells.

Book Value/Market Value Comparison Spreadsheet

Solutions for all of the problems in the Chapter 3 are here. You should be able to work 1-3. The rest are there in case you need them. We will look at Problem 3 in class.

Exam 1

This exam will be taken in the classroom on one of the machines in our classroom. A setup spreadsheet will be provided to you with several problems, one long one and some short ones. The problems will be based on things we have done in class and in the assigned end-of-chapter problems. No additional materials are allowed. You may not use the internet (other than to get the assignment from BlackBoard) and you may not use email while you are working on this portion of the exam.

NOTE THAT YOUR TEST WILL INCLUDE AN OBJECTIVE QUESTION PART (True/False and Multiple Choice) THAT WILL COUNT FOR 25 POINTS OUT OF 100. This part will cover material that was discussed in class -- mostly concerning non-Excel topics.

The Fall 2009 exam setup and instructions are here. The Word picture for Problem 4 is here. The exam solution spreadsheet is here.

The Winter 2010 setup is here. The picture for the last problem is here. The solved exam is here.

This raw test (Spreadsheet portion) for Spring 2010 is here. The solved test is here.

Chapter 7: Time Value of Money

The setup spreadsheet for this chapter is here.
The Day 2 Version is here.

The Time Value problems discussed in class are here.
The spreadsheet for the time value problems is here.
The solved spreadsheet for the time value problems is here.

Amortization table handout with regular payments is here.
Amortization table handout with a balloon payment is here.

The framework for the amortization model is here.

Discussion will include this material:

Handout on brief overview of risk, return, and the CAPM

Spreadsheet for SML

Dr. Damodaran's historical data on equity risk premia from http://pages.stern.nyu.edu/~adamodar/New_Home_Page/data.html

Work all of the chapter problems in this section. The author's solutions are here.

Chapter 5: Financial Forecasting

Setup Spreadsheet is here.

Solutions to Problems 1 and 2 are here.

 

 Exam 2 - This exam will cover the material from Chapters 5 and 7 only

The Fall 2009 raw exam is here. The solved exam is here.
The Winter 2010 raw exam is here. The solved exam is here.

NOTE THAT YOUR TEST WILL INCLUDE AN OBJECTIVE QUESTION PART (True/False and Multiple Choice) THAT WILL COUNT FOR 25 POINTS OUT OF 100. This part will cover material that was discussed in class -- mostly concerning non-Excel topics.

The spreadsheet portion of the Spring 2010 raw exam is here. The solved exam is here.

 

 Chapter 11: Capital Budgeting

Setup Spreadsheet is here.

 Building a comprehensive capital budgeting model

The setup spreadsheet is here.

Day 2 setup spreadsheet is here.

Day 3 setup spreadsheet is here.

The completed model is here.

Solutions to Chapter 11 end-of-chapter problems are here.

Apr 13 and 15

Special Topics:

Macros and Controls

The Financial Calculator model we created in class is here.

Review for Exam -- Question and answer period

Exam 3

The raw exam from Fall 2009 is here. The solved exam is here.

The raw exam from Winter 2010 is here. The solved exam is here.

NOTE THAT YOUR TEST WILL INCLUDE AN OBJECTIVE QUESTION PART (True/False and Multiple Choice) THAT WILL COUNT FOR 25 POINTS OUT OF 100. This part will cover material that was discussed in class -- mostly concerning non-Excel topics.

HINTS: Almost all of our time was spent on the capital budgeting material and model. That is what you need to know how to do. Know how to do all of the operations we did in the large model that we created. I would not ask you to create an entire model with all of those features, but you should know how to do a basic capital budgeting setup (see the example tests) and you should know how to do any operation that we did in the model although I would put the mode complex operations in stand-alone problems. The objective portion (the 25 points in BlackBoard) will cover the concepts that we talked about and that are listed in the notes pages of the two models we used in class. We also talked about macros and controls, so you should know how to work with those in some simple ways.

The raw Exam 3 is here. The solved exam is here.

 

 Special Topics: Filters, Tables, Pivot Tables, and Pivot Charts

The setup spreadsheet is here.

The final exam is cumulative. It will re-test the material covered on the first three tests. Those tests and the solutions are posted on this page. You should know how to do everything on those three tests in a reasonable (short) period of time. If there is any "curve" on the final, it will be very very small as you now have very specific things to learn and master.

You have three options concerning the final exam:

1. If you took all three regular exams, you can opt not take the final and instead substitute the average of your three regular exam grades for the final exam grade.

2. If you missed one of the regular exams, you must take the final exam and the score you earn on it will count for the test you missed and for the final exam score.

3. If you took all three regular tests and you opt to take the final, the score you earn on the final will substitute for the lowest of the three regular exam scores in addition to counting for the final exam score.

NOTE: Taking the final under Option 1 above CANNOT HURT YOUR GRADE. If you take the final and do worse than the average of your three exam grades, the final will not be counted.

Grade Calculator:

To compute your grade before the final, and to estimate the score you would need on the final to make a particular letter grade, use this spreadsheet.