How do you compute IRR without any negative cash flows?

I've been working on this modeling exercise in excel for a real estate development. There is an initial construction loan, and initial cash outflow from the land purchase, but the problem is that the construction costs are supposed to me amortized evenly over 12 months. So you have all this cash coming in immediately from the loan (in excess of the amount being spend on just the land and first month of construction), such that the period 1 cash flow is positive. But the IRR formula doesn't work if you don't have at least one negative cash flow value.

What should I do? Should I spread out the disbursement of the loan funding over 12 months as well? If I did it exactly evenly, it wouldn't cover the land purchase in the first month. So what if I subtracted the land value from the total loan, and then disbursed the remaining money of that loan over 12 months? So say the loan is for 4.5m and the land is 3m. You'd initially receive 3m + 1.5m/12, and then 1.5m/12 for the next 11 months.

Does that make any kind of sense?

Thanks for any help

 

Oh I see, so if I'm doing this as a modeling test for a REIT or something, typically I should assume that the CL does not factor in land cost? Should I make the CL proceeds received evenly over the construction phase?

Thanks for your help.

 
Most Helpful

Bank will occasionally allow you to step up your land cost to value for loan sizing, but I would assume it's at cost. You typically fund all of the equity first before the lender puts in any money, so construction loan proceeds would cover the last $X of your costs.

Overly simple example: You buy land for $100. That will generally come exclusively from equity (negative cash flow). If you have $400 of additional construction costs, the bank may lend you $250 (50% LTC). The first $250 comes from equity - so the land purchase and the first $150 of construction costs are negative CFs. The remaining $250 comes from the construction loan (net $0 CFs as the loan is funded).

 

What doesn't make sense about it?

When you say in your other comment that there is no cash flow during construction phase, I understand that there is no rental income, but aren't the receipt of funding, loan payments, and construction costs considered cash flows? Isn't the IRR computed off all cash flows including those?

What does it mean that the equity contribution account is fully deployed? I'm unfamiliar with this terminology.

Thanks

 

Say the capital stack is 35% equity and 65% debt (construction loan). The equity contribution will be completely used before the construction loan proceeds kick in. So...in most instances...the equity will cover the costs at closing (including the land acquisition) and the equity account will continue to be drawn down until it is depleted. On most projects...the equity contribution will float all of the costs for the first few months post closing.

 

Construction loan could include the cost of the land acquisition. You close on the land when you close on the loan...in most instances.

You receive the construction loan proceeds in draws (usually monthly basis) as the project is being developed.

There is no cash flow during the construction phase.

The equity contribution account is fully deployed before the construction loan proceeds are used (again...in most instances). So...the equity portion will often technically be the source of funds used to close on the dirt.

 

To summarize what the others are saying, there are several different IRRs that can be calculated.

If you are trying to find the IRR for the investors (equity), then the initial contribution is the negative cash flow. Construction loan draws would not be factored into the cash flows and the only cash flows that would show up from the debt side would be proceeds from cash out during refinancing, NCF (after Debt Service), and debt retirement.

If you are trying to find the property level IRR, then both the equity investment and debt draws are negative cash flows. Everything that is tied to NOI pre-debt is considered to be part of the cash flow as well as the disposition value. Debt is completely removed from the equation.

 

Facere accusantium eos quaerat laboriosam quia asperiores. Iste eveniet velit quis numquam. Temporibus odit quo quia optio est. Consequuntur quibusdam explicabo minus esse esse et maxime et. Ut ea qui consequuntur dolores non molestiae. Ratione dolorem corporis delectus quia aliquid. Et dicta est ratione voluptate.

Accusantium molestias quo et quae eos dolore. Totam quasi delectus in. Iure mollitia rerum dolorem. Sequi ipsa voluptatem enim dolor. Nisi quis voluptate possimus tempora. Optio nihil mollitia quas veniam. Et aliquam sunt dolor temporibus explicabo autem dolorem et.

Quod sapiente quis ullam doloremque nam odit voluptates. Aut culpa velit consequatur quasi id aliquid quisquam. Repellat magni sit similique autem sint dolorum ipsum. Cupiditate voluptas ipsa voluptatem quasi.

Consequatur sunt nam aliquam cumque et distinctio. Officia ut recusandae itaque quis ratione itaque. Perspiciatis amet eius tenetur enim dolores adipisci. Voluptatem amet temporibus nihil nam ad dolorem enim. Quis rerum occaecati illum impedit.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
kanon's picture
kanon
98.9
6
DrApeman's picture
DrApeman
98.9
7
dosk17's picture
dosk17
98.9
8
CompBanker's picture
CompBanker
98.9
9
GameTheory's picture
GameTheory
98.9
10
numi's picture
numi
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”