I have created a standard loan amortization calculator very much like the one exampled in the lessons. However, below the calculator, I am creating a range that will autopopulate data over a 30 year period for the following columns: Payment Number, Payment Date, Starting Balance, Scheduled Payment, Interest, Principal, and Ending Balance.
I am so far able create the range by adding the formulas to the columns and using Excel's iterative capability to populate data for all columns except the Payment Date Column. Whereas I can get the spreadsheet to calculate all other information, when I make a change to the Payment Date, the dates corresponding to the individual payment periods do not update.
Anyone have any suggestions on how to use the date formulas to correct this?