![]() ![]() Understanding why the formula works and why you should use FV as P.J correctly states! I don't like to post answer when there already exist a brilliant answer, but I want to give some views. ![]() I'd hate to have to create 25 different amortization schedules - a lot of copy-paste-dragging. With a table, when you want to look at the balance after a certain amount of payments have been made for the home loan, you would just visually scan the table for that period.īut is there any single formula which shows the remaining loan balance by just changing the "time" variable? (# of years/mths in the future).Īn example of the information I'm trying to find is "what would be the remaining balance on a home loan with the following criteria after 10 years": Finding the future balance for multiple home loans would require setting up a table for ea. Its looks like it is not possible to find the home loan balance w/ out creating one of those long tables ( example). I'm trying to calculate the remaining balance of a home loan at any point in time for multiple home loans. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |