change loan periods in an amortization schedule

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?
 
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
interest only loan amortization schedule 2
Amortization Schedule 11
change the payment period of amortization schedule 2
360-day Year Based Payment & Amortization Calculations? 1
Creating a List of Loan Periods Dynamically 2
loan amortization schedule - skiped months 2

Top