A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » New Users to Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

interest due on capital balance

Thread Tools Display Modes
Old November 8th 15, 07:44 PM
Quilp Quilp is offline
Junior Member
First recorded activity by ExcelBanter: Aug 2013
Posts: 27
Default interest due on capital balance

I have lent money for a period of 36 months where the borrower pays 1/36th of the original loan back each month together with interest, at the monthly rate, on the remaining loan balance.

I would like to have a column in my spread sheet which shows the interest due at the end of the current month and which automatically shows the reduced interest due as time goes on.

For example, for a loan of £100 at 10%/year interest, taken out on November 1st, would, during November, the cell would show that on December 1st interest of (£100 x 10%)/12 = £0.83 is due. Come December 1st and until December 31st the interest would be shown as (£90 x 10%0/12 = £0.75 and so on.

Is there a formula which would return this variable interest?

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a spreadsheet to accrue interest on a balance 30+d dowwcoww Setting up and Configuration of Excel 1 May 30th 09 08:48 PM
How to automate daily interest in a balance sheet? JimS Excel Discussion (Misc queries) 0 May 10th 06 07:45 AM
Simple interest, multiple payments, loan balance NinasNumber Excel Worksheet Functions 1 January 9th 06 07:31 PM
Interest and capital calculations mattguerilla Excel Discussion (Misc queries) 1 December 28th 05 02:50 PM
calculating balance w/interest slaw Excel Programming 6 December 16th 03 12:13 AM

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

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