See page 241 in the text, as well as the Chapter 9 Excel Spread Sheets found in the
Additional Instructor Resources & Solutions folder.
One way to calculate this is to use Excel’s PMT function.
Just multiply the result of the PMT calculation by 25 for the total number of years; for a 5%
interest, the total payments are $177,381,143.25. For the 7% interest rate, it is
Responses to Questions
This case analysis asks students to devise a public financing plan for an NBA arena in
Sacramento, California. Similar to the exhibits in the chapter (e.g., Exhibits. 9.9, 9.10),
students should create a table showing the various sources and to what extent they’ll cover
the cost of construction. Additionally, students needs to measure (see Question 5) the total
payments to show that they can calculate the interest, etc.
See the resources for Chapter 9 in the Additional Instructor Resources & Solutions folder;
specifically, see Chapter 9 Excel Spread Sheet and Case Study PDFs.
2. In the Excel spread sheet (found in the Additional Instructor Resources & Solutions
folder), one worksheet shows a sample financing plan that uses property taxes, sales
taxes, and hotel taxes. The final worksheet calculates the annual payments needed to
3. Also in the Additional Instructor Resources & Solutions folder are some case study
documents for this chapter (in PDF format); they show some of the information needed
to make the calculations. For example, what is the current sales tax rate, and how much
would it need to be raised to generate a certain amount of additional revenue? I’ve