Thread: Weekly Returns
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robbins Robbins is offline
external usenet poster
 
Posts: 7
Default Weekly Returns

Oh ok i thought that's what it was but our book and notes don't really
explain it as easily.

"Fred Smith" wrote:

If you bought something for $100, and one week later sold it for $110,
what's your return on investment? Hopefully, you were able to answer
instantly that it's 10%. If not, maybe finance is not for you.

It's the same with returns on a stock price. The return on investment is
always:
=(EndingValue - BeginningValue) / BeginningValue

Hopefully you can take it from here. But if you need more help, post back.

Regards,
Fred.

"Robbins" wrote in message
...
i'm doing a project in my finance class and i need to do the weekly return
of
the closing price of the companies stock for 15 weeks. Is there a function
for this, and if not does anybody know how i can calculate the weekly
return


.