ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   loan amortization schedule - skiped months (https://www.excelbanter.com/excel-worksheet-functions/189327-loan-amortization-schedule-skiped-months.html)

jc12999

loan amortization schedule - skiped months
 
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.

Niek Otten

loan amortization schedule - skiped months
 
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.



Fred Smith[_4_]

loan amortization schedule - skiped months
 
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.




All times are GMT +1. The time now is 04:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com