# New HECM Principal Limit Factors

September 28, 2009 10:13# TWITTER!

July 14, 2009 10:12Come follow us on twitter. I don't know how many tweets you'll see but we'd love to have you follow along. If you'd like, we'll follow you too. Happy tweeting!

# Silverlight!

May 27, 2009 11:29Well, I am long overdue for a posting to this blog. I'm sure all of you know how it goes when you get swamped by a project or two or three or.... Anyway, it's tough to find a few free moments. I will have to try to be better about my responsibilities out here.

Our newest news is that we now have a Facebook page. We invite you to view it at Facebook. Just search us out and become a fan. Let us know if you have any troubles finding it.

# Adding Insurance to a Loan

April 16, 2009 09:55In this entry, we are going to provide instructions on how to add insurance to almost any loan you structure using eZMath or ZMath.

First, there are two main types of insurance that eZMath and ZMath calculate. They are mortgage insurance and credit insurance. Generally, mortgage insurance is for use on mortgages where the loan-to-value ratio is less than 80%. This generally happens when the borrower does not have a sufficient downpayment. Credit insurance is an insurance coverage that is generally offered on consumer loans (i.e. auto, boat and personal loans). This insurance has two components, life and accident and health. eZMath and ZMath calculate both premiums.

Let's cover mortgage insurance first. Once you have selected a loan type, click on Options and Variations and the screen below is displayed. Mortgage insurances are covered in FHA, VA, PMI Standard, PMI Monthly and PMI Split Premium. FHA is insurance offered through HUD loans. VA is a funding fee charged on loans offered through the VA. PMI is private mortgage insurance offered through insurance companies. Standard is the old way of calculating the insurance where the first year's premium is prepaid at closing. The second year's premium is collected with the monthly payments beginning in the first year, etc. You are always one year ahead in this form of insurance. Monthly is where there is no upfront premium and you are not paid one year in advance. Split premium is like monthly but it has an upfront premium as well. Make sure that you select the correct type of insurance by clicking on the correct radio button as the pane that is set up on the terms screen will be determined by your selection.

When you return to the terms screen, you will see a pane that has entries which are required for the calculation of the insurance. What you need for these entries are the correct insurance rates. These rates are readily available from the insurance carrier that you are using (including HUD and the VA). These rates are usually stated as a rate per hundred dollar of indebtedness. That is how we want the number entered. For example, a common rate for FHA renewals is 0.50 per hundred. That is what we want entered; 0.50. You also need to enter what **year** the rate for that renewal period is valid through.

In addition to the rates, you must tell the engine what the premiums are calculated on; the beginning level balance or a declining balance. If it is on the declining balance, you must select the beginning, average or ending balance. In the same section of the insurance terms pane, if you have an upfront premium you are asked whether any of the upfront premium is financed. You can enter that as a percentage or dollar amount. You also enter the number of months, if any, of premium that are escrowed. If there are months escrowed, please click on the radio button as to whether the escrowed months are used or refunded. You can also select a number of months of premium to be prepaid.

One of the most important entries follows. It is the LTV Cutoff value. You are telling eZMath and ZMath where to cutoff the collection of insurance premiums. This is required by regulation so accuracy with this entry is extremely important. Generally, this value will be 80 or 78. The final entry is what the appraised (or sale price, whichever is less) value of the property is. This is the number that the LTV will be calculated on. Again, since this is a regulatory requirement, accuracy is extremely important.

Once your entries are made, click on calculate. At the output screen, your Truth-in-Lending figures will reflect the collection of insurance, your payment streams will reflect the effect of insurance premiums by being added to the regular principal and interest payment amounts, a total premium figure will be shown on the output, etc.

This is how mortgage insurace is added to mortgage loans in eZMath and ZMath. Our next entry will cover credit insurance which is a different type of insurance. As always, if you have any troubles with this or any other aspect of eZMath and ZMath, please feel free to contact us.

# An Interesting Development

March 24, 2009 10:55There has been an interesting development in lending that is borne of this economic crisis we're in. What is it? It it borrowers that take an FHA loan even if they have a sufficient loan-to-value ratio. What does this do? It requires that they pay the funding fee and mortgage insurance premiums for a minimum of five years. This is certainly an expense that most borrowers avoiided if they had at least an 80% loan-to-value ratio. However, since some lenders are only allowing FHA originations, borrowers are being forced into this added expense if they want a loan. In a future post, we will be showing you how to use eZMath and ZMath to originate loans with mortgage insurance, including FHA.

# How to Structure Balloon Loans in eZMath and ZMath

March 12, 2009 09:37In a previous post, I discussed the different types of balloon loans. It is time to show you how to apply that in our loan calculation software. While going through this tutorial, please refer fo the screen shot below.

First, select the loan type you need to work with as we offer the ability to calculate a balloon in virtually every loan type we offer. For our discussion, I will be working with a level payment (i.e. fixed rate) loan. Once you've selected the loan type and are in the base terms screen, select Options and Variations and make sure that the radio button Yes is selected under the Balloon heading. Then click on OK. When you return to the Base Terms screen, the Balloon Terms pane should be displayed. Now, let's look at how we would structure each of the balloon types discussed in the previous blog post.

The first balloon that I discussed is where the borrower would like to pay a certain amount and pay any leftover principal balance with the final payment. To structure this type of balloon, enter the Interest Rate, the Periods/Year, the Term, the Loan Amount, the Payment Amount, the Advance Date and the Date of 1st Pmt. Then click on Calculate. You will be taken to the Output screen. Note that the entered payment is made for one period less than the entered term. The final payment is the remaining principal balance plus the final accrued interest. Please take care to note if your entered payment amount caused negative amortization. That is, was the entered payment amount enough to reduce the principal balance. If not, you may want to make an adjustment to prevent that problem.

The second balloon that I discussed is where the borrower chooses an amount to remain unamortized. To structure this type of balloon, enter the Interest Rate, the Periods/Year, the Term, the Loan Amount, the Advance Date, the Date of 1st Pmt and the Balloon Amount. Then click on Calculate. You will be taken to the Output screen. Note that the entered balloon amount plus the calculated payment constitutes the final payment. The calculated payment is made for one period less than the entered term.

The third and final balloon I discussed was the prepay balloon. To structure this type of balloon, enter the Interest Rate, the Periods/Year, the Term (this is the number of periods the regular payment amount is based on or what we term the Amortization Term), the Loan Amount, the Advance Date, the Date of 1st Pmt and the Actual Term (this is the actual term of the loan). Then click on Calculate. You will be taken to the Output screen. Note that both the payment amount and balloon have been calculated. The payment amount is the payment that would be calculated on a loan that had the number of payments entered in Term. The balance remaining is then calculated at the end of the number of payments entered in Actual Term. This balance remaining is added to the regular payment amount to come up with the final (balloon) payment.

If you follow the steps above, you should be able to successfully structure balloon notes for virtually any of the loan types we offer in our loan calculation software packages, eZMath and ZMath. As always, if you have any troubles with these calculations, feel free to contact us.

# Output

March 5, 2009 10:16Okay, you've chosen a loan type, you've entered the data and you've hit the Calculate button, now what? Well, if all went as planned, you are taken to the output screen. What output is shown depends upon what output you were last on. In other words, if you had the Truth in Lending Statement up with your last calculation, you are taken to the same output with the current calculation. If you were on the Amortization Schedule output with your last calculation, you are taken the Amortization Schedule output with the current calculation, and so on. If you would like different output for the current calculation, select what you would like from the drop down menu at the top left of the screen next to the label "Output type:". The choices for output are: Truth in Lending Disclosure Statement, Amortization Schedule, Documentation, XML Output and Principal vs. Interest Chart. Once you make a selection, click on the "Request Output" button. If you have selected Amortization Schedule and you want the entire schedule, check the "Entire Schedule" box and click Request Output. Note that you can customize the Amortization Schedule output by clicking on the Customize button. There are many choices for customization available to you.

As you can see, we offer many output options in eZMath and ZMath. Your experimentation and creativity are the only limits to the possibilities.

# Balloon Loans

March 2, 2009 10:09A question that we often deal with is how to structure balloon loans. In a future post, we will look at how to mechanically structure balloons using eZMath and ZMath. In this post we are going to discuss the different types of balloon loans and how they are structured.

The first type of balloon loan is the type where a customer would like to pay a certain amount per month and the balance remaining on the loan with the final payment. In order to have a balloon (i.e. a balance remaining at term), the desired payment must be less than the regular payment amount that would be calculated given the other terms (i.e. interest rate, term and amount) of the loan. At the same time, it is usually essential that the payment amount desired by the borrower be enough that amortization (i.e. balance reduction) is occurring. If those two criteria are met and a lender's policy will allow balloon lending, then the loan can be structured in this way.

The second type of balloon loan is the type where the customer would like a certain amount of the loan to be left remaining (i.e. unamortized) at term. That remaining balance will be paid with the final payment. What occurs with this type of loan is that once the final balance is determined or set by the borrower, the regular payment amount is calculated. That payment amount is made for one less than the number of payments in the loan and the final payment is the balance remaining plus the regular payment amount. These types of balloons are often used when the borrower is expecting some kind of cash flow that coincides with the final payment of the loan (i.e. sale of the collateral, etc.) and the balance remaining equals or is slightly less than that cash flow.

The final type of balloon loan is the type where the term upon which the payment amount is calculated (the amortization term) is less than the actual term of the loan. We call this a prepay balloon. This is the type of balloon loan that we commonly see in mortgage lending. Sometimes it is termed a "X/Y Balloon Loan" where X is the amortization term and Y is the actual term (i.e. 30/7 Balloon Loan). In this type of balloon, the payment amount is calculated based on the amortization term. That payment amount is made for the number of payments in the actual term. The resulting balance at term is paid in full (or refinanced) with the final payment.

That summarizes the types of balloon loans seen in the lending industry. Our loan calculation software packages, eZMath and ZMath, easily calculate all three types. In a posting in the Calculators 101 section in the next few days, we will look at how to structure each type. In the mean time, if you ever have any questions on subject matter or the mechanics of running our software, please feel free to contact us.

# Basic Loan Information Entries

February 16, 2009 07:18Note: For the purposes of the following blog entry, we are assuming that Level Payment Loan was the Loan Type selected.

Okay, we've set the defaults and selected what we need from options and variations and have returned to the loan entry screen. What do we need to enter and in what form should it be entered in order to get the results we expect? First of all, you will notice that you are in the Base Terms pane. Within that pane there are entries for Interest Rate, Periods/Year, Term, Loan Amount, Payment Amount, Prepaids, Advance (note) Date, Date of 1st Pmt and Maturity Date. We will go through these entries one by one. In the interest rate field, enter the interest rate. Enter it as a whole number or as you say it (i.e. 8.5 not 0.085) not as a decimal. Then hit <tab> to go to the next entry. In Periods/Year enter the number of payments made per year. For monthly payments, enter 12. In the Term field enter the total number of payments made. If this is a 5 year, monthly payment loan, enter 60. In the Loan Amount field, enter the total dollar amount of the loan (prior to any financed insurance premium). You will notice that the software skips over the Payment Amount field. That is because the software will calculate the payment amount. If you had Balloon selected, you may make an entry here. We will discuss that in a future post. In the Prepaids field, enter the total amount of prepaid fianance charges that are **not** calculated by the software. The software, depending upon your choices in Options and Variations, will calculate prepaid interest, buydown amounts and mortgage insurance premiums and add them to this entered amount to come up with the total prepaid fianance charges. In the Advance Date, enter the funding date, closing date or the date when interest begins to accrue on the loan. Enter the date in the format, MM/DD/CCYY. In the Date of 1st Pmt, enter the date that the first payment is due. Unless you have an irregular final payment date, you do **not** need to put anything in the Maturity Date field. Once all of your entries are filled, click on the Calculate button and you will be taken to the results screen. We will cover the results screen in our next posting.

As always, if you have questions or problems operating the software, contact us for help.