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.

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


"jc12999" wrote in message ...
| 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.

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

Alternatively, simply look for another one on the web.

Regards,
Fred.

"jc12999" wrote in message
...
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.