It actually has a dialog box that pops up and jingles at me 'Please enter a
whole number of years from 1 to 30'. after I hit retry, it jingles the same
dialog box at me. When I select Cancel it returns everything to 3 years with
3-year calculations.

With regard to PMT functions, I do not understand what that means as I do
not work with lengthy formulas when using Excel. The link you sent, picture
a jet flying over my head--very quickly.

Isn't there a template for this that shows loan in number of months?

"Niek Otten" wrote:

<It does not allow me to input the number of months

Although it doesn't say so, it actually does.
If you enter 3.5, it shows 4, but it calculates with 3.5 (I used the last template; Mortgage amortization schedule)

You can check that with Excel's PMT function:

=PMT(5%/12,42,100000) and the same data in the template

But of course you can use Excel's built-in family of financial functions too. Look he

http://office.microsoft.com/en-us/ex...117451033.aspx


--
Kind regards,

Niek Otten
Microsoft MVP - Excel



"weisse" wrote in message ...
| It does not allow me to input the number of months (example-42 months) in the
| 'Loan in period of years' area. It is going to be used for is lease
| agreements for equipment, therefore, we would not need up to 30 years, but
| for smaller timeframes at quarter, half, three-quarter intervals, for
| example, 3-1/2 years.
|
| "Niek Otten" wrote:
|
| It's (almost) the same as in years, just use the number of months for duration and adjust the rate to a monthly rate.
|
| Look at templates he
|
| http://office.microsoft.com/en-us/ex...346401033.aspx
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "weisse" wrote in message ...
| |I do not understand accounting, however, I need to create/obtain a loan
| | amortization in months, not years. Is there an easy way to create or does
| | anyone know where I can obtain one?
|
|
|