1# This data file was generated by the Spreadsheet Calculator.
2# You almost certainly shouldn't edit it.
3
4set numeric
5label A0 = "This spreadsheet illustrates the use of the "
6label A1 = "@irr() function to calculate real-rate-of-return"
7label A2 = "for a given cash flow.  That is, the percentage"
8label A3 = "return which yields a certain cash flow or"
9label A4 = "sequence of payments"
10label A6 = "Example 1"
11label A7 = "payments"
12let B7 = -100
13let C7 = 10
14let D7 = 10
15let E7 = 10
16let F7 = 110
17label A8 = "@irr()"
18let B8 = @irr(B7:F7)
19label A9 = "an investment of 100, yielding payments of 10"
20label A10 = "with a final payoff of the principal and interest.  "
21label A11 = "Clearly, 10% or 1.10"
22label A12 = "Example 2"
23let B13 = -103.15
24label C13 = "l"
25let D13 = 9.13
26let E13 = 9.13
27let F13 = 9.13
28let G13 = 109.13
29label A14 = "return"
30let B14 = @irr(B13:G13)
31fmt B14 "#.0000"
32label A15 = "More realistic example, showing also that the formula"
33label A16 = "will ignore text or non-numeric entries"
34let F16 = -104
35label A17 = "Example 3.  Vertical input works too."
36label E17 = "return"
37let F17 = 8.7
38let E18 = @irr(F16:F21)
39fmt E18 "#.0000"
40let F18 = 3.2
41let F19 = 9.3
42let F20 = 8.7
43let F21 = 109.3
44label A22 = "Error testing"
45let A23 = 100
46let B23 = 1
47let C23 = 2
48let D23 = 3
49let E23 = -105
50let F23 = @irr(A23:E23)
51label G23 = "invalid"
52let A24 = 1
53let F24 = @irr(A24:E24)
54label G24 = "bad range"
55label A25 = "a"
56label B25 = "b"
57let F25 = @irr(A25:E25)
58goto A0
59