Know at a glance your balance and interest payments on any loan with this loan calculator in Excel. Use the following functions. If you want to make your own the PMT function in Excel coupled with other functions can be used to create a loan payment calculator.
Great for both short-term and long-term loans the loan repayment calculator in Excel can be a good reference when considering payoff or refinancing.
This will help you find your work later on if you. Doing so opens a new spreadsheet for your. From now on you need to pay back the loan in quarterly installment in 2 years. This example assumes that 1000 is invested for 10 years at an annual interest rate of 5.