Solve using excel:

A. Suppose you are considering the purchase of an apartment building that has 12 units that can be rented out at $1,050 per month. You have estimated operating expenses and expected vacancy and collection losses for the first year to be $35,700 and $30,240, respectively. You also have estimated that you will be able to generate an additional $3,840 in the first year from garage rentals on the property. If the expected purchase price of the property is $1,100,000 and you are planning on making a 10% down payment, calculate the debt yield ratio.

B. Assume you have taken out a balloon mortgage loan for $2,500,000 to finance the purchase of a commercial property. The loan has a term of 5 years, but amortizes over 25 years. Calculate the balloon payment at maturity (Year 5) if the interest rate on this loan is 4.5%.