As part of your due diligence, you connected with your loan officer. They can offer you a loan at a 5.25% interest rate, a 75% loan-to-value ratio, with monthly payments calculated based on a 25-year amortization period. You would also be expected to buy down 1 point(s) of the loan amount to secure that interest rate. Your broker also told you that you should budget an additional $5,500 for other closing costs.

Considering the data above, how much cash should you budget to make this investment?

What is your expected annual debt service payment?

What is your equity dividend rate in year 1?

What is your before-tax cash flow in year 3?

If your lender stipulated that you must maintain a debt coverage ratio of at least 1.25, is your expected before-tax cash flow in year 1 sufficient to maintain this?

At the end of five years, how much will you still owe on the mortgage?

What is your effective cost of borrowing if you sell the property and pay off the loan at the end of year 5?

Assuming that your investment criteria are such that you need to earn 10.00% on your equity investment, what is the leveraged net present value (NPV)?

What is the leveraged internal rate of return (IRR)?

Considering your initial cash investment, how much do you expect your equity to appreciate, assuming annual compounding?