I am trying to make a budget/schedule for after college. Basically I have rows of income/expense line items (one being for payment of each debt) and then a section for my debts. The columns are month by month.
What I would like to do is input the starting balance of my loan, as well as its interest rate. Then have a formula that takes the previous balance and updates to the new balance taking the interest rate and payment amount into account. Only thing is I am not quite sure how to do this.
Could anyone give me any tips or point me in the right direction on something to read on how to do this?