# Calculating investment returns using "PRODUCT" function?

#### mrbounce99

##### New Member
Hi, I'm getting 2 slightly different answers with my returns, why????

Initial investment (say) \$2,000,000

% monthly returns(1-4): 0.65%, -0.6%, 0.87%, -9.36%.

If I use the "PRODUCT" function to obtain an answer to my overall monthly returns its -8.53%

Actual monthly returns (1-4): \$12,990, -\$12,028, \$17,482, -\$187,292

If I total the monthly returns -\$168,848 and calculate this as a % of my initial investment (\$2m) I get -8.44%

My question is, why is this -8.44%, different to -8.53%?
Thank you

### Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
I get 8.442% both ways:

Code:
``````       --A-- -----B----- ---C--- D -------------E-------------
1   Month   Amount
2       0  2,000,000
3       1  2,012,990   0.649%   C3 and down: =B3/B2-1
4       2  2,000,962  -0.598%
5       3  2,018,444   0.874%
6       4  1,831,152  -9.279%
7
8                     -8.442%   C8: {=PRODUCT(1+C3:C6) - 1}
9           (168,848)           B9: =B6-B2
10                     -8.442%   C10: =B9/B2``````

You're welcome. Sorry about that April.

Replies
1
Views
805
Replies
2
Views
2K
Replies
3
Views
2K
Replies
1
Views
401
Replies
0
Views
463

1,219,905
Messages
6,150,906
Members
450,991
Latest member
ExcelDoer

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back