A rental property is listed for $2,000,000. It contains 4 units each renting for $2,750 per month. Assuming tax rate is 1.25% of the purchase price per year and insurance is 1% of purchase price per year. If I put 5% down assuming 5% interest rate, what price should I buy this property for in order to break even on the monthly payments? Please show excel calculations.

The Nguyens are thinking of buying a home for $121,000. A potential lender advertises an 80%, thirty-year simple interest amortized loan at 8 and 1/4% interest, with an APR of 9.23%. Use the APR to approximate the fees included in the finance charge. (Round your answer to the nearest cent.)

Suppose you obtain a 20-year mortgage loan of $196,000 at an annual interest rate of 7.9%. The annual property tax bill is $966 and the annual fire insurance premium is $488. Find the total monthly payment for the mortgage, property tax, and fire insurance. (Round your answer to the nearest cent.)

Assume you buy a house for $660,000 and have $132,000 as a down payment. Your mortgage rate is 3 percent APR compounded semi-annually and you amortize the mortgage over 25 years with monthly payments. You will assume that you could have earned 5 percent EAR on the down payment (opportunity cost), your marginal income tax rate is 40 percent, real estate fees are 4 percent +HST and property taxes will be $6,600 annually for this calculation. Ignore maintenance costs. a. What is the true return on your investment if you sell it in 6 years for $1,040,000? (Do not round your intermediate calculations. Round your answer to 2 decimal places. Omit the "%" sign in your response.) Return on Investment % b. What is an approximate annualized rate of return on your investment? (Do not round your intermediate calculations. Round your answer to 3 decimal places. Omit the "%" sign in your response.) Annualized Rate of Return %