-
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 1-5 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
- how-to 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
-
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.
We OOO GSK-NEFT are an official Oil & Gas Trading Company/Mandate
working direct with Russian Petroleum Refineries which deals on
Russian Petroleum Product such as JP54, D2, D6, JA-1 ETC with good and
workable procedure whereby buyers need to have there owned TSA of
their logistic company that is to sign CI along with the buyer and
insert tank numbers as proof that buyer has tanks availability at the
port to avoid waste of time and delays. Kindly Contact us via
E-mail:{ooogsk.neft@mail.ru} for our official
SCO.
Best regards
Mr Burdin Dmitry Yuryevich
Tel: +79268063267
Email: ooogsk.neft@mail.ru
Skype: ooogsk.neft@mail.ru