Hi, I did respond yesterday however my response seems to have not loaded. The
schedule is the 2007 one, whereby you give the loan amount, annual interest
rate, loan period, # of payments/yr, start date and optional extra payments.
This info calcs the repayments, the number, total interest and gives you a
breakdown of the principal and interest components.

I mean to find the principal and interest components of the loan annually -
not depreciate the equipment. It has a residual at the end of the period. ie
the loan is 100K, over a period of 5 years and the residual due on the last
payment (payment number 60) is 20K.

I hope that clarifies what I am trying to achieve. Many thanks.

"joeu2004" wrote:

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.