![]() You can see that extra payments have been added in the 19th period (after we are done with a total of 18 payments). We have input all the information in my template. You will input these values directly under the column Extra Payment (Lump Sum) for the respective payment periods. Adding Lump Sum Payments: On the 13 th and 17 th periods, let’s add two lump sum payments, $10,000 and $15,000, respectively. ![]() For “Monthly” Extra Payment Frequency, you cannot choose Weekly or Bi-weekly frequencies. You can also choose Bi-monthly, Quarterly, Semi-annually, Annually. Extra Payment Frequency: So, you want to add your extra payment ($200) every month.So, in addition to your regular PMT payments, you want to pay an extra $200. Extra Amount You Plan to Add ($): 200.For different Interest Compounding Frequency & Regular Payment Frequency, Interest Compounding Frequency must be equal to or higher than the frequency of the Regular Payment. This is the normal case: Regular Payment Frequency will be the same as the Interest Compounding Frequency. Interest Compounding Frequency: Monthly.Regular Payment Frequency: It means you pay your regular payments every month.Remaining Years: 28.50, It means you have already paid the regular payments for the period 30-28.50 = 1.5 years.Suppose you have loan details like the following: Let me show you the use of this template with an example. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |