It's not quite what you had asked for in your opening post but the template appears to allow changes.Test it a few times before implementing the changes. It may be a good idea to start a completely new schedule using the current balance as the beginning balance and just keep the original schedule for reference. The dates at seven day intervals will autofill all the way to the bottom of the schedule.ĭoing the dates in this manner will overwrite the formulae in this column but should not affect the overall schedule as named ranges and formulae are no longer involved. Select these two cells then double click on the little solid square at the bottom right of the second cell. For payment number 2, place the date as being seven days after the first. Hence, go back to the top of the schedule and place the date of the first payment beside payment number 1. The only quirk here, the basis of your enquiry, will be the Payment Date column as this is subject to a formula referencing named ranges. The data in the adjacent columns will automatically fill and the balance will show as zero in the last row. You'll note that "Actual number of payments" has now changed to that required for weekly payments. Drag the cell down to the number of payments required for weekly payments (you'll need to work this out first). ![]() Click on this cell and place the cursor on the little solid square at the bottom right of this cell. Go to the "Payment Number" column and go to the last cell with a number in it. The "Actual number of payments" will stay the same for now. The "Scheduled number of payments" will alter as well. You'll note that the "Scheduled Payment" will change to a weekly payment. Change the "Number of payments per year" to 52. Create a copy of your in-law's schedule (just in case!) to work on. I've just had a look at the Excel Loan Amortization template and it acts as a sample in it's own right with data already applied waiting for a User to simply make changes.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |