![]() ![]() Change cell A7 to the following formula: =A6+1.In cell E6 put this formula: =PMT(Rate/12,Term,Principal).(The IPMT function returns the amount of interest for a given payment.) ![]() This is the amount you will pay in interest in this payment.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |