Growth of $10,000

R

Rachel

HI,
I'm trying to graph the growth of $10,000 of a Mutual fund vs. the
benchmark. I'm working with montly returns over a period of 5 years. Can
anyone help with the appropriate graph?
Any help would be great.
Thanks,
Rachel
 
G

Gary Brown

In Cells A1:A60 enter your periods...Example: Jan 2006, Feb 2006, etc
in Cells B1:B60 enter your growth rate
in Cells C1:C60 enter your benchmark
Put your cursor on Cell A1
Select the Chart Wizard icon on the top command bar or Select
Insert>Chart... and follow the Chart Wizard.

HTH,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding required growth rate 0
Solve for rate of growth on an investment 0
% achieved to a negative goal 6
Future Value Function (FV) 2
how to trigger data 6
Calculating Hypothetical Growth of $10,000 in Excel 3
Customer name when in TOP 5 growth 3
Sharing Access MDB or Accdb with client using older or newer version of Office 1

Top