Questions on using, creating, or understanding data in Fund Manager graphs.
by philstunell » Fri Sep 29, 2023 7:44 am
I am a new user evaluating FM - and exploring how it works.
I have a couple of questions about graphs:-
1) Can you plot the cost of a shares held? (without adding distributions - ideally as a negative cash flow - ignoring distributions - to date)
I know that you can overlay data for different investments, for a single performance measure - share price or total return etc
But can also:-
2) For a single investment, overlay different measures of performance?
I would like to combine on a single plot:- a) Purchase cost of units held (average cost per unit x shares held) (-ve cash flow) b) Net cash flow ("A" above + Distributions - Expenses) c) Total Return ("B" above + current value)
Ideally, for a single investment, sub-portfolio, or portfolio
Is this possible? If so, which version of the software is required?
Thanks in advance.
Phil
-
philstunell
-
- Posts: 10
- Joined: Wed Sep 27, 2023 9:37 am
by Mark » Fri Sep 29, 2023 8:48 am
Hi Phil, 1) You can plot the "cost" of investments and portfolios. This cost is the Out Of Pocket (OOP) cost. Read that link for the details on how this is calculated, but the general idea is this is your break-even point. A reinvested distribution does not increase your OOP cost (but it does increase your tax basis). 2) You can't plot net cash flow or returns, but you can see the returns listed above each investment's graph for any time periods you want. They are figures, not graphed.
-
Mark
- Site Admin
-
- Posts: 11601
- Joined: Thu Oct 25, 2007 2:24 pm
- Location: Chandler, AZ
-
by philstunell » Fri Sep 29, 2023 3:43 pm
Hi Mark Thanks for responding and I understand OPP - and I think that is what I would describe as net cash flow. The 'cost of stocks held' shows the 'capital committed and provide context for interpreting the other graphs, but I have not found a way of plotting this.
Phil
-
philstunell
-
- Posts: 10
- Joined: Wed Sep 27, 2023 9:37 am
by philstunell » Sat Sep 30, 2023 1:43 am
Mark,
This is an example of the graphs / figures that I would like to generate.
Ideally, the share / unit price would be shown in separate window above this graph.
It reveals not only the performance of the share, but the impact of my decisions on the portfolio's performance.
Phil
- Attachments
-
- Screenshot 2023-09-30 093803.png (237.88 KiB) Viewed 3358 times
-
philstunell
-
- Posts: 10
- Joined: Wed Sep 27, 2023 9:37 am
by Mark » Sat Sep 30, 2023 10:36 am
Hi Phil,
Okay, thanks for the idea/information. These aren't available today. You can get value, price, price + dist, and OOP cost (either per share, or in value terms). Maybe we could do something like a user-defined plot, which would work similar to user-defined custom report fields, where you can write an Excel like equation to plot what you want.
-
Mark
- Site Admin
-
- Posts: 11601
- Joined: Thu Oct 25, 2007 2:24 pm
- Location: Chandler, AZ
-
by philstunell » Sat Sep 30, 2023 3:20 pm
I think the Net Cash Flow = NAV + Distributions (so that is available) Total Return is also available, so not a problem.
The surprising omission is the cost of assets held.
As, I think, this is required to work out the taxable gain on sales / redemptions - I think the information probable exists, although it is not presented.
regards
Phil
-
philstunell
-
- Posts: 10
- Joined: Wed Sep 27, 2023 9:37 am
by Mark » Sun Oct 01, 2023 8:45 am
Hi Phil,
FM will calculate both your "taxable" as well as what we call your "Out Of Pocket" cost basis. However, it will only graph the OOP basis. It doesn't plot the taxable basis, although this figure is available in the reports and Portfolio Editor.
-
Mark
- Site Admin
-
- Posts: 11601
- Joined: Thu Oct 25, 2007 2:24 pm
- Location: Chandler, AZ
-
Return to Graphs
Who is online
Users browsing this forum: No registered users and 20 guests
|