Post Reply 
(11C) Purchase or Lease
09-25-2018, 10:24 AM (This post was last modified: 09-26-2018 01:39 AM by Gamo.)
Post: #1
(11C) Purchase or Lease
This program is the "Discount Cash Flow Analysis" to find NPV or
Net Present Value.

This program was from the HP-11C Solutions Handbook

I found this interesting that the example shown two set of data, one for
Purchase and another for Lease.
This program help you to choose which one is the best choice.

Procedure:

[A] Initial Investment
[B] Periodic Interest
[C] Key in the number of equal cash flow if greater than 1
[D] Net Present Value
[E] Review # of Cash Flow

Program:
Code:

LBL A  // Initial Investment
STO 0
0
STO 5
1
STO 2
RCL 0
CHS
RTN
-----------------------------------
LBL B  // I(%)
EEX 
2
÷
STO 1
LSTx
x
RTN
----------------------------------
LBL C  // Numbers of equal cash flow
STO 2
RTN
----------------------------------
LBL D  // NPV
STO 3
1
RCL 1
+
RCL 2
STO+5
Y^X
STO 4
RCL 0
x
RCL 4
1
-
RCL 1
÷
RCL 3
x
+
STO 0
1
RCL 1
+
RCL 5
Y^X
÷
1
STO 2
Rv
RTN
-----------------------------------------------------
LBL E    // Review # of Cash Flow
RCL 5
RTN

Registers

R0: NPV
R1: i / 100
R2: # of equal CF
R3: CF
R4: (1+n)^n
R5: Σn
R6-R9: Unused

Example:

Company needs a new photocopier and is considering leasing the equipment
as an alternative to buying. The end of the year net cost of each option is:

Purchase

Year Net Cash Cost
1 533
2 948
3 1,375
4 1,815
5 2,270

Total Net Cash Cost 6,941

-------------------------------------------------------

Lease

Year
1 1,310
2 1,310
3 1,310
4 1,310
5 1,310

Total Net Cash Cost 6,550

----------------------------------------------------
Looking at the total cost, leasing appears to be less, But purchasing
costs less the first two years. He known that he can make a 15% return
on every dollar he puts in the business; the sooner he can reinvent money,
the sooner he earn 15%. Therefore, he decides to consider the timing of the
costs, discounting the cash flows at 15% to find the present value of the
alternatives. Which options should he choose?
------------------------------------------------------

Purchase:
0 [A]
15 [B]
533 [D] 948 [D] display 1,180.30
1375 [D] 1815 [D] display 3,122.12
2270 [D] answer 4,250.71

Lease:
0 [A] 5 [C] 1310 [D] answer 4,391.32

-----------------------------------------------------
Leasing has a present value of 4391.32, while purchasing has a
present value of 4250.71.
Since these are both expense items, the lowest present value is the most
desirable. So, in this case, purchasing is the least costly alternative.
-----------------------------------------------------

Gamo
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
(11C) Purchase or Lease - Gamo - 09-25-2018 10:24 AM
RE: (11C) Purchase or Lease - Albert Chan - 09-25-2018, 01:28 PM
RE: (11C) Purchase or Lease - Dieter - 09-25-2018, 04:27 PM
RE: (11C) Purchase or Lease - Albert Chan - 09-25-2018, 06:36 PM
RE: (11C) Purchase or Lease - Gamo - 09-26-2018, 02:11 AM
RE: (11C) Purchase or Lease - Dieter - 09-26-2018, 05:40 AM
RE: (11C) Purchase or Lease - Gamo - 09-26-2018, 07:37 AM
RE: (11C) Purchase or Lease - Albert Chan - 09-26-2018, 12:53 PM
RE: (11C) Purchase or Lease - Dieter - 09-26-2018, 06:59 PM
RE: (11C) Purchase or Lease - Gamo - 09-27-2018, 01:23 AM
RE: (11C) Purchase or Lease - Dieter - 09-30-2018, 05:45 PM



User(s) browsing this thread: 1 Guest(s)