how to make a credit card amortization schedule excel

=NPER(interest rate/12,payment,-starting debt) months You have all 4 variables to get the last: 'How long will it take?' You know the interest rate and starting amount of the debt. You have a budget - you know how much you can afford to spend on this debt. I've created an amortization schedule for my credit card payments in excel Here, please treat others with respect, stay on-topic, and avoid self-promotion.Īlways do your own research before acting on any information or advice that you read on Reddit. Get your financial house in order, learn how to better manage your money, and invest for your future. Banking Megathread: FDIC, NCUA, and your cash.Private communication is not safe on Reddit. Scam alert: Ignore any private messages or chat requests.

This chart was created using the ARM Calculator spreadsheet. The red and blue lines represent the interest and principal portions of that payment, respectively. You'll see in the chart below for a 3/1 ARM that the total payment due starts increasing each year after the initial 3-year fixed period. This is particularly useful when looking at an adjustable rate mortgage (ARM). Principal Payment ChartĪnother useful amortization chart shows the interest vs. This technique is not as compatible with other spreadsheet software, though. It involves creating dynamic named ranges and using the named ranges for the series in the chart.

However, it is more complicated, and designed to make it hard to figure out what is going on. There is another trick which I use in a lot of my mortgage calculators. You'll see how this works if you take a look at the Period column in the template.

For the X-axis, use the NA() function to avoid displaying the portion of the range after the last payment.

This doesn't let you create bar graphs (without some fancy error bar tricks), but bar graphs waste a lot of ink so I try to avoid them anyway. If you want to see how they work, take a look at the above spreadsheet. I'm not going into detail, but I'll give you the 2 tips that you'll need. One of the tricks to creating a chart like this in Excel is knowing what type of chart to use, and how to make it work for a variable length amortization table. My loan amortization schedule and mortgage calculator are much more useful for use in evaluating and tracking real loans and mortgages. This file is intended for educational purposes only. Use this basic amortization spreadsheet to see how to create an amortization and payment chart in Excel.

How to make a credit card amortization schedule excel