Members

RSS Latest Forum Comments

Site Wide Activity

Recent Blog Posts

Site Wide

Mortgage Tools

Excel Mortgage Pricing Calculator

Posted by Trace Richardson on October 17th, 2008

More free mortgage tools from LeadPress! This is the pricing tool we use day in and out to price deals. It was built when we realized that using a calculator was inefficient when pricing multiple pricing scenarios and when trying to compare scenarios and loan products. This spreadsheet makes comparing scenarios easy and when you are finished you simply save the spreadsheet as you client’s name and you have it for future reference.

This free mortgage broker tool enables you to price multiple deals using different pricing scenarios. The first row has three boxes that enable three different pricing scenarios for a specific product. We commonly price a No Cost Loan, a Cost Loan, and a Cost plus Points loan in each of these boxes. The second row enables you to do the same with a different product. We will commonly price a fixed rate product in the first rows and an adjustable rate product in the second rows. The third row will enable you to price an option arm and a 2nd as well.

The pricing tool is a bit daunting to look at first. Go to the “With Instructional Comments” tab and hover over the red triangles to read comments about what each cell is for. Once you have a grip on the basics, go to the “Full Version” tab to see the full version.

Every time we price a deal we save it in a “Loan Scenarios” folder as the Client’s name. This allows us to have the pricing for future reference.

Free Excel Mortgage Pricing Tool Free Excel Mortgage Pricing Calculator

Tags: , , ,

Related Posts

  1. Free Mortgage Lead Generation Tools
  2. LoanSifter Mortgage Pricing Tools
  3. NYLX Loan Pricing Software
  4. Mortgage SEO Basics: Choosing Mortgage Keywords
  5. What Can LeadPress Do for You?

Trace Richardson - has written 46 posts on LeadPress.

I'm Trace Richardson and am the founder of LeadPress. I’m a licensed California Real Estate broker and a former equities trader previously holding the Series 7, 63, 55 and 24 securities licenses.

Contact the author