Texas Instruments BA-20 Profit Manager User Manual - Page 53

Computing NPV

Get Texas Instruments BA-20 Profit Manager PDF manuals and user guides View all Texas Instruments BA-20 Profit Manager manuals
Add to My Manuals
Save this manual to your list of manuals

Page 53 highlights

• 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. To Press Display Set all variables to defaults. Select Cash Flow worksheet. & } ! ' RST CFo= 0.00 0.00 Enter first group of cash flows. # # 3 ! C01= F01= 0.00 3.00 Enter second group of cash flows. # 5000 S ! C02= # 8 ! F02= -5000.00 8.00 Enter third group of cash flows. # # 3 ! C03= F03= 0.00 3.00 Enter fourth group of cash flows. # 6000 S ! C04= # 9 ! F04= -6000.00 9.00 Enter fifth group of cash flows. # # 2 ! C05= F05= 0.00 2.00 Enter sixth group of cash flows. # 7000 S ! C06= # 10 ! F06= -7000.00 10.00 Select NPV. ( I= 0.00 Cash Flow Worksheet 49

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
Cash Flow Worksheet
49
•
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.
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
Enter third group of cash
flows.
#
#
3
!
C03=
F03=
0.00
3.00
Enter fourth group of cash
flows.
#
6000
S
!
#
9
!
C04=
F04=
-6000.00
9.00
Enter fifth group of cash flows.
#
#
2
!
C05=
F05=
0.00
2.00
Enter sixth group of cash flows.
#
7000
S
!
#
10
!
C06=
F06=
-7000.00
10.00
Select
NPV
.
(
I=
0.00