Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lisa
 
Posts: n/a
Default Simple Interest Calculation Problems

I'm trying to get a come up with an easy way to figure out how much I paid on
principal and interest on a loan. The only problem is that the payments vary
from year to year. Does anyone have any ideas??
  #2   Report Post  
Posted to microsoft.public.excel.misc
Duke Carey
 
Posts: n/a
Default Simple Interest Calculation Problems

The easy way to determine principal is to deduct the ending balance from the
beginning balance. Interest, then, would the the total of all your payments
less the principal calculated in the first step.

If you want to break it down into year by year values, you'll again need to
know the starting principal balance, but you'll also need to know the
periodic interest rate and how interest is calculated (in other words, is it
calculated an an actual day basis, on a 30/360 basis (most fixed rate home
mortgage loans are this way), or an actual/360 basis.

"Lisa" wrote:

I'm trying to get a come up with an easy way to figure out how much I paid on
principal and interest on a loan. The only problem is that the payments vary
from year to year. Does anyone have any ideas??

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
Fv & Emi! via135 Excel Worksheet Functions 6 January 13th 06 06:23 PM
Simple interest, multiple payments, loan balance NinasNumber Excel Worksheet Functions 1 January 9th 06 07:31 PM
Interest calculation David B Excel Discussion (Misc queries) 4 October 24th 05 11:42 PM
Conditional reference on average interest calculation PiPPo Excel Worksheet Functions 1 October 21st 05 07:28 PM
Compound interest calculation Ira Hayes Excel Discussion (Misc queries) 7 January 13th 05 12:18 PM


All times are GMT +1. The time now is 03:58 AM.

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"