LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Constant loan payments vs. constant payments of principal


I assume you mean that you want the interest on the outstanding balance
before the payment for the period. For example, consider a 5-yr loan
of $120,000 at 12% with the first payment due in a month. When the
first payment is made, I would expect it to be $2000 in principal plus
$1200 in interest (1% of $120,000); so the total payment is $3200. The
remaining (new outstanding) balance is $118,000 (120000 - 2000). Do
you agree?


Yes, I agree. And the last payment in your example would be $2020 (the
remaining balance + intrest (1% of $2000). This is exactly what I was looking
for.
Thank you very much!
 
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
APR (Annual Percentage Rate) calculator jeton Excel Discussion (Misc queries) 3 October 13th 06 04:38 AM
biweekly payments on a loan using Pmt function Payment Function Excel Discussion (Misc queries) 1 August 7th 06 09:35 PM
WANTED: Excel template for loan payment record with random/irregular payments cassidy Excel Discussion (Misc queries) 1 July 24th 05 01:09 AM
Extra Payments go toward principal or interest in template? Lindsay Excel Discussion (Misc queries) 1 April 7th 05 03:57 AM
How to calculate total interest on 12 month loan with early payments Fred Smith Excel Worksheet Functions 0 January 6th 05 02:33 AM


All times are GMT +1. The time now is 10:45 AM.

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

About Us

"It's about Microsoft Excel"