Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Cost of Holding

Questions on using, creating, or understanding data in Fund Manager graphs.

Postby 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

Postby 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.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11601
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby 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

Postby 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
Screenshot 2023-09-30 093803.png (237.88 KiB) Viewed 3357 times
philstunell
 
Posts: 10
Joined: Wed Sep 27, 2023 9:37 am

Postby 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.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11601
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby 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

Postby 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.
Thanks,
Mark
Fund Manager - Portfolio Management Software
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 19 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2024 Beiley Software, Inc. All rights reserved.