Solve using excel:

A. Given the following information, calculate the debt coverage ratio of this commercial loan. Estimated net operating income (NOI) in the first year: $150,000, Debt service in the first year: $100,000, Loan amount: $1,000,000, Purchase price: $1,300,000

B. Given the following information, calculate the loan-to-value ratio of this commercial loan. Estimated net operating income in the first year: $150,000, Debt service in the first year: $100,000, Loan amount: $1,000,000, Purchase price: $1,300,000

C. Given the following information, calculate the debt yield ratio on the following commercial property. Estimated Net Operating Income in the first year: $2,500,000, Debt service in the first year: $960,000, Loan amount: $20,000,000, Purchase price: $27,300,000