Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Michelle - ecowtent
 
Posts: n/a
Default 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   Report Post  
Gary Brown
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Variable rate loan amortization template ColoAvsPuckhead Excel Discussion (Misc queries) 0 April 7th 05 05:29 PM
Variable rate loan amortization template ColoAvsPuckhead Excel Discussion (Misc queries) 0 April 7th 05 05:29 PM
Loan Amortization Template in Excel [email protected] Excel Worksheet Functions 3 January 29th 05 04:50 AM
Loan Amortization Template - Amount of Final Payment Glenn Excel Discussion (Misc queries) 0 December 11th 04 02:05 AM
Loan amortization schedule with bi-monthly payments McCarthy_MF Excel Worksheet Functions 0 December 9th 04 10:45 PM


All times are GMT +1. The time now is 01:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"