change the payment period of amortization schedule

G

Guest

I have downloaded the template for the loan amortization schedule and entered
all my data, but the template will not accept partial year loans. for
example, I am trying to make a schedule for 14.5 years or 174 months. How do
I change it to monthly terms? or change it so it will accept half years?
 
G

Guest

adjust the formula so it works on a monthly basis and adjust the rate of
interest to reflect months instread of annual.
 

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

Amortization Schedule 11
Amortization schedule with veriable payments 2
How do I change the loan period in a amortization from years to mo 7
Loan amortization schedule for variable interest rates 5
Help to create amortization schedule 0
change loan periods in an amortization schedule 2
loan amortization schedule - skiped months 2
interest only loan amortization schedule 2

Top