please help me solve this with excel im having a hard time

Q2 Given the following information, calculate the going-in capitalization rate for the specific property: First-year NOI: $250,700; Acquisition price: $4,250,000; Equity investment: 30%; Before-tax cash flow: $60,500. Q3 Given the following information, calculate the debt coverage ratio for this investment: Potential gross income: $123,500; Vacancy rate: 5%; Net operating income: $64,975; Operating expenses: $52,350; Acquisition Price: $625,000; Debt service: $45.620. Please show your work in an Excel file, highlighting the answers