Question

In: Finance

You are buying a condo on the beach in Galveston, TX. Here are the details. Overview:...

You are buying a condo on the beach in Galveston, TX. Here are the details.

Overview:

condo 893 sqft

2 beds $286/sqft

2 baths 673

Built in 2006

131 days on Trulia

Description:

New washer/dryer, fresh paint in living and kitchen in October. This condo is one of the best on Seawall. enjoy the beautiful interior with its relaxed atmosphere. You'll be drawn to the balcony where you will enjoy the amazing biew of the ocean and enjoy the sounds of seagulls. This condo has a modern and full equipped kitchen, stainless steel appliances, granite counter tops, travertine floors throughout. The elegant master bedroom with an amazing view of the ocean. Full furniture conveys with the sale. Ready for you to move in or rent out.

SELLING PRICE:   $224,000

Welcome to your virtual bank. For this assessment, assume the mortgage amount is the sale price of the house you chose. Based on your credit score, you are offered a fixed rate, an adjustable rate, and a balloon mortgage. Each is described below. For each mortgage option, submit the following to your instructor:

  • Fill in each table. (2 pts for each answer in table)

  • Calculate the total cost of principal and interest for each option. (2 pts each)

  • Conclude with the option you would choose and why. (4 pts)

OPTION 1:

Fixed Rate Mortgage: 5% for 30 years

Year

Monthly Payment

# of Payments

1-30

360

TOTAL COST (PRINCIPAL + INTEREST): ­­­­­­­­­­­­_______________________

    OPTION 2:

Adjustable Rate Mortgage: 4% with terms 5/1 with a 2/6 cap for 30 years
(Assume the interest rate increases by 1% after the initial period and every 10 years thereafter.)

Year

Monthly Payment

# of Payments

Total Cost for Each Period

1-5

60

6-15

120

16-25

120

26-30

60

TOTAL COST (PRINCIPAL + INTEREST):___________________________

   OPTION 3:

Balloon Mortgage: 4% fixed interest rate with terms 30/7

Year

Monthly Payment

# of Payments

Total Cost for Each Period

1-7

         84

Balloon Payment

1

TOTAL COST (PRINCIPAL + INTEREST):__________________________

Which option would you choose and why?

Solutions

Expert Solution

OPTION 1:

Fixed Rate Mortgage: 5% for 30 years

Year

Monthly Payment

# of Payments

1-30

$1,202.48

360

Total Cost (Principal + interest) = $1,202.48 * 360 = $432,893

Total Interest = $432,893 - $224,000 = $208,893

OPTION 2:

Adjustable Rate Mortgage: 4% with terms 5/1 with a 2/6 cap for 30 years
(Assume the interest rate increases by 1% after the initial period and every 10 years thereafter.)

Year

Monthly Payment

# of Payments

Total Cost for Each Period

1-5

$1,069.41

60

=1069.41 * 60 = $64,164.62

6-15

$1,184.39

120

=1184.39 * 120 = $142,127.24

16-25

$1,263.87

120

=1263.87 * 120 = $151,664.14

26-30

$1,263.87

60

=1263.87 * 60 = $75,832.07

Total Cost $433,788

OPTION 3:

Balloon Mortgage: 4% fixed interest rate with terms 30/7

Year

Monthly Payment

# of Payments

Total Cost for Each Period

1-7

$1,069.41

         84

=1069.41 * 84 = $89,830

Balloon Payment

$192,773.21

1

=192773.21 * 1 = $192,773.21
Total Cost $282,604

Since total cost is least in Option 3 which is Balloon payment option with a total cost of $282,604, this option should be chosen.


Related Solutions

Suppose you are buying a beach house condo for $450,000. You are planning to finance the...
Suppose you are buying a beach house condo for $450,000. You are planning to finance the ENTIRE amount of the condo via a mortgage for 30 years, 5% fixed, 0-points. The HOA fees, property taxes, Annual maintenance + Upkeep of the condo = $12,000 per year. Utilities are $150/month You are planning to rent this condo, and your rental income is $40,000 per year (gross), which goes up by 2% per year. Expenses to rent out the property are 30%...
Suppose you are buying your first condo for $160,000, and you will make a $15,000 down...
Suppose you are buying your first condo for $160,000, and you will make a $15,000 down payment. You have arranged to finance the remainder with a 30-year, monthly payment, amortized mortgage at a 4.5% nominal interest rate, with the first payment due in one month. What will your monthly payments be?
You are buying your first condo for $220,000 and are making a $20,000 down payment. You...
You are buying your first condo for $220,000 and are making a $20,000 down payment. You have arranged to finance the remaining amount with a 30-year monthly payment amortized mortgage at a 5.75% nominal interest rate. What will your monthly payments be? a.   $1,167.15 b.   $1,900.88 c.   $1,200.93 d.   $1,962.70 e.   $1,324.02 f.    $2,100.04 What is the estimated payoff on the mortgage question above after you have paid for 10 years? Show how you obtained the mortgage balance using Excel...
1. You are interested in buying a 2-bedroom condo in Cincinnati. The price is $300,000. You...
1. You are interested in buying a 2-bedroom condo in Cincinnati. The price is $300,000. You have a 30-year 3% APR mortgage with 20% down payment. a. What would be the monthly mortgage payment? b. Suppose you rent the property out and the rental you collect will just cover the mortgage payment. You plan to keep the property till the mortgage matures and do not plan to make any pre-payment. What is your annual investment return (please calculate the bond-equivalent...
Alexa owns a condo near Cocoa Beach in Flordia. This year, she incurs the following expenses...
Alexa owns a condo near Cocoa Beach in Flordia. This year, she incurs the following expenses in connection with her condo: Insurance $3,500 Mortage interest $10,800 Property Taxes $3,700 Repairs and maintance $1,150 Ulitites $2,900 Depreciation $22,000 During the year, Alexa rented out the condo for 132 days. Alexa's AGI from all sources other than the rental properrty is $200,000. Unless otherwise specifies, Alexa has no sources of passive income. Assume that in addition to renting the condo for 132...
Billy McMahon is interested in buying a waterfront condo and has saved $100,000 for the down...
Billy McMahon is interested in buying a waterfront condo and has saved $100,000 for the down payment. His plans call for making additional monthly deposits into an investment account over the next 36 months. Billy McMahon wants to make the purchase 48 months from today and wants to have $180,000 saved up for the down payment. A) What is the amount of each of the additional payments he must make for his plan to work out?   Assume Billy can earn...
Billy McMahon is interested in buying a waterfront condo and has saved $100,000 for the down...
Billy McMahon is interested in buying a waterfront condo and has saved $100,000 for the down payment. His plans call for making additional monthly deposits into an investment account over the next 36 months. Billy McMahon wants to make the purchase 48 months from today and wants to have $180,000 saved up for the down payment. a. What is the amount of each of the additional payments he must make for his plan to work out?   Assume Billy can earn...
Discuss in details Alternative Investment - Overview, Features and Classification
Discuss in details Alternative Investment - Overview, Features and Classification
Sally & Dave’s Condo Project: Financing with a Mortgage Overview This mini-case takes us back to...
Sally & Dave’s Condo Project: Financing with a Mortgage Overview This mini-case takes us back to b-school grads Sally and Dave. You’ll perhaps recall from PFE Chapter 4 that   they’re   thinking   of   buying   a   condo.   In Chapter 4, Sally and Dave were planning to finance the condo purchase without borrowing. In this case we consider the case where they take out a mortgage to finance the investment. The point of this case is to get you to think about the...
(In Java Using recursive techniques) When buying a house or condo (using a mortgage), or when...
(In Java Using recursive techniques) When buying a house or condo (using a mortgage), or when taking out a loan, you’ll likely wind up with some form of a fixed monthly payment. Mortgages and loans work this way: You take out a loan from the bank or lender for a specified amount of money at a specified annual interest rate with a specified monthly payment amount At the beginning of every month, interest is added to the amount you owe...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT