This page contains the spreadsheets which we used in class. If you would like copies for your own use, you may down load them
¨ Finance Basics: Present Value Examples. At the end of the Finance Basics outline there are a few present value calculations. The enclosed excel spreadsheet was used to calculate the numbers in the example. If you are interested in how I calculated the annual payment on the car loan or the remaining loan balance, the numbers are here.
¨ Energy Gel Case.
· Case Exhibits. To speed your preparation, I have entered the data from Exhibit 5. To value the Energy Gel project you want to discount the projected cash flows at the cost of capital. Many, but not all of the numbers, you will need are contained in Exhibit 5.
· Possible Answers. This file contains the spreadsheets which I generated to value HPC’s possible entry into and investment in the energy gel market.
¨
· Case Exhibits. To speed your preparation, I have entered the data from Exhibit 1 through 7. To value the West Teleservice we will calculate both a multiples valuation and a DCF valuation. Many of the numbers you need should be contained in these exhibits.
·
Possible
Answers This file contains the
spreadsheets which I generated to value
[Finance Department] [Kellogg School of Management] [Northwestern University]
If you have questions about this web page, please e-mail
me.