Loan repaymnet spredsheet wanted

Loan repaymnet spredsheet wanted

Didn't find your answer?

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.

avatar
By User deleted
09th Feb 2008 18:17

Richard and James
Thankyou both very much. It worked!
sorry for delay

Thanks (0)
avatar
By AnonymousUser
24th Jan 2008 23:02

See template in Excel
Windows Start. New Office Document. Spreadsheet solutions. Loan amortization.

Thanks (0)
avatar
By rjwbailey
23rd Jan 2008 21:55

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.

Thanks (0)