PC Review


Reply
Thread Tools Rate Thread

how do i do interest roll up calculation in excel

 
 
Steve Costello
Guest
Posts: n/a
 
      27th Aug 2008

 
Reply With Quote
 
 
 
 
Spiky
Guest
Posts: n/a
 
      28th Aug 2008
On Aug 27, 12:06 pm, Steve Costello <Steve
Coste...@discussions.microsoft.com> wrote:
>


Make a table like for any loan. Period, Date, Payment, Interest,
Principal, Balance. In the Balance column where you usually take the
previous balance less principal payment, also add in the interest.
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Interest Income Calculation in Excel Dimitar Kouchev Microsoft Excel Misc 1 2nd Dec 2007 01:24 AM
Custom Roll up and Drill down calculation for Excel Pivot table Karen Microsoft Excel Discussion 2 31st Jan 2007 04:24 PM
Mtge calculation (Dly compound interest and multiple interest rate =?Utf-8?B?U3B1ZHNvbg==?= Microsoft Excel Programming 2 3rd Nov 2005 07:49 PM
Re: Interest Calculation Jerry W. Lewis Microsoft Excel Worksheet Functions 0 7th Sep 2004 01:19 PM
Interest Calculation - Please Help! Jim Microsoft Excel Misc 5 14th Jan 2004 06:24 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:43 PM.