loan amortization schedule - skiped months

J

jc12999

The loan amortization schedule template skips a month. It only gives you 11
months in one year. But, it is figuring extra interest for the skipped month.
Why does it do this, and how do I get 12 months figured in correctly? On a 6
year note, it leaves out 6 months - one for each year. I need a simple
answer. Thanks.
 
N

Niek Otten

Tell us what schedule you use. Where did you get it? Or is it just a formula? What formula?
What is your data, what result did you expect and what did you get instead?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| The loan amortization schedule template skips a month. It only gives you 11
| months in one year. But, it is figuring extra interest for the skipped month.
| Why does it do this, and how do I get 12 months figured in correctly? On a 6
| year note, it leaves out 6 months - one for each year. I need a simple
| answer. Thanks.
 
F

Fred Smith

There are lots of loan amortization templates around. Which one did you use?

Alternatively, simply look for another one on the web.

Regards,
Fred.
 

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

Loan amortization schedule for variable interest rates 5
How do I change the loan period in a amortization from years to mo 7
Amortization Schedule 11
interest only loan amortization schedule 2
loan amortization schedule 3
change the payment period of amortization schedule 2
change loan periods in an amortization schedule 2
CUMIPMT 0

Top