Calculator Downloads Available
Posted: Sat May 29, 2004 10:27 am
I have successfully posted four of my modified calculators at Yahoo briefcase. I have checked everything out. These are memory hogs: they consume 5 MB each. I was unsuccessful in posting them as zip files. [I don't know where the problem is. I posted something but I was not able to recover the calculators when I tried to download them.]
Yahoo is very slow in downloading. The downloading speed this morning was 21 KB per second even though I have broadband (cable) internet service. It takes 5 minutes per calculator.
To download these files, you will need my Yahoo username. It is jwr19452000 (notice that I have used small letters for jwr). I will need your Yahoo username for me to grant you access. You may post it on this thread or send me a private message, as you wish. After you have located a file to download, right click and select Save-Target-As to begin the process. (You use the same procedure as when you download Old Time Radio programs.)
BTW, it took me 5 hours to figure everything out. With computers, things always go a whole lot faster the second time.
I have attached a short description of the modifications below.
Have fun.
John R.
++++++
REHP Deluxe V1.0A is the basic Retire Early Safe Withdrawal Calculator (Version 1.61 of November 7, 2002) with a fully functional switching capability and with a variety of data analysis enhancements.
Switching is limited to portfolios of stocks and commercial paper.
The unmodified Retire Early Safe Withdrawal Calculator did not include its intended switching capabilities because of Excel programming limitations. I have added row 2550, which calculates the total stock return. Its calculation is exactly the same as was originally made in row 182. By making this calculation separately, I have been able to implement the full switching logic that was originally intended. Excel does not allow enough code to do everything in row 182 by itself. The modified logic in row 182 now uses both P/E10 switching thresholds and all three portfolio allocations. [Previously, the only cells F19, B20 and I20 were functional. Cells I19 and F20 were not used.]
[I have included rows 2560-2562, which summarize the more stable portion of returns: dividends and dividends plus interest.]
There are two data analysis groups.
The first is in columns L through T and rows 1 through 9 and in columns BA through BJ and rows 1 through 144. This area makes determining which portfolios would have survived as a function of withdrawal rates much easier. In particular, it allows you to select the retirement start years that you are interested in. I usually examine 30-year retirements from 1871-1980 and 1921-1980. Notice that I include some partially completed sequences (which are subjected to dummy data after 2002) but not all.
I have put the instructions for using the other area of data analysis in columns F through I and in rows 12 through 17. Simply press function key F5 (Go To) and enter the proper location.
Here is another helpful hint. Use the shortcut CTRL+HOME to return to the beginning of the spreadsheet (at cell A1). It saves a lot of time.
JanSz-Chips Deluxe V1.0B includes three additional enhancements.
1) The JanSz feature reduces the portfolio balance by a specified percentage of any increase from six years earlier. It leaves the balance untouched when there is a decrease. It should normally be set to 0%.
2) The Chips feature allows you to specify what fraction of the dividend amount that you reinvest. It should normally be set to 100%.
3) The B feature expands the switching capabilities. It introduces four P/E10 thresholds with five allocations. However, the stock allocation below the lowest threshold is fixed at 100% and the stock allocation above the highest threshold is fixed at 0%. You can choose any combination of percentages for the intermediate allocations. In version V1.0B, switching is limited to portfolios of stocks and commercial paper.
JanSz-Chips Deluxe V2.0B TIPS is identical except that switching is with portfolios of stocks and TIPS.
JanSz-Chips Deluxe V3.0B ibond is identical except that switching is with portfolios of stocks and ibonds.
Have fun.
John R.
Yahoo is very slow in downloading. The downloading speed this morning was 21 KB per second even though I have broadband (cable) internet service. It takes 5 minutes per calculator.
To download these files, you will need my Yahoo username. It is jwr19452000 (notice that I have used small letters for jwr). I will need your Yahoo username for me to grant you access. You may post it on this thread or send me a private message, as you wish. After you have located a file to download, right click and select Save-Target-As to begin the process. (You use the same procedure as when you download Old Time Radio programs.)
BTW, it took me 5 hours to figure everything out. With computers, things always go a whole lot faster the second time.
I have attached a short description of the modifications below.
Have fun.
John R.
++++++
REHP Deluxe V1.0A is the basic Retire Early Safe Withdrawal Calculator (Version 1.61 of November 7, 2002) with a fully functional switching capability and with a variety of data analysis enhancements.
Switching is limited to portfolios of stocks and commercial paper.
The unmodified Retire Early Safe Withdrawal Calculator did not include its intended switching capabilities because of Excel programming limitations. I have added row 2550, which calculates the total stock return. Its calculation is exactly the same as was originally made in row 182. By making this calculation separately, I have been able to implement the full switching logic that was originally intended. Excel does not allow enough code to do everything in row 182 by itself. The modified logic in row 182 now uses both P/E10 switching thresholds and all three portfolio allocations. [Previously, the only cells F19, B20 and I20 were functional. Cells I19 and F20 were not used.]
[I have included rows 2560-2562, which summarize the more stable portion of returns: dividends and dividends plus interest.]
There are two data analysis groups.
The first is in columns L through T and rows 1 through 9 and in columns BA through BJ and rows 1 through 144. This area makes determining which portfolios would have survived as a function of withdrawal rates much easier. In particular, it allows you to select the retirement start years that you are interested in. I usually examine 30-year retirements from 1871-1980 and 1921-1980. Notice that I include some partially completed sequences (which are subjected to dummy data after 2002) but not all.
I have put the instructions for using the other area of data analysis in columns F through I and in rows 12 through 17. Simply press function key F5 (Go To) and enter the proper location.
Here is another helpful hint. Use the shortcut CTRL+HOME to return to the beginning of the spreadsheet (at cell A1). It saves a lot of time.
JanSz-Chips Deluxe V1.0B includes three additional enhancements.
1) The JanSz feature reduces the portfolio balance by a specified percentage of any increase from six years earlier. It leaves the balance untouched when there is a decrease. It should normally be set to 0%.
2) The Chips feature allows you to specify what fraction of the dividend amount that you reinvest. It should normally be set to 100%.
3) The B feature expands the switching capabilities. It introduces four P/E10 thresholds with five allocations. However, the stock allocation below the lowest threshold is fixed at 100% and the stock allocation above the highest threshold is fixed at 0%. You can choose any combination of percentages for the intermediate allocations. In version V1.0B, switching is limited to portfolios of stocks and commercial paper.
JanSz-Chips Deluxe V2.0B TIPS is identical except that switching is with portfolios of stocks and TIPS.
JanSz-Chips Deluxe V3.0B ibond is identical except that switching is with portfolios of stocks and ibonds.
Have fun.
John R.