Collections:
Other Resources:
"30/360 US" - Monthly Interest Frequency
Is there any example of using the "30/360 US" Day Count Rules on monthly Interest Frequency?
✍: FYIcenter.com
There is one example from the
"Don‘t Let Accounting Practices Hamstring Your Portfolio"
presentation slides.
This example uses the following Citigroup bond:
Issuer: Citigroup Interest rate: 3.8% Interest frequency: Monthly, Paid on EOM Day Count Convention: 30/360 US Term: 13 Months Start Date: 2022-06-30 Maturity Date: 2023-07-30
To count days in each Accrual Period, it uses the Microsoft Excel function DAYS360() with the following 2 adjustments, which are not so easy to understand:
The table below shows you how monthly interests of %5,000,000.00 Principal are calculated in this example:
Interest rate: 3.8%
Principal: $5,000,000.00
Interest Rate 3.80%
Principal 5000000.00
T1 T2 DAYS360() Adj. Interest
---------- ---------- --------- ---- --------
2022-06-30 2022-07-31 30 15833.33
2022-07-31 2022-08-31 30 15833.33
2022-08-31 2022-09-30 30 15833.33
2022-09-30 2022-10-31 30 15833.33
2022-10-31 2022-11-30 30 15833.33
2022-11-30 2022-12-31 30 15833.33
2022-12-31 2023-01-31 30 15833.33
2023-01-31 2023-02-28 28 2 15833.33
2023-02-28 2023-03-31 30 15833.33
2023-03-31 2023-04-30 30 15833.33
2023-04-30 2023-05-31 30 15833.33
2023-05-31 2023-06-30 30 15833.33
2023-06-30 2023-07-30 30 15833.33
The picture below shows you the original slide with the above example:
⇒ "30/360 US" - Variations of EOM Rules
⇐ "30/360 US" - EOM Period Examples
2026-02-09, ∼321🔥, 0💬
Popular Posts:
What are Historical Values of the US Prime Rates? Here are Historical Values of the US Prime Rates f...
Collections: Day Count Convention What Is CUSIP US Fed CUSIP Search Stock Symbol Search Compare Stoc...
What is the performance of the Amazon.com, Inc. (NasdaqGS: AMZN) stock? The performance of the Amazo...
What is the performance of the NASDAQ Composite (Nasdaq GIDS: ^IXIC) index? The performance of the N...
What are Historical Values of the US Prime Rates? Here are Historical Values of the US Prime Rates f...