The Motley Fool Discussion Boards
Retirement Discussions / Retire Early CampFIRE
|Subject: Re: retire early study||Date: 2/3/2000 11:03 PM|
|Author: intercst||Number: 3057 of 708947|
I recently bought excel, and have been having a blast making basic models. I quickly found out my calculus skills are getting a bit rusty! Does anyone know how to solve summation equations using excel without doing each calculation separately?
I haven't done anything like that in 20 years, well before the advent of MSExcel. Maybe BluesH or one of the other math wizards knows.
I have a question on the commercial paper data going back to 1871. Is this an average rate, a realized rate (read the 30's great default), or a particular date in each year?
I got the data from Prof. Robert Shiller's web site. This is his explaination of the commercial paper data.
"The nominal interest rate series, Table 26.1, Series 4 is the total return to investing for six months in January at the January 4-6 month prime commercial paper rate (six month starting January 1980) and for another six months at the July 4-6 month prime commercial paper rate (six month starting July 1980). It is computed as 100[1/((1-Rjan/200)(1-Rjul/200)) - 1]. Data starting 1938 are from the Federal Reserve Bulletin. Data before 1938 are from Macaulay , Table 10, pages A142-60."
|Copyright 1996-2013 trademark and the "Fool" logo is a trademark of The Motley Fool, Inc. Contact Us|