***PLEASE PREPARE CASH FLOW STATEMENT***

You and a developer have bought a site with equity for $200,000 on the last day of Year 0. You develop the project for an additional $750,000 that will be built in Year 1 which will be financed entirely by a construction loan including all interest. Upon completion, the project will be worth $1,000,000. At the completion of construction, you and the developer will obtain permanent financing in the amount of $750,000. A recap of the capital structure is outlined below. . First mortgage of $750,000 Construction financing of $750,000 Preferred equity of $180,000 Developer equity of $20,000 0 Cash flow assumptions are as follows: 1. We will assume or define the time period when the land is purchased is at the end of Year 0 or 12/31/00. 2. The project will be completed during Year 1 and the construction loan paid off at the end of Year 1. 3. Lease-up begins Year 2 or 1/1/02. We will ignore partial leasing during the year and assume all cash flows received will be at the END of the year. 4. Assume net operating cash flows start in Year 2 at $60,000/year and grow at 1%/year. 5. First mortgage of $750,000 has an interest rate of 5.5% on the outstanding balance. Also $2,000 of amortization is paid per year. 6. $50,000 of Cap Expenditures are required in years 4 and 9, thus reducing cash flow. NOTE: this will require additional equity contributions by the partners. 7. At the end of Year 11, the project is sold based on Year 12's NOI capped at 6%. The financial commitments and assumptions are as follows: 1. You as the Preferred Equity or Money Partner will cover 90% of the land cost while the operational partner will contribute 10% and retain operational control. Both partners are responsible for their proportionate shares of additional capital contributions. 2. You as the Money Partner will receive a 6% cumulative preferred return on your investment AFTER debt service has been paid on the senior loan. 3. Any cash flow remaining after all preferred return arrearages and preferred return are paid will be split 50/50. 4. The waterfall while operating the property is as follows: I. Total preferred return earned; II. Payment of previous earned but not paid; III. Any cash flow remaining is split 50/50. 5. The waterfall upon sale is as follows: I. Repayment of debt II. Total preferred return earned; III. Payment of previous earned but not paid; IV. Return of equity V. Any cash flow remaining is split 50/50. NOTE: Any equity investments made by the partners are NOT recovered until a final disposition of the property Compute the following: 1. Prepare a cash flow statement from Year 0 to Year 12. 2. Prepare an permanent debt amortization table. 3. Prepare a Preferred Equity Capital account for the Money Partner. 4. What is the IRR to the developer? 5. What is the IRR to the money partner? E23 JX A G B C D E F H I J L M N 0 Note: The preferred equity return described here specifies current earned preferred return, to be compounded, but to be paid from only (but all of) the current operatin 90% 6.00% 50% $200,000 1% 5.50% $2,000 $50,000 $50,000 6% OPERATIONS SALE Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Year 11 Year 12 1 Splits analysis: Expected Case 2 Preferred Equity Partner Contribution 3 Preferred Return 4 Preferred Partner Residual Share 5 First Year Operating CF 6 Operating CF Growth Rate 7 Mortgage Rate 8 Yearly Amortization 9 Capital Expenditures (Year 4) 10 Capital Expenditures (Year 9) 11 Reversion Cap Rate 12 Calendar Years Ending: 13 Project Cash Requirements as Proposed: 14 Site Acquisition 15 Hard & Soft Development Costs 16 Total Devipt Phase Cash Requirements 17 Devlpt Phase Total Equity Funding 18 Devlpt Phase Debt Funding (Constr Loan) 19 Construction Loan Repayment 20 Proposed Permanent Loan Amount (Take Out) 21 Operating Cash Flow 22 Capital Expenditures 23 Reversion Cash Flow 24 PBTCF 200,000 750,000 (750,000) (200,000) 200,000 750,000 (750,000) 750,000 0 0 0 0 0 0 0 0 0 0