Loan amortization

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loan amortization schedule for variable interest rates 5
Calculate Loan Term 1
Loan Amortization Schedule 1
How do I change the loan period in a amortization from years to mo 7
Amortization Schedule 2
Amortization Schedule 11
change the payment period of amortization schedule 2
Help to create amortization schedule 0

Back
Top