Thread: Reducing balance
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Chris Bode via OfficeKB.com Chris Bode via OfficeKB.com is offline
external usenet poster
  
Posts: 47
Default Reducing balance
A2=loan
B2=rate
C2=year
Then monthly payment
=(A2*B2*C2+A2)/(12*C2)

Hope this helps€¦.


Chris
------
Convert your Excel spreadsheet into online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200903/1

Reply With QuoteReply With Quote