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.