Article View: comp.apps.spreadsheets
Article #54calculating interest
From: Porter, William M.
Date: Thu, 06 Aug 1992 07:14
Date: Thu, 06 Aug 1992 07:14
27 lines
1864 bytes
1864 bytes
This may be quite simple, but it has me stumped. I've searched through the manual to no avail. I'm using Excel 4.0 (for the Mac, though it doesn't seem to make much difference). My 12-year-old daughter deposits her babysitting earnings in the Bank of Dad, earning 10% interest, which I would like to compound daily. (Too bad federal law prohibits me from depositing there myself!) Anyway, is there a formula by which I can calculate the interest to be added to her account at any time--that is, more or less randomly? That is, say there is $100 in her account on August 1, and then on August 6 she deposits $12 more. I'd like to be able to calculate the interest on that $100 for the six days it was on deposit, and THEN add the new $12. Simply taking 1/365th of 10% of $10 and multiplying it by the number of days won't do (though the resulting error with such small amounts of money will be negligible): that simple approach (which I'm using currently) doesn't actually >compound< the interest. That is, her interest earning on August 2 should be slightly higher than her interest earning on August 1. Does this make sense? Any help would be appreciated. Post here or send me e-mail direct. William Porter Classical Languages: University of Houston Houston, Texas 77204-3784 Internet: hcls6@jetson.uh.edu CompuServe: 75430,1351
Technical Details
Message-ID:
<6AUG199202140982@jetson.uh.edu>Path:
arc1-ca.pugleaf.net!sparky!uunet!haven.umd.edu!darwin.sura.net!zaphod.mps.ohio-state.edu!menudo.uh.edu!jetson.uh.edu!hcls6Show Full Headers
Complete Article Headers
Newsgroups: comp.apps.spreadsheets Path: arc1-ca.pugleaf.net!sparky!uunet!haven.umd.edu!darwin.sura.net!zaphod.mps.ohio-state.edu!menudo.uh.edu!jetson.uh.edu!hcls6 From: hcls6@jetson.uh.edu (Porter, William M.) Subject: calculating interest Message-ID: <6AUG199202140982@jetson.uh.edu> News-Software: VAX/VMS VNEWS 1.41 Sender: usenet@menudo.uh.edu (USENET News System) Nntp-Posting-Host: rosie.uh.edu Organization: University of Houston Distribution: usa Date: Thu, 6 Aug 1992 07:14:00 GMT Lines: 28