Owner's Manual

Table Of Contents
50 Cash Flow Worksheet
Example: Value of a Lease with Uneven Payments
A lease with an uneven payment schedule usually accommodates seasonal or
other anticipated fluctuations in the lessees cash position.
A 36-month lease has the following payment schedule and beginning-of-
period payments.
Number of Months Payment Amount
4 $0
8 $5000
3 $0
9 $6000
2 $0
10 $7000
If the required earnings rate is 10% per 12-month period with monthly
compounding:
What is the present value of these lease payments?
What even payment amount at the beginning of each month would result
in the same present value?
Because the cash flows are uneven, use the Cash Flow worksheet to
determine the net present value of the lease.
Computing NPV
The cash flows for the first four months are stated as a group of four $0 cash
flows. Because the lease specifies beginning-of-period payments, you must
treat the first cash flow in this group as the initial investment (
CFo) and enter the
remaining three cash flows on the cash flow screens (C01 and F01).
Note: The BGN/END setting in the TVM worksheet does not affect the Cash
Flow worksheet.