Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable rate loan amortization template | Excel Discussion (Misc queries) | |||
Variable rate loan amortization template | Excel Discussion (Misc queries) | |||
Loan Amortization Template in Excel | Excel Worksheet Functions | |||
Loan Amortization Template - Amount of Final Payment | Excel Discussion (Misc queries) | |||
Loan amortization schedule with bi-monthly payments | Excel Worksheet Functions |