You currently live at Boardwalk and are considering taking a mortgage out on your property to…

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.