Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Interest Earned?? over time?
Starting with $50.
Contributing exactly $100 per month every month for 10 months Formula would be? using excel 97' |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Interest Earned?? over time?
hi
based on the "limited" amout of info you have provided, i would suggest that you look up these formulas in xl help...... =pmt =PPmt =cumpmt =CumPrinc there are others surely one of these will get you started regards FSt1 regards FSt2 "Robert Blass" wrote: Starting with $50. Contributing exactly $100 per month every month for 10 months Formula would be? using excel 97' |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Interest Earned?? over time?
Robert,
With the Annual interest rate in cell A1 (Entered as a percent) =FV(A1/12,10,-100,-50) Interest earned would be that - 1050. HTH, Bernie MS Excel MVP "Robert Blass" wrote in message ... Starting with $50. Contributing exactly $100 per month every month for 10 months Formula would be? using excel 97' |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Interest Earned?? over time?
On Fri, 10 Oct 2008 18:19:01 -0700, FSt1
sayd the following: hi based on the "limited" amout of info you have provided, i would suggest that you look up these formulas in xl help...... =pmt =PPmt =cumpmt =CumPrinc there are others surely one of these will get you started oh of course, surely one will...ok |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Interest Earned?? over time?
Allow me and permit me to explain more better.
It started @ $44 and is NOW @ $1,600 in just 10 months. What would it have been IF I had contributed $108 per month for all 10 months so far? thanks all...... On Fri, 10 Oct 2008 21:24:48 -0400, "Bernie Deitrick" <deitbe @ consumer dot org sayd the following: Robert, With the Annual interest rate in cell A1 (Entered as a percent) =FV(A1/12,10,-100,-50) Interest earned would be that - 1050. HTH, Bernie MS Excel MVP "Robert Blass" wrote in message .. . Starting with $50. Contributing exactly $100 per month every month for 10 months Formula would be? using excel 97' |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Interest Earned?? over time?
What is "it" that you want calculated? The rate of return earned? If so, use
XIRR. Regards, Fred. "Robert Blass" wrote in message ... Allow me and permit me to explain more better. It started @ $44 and is NOW @ $1,600 in just 10 months. What would it have been IF I had contributed $108 per month for all 10 months so far? thanks all...... On Fri, 10 Oct 2008 21:24:48 -0400, "Bernie Deitrick" <deitbe @ consumer dot org sayd the following: Robert, With the Annual interest rate in cell A1 (Entered as a percent) =FV(A1/12,10,-100,-50) Interest earned would be that - 1050. HTH, Bernie MS Excel MVP "Robert Blass" wrote in message . .. Starting with $50. Contributing exactly $100 per month every month for 10 months Formula would be? using excel 97' |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Interest Earned?? over time?
Or, if you have equal periods (like monthly), you can use the rate command,
as in: =rate(10,-108,-44,1600) Remember, this answer will be a periodic (ie, monthly) rate of return. Most people would just multiply by 12 to get an annual rate, but remember it's compounded monthly. Regards, Fred. "Fred Smith" wrote in message ... What is "it" that you want calculated? The rate of return earned? If so, use XIRR. Regards, Fred. "Robert Blass" wrote in message ... Allow me and permit me to explain more better. It started @ $44 and is NOW @ $1,600 in just 10 months. What would it have been IF I had contributed $108 per month for all 10 months so far? thanks all...... On Fri, 10 Oct 2008 21:24:48 -0400, "Bernie Deitrick" <deitbe @ consumer dot org sayd the following: Robert, With the Annual interest rate in cell A1 (Entered as a percent) =FV(A1/12,10,-100,-50) Interest earned would be that - 1050. HTH, Bernie MS Excel MVP "Robert Blass" wrote in message ... Starting with $50. Contributing exactly $100 per month every month for 10 months Formula would be? using excel 97' |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate total interest earned on a loan and monthly payment | Excel Worksheet Functions | |||
Calculating Interest Earned | Excel Discussion (Misc queries) | |||
Interest earned formula | Excel Discussion (Misc queries) | |||
Interest Earned Formula | Excel Discussion (Misc queries) | |||
Interest Earned on Investment w/Daily Compounding | Excel Worksheet Functions |