USA Monthly Line of Credit Interest

Joined
Jan 29, 2020
Messages
1
Reaction score
0
Country
United States
Hello,

I am trying to calculate the monthly line of credit interest on $7,000,000 maturing on 12.31.2026. The start date of the note is 12.19.2019. Interest accrues on the unpaid balance of the note at the rate of 5.75% annually, fixed. Interest will be computed on the basis of the actual numbers of days elapsed over a year composed of 360 days. Interest will accrue from the first date that funds are advanced to the borrower until the line of credit is paid in full. Accrued interest is due and payable in consecutive monthly payments beginning 2.1.2020 until the maturity date (12.31.2026).

Any help or advice is very much appreciated.

Thanks for your patience.

CSR
 

kirby

VIP Member
Joined
May 12, 2011
Messages
2,445
Reaction score
332
Country
United States
If you are going to do a lot of this type of work, look into the Tvalue software. Not expensive. If this is a one-off, look on line for freebie Excel line of credit interest calculators. So do a search for "Excel line of credit interest calculator".

Whatever you do, be sure to compare your first month's results to the actual interest from the bank. If different, see if you can get your mgmt's approval for you to contact the bank and ask them to help you figure out why you got a difference. It is to their benefit to help you so they can get paid on time. Maybe send them a picture of Vitruvian Man with his arms raised way up and the text "I dunno"
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top