There was a question about setting up amortization schedules. I use excel to do this. It's pretty easy once you get started.

You first need a bit of information. The first is your interest rate. The second is how is your interest calculated. Most mortgages are calculated as monthly interest (so the timing of your payment isn't important as long as you get it in before the late charge kicks in). Most cars and other loans are calculated as daily simple interest and the timing of your payment can make a big difference. You also need your current balance.

To figure your monthly or daily interest rate, divide your yearly rate by 12 or 365 (occasionally there will be a 360 DSI loan, but you'll catch that when it comes along). Don't forget to convert interest rates to decimals - 8% = 0.08.

So first, set up your columns. We'll do mortgage first, since it is simpler.

Column A - the month.

Column B - the current principal balance

Column C - =B*the monthly interest rate

Column D - the payment you are making

Column E - =B+C-D (this is your balance after making your payment)

Then it's a matter of cut and paste to get the rest. Column A you fill in, Column B - type "=E1". When you cut and paste it will go to "E2" etc. Note - I say E1, if you are on any row other than 1, use that row.

Okay for cars you need an extra column

Column A - the date you are making the payment

Column B - =A-the last date you made a payment (when you set this up, after the first row just put A2-A1, again changing the cell numbers if you need to).

Column C - current balance

Column D - =B*interest rate*C

Column E - the payment you are making

Column F - =C+D-E (your new balance).

This probably makes as much sense as mud, but open excel and see if you can figure it out. If not, maybe Jeffrey and/or Nate can walk me through posting a screen shot of an excel worksheet.

There are shorter ways to do this, but this provides a lot more information and is easy to work with.

# Amortization Schedules

February 20th, 2006 at 09:15 pm

### 5 Responses to “Amortization Schedules”

### Leave a Reply

**Supporting Sites:**

February 20th, 2006 at 09:18 pm

February 21st, 2006 at 05:37 am

February 21st, 2006 at 02:21 pm

If you have too much trouble, we'll see if we can figure out how to do a screen shot.

February 22nd, 2006 at 06:44 am

http://www.savingadvice.com/forums/showthread.php?t=4748&page=1&pp=20&highlight=Amortization

February 22nd, 2006 at 06:45 am