Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Yield on Cost as defined field (YOC)

Comments, critical feedback, praise, or suggestions for new features.

Postby twj332 » Mon Nov 21, 2016 6:17 pm

Yield on Cost field (YOC)

May I suggest that the defined fields be increased to include a yield on cost field. The annual dividend rate of a security divided by the average cost basis of the investment. It shows the dividend yield of the original investment.
YOC lets you understand how well your money is actually working for you; it shows you the real earning power of your money over time.

This would be very helpful field since the "Define Fields feature" is only available in the Professional and Advisor versions.

Thank You
Terry
twj332
 
Posts: 43
Joined: Sun Sep 13, 2009 11:49 am

Postby Mark » Tue Nov 22, 2016 8:17 am

Hi Terry,

Okay, thanks for the feedback. It sounds like this would be similar to the current Dividend Yield, but instead of dividing by the ending share price, you would divide by your cost/share?
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby twj332 » Tue Nov 22, 2016 12:53 pm

Yes Mark
I would think you divide by the adjusted cost base (ACB)
Thanks to consider this for us.
twj332
 
Posts: 43
Joined: Sun Sep 13, 2009 11:49 am

Postby divinest » Sat May 12, 2018 2:52 pm

Hi Mark,

Can you please suggest what the formula would be to get the annualized yield amount based on the last dividend payment, to get the yield on cost, here is what i have, however might be a better efficient way to do this

((EVAL(ENDDAYS()-90,ENDDAYS(),Distdist_s_btw)*DivFreq)/Taxbasiss_Assigned)*100

where DivFreq is a custom value that includes the number of payments per year

Thanks in advance,
divinest
 
Posts: 149
Joined: Tue Sep 05, 2017 7:07 pm

Postby Mark » Sun May 13, 2018 9:29 pm

Hi divenvest,

I don't have anything to add to your equation. If you have some more specific issue I can try to help.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby divinest » Mon May 14, 2018 3:59 am

Thanks Mark, having challenges in finding out the most recent dividend paid out by a security. For example some pay in the last 90 days, some have semi-annual and some pay twice within 95 days. Do you have any suggestions how to get the most recent dividend paid out irrespective to the frequency?
divinest
 
Posts: 149
Joined: Tue Sep 05, 2017 7:07 pm

Postby Mark » Mon May 14, 2018 7:19 am

Hi divinely,
I'm out of the office this week. I don't recall if such a field exists, but will take a look when I return.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby divinest » Mon May 14, 2018 2:53 pm

Hi Mark, I think the following might work, as the eval gives the distribution on most recent based on the last_dist date.
((EVAL(Last_dist,ENDDAYS(),Distdist_s_btw)*DivFreq)/OOPCbasis_s_end)*100

Thanks!
divinest
 
Posts: 149
Joined: Tue Sep 05, 2017 7:07 pm

Postby Mark » Mon May 21, 2018 7:36 am

Hi divinest,

Looks good, glad you found a solution.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to Feedback

Who is online

Users browsing this forum: No registered users and 12 guests

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