Owner Occupant Pre Qualification Spreadsheet

This 13 page spreadsheet is for calculating global income for SBA 7a loans, SBA

504 loans, USDA B & I loans as well as conventional owner occupant loans.

Of all the various products we offer for commercial mortgage brokers, this is the most practical and we highly recommend it. This is by far the best owner user type spreadsheet we've ever seen/used. It was produced by a 25 year veteran SBA lender - Craig Kaffenberger of Community South Bank (Feel free to contact Craig regarding your deals, his contact information is on the spreadsheet).

This spread sheet will enable you to fully pre screen your loan requests, in the exact same way that BDO's do (Business Development Officers) - Giving you CONFIDENCE that the loan requests your working on has a great chance of closing.

Properly pre screening loans is perhaps the smartest thing you can do as an originator- you will save yourself a tremendous amount of time by NOT working on "unfundable" loans. So by using this spreadsheet you will avoid the most common mistake brokers make - working on deals that have ZERO chance of closing from the start.

Think about this for a second. Filling out this spreadsheet will take you maybe 45 minutes to an hour. By the time you have it complete, you will know if the loan request meets virtually all underwriting criteria. So you can than continue to work on it with confidence, knowing that your deal has a solid chance of closing. OR you can work on your loan request like most brokers, ie you gather up a partial package and start submitting the requests to banks. Not only will you waste weeks or months of your own time, but you will waste bank loan officers time and thereby ruin your reputation with them by submitting bad deals. Do it right! Pre Qual your deals on the front end like a pro and submit them with confidence that you have a real loan request that is doable.

Mechanics - This Spreadsheet Calculates Global Income and More

This spreadsheet layouts the overall picture of the borrowers situation. Though it's much to comprehensive to list all of it here. We invite you to look at the examples of the individual spreadsheet pages below. Here's the major criteria:

Subject businesses cash flow for the last three years and year to date. Including easy to use "Add Backs" so you can get to the real level of cash flow of the business, referred to as "total cash available for debt service". And this of course includes the calculation for DSCR's.
It establishes the trends of the businesses, in terms of its historical gross sales and total historical cash available for debt service. Trends are critical in this lending environment for SBA, USDA and especially for conventional loans.
It can calculate up to 4 affiliated businesses in a easy to use manor and factors all of their "Add Backs" creating a snap shot of the borrowers TOTAL available cash for debt service on ALL of their businesses, personal expenses and more. This is commonly referred to as Global Income. This calculation is perhaps the most complicated in all of commercial underwriting, but by using this spreadsheet it makes it simple.
It factors in the borrowers personal expenses (AKA personal needs). Keep in mind most banks double the borrowers monthly personal expenses that show up on their personal credit report and net this amount out of their businesses total cash available for debt service... Not calculating personal needs properly is a common mistake and a major deal killer.
Factors in other criteria such as complete break down of the total projects costs, loan to value, collateral loan to value, automatically calculates typical closing costs for both 504 and 7s loans, business balance sheet, personal financial statement, personal needs, etc. Please see the below images of the actual main pages to get a better idea.

Page 1 0f 13

Page 2 of 13

Page 3 of 13

The Offer

You will get 1. the actual live/blank Pre Qualification Spreadsheet 2. as well as a second completely filled out spreadsheet with notes for your reference and 3. a comprehensive reference eBooklet that discusses how to use the spreadsheet in great detail.

Our software program will automatically email you the spreadsheet upon purchase. So no waiting or additional shipping costs. Spreadsheets come in Excel, the eBooklet comes in a PDF. Get it now. $75.

Commercial Real Estate Loans

Commercial Mortgage Broker Training

Commercial Mortgage Loans Misc

Owner Occupant Pre Qualification Spreadsheet