Forum Discussion
Looking for someone to create an excel template for me
Hello, I am extremely new to excel and hopeful to find someone to create me an excel document. I found the excel template 'Loan Amortization schedule', which is the closest thing to what I a...
TripsterYH As with most templates found on-line, they are not very useful if your own needs do not exactly meet those of the creator. They are often full with tricks, named ranges and named formulae and hidden "treasures". This particular one is indeed quite silly as it allows you to enter 52 payments per year, but it calculates payment dates on a monthly basis. I changed the formula in C to add 7 days to each previous payment date. Also added 360 rows to the table allowing for 15 years with 52 payments each. Now, i didn't touch any of the other formulae and it seems to work just fine.
See if the attached file works for you.