•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
trying to check how much is left on a loan after payment
So I am building a budgeting excel to track my monthly expenses and whatnot.
Adding in my loans, I figured out how to track how many months are left, but I want to go ahead and add a column for how much is left in the loan.
So for instance, I have the months as =NPER(E7/12, D7,-C7) being:
E7 = interest rate
D7= minimum payment amount
-C7 = Total of loan before payment is made.
How can I convert to say how much is left in the loan as a monetary amount after the payment is made?
[link] [comments]
Want to read more?
Check out the full article on the original site