So, just enter the above information in their respective cells and the amortization schedule will be generated, as shown in the picture below. Finally, the Payment Frequency is Monthly.įurthermore, you want to know what your monthly payment will be.Fourth, the Payment Type involves paying at the End of the Period.Third, the Annual Percentage Rate ( APR) consists of 6%.Second, the Loan Term spans over 20 years.Now, let us consider the following scenario, where you took a home loan (or for any other purpose) with the following details: Therefore, without further delay, let’s explore them one by one.Ĭase-1: Amortization Schedule with Regular Payment (PMT) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |