•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
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#loan
#payment
#Excel
#monthly expenses
#budgeting
#interest rate
#minimum payment
#NPER
#monetary amount
#remaining balance
#loan tracker
#loan calculation
#total loan
#financial management