Part 2 is the information you need to calculate the purchase, financing and sales proceeds for Part 1. From there you will be able to add the Debt Service, BTCF, Levered and Unlevered BTCF to your Part 1 Annual Cash Flows. Then answer the 3 questions you are asked.

Part One Directions Complete pro forma for NOI Commercial Complex 4 tenants Property will be held for 5 years Tenant Lease Type Size Current Lease Rate Rent Growth CAM Bank NNN Outparcel $85,250/yr 2.15% $4.50/ sq ft Retailer Percentage 3,125 foot Plus 4.55% Tenant revenue is Limited to expected to $2.75 per sa grow at 2.5% per year Pro rata on Year 1 sq feet Revenues are $310,000 revenue Office 9,600 $21.00/ sq ft CPI None Limited to $5.25 per sa foot Office 4,375 $22.50/ sq ft CPI Pro rata on sq feet OP EX Category Cost Growth Rate Utilities $3.25 per sq ft 2.85% per year Taxes $11,627 per year 2.75% per year Insurance $2.75 per sq ft 2.0% per year Maintenance $3.15 per sq ft 3.15% per year CPI Rate Years 1-3 1.75% Years 4-7 2.25% Years 8-10 3.25% Part Two Questions: 1. Calculate The Max Debt for this property. 2. Calculate the amount of equity needed for this property. 3. Calculation the Net Sale Proceeds to Owner. Going In Cap Rate 6.25% Terminal Cap Rate 5.75% Loan Interest Rate 3.35% Max loan to value for debt 60% Required Debt Service Coverage 1.42 Discount Rate 12% Loan Amortization Period 20 years Loan Term 7 years Loan Fees 2.0% Cost of Sale 3% Make sure to show your work in the uploaded Excel file (be sure to show cash flows through BTCF). Part One Directions Complete pro forma for NOI Commercial Complex 4 tenants Property will be held for 5 years Tenant Lease Type Size Current Lease Rate Rent Growth CAM Bank NNN Outparcel $85,250/yr 2.15% $4.50/ sq ft Retailer Percentage 3,125 foot Plus 4.55% Tenant revenue is Limited to expected to $2.75 per sa grow at 2.5% per year Pro rata on Year 1 sq feet Revenues are $310,000 revenue Office 9,600 $21.00/ sq ft CPI None Limited to $5.25 per sa foot Office 4,375 $22.50/ sq ft CPI Pro rata on sq feet OP EX Category Cost Growth Rate Utilities $3.25 per sq ft 2.85% per year Taxes $11,627 per year 2.75% per year Insurance $2.75 per sq ft 2.0% per year Maintenance $3.15 per sq ft 3.15% per year CPI Rate Years 1-3 1.75% Years 4-7 2.25% Years 8-10 3.25% Part Two Questions: 1. Calculate The Max Debt for this property. 2. Calculate the amount of equity needed for this property. 3. Calculation the Net Sale Proceeds to Owner. Going In Cap Rate 6.25% Terminal Cap Rate 5.75% Loan Interest Rate 3.35% Max loan to value for debt 60% Required Debt Service Coverage 1.42 Discount Rate 12% Loan Amortization Period 20 years Loan Term 7 years Loan Fees 2.0% Cost of Sale 3% Make sure to show your work in the uploaded Excel file (be sure to show cash flows through BTCF)