1) Based on the lenders' underwriting requirements, what is the maximum amount, in dollars, they will lend?

2) Based on this scenario, what are the after-tax sales proceeds, in dollars, available for distribution to the equity?

3) Based on the brother's return requirements, should the investor expect the brother to participate? (Yes or No)

You are considering the purchase of a small office building. The office building specializes in offering facilities to small startup firms who are looking to avoid long-term commitments while their businesses are growing. Tenants sign one-year leases and may renew at market rates, if they so desire. The building is configured with 20 suites. Five (5) suites have 4,000 useable square feet and five (5) have 2,500 usable square feet. The remaining 10 suites each have 1,000 useable square feet. The building has 7,500 square feet of common area. In addition, a food truck pays $5,000 per year to operate in the parking lot during lunch hours.Market rents are $35 per square foot, based on total leased space. As this is the only similar facility in the market, market rents are expected to increase 4% per year indefinitely. Property taxes are $250,000 per year and increases are capped at 2% per year. Other operating expenses total $280,000 per year and are expected to increase at the rate of inflation, estimated at 3% per year. In most years, capital expenditures equal 4% of effective gross income, although the roof will need to be replaced just before the expected sale at the end of year 5, at an estimated cost of $175,000. You estimate that 5% of the space will be vacant, on average, and that collection losses will total 2% of occupied space.Your market review indicates this property will sell at a price yielding a going-in capitalization rate of 8%. You believe the cap rate will increase to 8.5% at the time of a sale. Selling costs are expected to be 5% of the gross sales price. This building is suitable for professional investors, who view capital expenses as a "below the line" item. Based on these parameters, the unleveraged property returns exceed your required returns and you decide to seek mortgage financing. Local lenders are willing to lend up to 65% of the value of the building provided that debt service coverage exceeds 1.35x. Because of the relatively short holding period, lenders are willing to provide interest-only financing at 5.5% with total fees of 1.5%. You expect to close on the purchase on January 1. The land value is estimated at 20% of the purchase price. Because of the start-up nature of the tenants, there is effectively no personal property. Ordinary income is taxed at 30%, while capital gains are taxed at 15%. The depreciation recapture rate is 25%. Your brother will invest with you on a pro rata basis, provided his after-tax returns are projected to exceed 15%. Construct a Pro Forma Income Statement