How to enter repeated cash flows with Nj

When the same amount repeats for several years, enter it once and say how many times it occurs with gNjFV.

Problem

A rental property costs $120,000. It nets $18,000 a year for 5 years, $25,000 a year for the next 3, and you sell it for $60,000 at the end of year 9. What are its IRR and its NPV at 9%?

Keystrokes

fREGCLx
0.00
Clears all registers.
120000CHSgCFoPV
−120,000.00
The purchase.
18000gCFjPMT
18,000.00
The first run of flows.
5gNjFV
5.00
It happens 5 years in a row.
25000gCFjPMT
25,000.00
The second run.
3gNjFV
3.00
3 years in a row.
60000gCFjPMT
60,000.00
The sale in year 9.
fIRRFV
12.11
The internal rate of return.
9ifNPVPV
18,768.59
NPV at a 9% required return.

Answer

The IRR is 12.11%, and the NPV at 9% is $18,768.59.

Why it works

gNjFV stores a count for the flow just entered. Three entries describe nine years, which saves keystrokes and storage registers, since each flow takes one register however many times it repeats, up to 99.

Checking what you entered

RCLgCFjPMT shows the flows from last to first, and RCLgNjFV each one’s count.

Questions

What if the sale happens in the same year as a rental flow?

Add them together into one flow for that year.