pls show steps in excel i cant understand how to solve

From the Investment Decisions and Ratio Slides: You are considering purchasing a small office building for $1,975,000 Your expectations include: . . First-year gross potential income of $340,000; Vacancy & collection losses equal to 15% of PGI; Operating expenses = 40% of EGI; Capital expenditures = 5% of EGI Mortgage (75% LTV) @ 7% o What is debt amount? Mortgage will be amortized over 25 years with a monthly payment o What is the monthly payment ? Total up-front financing costs = 2% of the loan amount o What will be the Net loan proceeds to borrower? What is the required equity investment? Calculate the following Ratios: o Going-in Cap Rate o Cash-on-Cash EGIM o OER DCR DYR Prepare this information in Excel and highlight the requested information From the Investment Decisions and Ratio Slides: You are considering purchasing a small office building for $1,975,000 Your expectations include: . . First-year gross potential income of $340,000; Vacancy & collection losses equal to 15% of PGI; Operating expenses = 40% of EGI; Capital expenditures = 5% of EGI Mortgage (75% LTV) @ 7% o What is debt amount? Mortgage will be amortized over 25 years with a monthly payment o What is the monthly payment ? Total up-front financing costs = 2% of the loan amount o What will be the Net loan proceeds to borrower? What is the required equity investment? Calculate the following Ratios: o Going-in Cap Rate o Cash-on-Cash EGIM o OER DCR DYR Prepare this information in Excel and highlight the requested information