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%
  • What is debt amount?
• Mortgage will be amortized over 25 years with a monthly payment
  • What is the monthly payment ?

Can you teach me how to do this on excel? Thank you!