Homework Help Question & Answers

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.

0 0
Add a comment
Answer #1
The bank has approved you for a 12 year loan at 2.79% and up to $150,000 borrowed.
Interest in this loan = 150000*2.79% 4185
Rental Properties Loan amount Tenure of loan Interest % Interest p.a
St Charles Place 50000 30 6.13% 3062.5
Marvin Gardens 47000 30 5.75% 2702.5
Tennesse Ave 42000 10 4.38% 1837.5
States Ave 54000 15 5.88% 3172.5
Virgina Ave 44000 30 6.88% 3025
St. James 50000 10 4.46% 2230
Total Interest 16030
1 Here interest rate for Virgina Ave, St Charles Place & States Ave are higher.
So we need to pay them first to get the higher interest savings.
Interest rate Interest savings
Amount of loan taken 150000
Less paid for Viggina Ave -44000 6.88% 3025
Less paid for St Charles Place -50000 6.13% 3062.5
Less paid for States Ave -54000 5.88% 3172.5
Balance remaining 2000
Less paid for Marvin Gardens -2000 5.75% 115
Balance remaining 0
Total Interest saved 9375
Less Int paid on loan -4185
Net Interest saved 5190
2 Most benefit in cashflow today
So here we need to pay first to whom whose tenure of loan is lower
Accordingly
Interest rate Interest savings
Amount of loan taken 150000
Less paid for St James -50000 4.46% 2230
Less paid for Tennesse Ave -42000 4.38% 1837.5
Less paid for States Ave -54000 5.88% 3172.5
Balance remaining 4000
Less paid for Virginia Ave -4000 6.88% 275
Balance remaining 0
Total Interest saved 7515
Less Int paid on loan -4185
Net Interest saved 3330

3. If owner choose both the combination, then he should first pay the loan with lower tenure & loan with higher interest to meet the requirment of owner. So it is beeter for the owner to pay St James 1st, & then Virginia Ave & St charles place to get the higher saving in interest as these both properties have higher rate of interest.

Add a comment
Know the answer?
Add Answer to:
You currently live at Boardwalk and are considering taking a mortgage out on your property to...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coin

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 4. A. What would be your monthly mortgage payment if you pay for a $250,000 home...

    4. A. What would be your monthly mortgage payment if you pay for a $250,000 home by making a 20% down payment and then take out a 3.74% thirty year fixed rate mortgage loan where interest is compounded monthly to cover the remaining balance. All work must be shown justifying the following answers Mortgage payment = B. How much total interest would you have to pay over the entire life of the loan. Total interest paid = C. Suppose you...

  • When you purchased your car, you took out a five-year annual payment loan with an interest...

    When you purchased your car, you took out a five-year annual payment loan with an interest rate of 6.1% per year. The annual payment on the car is 5,500. You have just made a payment and have now decided to pay off the loan by repaying the outstanding balance. What is the payoff amount for the following scenarios? a. You have owned the car for one year (so there are four years left on the loan)? b. You have owned...

  • When you purchased your car, you took out a five-year annual-payment loan with an interest rate...

    When you purchased your car, you took out a five-year annual-payment loan with an interest rate of 6% per year. The annual payment on the car is $5,000. You have just made a payment and have now decided to pay off the loan by repaying the outstanding balance. What is the payoff amount for the following scenarios? a) You have owned the car for one year (so there are four years left on the loan). b) You have owned the...

  • (round the the nearest cent) When you purchased your car, you took out a five-year annual-payment...

    (round the the nearest cent) When you purchased your car, you took out a five-year annual-payment loan with an interest rate of 6.2% per year. The annual payment on the car is $5,200. You have just made a payment and have now decided to pay off the loan by repaying the outstanding balance. What is the payoff amount for the following scenarios? a. You have owned the car for one year (so there are four years left on the loan)?...

  • Mortgage Amortization Complete the loan amortization schedule for a Mortgage that will be repaid over 360...

    Mortgage Amortization Complete the loan amortization schedule for a Mortgage that will be repaid over 360 months and answer the following questions (The details about the loan are shown below): Correct Answers 1. What is your monthly payment? 2. What is the total $ amount of payments made over the life of the loan Enter Answers Here. 3. How many months will it take to pay off the loan if you pay an extra $465.71 per month? Note: Enter the...

  • The mortgage on your house is five years old. It required monthly payments of $ 1,422,...

    The mortgage on your house is five years old. It required monthly payments of $ 1,422, had an original term of 30 years and had an interest rate of 9% (APR). In the intervening five years, interest rates have fallen and so you have decided to refinance, that is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a 30-year term, requires monthly payments, and has an interest rate of 6.125 % (APR). a....

  • When you purchased your​ house, you took out a​ 30-year annual-payment mortgage with an interest rate...

    When you purchased your​ house, you took out a​ 30-year annual-payment mortgage with an interest rate of 5 % per year. The annual payment on the mortgage is $ 17 comma 573. You have just made a payment and have now decided to pay the mortgage off by repaying the outstanding balance. a. What is the payoff amount if you have lived in the house for 18 years​ (so there are 12 years left on the​ mortgage)? b. What is...

  • When you purchased your car, you took out a five-year annual payment loan with an interest...

    When you purchased your car, you took out a five-year annual payment loan with an interest rate of 5.9% per year. The annual payment on the car is $5,300. You have just made a payment and have now decided to pay off the loan by repaying the outstanding balance. What is the payoff amount for the following scenarios? a. You have owned the car for one year (so there are four years left on the loan)? b. You have owned...

  • When you purchased your car, you took out a five-year annual-payment loan with an interest rate...

    When you purchased your car, you took out a five-year annual-payment loan with an interest rate of 6.3% per year. The annual payment on the car is $5,100. You have just made a payment and have now decided to pay off the loan by repaying the outstanding balance. What is the payoff amount for the following scenarios? a. You have owned the car for one year (so there are four years left on the loan)? b. You have owned the...

  • The mortgage on your house is five years old. It required monthly payments of $ 1,422,...

    The mortgage on your house is five years old. It required monthly payments of $ 1,422, had an original term of 30​ years, and had an interest rate of 9 % ​(APR). In the intervening five​ years, interest rates have fallen and so you have decided to refinance long dash that ​is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a​ 30-year term, requires monthly​ payments, and has an interest rate of 6.125...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT