Demo file:
The PMT perform in Excel might be be used to decide the month-to-month fee for any fixed-rate mortgage. By offering info like automotive mortgage quantity, rate of interest, and months, we are able to calculate the actual month-to-month fee and then decide the complete price paid for a automotive.
source