please show all steps in excel if possible

5,6,7 only please

You buy two more properties. You distribute the following cash flows from their operations to your investors each year: 1 2 3 350,000 400,000 450,000 NOI 4 500,000 5 550,000 You distribute 100% of the cash flows from operation of all three buildings to your investors each year. 5. How much do you have to earn from the sale of these two properties, remembering again that you pay 3% in selling expenses, in order to achieve your investors' target 50% holding period return? 6. How much do these two property values have to appreciate in order to achieve your investors' target 50% holding period return? 7. If these properties actually appreciate by 75% instead, how much capital gets distributed to you and how much to your investors? Q Search or enter website name 2 3 5 7 8 9 1 0 Q E R T Y U 1 0 A S D F G H J K L Z V B N M 26 command command option You are considering the purchase of a small office building. The NOI is expected to be the following: 1 2 3 200,000 210,000 220,000 4 230,000 5 240,000 6 250,000 NOI You set aside 8% of NOI every year for capital reserves. The property will be sold at the end of year 5, an you will pay 3% of the price in selling expenses. You believe that the property will have a terminal cap rat of 7%. You plan to pay all cash for the property. You want to earn a 10% IRR annually. 1. What property value are you projecting at the end of year 5? 2. What purchase price should you pay to earn your desired IRR? 3. If everything works out according to your projections, how much will the property value appreciate over these five years? You decide to create a closed-end fund to buy the office property. The fund will have a five-year life. You want a minimum holding period return of 50% for your investors. As the fund manager, you will receive a "promote" equal to 25% of cash flows remaining after sale of the assets and after equity investors receive their 50% preferred return. You raise an equity investment of $15 million 4. After you buy the office property for the purchase price you determined above, how much capital descombasa...mins2