Amortization table

[Bradley M. Small]

I would like to create a macro that creates an amortization table.

Something like putting in the present value, rate, and number of months then
have excel use as many rows as necessary to output the princ/int values.

Can this be done? Is there a sample somewhere that does anything like this?

 

[Don Guillett]

Why not try recording and then changing rows to a variable controlled by
years in a cell/12

 

[Bradley M. Small]

Thanks, that worked fine. I guess I was just over thinking it.