Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Bar Graph for Bond Ladder

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

Postby jlcooper » Tue Oct 21, 2014 1:41 pm

I was hoping to generate a graph showing a bond ladder--specifically, each bar would represent the total accumulated value of bonds maturing each year in the future. Is there any way to accomplish that in the system or, alternatively, could that be incorporated in the future? Thank you very much for your assistance.
jlcooper
 
Posts: 2
Joined: Tue Oct 21, 2014 1:36 pm

Postby Mark » Tue Oct 21, 2014 2:00 pm

Hi jlcooper,

Sorry, no, we don't have a graph or report like this. Thanks for the feedback, we can consider this for a future update.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby jlcooper » Tue Oct 21, 2014 4:17 pm

Thank you. Also, is there a way to subtotal bonds in the report by the year of maturity? This would at least partially solve the issue.
jlcooper
 
Posts: 2
Joined: Tue Oct 21, 2014 1:36 pm

Postby Mark » Tue Oct 21, 2014 4:58 pm

Hi jlcooper,

You cannot "subtotal" by maturity date, but you can "sort" by maturity date. Either the Custom report or a Bond Summary report can have the Maturity Date as a field. Once you do, use the top level "Sort / Maturity" command to sort the report by this field.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby silvan » Sat May 09, 2015 1:17 am

Hi Mark,

Just like jlcooper I would very much like being able to create a bar graph showing a bond ladder and a bar graph showing monthly interests and dividends.

Thanks, Silvan
silvan
 
Posts: 47
Joined: Sat Apr 11, 2015 2:40 am

Postby Mark » Sat May 09, 2015 7:41 am

Hi Silvan,

Okay, appreciate the feedback. Sounds like it would be a welcome improvement to add this capability.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby silvan » Sat May 09, 2015 10:02 am

Hi Mark,

Yes, I am sure bond (and other income) investors would love it! :D

It is very useful for financial planning and your cash flow analysis.

Silvan
silvan
 
Posts: 47
Joined: Sat Apr 11, 2015 2:40 am

Postby marathon » Wed May 13, 2015 1:47 am

Would like to add a "cash flow ladder" report variant as well

For given period specified e.g. month, qtr, yr

show the bonds maturing as well as other income events totaled up e.g. dividend forecasted, coupon forecasted

show all interest payments and loans maturing

nett cash flow impact to portfolio projected into future

purpose would be to answer the question of which time period is going to have reinvestment risk?

and

do I need to rollover a loan, pay down a loan or let it mature
marathon
 
Posts: 32
Joined: Thu May 07, 2015 11:44 am

Postby Mark » Mon Jun 01, 2015 8:33 am

Hi marathon,

Thanks for the feedback. If you set up your "Investment Properties... / Income" values for your investments, you can use the "Income Schedule" report to get a list of expected future income.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby silvan » Wed Sep 16, 2015 11:32 am

Hi Mark,

Is it possible in FM 2016 (income schedule graph) to include the cash flows of future redemptions of the bonds, so you can see in which years the bonds are maturing?

Regards, Silvan
silvan
 
Posts: 47
Joined: Sat Apr 11, 2015 2:40 am

Postby Mark » Wed Sep 16, 2015 11:40 am

Hi Silvan,

Sorry, no. It only includes "Income" as specified under the "Investment Properties... / Income" tab. We can consider making it an option to include adding in the face value of bonds on their maturity date.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby silvan » Wed Sep 16, 2015 11:47 am

Hi Mark,

Thanks. It would be great if you could add that option.

Silvan
silvan
 
Posts: 47
Joined: Sat Apr 11, 2015 2:40 am

Postby silvan » Tue Oct 06, 2015 9:18 am

Hi Mark,

Is the option to add the face value of bonds on their maturity date now included in the latest FM 2016 release?

Thanks, Silvan
silvan
 
Posts: 47
Joined: Sat Apr 11, 2015 2:40 am

Postby Mark » Tue Oct 06, 2015 10:26 am

Hi Silvan,

Sorry, no. Unfortunately we weren't able to add this into the 2016 release.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby silvan » Mon Apr 11, 2016 2:44 am

Hi Mark,

Any (expected) updates on these questions?

Thanks, Silvan
silvan
 
Posts: 47
Joined: Sat Apr 11, 2015 2:40 am

Next

Return to Graphs

Who is online

Users browsing this forum: No registered users and 7 guests

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