Filter
Top Products
50 Cash Flow Worksheet
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.
9 $6000
2$0
10 $7000
To Press Display
Set all variables to defaults. & } !
RST
0.00
Select Cash Flow worksheet. '
CFo= 0.00
Enter first group of cash flows. #
# 3 !
C01=
F01=
0.00
3.00
Enter second group of cash
flows.
#
5000 S !
#
8 !
C02=
F02=
-5000.00
8.00
Number of Months Payment Amount