![]() If you are going to make monthly payments on the same loan, then use this formula: 1 - payments are due at the beginning of each period.įor example, if you borrow $50,000 for 3 years with an annual interest rate of 8% and you make annual payments, the following formula will calculate the principal portion of a loan payment for period 1:.0 or omitted - payments are due at the end of each period.Type (optional) - indicates when the payments are due:.If omitted, it is assumed to be zero (0). the balance you wish to have after the last payment is made. ![]() Fv (optional) - the future value, i.e.The present value of a loan is the amount you originally borrowed. how much a series of future payments is worth now. Pv (required) - the present value, i.e. ![]() ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |