Please answer all questions and provide working(with excel if possible). Thank you!

Common information for the first block of numerical questions in this HW. You want to purchase an office building in Brooklyn. The property contains 27,500 square feet of rentable space and is currently occupied by multiple tenants each with differing maturities on their respective leases. No lease is currently shorter than 1 year. The annual rent in the 1st year of ownership is $42.50/sq ft. The vacancy rate is 6.5%. You expect to incur collection losses (from tenant default) on 1.5% of the square feet during your first year. You decide you want to take out a loan to finance the purchase of this property. It will be an IO loan at a rate of 6.25%, compounded annually, with annual payments. The lender will provide financing up to a minimum Debt Service Coverage Ratio (DSCR) of 1.2 based off of the 1st year NOI. What is the largest annual loan payment the lender will allow you to make based on the DSCR? State your answer as a number rounded to the nearest cent (e.g. if you get $13.57654, write 13.58) QUESTION 5 Common information for the first block of numerical questions in this HW. You want to purchase an office building in Brooklyn. The property contains 27,500 square feet of rentable space and is currently occupied by multiple tenants each with differing maturities on their respective leases. No lease is currently shorter than 1 year. The annual rent in the 1st year of ownership is $42.50/sq ft. The vacancy rate is 6.5%. You expect to incur collection losses (from tenant default) on 1.5% of the square feet during your first year. You decide you want to take out a loan to finance the purchase of this property. It will be an IO loan at a rate of 6.25%, compounded annually, with annual payments. The lender will provide financing up to a minimum Debt Service Coverage Ratio (DSCR) of 1.2 based off of the 1st year NOI. What is the largest loan a lender is willing to provide you with based on the largest payment the bank would allow? (Assume this is an IO loan at 6.25\%)? State your answer as a number rounded to the nearest cent (e.g. if you get $13.57654, write 13.58) QUESTION 6 Common information for the first block of numerical questions in this HW. You want to purchase an office building in Brooklyn. The property contains 27,500 square feet of rentable space and is currently occupied by multiple tenants each with differing maturities on their respective leases. No lease is currently shorter than 1 year. The annual rent in the 1st year of ownership is $42.50/sq ft. The vacancy rate is 6.5%. You expect to incur collection losses (from tenant default) on 1.5% of the square feet during your first year. The seller's asking price for the property is $7,000,000. If the lender has a maximum 70% LTV requirement what is the most the bank will lend you (the largest loan based on LTV constraint only, ignoring DSCR)? State your answer as a number rounded to the nearest cent (e.g. if you get $13.57654, write 13.58)