The loan was 200,000 yuan, and the other party received a handling fee of 24,000 yuan, and actually got176,000 yuan; The principal of 200,000 yuan will be paid off in 36 months (5556 yuan per month). What is the annual interest rate？ Conditions: the amount is 200,000 yuan, the handling fee is 12%, the term is 3 years, and the principal and interest are equal.

Requirements: Calculate the annual interest rate.

Calculation (1): Simple annual interest rate conversion without considering the time value of money.

1. Because 5556 times 36 months is 2000160,000 yuan, which is about 200,000 yuan. Your monthly repayment is the principal, and there is no interest. That is to say, this loan method does not charge you monthly interest according to the par value.

2. The handling fee is 24,000 yuan, equivalent to 12% of the loan amount of 200,000 yuan, that is, handling fee 12 points. If the term is 3 years, the handling fee is about 4 points per year. If the time value is not calculated, the annual interest rate of this part is above 4%.

To sum up, the real interest rate of your loan is above 4%.

Calculation (2): Considering the time value of money, the general investment income of banks should be calculated.

(With EXCEL software, import your cash flow below, and the yield calculated with XIRR function is 8.8483%. )

Number of periods, date, days, cash flow

0 20 13-0 1-0 1 0 176,000.00

1 20 13-02-0 1 3 1 -5,555.56

2 20 13-03-0 1 28 -5,555.56

3 20 13-04-0 1 3 1 -5,555.56

4 20 13-05-0 1 30 -5,555.56

5 20 13-06-0 1 3 1 -5,555.56

6 20 13-07-0 1 30 -5,555.56

7 20 13-08-0 1 3 1 -5,555.56

8 20 13-09-0 1 3 1 -5,555.56

9 20 13- 10-0 1 30 -5,555.56

10 20 13- 1 1-0 1 3 1 -5,555.56

1 1 20 13- 12-0 1 30 -5,555.56

12 20 14-0 1-0 1 3 1 -5,555.56

13 20 14-02-0 1 3 1 -5,555.56

14 20 14-03-0 1 28 -5,555.56

15 20 14-04-0 1 3 1 -5,555.56

16 20 14-05-0 1 30 -5,555.56

17 20 14-06-0 1 3 1 -5,555.56

18 20 14-07-0 1 30 -5,555.56

19 20 14-08-0 1 3 1 -5,555.56

20 20 14-09-0 1 3 1 -5,555.56

2 1 20 14- 10-0 1 30 -5,555.56

22 20 14- 1 1-0 1 3 1 -5,555.56

23 20 14- 12-0 1 30 -5,555.56

24 20 15-0 1-0 1 3 1 -5,555.56

25 20 15-02-0 1 3 1 -5,555.56

26 20 15-03-0 1 28 -5,555.56

27 20 15-04-0 1 3 1 -5,555.56

28 20 15-05-0 1 30 -5,555.56

29 20 15-06-0 1 3 1 -5,555.56

30 20 15-07-0 1 30 -5,555.56

3 1 20 15-08-0 1 3 1 -5,555.56

32 20 15-09-0 1 3 1 -5,555.56

33 20 15- 10-0 1 30 -5,555.56

34 20 15- 1 1-0 1 3 1 -5,555.56

35 20 15- 12-0 1 30 -5,555.56

36 20 16-0 1-0 1 3 1 -5,555.40