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.
 
Top