![]() ![]() Now that you know how to find any missing value, it's time to create the amortization table. the simple interest EMI calculator instantly shows you the amount you will pay or receive after the maturity period. RATE should always be divided by 12 when your NPER is based on months otherwise, you'll get a severely deflated value. Total Loan Amountįinally, if you want to know how much you can borrow given a specific interest rate, the amount you can afford monthly, and the number of months you're willing to pay the loan, use the PV function: =PV(RATE,NPER,-PMT, When you're unsure how many months you're going to pay a loan, but you know how much you're borrowing and how much you can afford to repay every month, you can use the NPER function: =NPER(RATE,-PMT,PV,)Īgain, divide the RATE by 12 since you're computing the number of months you will repay a loan. To calculate the effects of sporadic payments, you’ll have to input them manually into your amortization schedule formula: By the end of our loan, we’ll have made total early payments of 9000, reduced our loan period by almost a year, saving over 5900 in interest. This formula will give you the monthly rate, so don't forget to multiply the final result by 12. If you need to determine the interest rate, use the RATE function: =RATE(NPER,-PMT,PV,) Just remember to divide the RATE by 12, as we're computing for the monthly payments. To compute the monthly payments, use the PMT function: =-PMT(RATE,NPER,PV,) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |