
To make a spreadsheet similar to the one in Example 2, use the steps below. It should be noted that while the numbers that are displayed in the spreadsheet are shown to two decimal places, the actual numbers in the calculations may be carried out to more than two decimal places.
 Enter the titles "Payment Number," "Balance before Payment," "Monthly Interest," "Monthly Payment," and "Balance after Payment" into Row 1.
 Enter 1 into cell A2.
 Enter the formula = A2 + 1 into cell A3.
 Select cell A3. From the Edit menu, choose Copy.
 Select cells A4 through A61. From the Edit menu, choose Paste.
 Enter 25000 into cell B2.
 Enter the formula = 0.08/12*B2 into cell C2.
 Enter the formula = PMT(0.08/12,60,25000) into cell D2.
 Enter the formula = B2 + C2  D2 into cell E2.
 Enter the formula = E2 into cell B3.
 Select cell B3. From the Edit menu, choose Copy.
 Select cells B4 through B61. From the Edit menu, choose Paste.
 Select cell C2. From the Edit menu, choose Copy.
 Select cells C3 through C61. From the Edit menu, choose Paste.
 Select cell D2. From the Edit menu, choose Copy.
 Select cells D3 through D61. From the Edit menu, choose Paste.
 Select cell E2. From the Edit menu, choose Copy.
 Select cells E3 through E61. From the Edit menu, choose Paste.
To format the cells, use the steps below.
 Select cells B2 through B61.
 From the Format menu, choose Cells....
 In the Format Cells dialog, select the Number tab.
 From the Category: list, select Currency.
 For Decimal places:, enter 2. For Symbol, choose $ from the drop down list. Then click OK.
 Repeat Steps 15 for cells C2 through C61, cells D2 through D61, and cells E2 through E61.

Taking out a loan can be confusing and overwhelming. If you plan on taking out a loan to make a major purchase in the future you might want to check out Yahoo Finance, where you can find a wealth of information about loans. The site includes
 news articles pertaining to loans
 various loan calculators
 howto guides for many different loan and debt situations
and many other features.

 You pay So, the interest paid is
 If the annual percentage rate is 9%, then your monthly payment is
So, the interest paid is
If the annual percentage rate is 10%, then your monthly payment is
So, the interest paid is

Comments (1)
These comments are not screened before publication. Constructive debate about the information on this page is welcome, but personal attacks are not. Please do not post comments that are commercial in nature or that violate copyright. Comments that we regard as obscene, defamatory, or intended to incite violence will be removed. If you find a comment offensive, you may flag it.
When posting a comment, you agree to our Terms of Use.Showing 1 commentsRon Larson (author)9 years ago Example 2 illustrates a characteristic of installment loans. That is, during the first half of the repayment period, you are paying more than half of the interest and less than half of principle.0 0