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 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)