This is really troublesome. Many assumptions are not given, such as whether the loan is in dollars first or in equal proportion at the same time, whether the input is based on the beginning of the period or in equilibrium, etc. Assumptions are given below and calculated accordingly.
1. Funding requirements: 5000 52180*1.05=597.89 million
2. RMB loan 400 million, USD loan 2300*8.3=190.9 million, total loan 590.9 million
3. Self-raised funds are invested 59789-59090 = 6.99 million, and it is assumed to be part of the reserve fund, and the investment at the beginning of the period
4. Loan investment (assumed to be a loan during the construction period Investment at the beginning of the period, and assuming that RMB loans and US dollar loans are invested in the same proportion)
RMB accounted for 67.6933, and US dollars accounted for 32.3067
5. Interest expenses *** totaled 121.0467 million, details The calculation is shown below
Self-raised 699?
Interest rate? 12.80?8?
Year and quarter RMB loan periodic interest calculation method annuity calculation method US dollar loan (converted to RMB) Periodic interest method investment ratio
1 1 2000 2064.00 3818 ? 20
2 2000 4194.05
3 2000 6392.26
4 2000 8660.81 8660.81 4123.44
2 1 5500 14613.96 10499.5 ? 55
2 5500 20757.60
3 5500 27097.85
4 5 500 33640.98 33640.98 15792.78
3 1 2500 37297.49 4772.5 ? 25
2 2500 41071.01
3 2500 44965.28
4 2500 48984.17 48984.17 22210.50
Total? 40000 ?19090 ? 100
Interest? 8984.17 8984.17 3120.50 12104.67