5/25/12 IMPORTANT ANNOUNCEMENT: MAJOR BP Update Next Week!

Hide this

Jump to Category View All

Click a category below to view different forum categories.

BiggerPockets

General Info

Rss10 BiggerPockets Q&A, Site Questions, & Announcements

1001 topics, 8199 posts — Last Post 05/25/12, 08:01PM

Rss10 BiggerPockets Exclusive PRO Area

12 topics, 81 posts — Last Post 03/23/12, 03:25PM

Rss10 New Member Introductions

4596 topics, 26506 posts — Last Post 05/25/12, 04:49AM

Rss10 BiggerPockets Success Stories

152 topics, 1813 posts — Last Post 05/25/12, 10:22AM

Rss10 BiggerPockets Real Estate Investing Summit

87 topics, 1549 posts — Last Post 05/07/12, 02:13PM

General Real Estate

General Real Estate

Rss10 Buying Real Estate

1319 topics, 10391 posts — Last Post 05/25/12, 09:13PM

Rss10 Selling Real Estate

320 topics, 2544 posts — Last Post 05/08/12, 07:34PM

Rss10 Renters

202 topics, 1618 posts — Last Post 05/25/12, 11:34AM

Rss10 Get Foreclosure Help - Help Stop Foreclosure Forum

221 topics, 1747 posts — Last Post 05/18/12, 08:38PM

Rss10 Home Owner Association (HOA) Issues & Problems Forum

111 topics, 719 posts — Last Post 05/08/12, 06:37AM

Rss10 Do it Yourself

328 topics, 2841 posts — Last Post 05/25/12, 09:10AM

Reviews & Feedback

Rss10 Real Estate Deal Analysis and Advice

1625 topics, 12980 posts — Last Post 05/25/12, 10:02PM

Rss10 Real Estate Guru, Book & Course Reviews and Discussions

700 topics, 7128 posts — Last Post 05/23/12, 02:16PM

Rss10 Ask About A Real Estate Company

330 topics, 4781 posts — Last Post 05/10/12, 10:31PM

Real Estate Investing

Real Estate Strategies

Rss10 Wholesaling

2589 topics, 19949 posts — Last Post 05/25/12, 08:41PM

Rss10 Rehabbing and House Flipping

1622 topics, 14297 posts — Last Post 05/25/12, 03:24PM

Rss10 Real Estate Development

202 topics, 1123 posts — Last Post 05/19/12, 07:40AM

Rss10 Pre-Construction & New Home Construction

90 topics, 600 posts — Last Post 05/05/12, 11:02AM

Rss10 Innovative Strategies

378 topics, 2938 posts — Last Post 05/25/12, 09:18PM

Rss10 Tax Liens, Notes, Paper, & Cash Flows Discussion

477 topics, 2850 posts — Last Post 05/25/12, 02:54PM

Rss10 Rent to Own a.k.a. Lease Purchase, Lease Options

355 topics, 2229 posts — Last Post 05/25/12, 03:12PM

Rss10 1031 Exchanges

62 topics, 342 posts — Last Post 04/29/12, 08:09PM

Foreclosure Investing

Rss10 General Foreclosure & Pre-Foreclosure Forums

1156 topics, 7084 posts — Last Post 05/24/12, 06:30PM

Rss10 HUD, VA, and Tax Sales

216 topics, 1327 posts — Last Post 05/25/12, 01:59PM

Rss10 REOs

948 topics, 7884 posts — Last Post 05/23/12, 05:04PM

Rss10 Short Sales

1255 topics, 10447 posts — Last Post 05/25/12, 10:10PM

Landlord & Tenant Forums

Rss10 Rental Property Questions & Landlording Issues

3183 topics, 28801 posts — Last Post 05/25/12, 04:53PM

Rss10 Land & Farm Investing

118 topics, 736 posts — Last Post 05/25/12, 01:27PM

Rss10 Mobile Homes & Mobile Home Park Investing

416 topics, 3071 posts — Last Post 05/24/12, 05:40PM

Real Estate Dealmaking

Rss10 Make Deals, Find Partners, Mentors & BirdDogs, etc.

3703 topics, 13611 posts — Last Post 05/25/12, 06:57PM

Rss10 Promote Your Real Estate Buyer's List

160 topics, 689 posts — Last Post 05/02/12, 05:54AM

Rss10 Property Wanted

635 topics, 3041 posts — Last Post 05/19/12, 07:44AM

Rss10 Seeking Financing, Money, or Loans

1245 topics, 7437 posts — Last Post 05/21/12, 10:41AM

Rss10 Tax Liens, Notes, Paper, & Cash Flows Dealmaking

277 topics, 1909 posts — Last Post 05/23/12, 06:40PM

Rss10 Bulk REO Discussion and REO Dealmaking

843 topics, 5906 posts — Last Post 02/02/12, 04:20PM

Investor Basics

Rss10 Starting Out

4197 topics, 30898 posts — Last Post 05/24/12, 03:17PM

Rss10 Investor Psychology

298 topics, 4486 posts — Last Post 05/04/12, 09:01PM

Rss10 General Real Estate Investing

3145 topics, 21840 posts — Last Post 05/25/12, 03:22PM

Rss10 Real Estate Investor Marketing

910 topics, 7482 posts — Last Post 05/25/12, 10:26AM

Commercial Real Estate

Rss10 Commercial Real Estate Investing Forum

743 topics, 3995 posts — Last Post 05/23/12, 08:46AM

Rss10 Multi-Family and Apartment Investing

219 topics, 2013 posts — Last Post 05/25/12, 11:11AM

Rss10 Office Investing

3 topics, 36 posts — Last Post 11/15/11, 02:42PM

Rss10 Industrial Property Investing

4 topics, 14 posts — Last Post 05/04/12, 06:44AM

Rss10 Retail Property Investing

10 topics, 77 posts — Last Post 05/25/12, 10:15AM

Rss10 CRE Financing and Lending

26 topics, 247 posts — Last Post 05/23/12, 05:27AM

Rss10 CRE Syndication and Fundraising

26 topics, 236 posts — Last Post 05/20/12, 04:52PM

Rss10 CRE Property Management & Leasing

2 topics, 12 posts — Last Post 05/18/12, 12:34PM

The Business of Real Estate

Real Estate Technology and the Internet

Rss10 Technology, Social Media, Real Estate & The Web

270 topics, 2280 posts — Last Post 05/25/12, 10:10PM

Rss10 Real Estate Blogs & Blogging

24 topics, 293 posts — Last Post 05/16/12, 09:29PM

Business Basics

Rss10 Goals, Business Plans & Entities

428 topics, 4273 posts — Last Post 05/24/12, 09:08PM

Real Estate Finance & Legal

Financial, Tax, and Legal

Rss10 Tax, Legal Issues, Contracts, Self-Directed IRA

1349 topics, 9465 posts — Last Post 05/24/12, 07:35AM

Rss10 Credit & Credit Repair

182 topics, 1484 posts — Last Post 05/22/12, 06:06PM

Rss10 Property Insurance

135 topics, 851 posts — Last Post 05/25/12, 08:31PM

Rss10 Bankruptcy

21 topics, 113 posts — Last Post 05/21/12, 08:25PM

Loans, Mortgages, Credit Lines

Rss10 Private & Conventional Lending Discussion

1346 topics, 8087 posts — Last Post 05/25/12, 02:20PM

Rss10 Creative Real Estate Financing

659 topics, 4285 posts — Last Post 05/24/12, 10:58AM

Real Estate Professionals

Real Estate Professionals

Rss10 Real Estate Agents

639 topics, 3562 posts — Last Post 05/24/12, 07:47PM

Rss10 Bankers, Lenders, and Mortgage Brokers

355 topics, 1268 posts — Last Post 05/04/12, 01:18AM

Rss10 Contractors

122 topics, 670 posts — Last Post 05/25/12, 08:51PM

Local Real Estate

International Real Estate

Local Real Estate

Rss10 Local Real Estate Networking

612 topics, 3434 posts — Last Post 05/24/12, 02:08PM

Rss10 Americans & International Real Estate

139 topics, 505 posts — Last Post 05/20/12, 02:00PM

Rss10 Foreigners Buying in the USA

56 topics, 288 posts — Last Post 05/02/12, 07:54PM

Rss10 Canadian Real Estate

26 topics, 130 posts — Last Post 03/19/12, 05:58PM

Marketplace

Real Estate Marketplace

Rss10 Mortgages & Lending

392 topics, 1757 posts — Last Post 05/20/12, 03:10AM

Rss10 Residential Property, Land, & Farms For Sale

760 topics, 1463 posts — Last Post 05/24/12, 06:58PM

Rss10 Real Estate Events & Happenings

118 topics, 505 posts — Last Post 05/07/12, 10:07PM

Rss10 Commercial Properties for Sale or Lease

224 topics, 671 posts — Last Post 05/25/12, 08:42AM

Rss10 Domains & Website Reviews

48 topics, 391 posts — Last Post 05/25/12, 07:07AM

Rss10 Classifieds - Promote your Website, Newsletter, or Product

595 topics, 2801 posts — Last Post 05/23/12, 06:42PM

Off-Topic

Off Topic

Rss10 Off-Topic

1866 topics, 19997 posts — Last Post 05/25/12, 08:12AM

Rss10 Housing News & Real Estate Market

666 topics, 6615 posts — Last Post 05/09/12, 03:11PM

BiggerPockets Resources

Forums » Real Estate Deal Analysis and Advice » Property Analysis in Excel Spreadsheet

Property Analysis in Excel Spreadsheet Subscribe to Property Analysis in Excel Spreadsheet

8 posts by 6 users

Signup

General Contractor · Dallas/Ft. Worth, Texas


Does anybody have the property analysis tool available in an Excel spreadsheet? I was thinking of making one myself, but I thought I would check to see if anybody has one first.


Homeowner · Weare, NH


Hi Adam,

I've attached the one I use.


Homeowner · Weare, NH


Hi All,
I've noticed several downloads of the file I posted here. Feel free to post or email me any comments especially if you notice any errors in calculation! :mrgreen:


A F

Commercial Real Estate Agent


I can help if you want to do a more comprehensive analysis or if you want to send one you have completed for a second opinion.

My contact information is on my site.



I met a young wiz kid recently at a CCIM course. He just started a real estate financial analysis company that specializes in building custom financial models for small investment firms and individual investors. I've never seen anything like it, this kid was amazing.

Needless to say I spoke with him and had him working on one of my deals during the course. He creates a detailed report with everything that the top notch firms have, that we were never able to access. Not only did I end up doing the development, the report got me some great financing and made rounding up investors a breeze.

My point I guess is that basic analysis is great, especially a sheet on excel but a professional can do wonders for your business. FOr how much this kid can make you, I'm amazed he doesn't charge an arm and leg (he is actually pretty cheap if you ask me).

He gave me a few basic sheets for excel that I can send anyone if you send me your contact information.

If anyone is interested in this kid's services let me know and include your contact info. I will pass it along to him (he doesn't like his contact information passed around)

The sheets are more indepth that the one posted but still basic enough to handle without a lot of training.

best.

Other People's Money



sorry it has taken so long to reply, I'm kind of blown away by how many messages I've gotten asking about more detail. Instead of replying individually, I'm going to try to answer them all at once. I don't know what I've gotten myself into :shock:

1) what do you personally use him for? Well starting about 3 weeks ago I actually signed a " contract" with him. I was so amazed at what he did for me that I now use him on everything I do. For small prospect projects he does basic reports and helps me analysis the location, property, market etc. I have him run numbers to see if they are even feasible. These are not real indepth, I only use the comprehensive one's once I've decided to go forth or if I am deciding between two good projects, or if I am talking to investors.

2) what can he do? I've yet to figure out what he Can't do. Everything I've said " that would be great" he has done. It is hard to explain but everything is really custom. We spoke at lengths about what I was looking for and the next day he has a report that fit the bill. It was really amazing.

I was so impressed (I'm really critical so it doesnt happen often) that I flew him out to give a presentation to some potential investors. He has changed my business and for that I am very grateful. I use to do very small deals now I am doing mid size ($3-$12mil) and almost twice as many. Even the recent economic slow down has had no effect on my business.

3) What does he charge? that is another hard question to answer. He charges a " fair" price, but it is really fair. Please do not relay any of this infomation to him if you speak but I pay him a flat fee on each project and then give him a bonus. Because of what he has done for me I pay him a large amount, but he tells me that he charges fees depending on how much TIME & EFFORT the work requires. For basic number crunching, it sounds like he charges any where from $50-$150. I really don't know. For reports that I use in my presentations, lender apps etc it's a lot more.

4) Is it worth the money? ABSOLUTELY. for less than an appraisal he saves/makes me a huge amount of money. That is why I have him work on everything I do. Any huge deal he is now a part of period. We now compete with the big boys and to me that makes all the difference in the world.

5) Can you email me his contact info? Like I said before no! Give me your contact info and I will pass it along. With his services, there is absolutely no way that you can possible do everything by email unless you have lots of patience. It really helps to just get on the phone with this kid for a few minutes and talk about what you need, fees timeline etc.

6) what do the reports consist of? The reports are like nothing I have ever seen, even from the top analysts I have run across. There are proformas, cash flow analysis, sale/valuation sheets, IRR/NPV analysis (absolutely wild stuff!), expense anaylsis, monte carlo and sensitivity analysis and lots more.

Some of it is above my head, but he clearly explains the importance in his write ups. The thing I like best is " Investor profile" where he describes the ideal investor for a particular project. I found this to be so effective for raising capital, investors love it!

I don't have time to answer anymore right now, I need some sleep badly.

Email me his contact info anyone that has not done so yet. I will not send you his.

I will try to answer the rest of the questions later, but you guys are kind of overwhelming me right now. I'd rather he tells you about his business than me.

- OPM


Real Estate Consultant · Boise, Idaho


I would like to meet this whiz kid - I do the same type of work. I work with Excel and Argus extensively. I am a former appraiser and mm buyer for a large company. I have developed excellent formats for presenting and analyzing investment real estate. I use Argus on complex properties, then export the output to my Excel worksheets. These formats are the result of many years of building and refining.

I am now working independently - marketing and valuation analysis. I like to team up with investors or sellers needing help. I am very responsive and reasonable. My analysis can be as detailed and crystal clear as you wish.


Developer · Miami, Florida


Always interested in meeting a whiz kid with a reasonable menu...! Haxton by the way I have your info I'll contact you for a possible project...Im in b/w guys with your skills at the moment.....take care and thanks for the posting!




Sign up