change loan periods in an amortization schedule

B

Barbara

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?
 
G

Gary L Brown

Example...
Change the Length of Loan period from 30 years to 360 months.

HTH,
 
B

Bernie Deitrick

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

HTH,
Bernie
MS Excel MVP
 

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
360-day Year Based Payment & Amortization Calculations? 1
loan amortization schedule - skiped months 2
Amortization schedule with veriable payments 2
change the payment period of amortization schedule 2

Top