You currently live at Boardwalk and are considering taking a mortgage out on your property to pay off several rental properties that you own. The bank has approved you for a 12 year loan at 2.79% and up to $150,000 borrowed. Your goal would be to pay off 4 of your rentals. You currently have the following rental properties in your portfolio: 1. St Charles Place: 6.125% interest, 30 year, original loan amount 50,000. You just made payment #109 2. Marvin Gardens: 5.75% interest, 30 year, original loan amount 47,000. You just made payment # 110 3. Tennesse Ave: 4.375% interest, 10 year, original loan amount 42,000. You just made payment #58 4. States Ave: 5.875% interest, 15 year, original loan amount 54,000. You just made payment #72 5. Virgina Ave: 6.875% interest, 30 year, original loan amount 44,000. You just made payment #96 6. St. James: 4.46% interest, 10 year, original loan amount 50,000. You just made payment #44 As a business owner you want to review your options and see which one makes the most sense.

1. Which combination of properties will result in the most amount of interest saved over the course of the loan?

2. Which combination of properties will result in the most benefit in cash flow today?

3. If as the owner you would like to find a balance between cash flow and interest saved; then which combination of properties would you recommend paying off? (show all work)

should use excel to create an amortization table . Use the payment (PMT) solver in excel to calculate payment.