| Knowing how to build an amortization table will give | | | | 'outstanding '. |
| you a good handle on your monthly payment for a | | | | In the cell, E-3, enter your total loan amount. |
| loan and how much you will be in the interest of your | | | | In cell A-4, type '1 '. |
| loan over pay. | | | | In cell A-5, type "= A4 +1. |
| I use amortization tables, much in business and in my | | | | Copy and paste into the cells in column A in A-5 to |
| personal life. For companies, I usually use it to | | | | A-39 (or something received that the numberin the last |
| determine a monthly payment or to determine the | | | | cell of the number of months equivalent) of your loan. |
| current interest rate on a loan. Often a loan include a | | | | In cell B-4, enter an appropriate number for your |
| monthly fee or service fee in advance – is really | | | | payment, 1,000, for each $ 100,000 in borrowed money |
| just another The form of interest, but if you compare | | | | work just fine. |
| two loans, you need to know what is your real cost of | | | | In cell C-4, type "= E3 * $ B $ 1 / 12". |
| capital. | | | | In the cell, D-4, Type "= B4-C4". |
| In personal use, I use an amortization table to | | | | In the cell, E-4, type "= E3-D4. |
| determine what my mortgage interest for purposes of | | | | In cell B-5, type "= B4". |
| calculating the estimated taxes mean. I use it to also | | | | Copy cell C-4 to E-4 into the cells by C-5 E-5. |
| determine what the payment is based on a car loan | | | | Copy cells B-5 through E-5, and paste it in each line |
| for various loan conditions, for example. | | | | from line 6 of line 39 |
| Information you need: | | | | Select the cell E-39. |
| Loan amount (Example: $ 200,000) | | | | Select "Goal Seek …" outOn the Tools menu. |
| Interest rate (eg 6%) | | | | In the 'Set cell:' It should say: "E39". |
| > Loan Duration in month (in this example, let's say, | | | | In "To value: 'Enter into '0'. |
| 36 months) | | | | In "By changing cell:" type "B4". |
| Open Excel, in cell A-1, type "interest". | | | | Press OK. |
| In cell B-1, enter your annual interest rate. | | | | This will give you the exact payment and monthly |
| In cell A-2, type "term", in B-2, type "payment" in C-2, | | | | interest and principal payments on your loan. |
| type "interest" in D-2, type "principal" in E-2, type | | | | |