Accountants/Mathematicians Interest Question
 10-02-2007, 03:54 PM #1 Recycles dryer sheets   Join Date: Aug 2007 Posts: 433 Accountants/Mathematicians Interest Question Since it's very important not to exceed \$100,000 total in one account, (assume a CD here), can anyone give a formula to calculate the amount of principle one would need to deposit to arrive at exactly \$100K on the date of maturity? A good example is the 6.0% 3, 4, and 5 year MM certificates being discussed on this forum. Pen Fed says these have a dividend rate of 5.83% and an APY of 6.00% Dividends(interest) compounds daily on a 365 day basis and are credited monthly. Let's ignore leap year for simplicity. Let the maths commence. __________________
 Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free! Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE! You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more! Join Early-Retirment.org For Free - Click Here
 10-02-2007, 04:18 PM #2 Thinks s/he gets paid by the post   Join Date: Jun 2006 Location: Central, Ohio, USA Posts: 2,599 Spread sheet or just use the calculator at the PENFED Site (see the top bar and select the calculators). FYI \$66,480 at 6% APY and 5.83 APR will get you to a total of \$99,979 in 7 years (I got tired of plugging the number). Additionally, the Bank Rate site has a very good calculator for this purpose and it is a bit easier to use and gives the same results using months. But you can always switch from having the interest accrue to the CD to having it paid to your share account and then transfer it someplace else if you are worried about the NCUA insurance limit. PENFED is the #2 CU (after NFCU) in the country in size and neither of these two institutions were involved in the so called "Liars Mortgages" referred in the PC press as Sub Prime. Also if you have a DW you could always put CD's in her name/his name to get \$200K insurance. Could go further with another joint account too. __________________ __________________ Vietnam Veteran, CW4 USA, Retired 1979
 10-02-2007, 04:26 PM #3 Thinks s/he gets paid by the post   Join Date: Jun 2006 Posts: 1,378 Roughly, \$100,000/(1 + interest rate)^years For example, for 6% at 5 years, \$100,000/(1.06)^5 = \$74,725 initial deposit. (Edit: this ignores stuff like daily compounding, which is why I said "roughly." You can simply change the interest rate to the daily rate and the period to years*365 to get daily compouning.)
 10-02-2007, 07:03 PM #4 Give me a museum and I'll fill it. (Picasso)Give me a forum ...   Join Date: Mar 2003 Posts: 16,435 Knowing Pen Fed, I wouild just call them and ask. They will almost certainly be able to tell you and I would trust them to do so/ Alternatively, you could put 100k in and just tell them to send you interest checks every month. __________________ "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest have to pee on the electric fence for themselves." - Will Rogers
 10-02-2007, 07:11 PM #5 Give me a museum and I'll fill it. (Picasso)Give me a forum ...   Join Date: Mar 2003 Posts: 16,435 Just took a look at pen fed's 6/30 financials. They look at least as solid as most banks I see and they have plenty of capital and deposits. What they do not have enough of is long term deposits, which is why I think they are offering such a generous deposit rate on the CDs. Bottom line, I see very limited credit risk in Pen Fed. You should stay under the 100k insurnace limit, but they are very solid IMO. __________________ "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest have to pee on the electric fence for themselves." - Will Rogers
 10-02-2007, 09:26 PM #6 Recycles dryer sheets   Join Date: Aug 2007 Posts: 433 Thanks guys. I have talked to Pen Fed personnel and they're very nice people. I'd have no worries about his organization at all, but I was just using them as a current example of a good deal. I was mostly interested in a formula or algorithm to apply to any offering both for practical use when looking at actual offerings and just to have a little fun keeping my programming skills up to speed. I recently realized it must have been four or five years since I even looked at a C++ compiler or BASIC interpreter. I'd probably just do it the easy, lazy way in Excel. This is just re-inventing the wheel, because I know the routine has been coded millions of times already, but it doesn't hurt to keep your hand in.
 10-02-2007, 11:42 PM #7 Thinks s/he gets paid by the post   Join Date: Nov 2005 Location: North of Montana Posts: 2,753 Up here in Canukistan only the first \$100K is insured. So if you have \$105K in an account, only 5K is at risk. Is it similar in the south or are any accounts with 100K+1 not insured? __________________ There are two kinds of people in the world: those who can extrapolate conclusions from insufficient data and ..
10-03-2007, 12:41 AM   #8
Recycles dryer sheets

Join Date: Apr 2007
Posts: 113
Quote:
 Originally Posted by kumquat Up here in Canukistan only the first \$100K is insured. So if you have \$105K in an account, only 5K is at risk. Is it similar in the south or are any accounts with 100K+1 not insured?

Any amount above \$100k in an individual account is not insured, the same as up north.

10-03-2007, 05:57 AM   #9
Recycles dryer sheets

Join Date: Sep 2007
Posts: 87
Quote:
 Originally Posted by twaddle Roughly, \$100,000/(1 + interest rate)^years For example, for 6% at 5 years, \$100,000/(1.06)^5 = \$74,725 initial deposit. (Edit: this ignores stuff like daily compounding, which is why I said "roughly." You can simply change the interest rate to the daily rate and the period to years*365 to get daily compouning.)
+1. This equation will get you there.

10-03-2007, 08:00 AM   #10
Thinks s/he gets paid by the post

Join Date: Jun 2006
Location: Boise
Posts: 2,686
Quote:
 Originally Posted by twaddle Roughly, \$100,000/(1 + interest rate)^years For example, for 6% at 5 years, \$100,000/(1.06)^5 = \$74,725 initial deposit. (Edit: this ignores stuff like daily compounding, which is why I said "roughly." You can simply change the interest rate to the daily rate and the period to years*365 to get daily compouning.)
Or you can just use the APY (6.00% in the case of PenFed) and it should be exact. Or close enough for government work.

2Cor521
__________________
"At times the world can seem an unfriendly and sinister place, but believe us when we say there is much more good in it than bad. All you have to do is look hard enough, and what might seem to be a series of unfortunate events, may in fact be the first steps of a journey." Violet Baudelaire.

10-03-2007, 09:10 AM   #11
Thinks s/he gets paid by the post

Join Date: Jun 2006
Location: Central, Ohio, USA
Posts: 2,599
Quote:
 Originally Posted by cho oyu Any amount above \$100k in an individual account is not insured, the same as up north.
That is unless they are CD's in an IRA account in which case the insurance, both FDIC and NCUA, is up to \$250K per individual.
__________________
Vietnam Veteran, CW4 USA, Retired 1979

10-03-2007, 08:06 PM   #12
Dryer sheet wannabe

Join Date: Oct 2005
Posts: 22
Quote:
 Originally Posted by SecondCor521 Or you can just use the APY (6.00% in the case of PenFed) and it should be exact. Or close enough for government work. 2Cor521
Agreed.

The 5.83% using monthly compounding means that if you divide it by 12 and compound for 12 months, you would arrive at the 6% APY.
(1+.0583/12)^12 = 1.06.

The formula Twaddle suggested is the way to go.

Quote:
 \$100,000/(1 + interest rate)^years
__________________

 Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)