Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Accrued Interest calculation problem

General questions about using Fund Manager that do not fit into any other forum.

Postby nebfinfm » Fri Feb 26, 2021 6:04 am

I own some foreign currency (CZK) denominated bonds and corporate notes. Accrued interest result doesn't make sense.

Maybe the problem is in the transaction recording because the bonds have unusual face value CZK 1. Below are examples how I recorded the transactions:

(1) Oct.2020 Bought for CZK1000 one thousand 5yrs bonds of face value CZK 1 each.
Style: Bond Interest Maturity: 5yrs Coupon 0.5%, Pmt.Freq:Yearly, DayCount: Actual/Actual
Price: 1, Shares 1000, Value 1000, Commission: 0, Accrued int: 0
Now on 2/26/20 FM report Accrued Interest = CZK 202.74
==================
(2) Dec.2020 Bought for CZK1000 one thousand 5yrs bonds of face value CZK 1 each
Remaining transaction was entered same as above 1)
Now on 2/26/20 FM report Accrued Interest = CZK 78.08
==================
(3) May.2020 Bought one Corporate 1yr note Face value 30000 / 4%
Style: Bond Interest
Maturity: 1yr Coupon 4% Pmt.Freq: At maturity, DayCount:Actual/Actual
Price: 1, Shares 30000, Value 30000, Commission: 0, Accrued int: 0
Now on 2/26/20 FM report Accrued Interest =90821.92

===================
Where is the error? Why similar investments (1) and (2) have such big difference?
Thanks nebfinfm
nebfinfm
 
Posts: 95
Joined: Thu Apr 07, 2011 12:54 pm

Postby Mark » Fri Feb 26, 2021 10:16 am

Hi nebfinfm,

The amount of accrued interest depends on when in the interest period you are. So, the maturity date and date for any calculation you look at both matter. Also, for accrued interest calculations to work you need to have the shares at 1/100th the face value of the bond. See these tips for recording bond transactions in Fund Manager.
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 General

Who is online

Users browsing this forum: No registered users and 9 guests

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