# How to Use the Ultimate Financial Calculator

## How to Calculate a U.S. Rule Loan & Negative Amortization

Tutorial 16

**The U.S. Rule is defined in the United States Consumer Financial Protection Bureau's (formerly the Fed's) Regulation Z, also known as the Truth in Lending Act:**

3. U.S. Rule. The U.S. Rule produces no compounding of interest in that any unpaid accrued interest is accumulated separately and is not added to principal. In addition, under the U.S. Rule, no interest calculation is made until a payment is received.

Thus, under the US Rule, only the unpaid principal balance (excluding unpaid interest) is used as the basis for interest due calculations. Further, if there are never periods of negative amortization, then there is no difference between normal amortization and amortization adhering to the U.S. Rule. (Negative amortization occurs when the loan balance is growing though payments are being made. That is, the payments are less than the interest due.) The Ultimate Financial Calculator supports all these concepts.

This example applies to our online Ultimate Financial Calculator. The C-Value! program for Windows works in a similar way and has a few more features including the ability to save your work.

All users should work through the first tutorial to understand basic concepts about the calculator.

To create an amortization schedule that adheres to the U S Rule and shows a separate interest balance, follow these steps:

- Set "Schedule Type" to "
**Loan**"- Or click the [Clear] button to clear any previous entries.
- The top two rows of the grid will not be empty
- Delete the 2nd row by selecting it and clicking on the [Delete] button

- Set "Rounding" to "
**Adjust last amount to reach "0" balance**" by clicking on the {Settings} {Rounding Options} - In the header section, make the following settings:
- For "Calculate Method" select "US Rule".
- Set "Initial Compounding" to "
**Monthly**". - Enter
**6.0**for the "Initial Interest Rate".

- In row one of the cash flow input area, create a "Loan" series
- Set the "Date" to
**July 1, 2016** - Set the "Amount" to
**35,000.00** - Set the "# Periods" to
**1**- Note: Since the number of periods is 1, you will not be able to set a frequency. If a frequency is set, it will be cleared when you leave the row

- Set the "Date" to

- Move to the second row of the cash flow input area.
- Select "
**Payment**" for the "Series".- For this example, we will assume we want to create a schedule for a 5-year loan (60 monthly payments).
- It has been agreed that the first six payments will be $150, which is less than the interest due

- Set the "Date" to
**August 1, 2016** - Set the "Amount" to
**$150.00** - Set the "# Periods" to
**6**

- Select "

- Move to the third row of the cash flow input area
- Select "
**Payment**" for the "Series" - Set the "Date" to
**February 1, 2017** - Set the "Amount" to "
**Unknown**" by typing "**U**" - Set the "# Periods" to
**54**

- Select "

- Your calculator will now look like this:

- Calculate the unknown. The result is $744.35

- To see the impact of the "U.S. Rule", you'll need to view the amortization schedule
- Click on the
**[Schedule]**button

- Click on the

- Points to note about the schedule:

- Notice the negative amortization - the loan balance is increasing since the first six payments are less than the interest due
- The unpaid interest is tracked as a separate balance as required by the U.S. Rule
- Though the loan balance is increasing the amount of interest calculated for each period remains a constant $175.00
- You may want to compare this schedule to one created with same inputs and the "Calculate Method" set to "Normal"

The U.S. Rule is a consumer friendly feature as it reduces the interest which would normally be paid otherwise. However, it only impacts interest calculations if negative amortization occurs and the difference will likely be minimal. You can use the Ultimate Financial Calculator to compare and find out.

##### C-Value!, A TVM Calculator for Windows

An extremely flexible time-value-of-money calculator for Windows computers.

- Loan or investment calculations.
- Cash flows can be regular or irregular
- Create and print schedules.
**Save your data to disk for later use.**

Suitable for auditors, accountants, lawyers and you!