From the BiggerPockets Blog

 BiggerPockets Blog »

Jump to Forum View All

Click a category below to view different forum categories.

BiggerPockets

General Info

BiggerPockets Q&A, Site Questions, & Announcements

1519 topics, 14414 posts — Last Post 04/20/14, 02:59AM

BiggerPockets Exclusive PRO Area

117 topics, 839 posts — Last Post 04/18/14, 05:47AM

New Member Introductions

10896 topics, 85720 posts — Last Post 04/20/14, 06:10AM

Real Estate Success Stories

396 topics, 6161 posts — Last Post 04/19/14, 05:20PM

General Real Estate

General Real Estate

Buying & Selling Real Estate

5943 topics, 46834 posts — Last Post 04/20/14, 06:16AM

Renters

643 topics, 5817 posts — Last Post 04/19/14, 09:29AM

Get Foreclosure Help - Help Stop Foreclosure Forum

316 topics, 2557 posts — Last Post 04/16/14, 03:58AM

Home Owner Association (HOA) Issues & Problems Forum

237 topics, 1609 posts — Last Post 04/17/14, 08:53AM

Do it Yourself

657 topics, 6278 posts — Last Post 04/20/14, 05:52AM

Reviews & Feedback

Real Estate Deal Analysis and Advice

3683 topics, 29533 posts — Last Post 04/20/14, 06:16AM

Real Estate Guru, Book & Course Reviews and Discussions

1133 topics, 11562 posts — Last Post 04/19/14, 12:17PM

Ask About A Real Estate Company

741 topics, 7323 posts — Last Post 04/19/14, 10:36PM

Real Estate Investing

Real Estate Strategies

Wholesaling

5606 topics, 43758 posts — Last Post 04/20/14, 05:18AM

Rehabbing and House Flipping

3334 topics, 31005 posts — Last Post 04/20/14, 06:08AM

Real Estate Development & New Home Construction

553 topics, 4685 posts — Last Post 04/19/14, 06:13PM

Innovative Strategies

703 topics, 6027 posts — Last Post 04/18/14, 08:48AM

Tax Liens, Notes, Paper, & Cash Flows Discussion

866 topics, 6678 posts — Last Post 04/19/14, 06:06AM

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

693 topics, 4902 posts — Last Post 04/19/14, 04:53PM

1031 Exchanges

143 topics, 1054 posts — Last Post 04/18/14, 08:41AM

Foreclosure Investing

General Foreclosure & Pre-Foreclosure Forums

1687 topics, 11292 posts — Last Post 04/20/14, 12:14AM

HUD, VA, and Tax Sales

415 topics, 3097 posts — Last Post 04/19/14, 10:19PM

REOs

1214 topics, 10578 posts — Last Post 04/20/14, 12:34AM

Short Sales

1534 topics, 13120 posts — Last Post 04/17/14, 04:44PM

Landlord & Tenant Forums

Landlord & Rental Property Questions

7207 topics, 70780 posts — Last Post 04/20/14, 06:00AM

Mobile Homes & Mobile Home Park Investing

638 topics, 5141 posts — Last Post 04/19/14, 09:49AM

Investor Basics

Starting Out

7706 topics, 60502 posts — Last Post 04/20/14, 05:08AM

Investor Psychology

431 topics, 6107 posts — Last Post 04/20/14, 06:04AM

General Real Estate Investing

4718 topics, 37215 posts — Last Post 04/20/14, 04:23AM

Real Estate Investor Marketing

1731 topics, 14094 posts — Last Post 04/19/14, 06:39AM

Commercial Real Estate

Commercial Real Estate Investing Forum

1410 topics, 8994 posts — Last Post 04/19/14, 04:34PM

Multi-Family and Apartment Investing

1109 topics, 9239 posts — Last Post 04/19/14, 07:12PM

The Business of Real Estate

Real Estate Technology and the Internet

Real Estate Technology, Social Media & Blogging

641 topics, 4896 posts — Last Post 04/20/14, 04:48AM

Business Basics

Goals, Business Plans & Entities

831 topics, 7562 posts — Last Post 04/18/14, 04:25PM

Real Estate Finance & Legal

Financial, Tax, and Legal

Tax, Legal Issues, Contracts, Self-Directed IRA

2788 topics, 20023 posts — Last Post 04/20/14, 01:26AM

Property Insurance

309 topics, 2045 posts — Last Post 04/17/14, 07:41PM

Personal Finance Discussion

328 topics, 2732 posts — Last Post 04/19/14, 06:57PM

Loans, Mortgages, Credit Lines

Private & Conventional Lending Discussion

2835 topics, 19704 posts — Last Post 04/20/14, 06:05AM

Creative Real Estate Financing

1210 topics, 8771 posts — Last Post 04/19/14, 08:28PM

Crowdfunding Real Estate

35 topics, 463 posts — Last Post 04/19/14, 06:24PM

Real Estate Professionals

Real Estate Professionals

Real Estate Agents

1211 topics, 7995 posts — Last Post 04/19/14, 08:09PM

Bankers, Lenders, and Mortgage Brokers

442 topics, 1924 posts — Last Post 04/19/14, 07:27PM

Contractors

269 topics, 1681 posts — Last Post 04/20/14, 04:59AM

Local Real Estate

Local Real Estate

Local Real Estate Networking & Recommendations

1990 topics, 11614 posts — Last Post 04/19/14, 07:40PM

Americans & International Real Estate

161 topics, 566 posts — Last Post 04/14/14, 11:19AM

Foreigners Buying in the USA

62 topics, 409 posts — Last Post 04/10/14, 06:27AM

Canadian Real Estate

64 topics, 428 posts — Last Post 04/18/14, 04:22AM

Marketplace

Real Estate Marketplace

Real Estate Marketplace

15021 topics, 53962 posts — Last Post 04/20/14, 05:42AM

Real Estate Events and Happenings

164 topics, 2515 posts — Last Post 04/19/14, 07:29PM

Off-Topic

Off Topic

Off-Topic

2905 topics, 32411 posts — Last Post 04/19/14, 08:03AM

Housing News & Real Estate Market

914 topics, 8351 posts — Last Post 04/17/14, 08:41AM

BiggerPockets Real Estate Investing Summit

97 topics, 1751 posts — Last Post 04/10/14, 02:27PM

BiggerPockets Resources

Forums » Real Estate Deal Analysis and Advice » Financial Modeling of Renovation/Rehab Costs

Financial Modeling of Renovation/Rehab Costs

7 posts by 4 users

Signup

· New York City, New York


You acquire a property that as a renovation/rehab play, not necessarily just for the units themselves, but also improvements to be made to building systems and exterior . . . Let's say you already know the approximate $ figures of the costs of the renovations you plan to make to the property. I usually just add this amount to the cash invested equity portion. But I am curious to see how others might be incorporating renovation/rehab costs in their financial model, especially if these changes are done over time, a period of a few years perhaps. Also, where you are adding these costs to - to the equity portion? taking additional debt? seller concession? How do you typically account for these renovations costs in your financial model?



Real Estate Investor · Ellicott City, Maryland


Are you talking about a SFH or an apartment? My answer would be different between a SFH rehab and an apartment value play where you're building equity by increasing cash-flow.

In general though, there are two options:

1. Assume all rehab costs are laid out upfront as part of your purchase costs. If you plan to hold the property for a while, this will skew your annual cash-on-cash return numbers as well as your IRR, but it's easier than trying to forecast when your expenses may come if you don't know. Also, this is a conservative approach, which is never bad.

2. You can try to forecast your future outlays, and use your income and outlays to build a model that predicts your IRR at various points in time, depending on when you ultimately decide to sell. This will give you a more realistic assessment of your return, but is obviously dependent on your being able to forecast your rehab expenditures.


Small_lishproplogoJ Scott, Lish Properties, LLC
E-Mail: [email protected]
Telephone: 770-906-6358
Website: http://www.123flip.com
CHECK OUT MY BIGGERPOCKETS BOOKS: http://www.biggerpockets.com/flippingbook


Real Estate Investor · Round Rock, Texas


That is a pretty broad question Michael. JScott's answers are terrific, as usual.

For certain projects the precision of the cash outlays won't really matter much. For other projects slippage in dates matters a great deal if you are using measurements that account for the time value of money. I like using IRR because it is difficult to determine a cost of capital to use NPV and the measurement still works well on most projects.

How the costs or contributions are modeled depends on the project too. In some instances the seller will give concessions that can reduce your initial cash outlay if the lender agrees to it. For most projects the improvements will be coupled with cash outlays that would need to be approximated over time using your judgment. For multi-year projects lumping approximate outlays into months each year to go with potential rent collection will generally suffice.

So the answer is that "it depends." Sorry...it just does depending on the circumstances of the project. That is why people build their own custom models instead of using Argus or other packages with canned functionality.


Small_inner10_logo__updated_Bryan Hancock, Inner 10 Capital
E-Mail: [email protected]
Telephone: 1-800-577-0401
Website: http://www.inner10capital.com/invest/
Join Our Investor Base - Currently Growing 12% Per Week


· New York City, New York


Thank you both very much for your insight.
J Scott: I am referring to a multi-family property, not a SFH. I like the conservative approach of laying the total figure out in the front of the model as part of the purchase price, with the hope being that the seller is more flexible on the price due to the renovations that need to be made. However, lumping in a large number upfront can also decrease the COC return, which many investors are looking for in the first year or two (of course until your improvements increase the property's top line numbers)
Bryan: I certainly see the validity in approximating the cash outlays over time on a monthly basis against the property's revenue as another approach.
At the end of the day, financial modeling is in many ways an art just as much as it is a science. I guess I will need to tinker with my models using both of your approaches to see the various returns that each approach yields, and perhaps take some sort of average of the two!
Thanks again!



· Stone Mountain, Georgia


For Apartments --depending on type of rehab-
you always buy at lower price --however--if you plan to get financing --you do projections and add cost -- to purchase price --lender can include the rehab costs --
However, renovations to building or structral repairs --called Improvements --such that it will increas value of property and of course higher rent -- than it is different --it is deffered maintenance - and have to consider based on components -- you also need to talk to an accountnt --for depreciation consideration --you need to buy a soft ware to anlayze -- using what if senerios -- for different assumptions -- IRR is the best -- always leverage and refinance to maximum available at the time --after rehab or major renovations are done and rent increases or cash flow increases --

I have done this for several Hotel loans ---similar principal apply --I use simple spread sheet to do five year proforma projections and improvements are added to loan --Lender keep money in escrow- called reserve for improvemnets -- fixed amount based on Recommendation in an Engineering Report. The engineering report identifies major components and remainig life- then estimated cost to replace in year one, two, three--like that -- you have to plan for that and set aside some money every year --for future repairs.

Hope this will help you --

What size apartment complex is it ??

Also --if it is too old --may have Asbestose and Lead Based Paint issues --- very expensive ---



Real Estate Investor · Round Rock, Texas


A poster named John is actually building what seems like a decent tool to automate some of this. I sent him some of our non-proprietary models to give him a sense of the way we model things. I am happy to forward those to you if you want to dig through them.

Modeling all of the rehab cash outlay at the beginning of the project certainly is conservative. I would argue it is too conservative, especially if you are trying to attract equity funding via LPs.


Small_inner10_logo__updated_Bryan Hancock, Inner 10 Capital
E-Mail: [email protected]
Telephone: 1-800-577-0401
Website: http://www.inner10capital.com/invest/
Join Our Investor Base - Currently Growing 12% Per Week


Real Estate Investor · Ellicott City, Maryland


Personally, I like to do my analysis in two steps:

1. I use my models to determine what my monthly and annual cash-flows will look like given a stabilized investment, and then...

2. I manually take those monthly or annual cash-flows from my model and create a list of cash-flows. I modify those cash-flows manually with my presumed rehab costs, and then run an IRR on it.

Here's an example (see attached spreadsheet)...

Let's say I want to model an empty apartment building that I'm rehabbing over the course of a couple years. I purchase it for $200K, and I have to immediately (over the first two months) put in $100K to start getting it rented. In the first twelve months after rehab, my model indicates a monthly cash-flow of $2500/month.

Then, after twelve months of cash-flow, I plan to sink another $100K into more renovations (which takes 2 more months), and for the next twelve months, my model indicates that I can expect a cash-flow of $6000/month.

At this point, I plan to sell the building for $500K.

Given that example, I take my monthly cash flows projected by my two models, and augment them based on my purchase/sale/rehab expenses, and run an IRR to get my expected return (in this case, about 25%).

If you want to see what this looks like for this example, see the attached spreadsheet...

Hope this helps!


Small_lishproplogoJ Scott, Lish Properties, LLC
E-Mail: [email protected]
Telephone: 770-906-6358
Website: http://www.123flip.com
CHECK OUT MY BIGGERPOCKETS BOOKS: http://www.biggerpockets.com/flippingbook




Sign up