On Jan 21, 12:22*am, Fran wrote:
Hi, I have the loan amortization schedule loaded & am using it
to amortise equipment (so it may be the wrong template to
use???). I need to enter in a balloon payment for the final payment
but it's not calculating how I want it to, can anyone give some
advice on setting up a balloon payment using this schedule?

I would like to. But first, you say "the loan amortization"
schedule. There are several. Could you be more specific?

Second, you say that you are using it to "amortize equipment". Do you
mean depreciate equipment? If so, by "baloon payment", do you really
mean its salvage or residual value?

Normally, the value of capital assets do not depreciate on the same
kind of schedule as a loan. So yes, if you are interested in
depreciation, a loan amortization schedule is probably not the right
thing to use. A noted exception: the depreciation of intangible
assets sometimes follow an amortization schedule.