The complete Excel Templates package is available below in Microsoft Excel format. The individual files making up the manual are packaged below as a Windows .ZIP file. After saving the file to your hard drive, decompress it using one of the many utility applications available for both Windows and Macintosh computers.

Excel Templates - Complete

Click the links below to access the individual chapter files of the Excel Templates in Microsoft Excel format.

Chapter 02

Investment Returns

Chapter 03

Calculating Investment Returns

Chapter 05

Series Discounts

Chapter 06

CVP Analysis

Chapter 07

Calculator for Formula 7-2
Days Between Dates Calculator
Simple Interest Calculator

Chapter 08

Demand Loan Schedule

Chapter 09

FV and PV of a Single Payment
Formula 9-4 Calculator

Chapter 10

FV of Any Annuity
FV of Ord Simple Annuity
Interest Rate Conversion
NPER Function
RATE Function

Chapter 11

PV of Any Annuity
PV of Ord Simple Annuity

Chapter 12

NPER for Any Annuity
PMT for Any Annuity
RATE for Any Annuity

Chapter 14

FV and PV of Constant Growth

Chapter 15

CUMIPMT and CUMPRINC for Any Annuity
Loan Amortization Schedule

Chapter 16

PRICE of a Bond
Sinking Fund Schedule

Chapter 17

NPV and IRR Functions