Hi everyone,
I want to calculate the commitment fee for the bank loan of an investment.
- The loan amount is $500 million,
- The commitment fee rate is 0.5% per annum,
- The loan usage period is 4 years.
The drawings from the loan will be on the monthy basis. I have the monthly timeline including dates and days in a month above the sheet.
I want to calculate the commitment fee dynamically. So if the user enters 6 (sem-annual) into the cell (G30), the commitment fee charged for the last 6 months will be added up and paid in every 6th month. If 4 is entered into the cell G30, it will be charged for quarterly and will be paid in every 4th month.
I hope I can write my question understandable.
Thank you very much in advance.
I want to calculate the commitment fee for the bank loan of an investment.
- The loan amount is $500 million,
- The commitment fee rate is 0.5% per annum,
- The loan usage period is 4 years.
The drawings from the loan will be on the monthy basis. I have the monthly timeline including dates and days in a month above the sheet.
I want to calculate the commitment fee dynamically. So if the user enters 6 (sem-annual) into the cell (G30), the commitment fee charged for the last 6 months will be added up and paid in every 6th month. If 4 is entered into the cell G30, it will be charged for quarterly and will be paid in every 4th month.
I hope I can write my question understandable.
Thank you very much in advance.
