Loan amortization
 

I am trying to do a loan cashflow for 3 years and then extended over ten and
need 2 separate loan amortization schedules, but the second schedule won't
run separateky. It picks up detail from the first due to the formula format.
Any idea on how to override or what to do?

It sounds like you have a named range in the second amortization table that
refers to the data in the first table. Maybe, something like...
=PMT(MyRate/12,MyPeriod/12,MyLoanAmt)
Change these range names to the appropriate cell address for the 2nd table.
ie =PMT(B1/12,B2/12,B3)
HTH,
Gary Brown


"Michelle - ecowtent" wrote:

I am trying to do a loan cashflow for 3 years and then extended over ten and
need 2 separate loan amortization schedules, but the second schedule won't
run separateky. It picks up detail from the first due to the formula format.
Any idea on how to override or what to do?