![]() ![]() 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. In cell D6 put this formula: =IPMT(Rate/12,$A6,Term,Principal).(The PPMT function returns the amount of principle for a given payment.) This is the amount you will pay toward your principal in this payment. In cell C6 put this formula: =PPMT(Rate/12,$A6,Term,Principal).The amount you put into cell B3 should now also appear in cell B6. ![]() ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |