The compnay will pay interest at X% and pay the loan over Y number of years.
I have been asked to do some projected calculations based on various interest rates and the repayment of capital over 3,5, and 10.
I recall some time back I found an excel based spredsheet that could do all this but can not remember where.
Can some body please direct me where I can get this spredsheet/calculator.
Thank you in advance
Martin
Replies (3)
Please login or register to join the discussion.
See template in Excel
Windows Start. New Office Document. Spreadsheet solutions. Loan amortization.
PMT function
I haven't got a ready made spreadsheet but in Excel the PMT function will do this for you
PMT
Calculates the payment for a loan based on constant payments and a constant interest rate.
Syntax
PMT(rate,nper,pv,fv,type)
Rate is the interest rate for the loan.
Nper is the total number of payments for the loan.
Pv is the present value, or the total amount that a series of future payments is worth now; also known as the principal.
Fv is the future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0.
Type is the number 0 (zero) or 1 and indicates when payments are due.