How can I input the following in Excel?

Knight's Plaza Purchase Price: $1,250,000 Acquisition Costs: $55,000 Year 1 EGI: $145,700 Year 1 OpEx: $35,000 Loan Information: Loan Amount: $875,000 Minimum DSCR: 1.35 Interest Rate: 6.5% Amortization Period: 20 years Loan Term: 10 years Loan Costs: 2% of loan Given this information calculated your year 1 cash flows, initial equity investment and the following ratios: Going-in Cap rate, Cash-on-cash, EGIM, OER, LTV, DCR, and DYR