View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default how do i do interest roll up calculation in excel

On Aug 27, 12:06 pm, Steve Costello <Steve
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.