Amortization schedules

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I create an amortization table with a variable rate loan such as a
line of credit?
 
Go to File... New... General Templates... Spreadsheet Solutions... "Loan
Amortization"

if you need the actual formula to calculate interest...
Principal = Payment * ((1-(1/((1+r)^(n*y))))/r)
Where:
n = number of periods per year
y = total years
r = interest rate per period, given by this formula:
r = Annual interest rate/n

Payment = (Principal * r)/(1-(1/((1+r)^n*y))

HTH

Die_Another_Day
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need a vehicle loan amortization 6
loan amortization years 4
Title row to stay in place when scrolling down 2
Amortization Tables 1
Help with Formula... 1
do you have a 365/360 loan amorization schedule 1
Loan Calc 5
Weighted Average Life 1

Back
Top