Weighted average interest rate = sum of current interest rates/cumulative weighted average of current principal.
The weighted average interest rate refers to the interest rate that can roughly reflect the cost of mixed loans through relevant calculation formulas.
For example, Company A applies for a loan from a bank for a project with a term of 1 year, 3 years and 5 years, and the interest rates are 5.5%, 5.65% and 5.76% respectively. The loan amount is 6,543,800,000 yuan and the loan period is 5 years, so the calculation process of the weighted average interest rate of this project is as follows:
10005.5% 5 = 2.75 million yuan
10005.65% 5 = 2.825 million yuan
10005.76% 5 = 2.88 million yuan
The total interest is: 8.455 million yuan.
823.5/3000/5=5.64%
That is, the weighted average interest rate of the loan of this project is 5.64%.
Generally speaking, the formula for calculating the weighted average interest rate is as follows:
Weighted average interest rate = sum of actual interest incurred in the current period of special loan/weighted average of principal of special loan × 100%.
How to calculate the weighted average interest rate of loans?
Weighted average interest rate = sum of actual interest incurred in the current period of special loan/weighted average of principal of special loan × 100%.
The numerator of the above formula "the sum of the interest actually incurred in the current period of special loans" refers to the amount of interest actually incurred by financial enterprises in the current period due to borrowed money.
The denominator of the above formula "weighted average of special loan principal" refers to the weighted average of the principal balance of various special loans in the accounting period, and its calculation should be determined according to the ratio of each special loan principal multiplied by the actual number of days occupied by the loan in the current period and the number of days covered in the accounting period. The calculation formula is:
Weighted average value of special loan principal = ∑ (principal of each special loan × days actually occupied by each special loan/days covered by accounting period)
In order to simplify the calculation, the number of months can also be used as the weight to calculate the weighted average of the principal of special loans.
If there is a discount or premium on these special loans, the amount of amortization discount or premium should also be used as the adjustment amount of interest, and the weighted average interest rate, that is, the capitalization rate, should be adjusted accordingly. Discount or premium can be amortized by the effective interest rate method or the straight-line method. At this point, the calculation formula of the weighted average interest rate is:
Weighted average interest rate = (the sum of the interest actually incurred in the current period of the special loan plus or minus the discount or premium to be amortized in the current period)/weighted average of the principal of the special loan × 100%.
Extended data:
Example:
A company applied for a loan of 1, 3-year and 5-year with interest rates of 6.00%, 6. 15% and 6.40% respectively. The loan period is five years, and the loan amount is 6,543,800 yuan. Calculate the weighted average interest rate of the project:
10006.00% 5 = 3 million yuan
10006.15% 5 = 3.075 million yuan.
10006.40% 5 = 3.2 million yuan
The total interest is: 9.275 million yuan.
927.5/3000/5=6. 18%
The weighted average interest rate of the loan of this project is 6. 18%.
The weighted average is characterized by several values and a period of time. Otherwise, it is the average. "