i am looking a formula in excel in the joint array which will find out my cash out schedule by year according to :the payment date and the amount per payment (which is a % of a fixed asset).
I can't find it! Thank's for your help! It is a great challenge!
 
                     Cash-out date                              Cash-out condition    Cash-out Schedule    
Amount         1st         2nd         3rd         4th                     1st 2nd     3rd 4th            2011 2012   2013 2014  
3 000 000      02-Sep-11 05-Dec-11 01-Mar-12 01-Apr-13            30% 30%    30% 10%