View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Emilystorey
 
Posts: n/a
Default Calculation of monthly installments


I have a number of customers with multiple invoices that they want to
pay by installments. How can I create a simple ready reckoner that will
calculate the sum of each invoice installment that will be due each
month.

eg

Invoice 1 £100: Jan£33.33 Feb£33.33 Mar£33.33
Invoice 2 £300 Feb£100 Mar£100 Apr£100
Invoice 3 £900 Mar£300 Apr£300 May£300

Total per month

Jan £33.33
Feb £133.33
Mar £433.33
Apr £400.00
May £300.00


--
Emilystorey
------------------------------------------------------------------------
Emilystorey's Profile: http://www.excelforum.com/member.php...o&userid=31534
View this thread: http://www.excelforum.com/showthread...hreadid=556941