i used the excel template to create an amortization schedule. the first few entries are fine but then the balance begins going UP. i looked at the formulae and it doesn't look like anything has changed. however, the formulae are much more complicated than what i normally use. i just want to be able to track someone's payment. i've attached a copy. Loan amortization schedule-w payments FOR WEB FORUM.xlsxany help is greatly appreciated! thanks!
I just rebuilt the schedule because I don't like how that one works. Take a look at this and let me know if it meets your requirements.
The template you're using most likely came with additional instruction on how to use the table. You need to manually fill in the values for column G and the table will update as you go. The same with column F.
Also, did you alter the formulas in column E? Why is the 134.28 hard coded into the formula? It should be =[@[TOTAL PAYMENT]]-[@[SCHEDULED PAYMENT]]
Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.
Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
If you're happy with an answer given, please click the * under the person's name to boost their reputation.
ty for the reply! thanks for sharing your schedule. i took a look at it and it might work for what i need. i appreciate it.
@Craig: i am not aware of any additional instructions. it was a template provided with the software. i fill in column G after a payment is submitted. payment amounts are not always the same. i also update column F. i entered extra payments in column E which automatically deleted the formula that was in there. at one point, the extra payments autofilled so i just put a 0 in it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks