In the cell of EXCEL, enter:
=-PMT (ratio/12, n, pv)
Pmt () is a function to calculate equal principal and interest. Because its value is negative, a negative sign is usually added.
speed
It's the annual interest rate,
Divide by 12 to get the monthly interest rate.
n
Term: 20 years * 12=240 periods.
Page views (page view)
This is the loan principal
This is the most commonly used formula in my work, please try it:)
2. Apply the above formula:
500,000 yuan, 20 years, commercial loan interest rate of 7.74%,
Monthly payment =-PMT (7.74%/12,240,500,000) = 410/.66.
Please feel free to contact me if you have any other questions.