LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
alanled
 
Posts: n/a
Default deducting a monthly payment


Hi I would like to have a cell displaying a total outstanding loan
balance and another cell displaying the monthly payment and every month
on a set day the payment cell would deduct the total outstanding balance
and also tell me how many payments i have left. Any help would be much
appreiciated.


--
alanled
------------------------------------------------------------------------
alanled's Profile: http://www.excelforum.com/member.php...o&userid=30949
View this thread: http://www.excelforum.com/showthread...hreadid=506197

 
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
Calculate total interest earned on a loan and monthly payment Matt Stanley Excel Worksheet Functions 4 May 4th 23 03:42 AM
safe ratio and monthly payment what does it mean James New Users to Excel 1 December 28th 05 07:47 PM
how do I calculate a monthly payment based on a variable rate? Chick N Egg Excel Worksheet Functions 1 November 17th 05 09:00 PM
monthly mortgage payment calculator Raza Excel Discussion (Misc queries) 2 October 17th 05 01:35 PM
pmt function in Excel does not return correct monthly payment amou Harraman@Bangalore Excel Worksheet Functions 6 March 3rd 05 01:28 PM


All times are GMT +1. The time now is 01:22 PM.

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

About Us

"It's about Microsoft Excel"