![]() ![]() Extra Payment is the input column where we can type any extra payments.We can get this with the PPMT() function. ![]() Principal Paid is the amount of principal paid in each month.=ROUND(NPER($E$7/12,$E$10,$D13),0) will tell us how many months it is rounded. ![]() We can use NPER function to get the answer here.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |