Question

ABC Fund has decided to enter a joint venture with Newton Development Inc. to develop and operate an office building that will require an initial investment of $200 million to cover all the development costs. There will be no debt financing for the joint venture. Each partner invests its capital at the beginning of the first year and cash flow from operations is projected as follows:

Year 1 $3,000,000

Year 2 $8,500,000

Year 3 $19,000,000

Year 4 $27,000,000

Year 5 $42,500,000

Year 6 $57,000,000

It is expected that the property will sell for $300 million at the end of year 6. ABC Fund will invest $180 million and Newton Development will invest the remaining $20 million. The development costs already include a developer fee to Newton and the cash flow projections for each year above are net of a property management fee being paid to Newton Development Inc. ABC Fund will receive a 5% preferred return that is noncumulative. After ABC is paid its preferred return, Newton Development Inc. will receive a 5% operating return that is noncumulative on its contributed capital. Remaining cash flows from operation, if any, will be split 50-50 to each party. When the property is sold, proceeds from the sale will be distributed as follows:

1. First, repay the initial capital investment by ABC Fund

2. Next, repay the initial capital investment by Newton Development Inc.

3. Next, pay ABC fund a 14 percent IRR preference on its investment

4. Thereafter, split all proceeds 50-50

Use the above assumptions to calculate the (i) cash flows that each party will receive and (ii) the expected IRR for each party.

Answer 1

The same with Excel Formulas shown:

(i) Cash flows that each party will receive

(ii) Expected IRR for each party