In fact, this method is not desirable, and the annual rush is not as good as the monthly rush.
I. Basic information of the loan:
Suppose 1: the provident fund loan is 600,000 yuan, the loan term is 300 months, the principal and interest are equal, the annual interest rate is 3.25%, the monthly repayment is 2,923.90 yuan, and the 300-month provident fund repayment is 2,923.90 yuan *300 months = 877 169+0 yuan.
Assumption 2: The commercial loan is 654.38 million +0 million, the loan term is 300 months, the principal and interest are equal, the annual interest rate is 5.25%, and the monthly repayment is 5,992.48 yuan. Repaying the commercial loan in 300 months: 5992.48 yuan *300 months = 179743. 15 yuan.
That is, the total loan repayment for 300 months: 877 169.2 1 yuan+179743. 15 yuan = 26749 12.35 yuan.
Suppose 3: the balance of provident fund10.5 million yuan, and the monthly contribution of provident fund is 3,000 yuan (company+individual), that is, the monthly income of provident fund is 3,000 yuan. Actual monthly repayment: 89 16.37-3,000 yuan = 59 16.37 yuan.
2. Select year:
If the balance of the provident fund is written off every year and the loan is repaid 1 time in advance, the provident fund loan is 600,000-1.5 million = 450,000, then the monthly repayment becomes 2 1.92 yuan.
300-month provident fund repayment becomes: 2 192.92 yuan *300 months = 657,876.90 yuan.
The repayment of commercial loans will remain unchanged for 300 months, that is, 5992.48 yuan *300 months = 1797743. 15 yuan.
Total repayment after 300 months: 657,876.90 yuan+1797,743.15 yuan+150,000 yuan = 2,605,620.05 yuan.
As can be seen from the above table, the monthly repayment is 865,438+085.40 yuan. Since there is still 3,000 yuan in the provident fund, the actual monthly repayment is only 5 185.40 yuan.
3. Choose monthly impulse:
The balance of provident fund is 6,543,800+5,000 yuan plus 3,000 yuan per month. How many months can it take each month?
The equation can be obtained as follows: 150000 yuan (original balance) +3000 yuan (monthly provident fund) *X months =89 16.37 yuan *X months.
Solve the equation: X=25 months (rounded), that is, 25 months without repayment.
Then you can use the repayment amount saved in these 25 months to repay the commercial loan 59 16.37 yuan *25 months = 147909.36 yuan in advance (this part of the money will also generate interest, and the algorithm is complicated, so it will not be counted for the time being).
In addition, in the past 25 months, the principal of commercial loans has been repaid to 42,632.82 yuan (see the bank repayment schedule).
Therefore, the principal of the commercial loan is 1 10,000-147,909.36 yuan-42,632.82 yuan = 809,457.82 yuan, and the loan period is shortened to 275 months to repay 5,066.66 yuan.
275-month commercial loan repayment: 5066.66 yuan *275 months = 1393332.50 yuan.
The repayment of the first 25 commercial loans is: 5992.48 yuan *25 months =149811.93 yuan.
The repayment of provident fund loan is unchanged for 300 months, that is, 2923.90 yuan *300 months = 877 169.2438+0 yuan.
Total repayment after 300 months:/kloc-0 1393332.50 yuan+14981.93 yuan +877 169.438+0 yuan+150,000 yuan = 20.
Four. Summary:
Select annual offset to save:
26749 12.35 yuan -2605620.05 yuan =69292.30 yuan.
Choosing a monthly impulse can save:
26749 12.35 yuan -25703 13.63 yuan = 104598.72 yuan.
Monthly impulse can save money more than annual impulse;
104598.72 yuan -69292.30 yuan =35306.42 yuan
As can be seen from the above, you can choose to spend more money on your monthly expenses, so that you can save more money by using the balance of the provident fund.