• Size the loan for a property with the purchase price and NOI provided below. • Include the Monthly Payment and Annual Debt Service for all the loan sizing criteria. • Use the MIN function to determine the loan amount in a separate cell and state which of the sizing criteria is determining the loan amount. Property Information Purchase Price/Appraised Value $9,575,000 NOI $577,500 Loan Information Interest Rate 6% Amortization 30 Yrs Sizing Criteria LTV 75% DSCR 1.15x Debt Yield 8% include correct formulas in excel sheet