Finance in Excel: Learn how to calculate accrued interest between dates

Описание: 📣Finance in Excel: Calculate accrued interest rate with ACCRINT function👩‍💻

✨ Formula
=ACCRINT(C2,C3,C4,C6,C7,C8,0)

📚Process
Issuance Date →The date the bond was first issued
First Interest Date → The date of the first interest payment after issuance
Settlement Date: →The date you actually buy the bond
Maturity Date →The date the bond expires and the principal is repaid
Annual Coupon Rate →The annual interest rate the bond pays
Par Value→ The face value of the bond you purchased
Frequency → Interest is paid semi-annually
Basis→ 0, U.S. (NASD) 30/360 day count basis - the standard

💬 Let me know in the comments section if it worked for you

📲 Share with a friend who also wants to improve their Excel skills

💚 Tap the plus for more Microsoft Excel Tutorials