Welcome Guest ( Log In | Register )

Bump Topic Topic Closed RSS Feed

Outline · [ Standard ] · Linear+

 Fundsupermart.com v8, The MS Excel Masterclass version!

views
     
j.passing.by
post Dec 29 2014, 09:58 PM

Regular
******
Senior Member
1,639 posts

Joined: Nov 2010
Full year ROI... if you have excel, use the XIRR formula...

31/12/2013 (10,000)








31/12/2014 11,000 10.00%

The above figures are in cells A1, B1, A10, B10 and C10.
C10 has this formula: =XIRR(B1:B10,A1:A10,0.01)

- what is important is the total values of the portfolio at 31st Dec.
- Any new investments and withdrawals, add the dates and their values in between the above figures.
- Investments are in negative values

j.passing.by
post Dec 29 2014, 10:55 PM

Regular
******
Senior Member
1,639 posts

Joined: Nov 2010
QUOTE(Pink Spider @ Dec 29 2014, 10:01 PM)
This is the most scientific/accurate way of calculating nod.gif

My method is the more simplistic one. icon_rolleyes.gif
*
where got 'scientific' tongue.gif
got calculator, use calculator... got pc, use spreadsheet...

explained simple & quick estimate also no point, if people still ask 'formula' laugh.gif

yeah, easy & quick to estimate by roughly assuming all the new investments are at mid year and thus divide by 2... still get the 17.4% as checked out by XIRR formula.

31/12/2013 (10,000)
1/7/2014 (3,000)
31/12/2014 15,000 17.48%


Topic ClosedOptions
 

Change to:
| Lo-Fi Version
0.0428sec    0.47    7 queries    GZIP Disabled
Time is now: 4th December 2025 - 05:12 PM