A B C D E F
1 Investments with irregular timing of returns
2
3 Inputs
4 Initial amount to invest $100,000
5 Maximum per investment $75,000
6 Interest rate on cash 3%
7
8 Cash outlays on investments (all incurred at beginning of year)
9 Investment
10 Year A B C D E
11 1 $1.00 $0.00 $1.00 $0.00 $0.00
12 2 $0.00 $1.00 $0.00 $0.00 $0.00
13 3 $0.00 $0.00 $0.00 $0.00 $1.00
14 4 $0.00 $0.00 $0.00 $1.00 $0.00
15
16 Cash returns from investments (all incurred at beginning of year)
17 Investment
18 Year A B C D E
19 1 $0.00 $0.00 $0.00 $0.00 $0.00
20 2 $0.50 $0.00 $1.20 $0.00 $0.00
21 3 $1.00 $0.50 $0.00 $0.00 $0.00
22 4 $0.00 $1.00 $0.00 $0.00 $1.50
23 5 $0.00 $0.00 $0.00 $1.90 $0.00
24
25 Investment decisions
26 Dollars invested
27
28 Maximum per investment
29
30 Constraints on cash balance
Returns from Cash after
31 Year Beginning cash investments Cash invested investing
32 1
33 2
34 3
35 4
36 5
37
38 Final cash