Hard Money Buying Worksheet

13

I have the worksheet I use of a ‘quick and dirty’ hard money purchase analysis and I thought I’d share it with you…download here! First if you don’t know much about worksheets, don’t worry; you simply input a few numbers at the top, and the worksheet automatically calculates the fields without your assistance. You just get to read the output.

Why I Use Hard Money: My Theory

Let me explain why I call this my “Hard Money Buying” worksheet. First, I hate putting my own money in purchases, since I’m already putting in my valuable time I feel adding my money to boot is too much to ask. With hard money or what some call private investor funds (rich guys that have more money than time) I seek to borrow not only the acquisition funds but the rehab funds and all the carrying costs including interest payments for 6 months. This is more than enough time to bring the property back to market either as a rental or a sale opportunity.

The Hard Money Worksheet

There’s a screen shot below…and then I’ll give a tour of what’s on it.

First, the gray fields are the only fields that you use to input data. Everything else is auto populated off of those data fields. The “yellow highlights” are there so your private lender gets an eye-full of the good news! As I get “more serious” about a property, I’d do more “complex” calculations, but this worksheet is the basis for my private lender to make his decision from…after all if they won’t lend, I’m not buying.

hard money excel worksheet

For example of how I use this worksheet, the screen shot shows my Acquisition Cost at 61.54% and 65.24% after 6 months…if my lenders cutoff is 65%…I’m asking for an exception to the rule. They may say “OK” or they may not. I may have to fax “this deal” to a number of private or hard money lenders to see which one accepts my exception.

Private funds in my experience want about a 12% nominal rate and worse case, 5 points…so the worksheet reflects this. The worksheet reflects the 6 months of turnaround time and tracks the carrying costs over that time. Private funds usually won’t lend if they are letting you in with “none of your own money” at a LTV of greater than 65%. The worksheet gives me two looks at LTV…one before 6 months of holding costs…and one after. This gives me the options with my private money loan request.

Next you’ll see the output for when I sell, the worksheet spits out gross profits for sales prices of 80% of appraised value growing in 5% steps up to 100%. So I can see what my profit potential is if I “hold out” for a higher sales price…or cut the home for a quick sale.

Now depending on the deal, I want to see a monthly cash flow projection as well. So there are inputs for annual property tax and hazard insurance estimates, as well as a 10% estimate for “management expenses”. Feel free to add any addition expenses the cost of a property manager, advertising, vacancy, and collection losses, etc. over the 10% I impugned in the “Est. Insurance” field until you feel you’ve adequately represented the “outflow” and then estimate your potential rent keying that in in the appropriate field as well.

For debt service, it is assumed a 90% loan at 8% amortized over 30 years on the 100% Sales Price figure. If these terms are too generous for you, feel free to calculate the final cash flow by hand using your own figure for monthly debt service…if they feel right…you’re in luck because the worksheet cranks out a lovely “Est. Cash Flow for you!

There are some fields that are nice to show private investors like “cost per square foot” and “rent per square foot”…but they are more for “them” than for you.

NOTE: This worksheet is equally useful for a “fix and flip” scenario using 100% hard money…or a monthly cash flow analysis to help you make long term hold decisions.

Have fun…and happy investing!

Subscribe to our mailing list

* indicates required Email Address * First Name Last Name
Share.

About Author

Rob K. Blake, a 15 year veteran of the mortgage industry, is a renowned public speaker, author, and former radio talk show host. His blog, TheMortgageInsider.net, is dedicated to educating mortgage consumers, mortgage providers, and investors about both mortgage and housing markets.

13 Comments

  1. Glad everyone likes it.

    I use it to decide if a “hard money” or private investor structure is possible. These deals are my version of “no money deals” I typically use for cash foreclosure buying, REO buying, or “Don’t Wanter” buying of all kinds.

    Rob K. Blake

    PS: I can’t stress enough how having a few private guys who “know” you…that can make common sense decisions quickly will improve your RE investing. Train them to make quick, preliminary decisions…just from this worksheet, knowing if you get the deal under contract…you’ll followup with a full due diligence package and financial.

  2. Interesting post. Thanks for the cool ideas.

    “Next you’ll see the output for when I sell, the worksheet spits out gross profits for sales prices of 80% of appraised value growing in 5% steps up to 100%. So I can see what my profit potential is if I “hold out” for a higher sales price…or cut the home for a quick sale.”

    I bet that is a tough call. Especially considering the housing market of today. I would probably be more inclined to actually sell right away. Thanks!

    outdoors videos’s last blog post: THE BEGINNERS GUIDE TO CAMPING

  3. Pingback: New Hard Money Tool - Free! | Rob K. Blake - The Insider

  4. nice… does this work sheet work as well on multi-family props? does it cover all the bases? and…do you have a more complete worksheet that you would suggest using once you are in due diligence?

  5. I hope I am not out of line here, but I noticed in the article that you included in there about points. Like you I rather not put out of pocket expenses if I don’t really have to. I am wondering if you can included in a field about the $500 appraisers cost. When I did this years ago we actually had No Doc Loans something I had to be creative with seeing the most I could get was 70% ARV (LTV), the investor I was buying from showed that he was carrying back a 2nd Mortgage when in reality the loan payed for everything, including the appraisers fee of $500 (nothing changed much since then fee’s wise, lol). I rather not pay anything out of pocket if I don’t have to, let the loan do it all (granted that means less cash coming to my pocket at closing, but hey that is why we figure budgets for the repairs lol).

Leave A Reply

css.php