Student Loans
Student loans information
Create an Excel payment schedule for my student loans?
I am trying to create a 'real time' payment schedule.What i have already done is create a monthly budget chart where i can enter all my bills, personal spending, and my paychecks, as i spend and get paid.Also, i have a monthly amortization schedule that i created that shows interest, principal, and current balance.What i want to do is create a chart that updates as i enter my bills. So, when i enter my bill for my student loan, it automatically updates on the chart for my remaining balance of my loans. This seems simple but i want it to have interest and principal calculated as well as remaining balance so i can compare it month to month. I want the chart to show my balance as i update the bill section.Any ideas??
|
