Question

6.       You are considering a hotel purchase. The current purchase price is $ 3,000,000. The bank...

6.       You are considering a hotel purchase. The current purchase price is $ 3,000,000. The bank is willing to finance 70% of the purchase price for 20 years in quarterly installments at 8% per annum mortgage nominal rate. What is the balloon payment you will have to pay, if you want to resell the hotel after 10 years? Consider a fully amortizing fixed rate mortgage.

a)      $ 0

b)      $ 1,445,395

c)       $ 1,669,270

d)      $ 1,981,333

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Step 1: Monthly payment
PV=-3000000*70%
N=20*4
I/Y=8%/4
FV=0
CPT PMT=52837.4814591

Step 2: Loan outstanding after 10 years
PMT=52837.4814591
PV=-3000000*70%
N=10*4
I/Y=8%/4
CPT FV=1445394.6271858

Balloon payment=Loan outstanding after 10 years=1445394.6271858

Add a comment
Know the answer?
Add Answer to:
6.       You are considering a hotel purchase. The current purchase price is $ 3,000,000. The bank...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

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
  • A hotel investment company is considering to add another hotel to its portfolio. The sales price...

    A hotel investment company is considering to add another hotel to its portfolio. The sales price is currently at $ 5,000,000. The purchase is partially financed by a loan with an LTV of 60%. The bank offers a 20-year monthly amortizing mortgage with a nominal interest rate of 6%. How much goes towards the principal in the second year? a)      $ 52,061 b)      -$ 43,599 c)       $ 1,557,428 d)      $ 85,034

  • You purchase a home and need to borrow $350,000. The bank is offering a 30-year loan...

    You purchase a home and need to borrow $350,000. The bank is offering a 30-year loan that requires monthly payments and has a stated interest rate of 9% per year. What is your monthly mortgage payment? Now suppose that you can only afford to pay $2,500 per month. The bank agrees to allow you to pay this amount each month, yet still borrow the original amount. At the end of the mortgage in 30 years, you must make a balloon...

  • 11. Suppose that you take out a $250,000 house mortgage from your local savings bank. The...

    11. Suppose that you take out a $250,000 house mortgage from your local savings bank. The bank requires you to repay the mortgage in equal annual installments over the next 30 years. Suppose that the interest rate is 5% a year. Then what is the amount of mortgage payment each year? (a) $16,263 (b) $13,452 (c) $12,583 (d) $10,127 12. Consider a borrower that is approved for a standard 15-year, fully amortizing house mortgage with an original balance of $500,000...

  • 1.       A hotel is on the market for a price of $ 10,000,000. The NOI projection...

    1.       A hotel is on the market for a price of $ 10,000,000. The NOI projection for the 1st year is $ 900,000. It is then estimated to grow at a constant rate of 1.5%. You plan on getting a loan from a bank which offers you a 20-year, quarterly amortizing loan at a nominal rate of 6%. What is the maximum loan the bank would give you with a DSCR of 1.3? a)      $ 8,152,517.31 b)      $ 8,032,036.76 c)      ...

  • Olivia plans to secure a 5-year balloon mortgage of $260,000 toward the purchase of a condominium

     Olivia plans to secure a 5-year balloon mortgage of $260,000 toward the purchase of a condominium. Her monthly payment for the 5 years is calculated on the basis of a 30-year conventional mortgage at the rate of 5%/year compounded monthly. At the end of the 5 years, Olivia is required to pay the balance owed (the "balloon" payment). What will be her monthly payment for the first 5 years, and what will be her balloon payment? (Round your answers to...

  • Q3: Mike decide to take the mortgage loan to buy a house with total price of...

    Q3: Mike decide to take the mortgage loan to buy a house with total price of $200,000.He made 50,000 for down payment. He decided to pay back the money every quarter in the equal amount. What should be his equal quarterly payment be over the next 20 years if the annual interest rate is 7%? Q4: You want to buy a car, and a bank will lend you $30,000. The loan would be fully amortized over 3 years (36 months),...

  • Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan...

    Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate. After 28 years, you would like to sell the property. What is your loan balance at the end of 28 years? Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate and your balloon payment is $50,000. What is your...

  • You plan to purchase a $1,000,000 house using a 30-year mortgage obtained from your local bank

    3. You plan to purchase a $1,000,000 house using a 30-year mortgage obtained from your local bank. The mortgage rate offered to you is 8.25%, and you will make a down payment of 20%. This is a fully amortizing mortgage loan. a. Calculate your required monthly payments. b. Calculate the interest payment, principal repayment, and ending balance for the first two months. c. Use a spreadsheet to calculate the total amount of interest payment. Is it greater or smaller than the amount of...

  • QUESTION 1 Suppose you are planning to purchase a home with a value of 5125,000. The...

    QUESTION 1 Suppose you are planning to purchase a home with a value of 5125,000. The bank has offered you a mortgage to finance 80% of the value of the home. How much of your own equity do you need to ivest in the purchase of the home? O $100.000 $125,000 O $25,000 O so QUESTION 2 1. Based on current interset rates, and your credit score. suppose the banik offers you a 30-year, fully-amortizing mortgage with monthly payments at...

  • D) 7.9% You are considering purchasing a new home. You will need to borrow $270,000 to purchase the home. A mortga...

    D) 7.9% You are considering purchasing a new home. You will need to borrow $270,000 to purchase the home. A mortgage company offers you a 20- year fixed rate mortgage at 6 % APR. If you borrow the money from this mortgage company, your monthly mortgage payment will be closest to: 14) A) $3094 B) $1934 C) $1547 D) $2708 5 A bank offers a loan that will requires you to pay 8% interest compounded semiannually. Which of the following...

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
ADVERTISEMENT