WinAmort Professional 2.0

Irregular Loans - Example 1

Hide Navigation Pane

Irregular Loans - Example 1

Previous topic Next topic No expanding text in this topic  

Irregular Loans - Example 1

Previous topic Next topic JavaScript is required for expanding text JavaScript is required for the print function Mail us feedback on this topic!  

Irregular Loan Icon

 

Although most loans and mortgages are set up with a fixed rate of interest and

a fixed payment schedule, often the loan payments are not made on a regular

basis. This is because the borrower sometimes becomes delinquent or misses a

payment for to some reason.

On the other hand, lenders also work with borrowers to set up special payment

schedules that are not always fixed to the lenders’ schedule but more suited to

the borrowers needs and financial position. Of course there also exists special

loans like prime plus one, which charge interest at the prime plus some arbitrary

value. This rate is always changing, since it is fixed with the prime rate.

In the above situations, the Fixed Rate and even the Adjustable Rates form are

not able to handle the irregular payments or interest rate changes. In this case

you need ultimate flexibility. The ability to make a payment or change the rate

at any time.

This is the basis behind this Irregular Rates Form. Also unlike the Adjustable

Rates form, which could only compute the Payment Value, this form can compute

any unknown value, including the Implicit Rate in a lease.

 

 

Irregular Loan - EXAMPLE 1

On June 12, 2011 Mr. E. Regullar negotiated a $150,000 loan at an interest rate of 10.25% compounded monthly. Starting on August 1, 2011, Mr. E. Regullar made 5 payments of $2,500.00 each. Another 16 payments of $1,750.00 each at an interest rate of 9.125% were made starting on January 15, 2011. Mr. E. Regullar did not make a payment on November 15, 2011. He made the missed payment on November 26, 2011. What was the outstanding balance at the end of the 16th payment? Assume the lender is using the Exact Day method to compute Interest charges.

 

 

SolveSolve The Balance outstanding on the loan after the 16th payment is made.

 

 

This question is normally very difficult to answer, because it involves interest

changes and odd days interest. When Mr. E. Regullar missed a payment on

November 15, 2010, he made up for it on November 26, 2010. This means that

he was charged odd days interest for the 11 days that he did not make a principal

payment.

 

 

 

 

ico_lite If you breakdown the information you have, it will make it easier to enter the data.

WinAmort Professional is very powerful in that it will compute the results accurately as long

as the data entered follows a logical pattern.

 

What we know from the example

Initial loan amount is - $150,000 taken out on June 12, 2010
The initial interest rate is - 10.25%
Payments start on August 1, 2011
5 payments of $2,500 were made
January 15, 2011 the interest rate changed to 9.125%
From January 15, 2011 another 16 payments were made for $1,750

 

Mr. E. Regular missed one regular scheduled payment on November 15, 2011 he made this payment 11 days late on November 26, 2011.

 

 

action Use all the known information and input the data step by step in the Irregular payments form.

Then compute the answer.

 

Type

 

 

 

 

 

 

 

 

 

 

 

Loan

 

 

 

 

 

 

Click

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Click

 

 

 

Tip

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Double
Click

 

 

 

 

 

 

 

Click

 

 

 

 

 

 

 

 

 

 

 

 

Click

 

 

 

 

 

 

 

 

 

 

 

 

 

Click

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Click

 

 

 

 

 

Mr. E. Regullar's Loan in the Heading field. This title will appear at the top of the screen when the amortization table is generated.

TAB or use the mouse to move to the next field.
 

Loan type is normal - default
Compounded is monthly- default
Basis Year is 365 days - default

 

Exact Day changed to Yes
Interest Rate is set to 10.25%

 

Now fill in the Transaction line by line based on what we know.

 

Enter the date: June 12, 2011

Amount:  150,000

Number: 1

Frequency: Monthly

 

 

add button at the top of the form. This will add a new line for another transaction. The default label will be set to Payment.

 

Enter the date: Aug 1, 2011

Amount: 2,500

Number: 5

Frequency: Monthly

 

This means that commencing Aug 1st, 2011, you are making monthly payments of $2,500 and you will do this for the next 5 months. WinAmort automatically computes the dates in the background. So it knows that the date of the last payment is now - Dec. 01, 2011. This will appear in the table. You do not have to worry about keeping track of this.

 

add button at the top of the form to add another transaction line.

 

ico_lite You can also right click on any transaction line to pop up the following menu for quicker access to the transaction ribbon buttons.

 

transactions popup menu

 

 

We need to take into account the new rate change that occurred on Jan 15, 2011. Therefore on this new line, change the Transaction type from Payment to Rate. In order to do this,

 
The Payment field. And a drop down menu will appear. Select New Rate and it will appear in the field.

 

 

Enter the date: Jan 15, 2012

Amount: 9.125

 

add button at the top of the form to add another transaction line.

 

You will start to see how this form works and appreciate its flexibility.

Next we need to enter in the new lower payments that commence right after the new rate change on Jan 15, 2011. Therefore on this new line:

 

Enter the date:Jan 15, 2012

Amount: 1,750

Number: 16 (this is the number of continuous payment we will make in this amount)

Frequency: Monthly

 

add button at the top of the form to add another transaction line.

 

Now, even though Mr. E.Regullar is suppose to make 16 payment in a row every 15th of the month, he was late with one payment. So on this line we will take this in to consideration Therefore on this new line:

 

Enter the date:Nov 15, 2012

Amount: (1,750) - Entered the amount as a negative using the minus sign.

Number: 1

Frequency: Monthly

 

add button at the top of the form to add another transaction line.

 

Mr. E.Regullar was late with his usual payment on the 15th of the month. However, he did pay it on the 26th of the month. So we need to enter in the date that he actually paid it.

 

Enter the date:Nov 26, 2012

Amount: 1,750

Number: 1

Frequency: Monthly

 

Now that we have entered all the data, we can make the table. So

 

make button and the table will be generated.

 

Scroll down to the 22nd line or stretch the bottom of the window to show more lines.

ico_smile

 
The balance outstanding on the loan after the 16th payment made is $134,480.50

 

If you did not get this answer, verify your form with the illustrated one below.

 

Irregular Payment Example 1

If you click on the Column Button at the top of the window and select to turn on the Loan Column, you will be able to see the first

entry with the $150,000 loan amount on the table.

 

When you are working with the Irregular Loan Form and Transaction, you can add, duplicate, delete or move any transaction line as needed.

Try moving the entries use the buttons.

 

Irregular Ribbon