change loan periods in an amortization schedule

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

Guest

I would like to change the loan period in an amortization schedule from years
to months. Any sugestions on how to do this in a template that was
downloaded?
 
Example...
Change the Length of Loan period from 30 years to 360 months.

HTH,
 
You also need to divide the rate (the Annual Rate) by 12 to fit the monthly payment schedule.

HTH,
Bernie
MS Excel MVP
 
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

How do I change the loan period in a amortization from years to mo 7
Loan amortization schedule for variable interest rates 5
Amortization Schedule 11
interest only loan amortization schedule 2
change the payment period of amortization schedule 2
360-day Year Based Payment & Amortization Calculations? 1
loan amortization template 2
loan amortization schedule - skiped months 2

Back
Top