View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomPl TomPl is offline
external usenet poster
 
Posts: 342
Default Calculate Daily Interest, Paid out Weekly

What is the principal and when is it paid. Are you talking about one
investment of $35.95 or a payment of $35.95 each week? There is a formula
for computing future value, but I dont understand your question.

Tom


"steve1040" wrote:

Not sure if the subject makes sense
I have 2 dates
Rate = 8%
Start = 12/28/2009
End = 2/18/2010
This is 7 weeks 3 days

Daily interest = .08/365 = 0.02192%



How do I find what the total for say $35.95 and the end of the period
02/18/2010 - If daily interest is applied at the end of every week.
1. Do I add the 3 days to 35.95 before calculating week1?

2. Is there a built in function that does this


I'm thinking the total should be around 253.20 + the 3 days

Thanks
Steve
.