Can someone suggest how I would have Excel automatically population the cells within the table. I need to take the total capital need for each Lot listed in the table in a regressive manor reduce the balance monthly in equal amounts until balance is zero out. I populated the first column manually for purposes of example. Your help is greatly appreciated.
Thanks in advance
-Manny
Bookmarks